private void label7_Click(object sender, EventArgs e) { string gam = gamasli.Text; string onv = onvan.Text; string shr = sharh.Text; string mod = modat.Text; string dar = darsad.Text; string das = dastavard.Text; shenasnameGam model = new shenasnameGam() { achivement = dastavard.Text, darsadeVazni = Int32.Parse(darsad.Text), description = sharh.Text, duration = modat.Text, title = onvan.Text, shenasnameID = GlobalVariable.shenasnameID, gamAsli = gamasli.Text, }; dbcontext.shenasnameGams.Add(model); dbcontext.SaveChanges(); int index = 0; foreach (Form form in Application.OpenForms) { if (form.Name == "Form2_shenasnameAdd") { break; } index += 1; } this.Hide(); Application.OpenForms[index].Close(); Form2_shenasnameAdd form2 = new Form2_shenasnameAdd(); form2.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { int iSelectedGridIndex = dataGridView1.CurrentCell.ColumnIndex; int rowindex = dataGridView1.CurrentCell.RowIndex; string rowID = dataGridView1.Rows[rowindex].Cells[2].Value.ToString(); if (iSelectedGridIndex == 1) { using (Context dbcontext = new Context()) { shenasname selecteditem = dbcontext.shenasnames.SingleOrDefault(x => x.ID == rowID); if (selecteditem.master != "1") { return; } string sID = RandomString(10); List <shenasnameGam> gamList = dbcontext.shenasnameGams.Where(x => x.shenasnameID == rowID).ToList(); if (gamList != null) { foreach (shenasnameGam item in gamList) { shenasnameGam newItem = item; newItem.shenasnameID = sID; dbcontext.shenasnameGams.Add(newItem); } } List <shenasnameFounder> founderList = dbcontext.shenasnameFounders.Where(x => x.shenasnameID == rowID).ToList(); if (founderList != null) { foreach (shenasnameFounder item in founderList) { shenasnameFounder newItem = item; newItem.shenasnameID = sID; dbcontext.shenasnameFounders.Add(newItem); } } List <ejraeiat> ejraeatList = dbcontext.ejraeiats.Where(x => x.shenasnameID == rowID).ToList(); if (ejraeatList != null) { foreach (ejraeiat item in ejraeatList) { ejraeiat newItem = item; newItem.shenasnameID = sID; dbcontext.ejraeiats.Add(newItem); } } List <sarmaye> sarmayeslist = dbcontext.sarmayes.Where(x => x.shenasnameID == rowID).ToList(); if (sarmayeslist != null) { foreach (sarmaye item in sarmayeslist) { sarmaye newItem = item; newItem.shenasnameID = sID; dbcontext.sarmayes.Add(newItem); } } List <masrafi> masrafislist = dbcontext.masrafis.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (masrafi item in masrafislist) { masrafi newItem = item; newItem.shenasnameID = sID; dbcontext.masrafis.Add(newItem); } } List <edari> edarislist = dbcontext.edaris.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (edari item in edarislist) { edari newItem = item; newItem.shenasnameID = sID; dbcontext.edaris.Add(newItem); } } List <omrani> omranilist = dbcontext.omranis.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (omrani item in omranilist) { omrani newItem = item; newItem.shenasnameID = sID; dbcontext.omranis.Add(newItem); } } List <gharardad> gharardadslist = dbcontext.gharardads.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (gharardad item in gharardadslist) { gharardad newItem = item; newItem.shenasnameID = sID; dbcontext.gharardads.Add(newItem); } } List <sayer> sayerslist = dbcontext.sayers.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (sayer item in sayerslist) { sayer newItem = item; newItem.shenasnameID = sID; dbcontext.sayers.Add(newItem); } } List <tashvighi> tashvighislist = dbcontext.tashvighis.Where(x => x.shenasnameID == rowID).ToList(); if (masrafislist != null) { foreach (tashvighi item in tashvighislist) { tashvighi newItem = item; newItem.shenasnameID = sID; dbcontext.tashvighis.Add(newItem); } } shenasname model = new shenasname() { comment = selecteditem.comment, date = DateTime.Now, time = DateTime.Now.TimeOfDay, changer = selecteditem.changer, dastgah = selecteditem.dastgah, dateFrom = DateTime.Now, title = selecteditem.title, token = selecteditem.token, parent = selecteditem.parent, ID = sID, noshke = selecteditem.noshke, dateTo = DateTime.Now, master = selecteditem.master, LvazifeT = selecteditem.LvazifeT, markaz = selecteditem.markaz, LvazifeHPR = selecteditem.LvazifeHPR, LvazifeHPD = selecteditem.LvazifeHPD, LrasmiT = selecteditem.LrasmiT, LrasmiHPR = selecteditem.LrasmiHPR, LrasmiHPD = selecteditem.LrasmiHPD, LgharartamamT = selecteditem.LgharartamamT, LgharartamamHPR = selecteditem.LgharartamamHPR, DghararsaatHPD = selecteditem.DghararsaatHPD, DghararsaatHPR = selecteditem.DghararsaatHPR, DghararsaatT = selecteditem.DghararsaatT, DgharartamamHPD = selecteditem.DgharartamamHPD, DgharartamamHPR = selecteditem.DgharartamamHPR, DgharartamamT = selecteditem.DgharartamamT, DighararsaatHPD = selecteditem.DighararsaatHPD, DighararsaatHPR = selecteditem.DighararsaatHPR, DighararsaatT = selecteditem.DighararsaatT, DigharartamamHPD = selecteditem.DigharartamamHPD, DigharartamamHPR = selecteditem.DigharartamamHPR, DigharartamamT = selecteditem.DigharartamamT, DirasmiHPD = selecteditem.DirasmiHPD, DirasmiHPR = selecteditem.DirasmiHPR, DirasmiT = selecteditem.DirasmiT, DivazifeHPD = selecteditem.DivazifeHPD, DivazifeHPR = selecteditem.DivazifeHPR, DivazifeT = selecteditem.DivazifeT, DrasmiHPD = selecteditem.DrasmiHPD, DrasmiHPR = selecteditem.DrasmiHPR, DrasmiT = selecteditem.DrasmiT, DvazifeHPD = selecteditem.DvazifeHPD, DvazifeHPR = selecteditem.DvazifeHPR, DvazifeT = selecteditem.DvazifeT, FDghararsaatHPD = selecteditem.FDghararsaatHPD, FDghararsaatHPR = selecteditem.FDghararsaatHPR, FDghararsaatT = selecteditem.FDghararsaatT, FDgharartamamHPD = selecteditem.FDgharartamamHPD, FDgharartamamHPR = selecteditem.FDgharartamamHPR, FDgharartamamT = selecteditem.FDgharartamamT, FDrasmiHPD = selecteditem.FDrasmiHPD, FDrasmiHPR = selecteditem.FDrasmiHPR, FDrasmiT = selecteditem.FDrasmiT, FDvazifeHPD = selecteditem.FDvazifeHPD, FDvazifeHPR = selecteditem.FDvazifeHPR, FDvazifeT = selecteditem.FDvazifeT, final = 0, FLghararsaatHPD = selecteditem.FLghararsaatHPD, FLgharartamamT = selecteditem.FLgharartamamT, FLghararsaatHPR = selecteditem.FLghararsaatHPR, FLghararsaatT = selecteditem.FLghararsaatT, FLgharartamamHPD = selecteditem.FLgharartamamHPD, FLgharartamamHPR = selecteditem.FLgharartamamHPR, FLrasmiHPD = selecteditem.FLrasmiHPD, FLrasmiHPR = selecteditem.FLrasmiHPR, FLrasmiT = selecteditem.FLrasmiT, FLvazifeHPD = selecteditem.FLvazifeHPD, FLvazifeHPR = selecteditem.FLvazifeHPR, FLvazifeT = selecteditem.FLvazifeT, hadaf = selecteditem.hadaf, isDone = false, LghararsaatHPD = selecteditem.LghararsaatHPD, LghararsaatHPR = selecteditem.LghararsaatHPR, LghararsaatT = selecteditem.LghararsaatT, LgharartamamHPD = selecteditem.LgharartamamHPD, ZDighararsaatHPD = selecteditem.ZDighararsaatHPD, ZDighararsaatHPR = selecteditem.ZDighararsaatHPR, ZDighararsaatT = selecteditem.ZDighararsaatT, ZDigharartamamHPD = selecteditem.ZDigharartamamHPD, ZDigharartamamHPR = selecteditem.ZDigharartamamHPR, ZDigharartamamT = selecteditem.ZDigharartamamT, ZDirasmiHPD = selecteditem.ZDirasmiHPD, ZDirasmiHPR = selecteditem.ZDirasmiHPR, ZDirasmiT = selecteditem.ZDirasmiT, ZDivazifeHPD = selecteditem.ZDivazifeHPD, ZDivazifeHPR = selecteditem.ZDivazifeHPR, ZDivazifeT = selecteditem.ZDivazifeT, bayganiFile = selecteditem.bayganiFile, gantFile = selecteditem.gantFile, gharardadFile = selecteditem.gharardadFile, listmavadFile = selecteditem.listmavadFile, mojavezFile = selecteditem.mojavezFile, motamamFile = selecteditem.motamamFile, peyvastFile = selecteditem.peyvastFile, pishraftFile = selecteditem.pishraftFile, }; dbcontext.shenasnames.Add(model); dbcontext.SaveChanges(); GlobalVariable.shenasnameID = sID; Form2_shenasnameAdd form2 = new Form2_shenasnameAdd(); form2.Show(); } } else if (iSelectedGridIndex == 0) { GlobalVariable.shenasnameID = rowID; Form2_shenasnameAdd form2 = new Form2_shenasnameAdd(); form2.Show(); } else { return; } }