insert data array using model table in database mvc c#

Question

Can you fix my problem? I try to insert data in table database oracle, but the data take from session array. this code controller to insert data

int[] NoId = (int[])Session["Id"];
string[] NamaBarang = (string[])Session["namaBarang"];
string[] HargaSatuan = (string[])Session["harga"];
string[] JumlahBarang = (string[])Session["jumlah"];
string[] HargaTotal = (string[])Session["total"];
string[] Diskon = (string[])Session["disc"];
string[] DPP = (string[])Session["Dpp"];
string[] PPN = (string[])Session["Ppn"];

MPMISTAX_DTLMASUK itemA = new MPMISTAX_DTLMASUK();
itemA.KD_PPN = "2";
itemA.KDUNIT = Kategori;
itemA.KODE_SUPP = "M2Z";
itemA.NOFAK = nomorFaktur;
itemA.KDFAK = kodeFaktur;
itemA.VKODECABANG = KodeMain;
item.TAHUN = TanggalFak.Year;
itemA.RETUR = "";
itemA.NMBRG = NamaBarang[0];
itemA.HRGSAT = HargaSatuan[0];
itemA.NPWP = npwpPenjual;
itemA.NODOK = "-";

dbContext.MPMISTAX_DTLMASUK.Add(itemA);
dbContext.SaveChanges();

I try using that code, but its error. I Hope you can help my problem. Thank you

itemA.NMBRG type data is long, but session array NamaBarang[0] type data is string, and can I insert data array in table database ? — Takishima
– Takishima, Commented May 31, 2016 at 4:19
You will have to loop through array to insert into database. — Mairaj Ahmad
– Mairaj Ahmad, Commented May 31, 2016 at 4:38
Can you give me example? I don't have any idea, because I still new learning about mvc and oracle database — Takishima
– Takishima, Commented May 31, 2016 at 4:44

Mairaj Ahmad · Accepted Answer · 2016-05-31 05:58:51Z

1

What is the datatype of

itemA.NMBRG?

if it's long please convert the NamaBarang[0] to long datatype before assigning. Like

itemA.NMBRG = (long)NamaBarang[0];

Hope this helps!!

edited May 31, 2016 at 5:58

Mairaj Ahmad

14.6k2 gold badges29 silver badges43 bronze badges

answered May 31, 2016 at 5:21

Abhishek

1708 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Takishima Over a year ago

the datatype of itemA.NMBRG is string, same of NamaBarang[0], but the problem is datatype of itemA.HRGSAT. that is long and the HargaSatuan[0] is string. I can't convert because the string include " . " not only character. and convert to long not worked.

Mairaj Ahmad · Accepted Answer · 2016-05-31 04:35:41Z

0

You are trying to assign string to a feild which is of type long .Parse the string to long for feild NMBRG.

itemA.NMBRG = (long)NamaBarang[0];

answered May 31, 2016 at 4:35

Mairaj Ahmad

14.6k2 gold badges29 silver badges43 bronze badges

9 Comments

Takishima Over a year ago

thank, that work, but you can help me, how can I Insert data array in table database?

Mairaj Ahmad Over a year ago

You have to insert two arrays ?

Takishima Over a year ago

Can you give me example with code? because I don't know how to explain that. My mind is blank. I Hope you can help me?

Takishima Over a year ago

I have one more question ? How is that string include " . " not only character?

Mairaj Ahmad Over a year ago

Strings are enclosed in double qoutes. Length of NamaBarang and HargaSatuan will be same ?

|

Collectives™ on Stack Overflow

insert data array using model table in database mvc c#

2 Answers 2

1 Comment

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related