how to store array list data into db using asp.net mvc4?

Sneha K

I have six fields TinNo, CstNo, PanNo, CinNo, ServiceTaxNo, ExciseRegNo in my view . each field have default Guid eg TinNo means(TinNo= FD713788-B5AE-49FF-8B2C-F311B9CB0CC4) I need to save those six fields in same column but not in same row and same cell of TaxInfoTaxField Table . TaxInfoTaxFiled table contain TAXINFOTAXFIELDID, TAXFIELDID,FIELDVALUE,that is i need to save those six field values which is entered in view in FieldValue column and their id's in TaxFieldID column .it need to save row by row . so i decided to put that default guid's in one list and fields in one list and call where we want.

My View

The Default guid is already saved in TaxField table

Need to save in format

ArrayList objValue = new ArrayList();

{

objValue.Add(TITFVM.TinNo);

objValue.Add(TITFVM.CstNo);

objValue.Add(TITFVM.PanNo);

objValue.Add(TITFVM.CinNo);

objValue.Add(TITFVM.ExciseRegNo);

objValue.Add(TITFVM.ServiceTaxNo);

}

List LG = new List();

LG.Add(new Guid("FD713788-B5AE-49FF-8B2C-F311B9CB0CC4"));

LG.Add(new Guid("64B512E7-46AE-4989-A049-A446118099C4"));

LG.Add(new Guid("376D45C8-659D-4ACE-B249-CFBF4F231915"));

LG.Add(new Guid("59A2449A-C5C6-45B5-AA00-F535D83AD48B"));

LG.Add(new Guid("03ADA903-D09A-4F53-8B67-7347A08EDAB1"));

LG.Add(new Guid("2F405521-06A0-427C-B9A3-56B8931CFC57"));

var taxinfotaxfieldID = Guid.NewGuid();

var listFiled = new List();

for (var item = 0; item < objValue.Count; item++)

{

listFiled.Add(new TaxInfoTaxFiled

{

TaxInfoTaxFieldID = taxinfotaxfieldID,

TaxFieldID = new Guid(LG[item].ToString()),

FieldValue = objValue[item].ToString()

});

}

db.TaxInfoTaxFiled.Add(listFiled );

db.SaveChanges();

return View();

}

All are working Fine looping is working fine it count the values. But I got error in (db.TaxInfoTaxFiled.Add(listFiled ); it show overload error near to list field . i donno what is my error is .Any one help me to find out my error and tell m ethe problem is ?.

Advance Thanks...

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted answer
It means you are entering duplicate value to primary key. I am suspecting that you need to generate Guid key inside for loop. See below code:

var listFiled = new List();

for (var item = 0; item < objValue.Count; item++)
{
   TaxInfoTaxFiled taxInfoObj = new TaxInfoTaxFiled()
   {
      TaxInfoTaxFieldID = Guid.NewGuid(),
      TaxFieldID = new Guid(LG[item].ToString()),
      FieldValue = objValue[item].ToString()
   };

   listFiled.Add(taxInfoObj);
   db.TaxInfoTaxFiled.Add(taxInfoObj);
}

db.SaveChanges();
return View();

Hope it will resolve your problem.
+3
Sneha K10y ago
Manas Thank you soooooooooo my issue got solved. thank you. Thank you for your help.
0
Sneha K10y ago
see i did same as like as you said
0
Sneha K10y ago
wait i will show you
0
Manas Mohapatra10y ago
Is that saving before in your DB. Secondly it shouldn't generate 0 with Guid value - something is wrong in your code.
0
Sneha K10y ago
Manas i tried same as like you said all are working fine . but if i give guid .new Guid it will 0 in all iteration and does not save in table too .but didnt show any error
0
Sneha K10y ago
ok lets i have a try
0
Sneha K10y ago
Manas Ihvae tried as per you said but i got Violation of PRIMARY KEY constraint 'PK_TaxInfoTaxFiled'. Cannot insert duplicate key in object 'dbo.TaxInfoTaxFiled'. The statement has been terminated. error
0
Manas Mohapatra10y ago
You are adding list TaxInfoTaxFiled to table which is not supported and it throws error. Try with below code:

var taxinfotaxfieldID = Guid.NewGuid();
var listFiled = new List();

for (var item = 0; item < objValue.Count; item++)
{
   TaxInfoTaxFiled taxInfoObj = new TaxInfoTaxFiled()
   {
      TaxInfoTaxFieldID = taxinfotaxfieldID,
      TaxFieldID = new Guid(LG[item].ToString()),
      FieldValue = objValue[item].ToString()
   };

   listFiled.Add(taxInfoObj);
   db.TaxInfoTaxFiled.Add(taxInfoObj);
}

db.SaveChanges();
return View();

Secondly, if your EntityFramework version 6.0 onwards then you can use AddRange() to add list of object to a table in single shot. See below code:

IList newStudents = new List();
newStudents.Add(new Student() { StudentName = "Student1 by addrange" });
newStudents.Add(new Student() { StudentName = "Student2 by addrange" });
newStudents.Add(new Student() { StudentName = "Student3 by addrange" });

using (var context = new SchoolDBEntities())
{
   context.Students.AddRange(newStudents);
   context.SaveChanges();
}
+2