public Int64 Insert(tblChlnBookHead obj, DataTable Dttemp, string GrHeadsIdno) { Int64 chlnBookId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnBookHead CHead = new tblChlnBookHead(); tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => (rh.Chln_No == obj.Chln_No) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && rh.Chln_type == 2).FirstOrDefault(); if (RH != null) { chlnBookId = -1; } else { db.tblChlnBookHeads.AddObject(obj); db.SaveChanges(); chlnBookId = obj.Chln_Idno; string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None); if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl(); objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]); objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]); objtblChlnBookDetl.ChlnBookHead_Idno = chlnBookId; db.tblChlnBookDetls.AddObject(objtblChlnBookDetl); db.SaveChanges(); } } if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(GrIdnos[i + 1]); TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Chln_Idno = chlnBookId; db.SaveChanges(); } } } } return(chlnBookId); }
public Int64 Update(DataTable ChallanBookDetl, Int32 Chlnidno) { Int64 ChallanBookHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { List <tblChlnBookDetl> rcptdetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == Chlnidno).ToList(); //foreach (tblChlnBookDetl rgd in rcptdetl) //{ // db.tblChlnBookDetls.DeleteObject(rgd); // db.SaveChanges(); //} tblChlnBookDetl obj = new tblChlnBookDetl(); foreach (DataRow rgd in ChallanBookDetl.Rows) { if (Convert.ToBoolean(rgd["Delivered"]) == true) { obj.Delivered = Convert.ToBoolean(rgd["Delivered"]); obj.Delvry_Date = Convert.ToDateTime((rgd["Delvry_Date"])); obj.Shrtg = Convert.ToBoolean(rgd["Shrtg"]); obj.remark = Convert.ToString(rgd["remark"]); db.SaveChanges(); } } dbTran.Commit(); } catch { dbTran.Rollback(); } } return(ChallanBookHeadId); } }
public Int64 Update(tblChlnBookHead obj, Int32 ChlnIdno, DataTable Dttemp, string GrHeadsIdno) { Int64 chlnBoookId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblChlnBookHead CH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == obj.Chln_No && (rh.Chln_Idno != ChlnIdno) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && (rh.Chln_type == 2)).FirstOrDefault(); if (CH != null) { chlnBoookId = -1; } else { tblChlnBookHead TBH = db.tblChlnBookHeads.Where(rh => rh.Chln_Idno == ChlnIdno).FirstOrDefault(); if (TBH != null) { TBH.Chln_No = obj.Chln_No; TBH.Chln_Date = obj.Chln_Date; TBH.BaseCity_Idno = obj.BaseCity_Idno; TBH.DelvryPlc_Idno = obj.DelvryPlc_Idno; TBH.Truck_Idno = obj.Truck_Idno; TBH.Year_Idno = obj.Year_Idno; TBH.Chln_type = obj.Chln_type; TBH.Driver_Idno = obj.Driver_Idno; TBH.Delvry_Instrc = obj.Delvry_Instrc; TBH.Inv_Idno = obj.Inv_Idno; TBH.Gross_Amnt = obj.Gross_Amnt; TBH.Commsn_Amnt = obj.Commsn_Amnt; TBH.Other_Amnt = obj.Other_Amnt; TBH.Net_Amnt = obj.Net_Amnt; TBH.Work_type = obj.Work_type; TBH.Adv_Amnt = obj.Adv_Amnt; TBH.RcptType_Idno = obj.RcptType_Idno; TBH.Inst_No = obj.Inst_No; TBH.Inst_Dt = obj.Inst_Dt; TBH.Bank_Idno = obj.Bank_Idno; db.SaveChanges(); chlnBoookId = TBH.Chln_Idno; List <tblChlnBookDetl> ChlnDetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == ChlnIdno).ToList(); foreach (tblChlnBookDetl rgd in ChlnDetl) { db.tblChlnBookDetls.DeleteObject(rgd); db.SaveChanges(); } //foreach (tblChlnBookDetl rgd in ChlnDetl) //{ // rgd.ChlnBookHead_Idno = chlnBoookId; // db.tblChlnBookDetls.AddObject(rgd); // db.SaveChanges(); //} string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None); if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl(); objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]); objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]); objtblChlnBookDetl.ChlnBookHead_Idno = ChlnIdno; db.tblChlnBookDetls.AddObject(objtblChlnBookDetl); db.SaveChanges(); } } if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(GrIdnos[i + 1]); TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Chln_Idno = ChlnIdno; db.SaveChanges(); } } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(chlnBoookId); }