public int Delete(Int64 HeadId) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblDelvChlnHead CH = db.tblDelvChlnHeads.Where(h => h.DelvChln_Idno == HeadId).FirstOrDefault(); List <tblDelvChlnDetl> CD = db.tblDelvChlnDetls.Where(d => d.DelvChlnHead_Idno == HeadId).ToList(); if (CH != null) { foreach (var d in CD) { tblChlnDelvDetl objTblchln = (from obj in db.tblChlnDelvDetls where obj.Gr_Idno == d.GR_Idno select obj).FirstOrDefault(); objTblchln.DelvChlnHead_Idno = 0; db.SaveChanges(); } foreach (var d in CD) { db.tblDelvChlnDetls.DeleteObject(d); db.SaveChanges(); } db.tblDelvChlnHeads.DeleteObject(CH); // Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "CB"); db.SaveChanges(); value = 1; } } return(value); }
public Int64 UpdateMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp, Int32 HeadIdno) { Int64 RcptHeadIdno = HeadIdno; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno) && (rh.Year_Idno == objMtrlRcptHOHead.Year_Idno) && (rh.ChlnDelvHead_Idno != HeadIdno)).FirstOrDefault(); if (RH != null) { RcptHeadIdno = -1; } else { tblChlnDelvHead objRcptHOHead = (from obj in db.tblChlnDelvHeads where obj.ChlnDelvHead_Idno == RcptHeadIdno select obj).SingleOrDefault(); if (objRcptHOHead != null) { objRcptHOHead.ChlnDelv_Date = objMtrlRcptHOHead.ChlnDelv_Date; objRcptHOHead.ToCity_Idno = objMtrlRcptHOHead.ToCity_Idno; objRcptHOHead.ChlnTransf_Idno = objMtrlRcptHOHead.ChlnTransf_Idno; objRcptHOHead.LocGR_Amnt = objMtrlRcptHOHead.LocGR_Amnt; objRcptHOHead.CrsngGR_Amnt = objMtrlRcptHOHead.CrsngGR_Amnt; objRcptHOHead.Net_Amnt = objMtrlRcptHOHead.Net_Amnt; objRcptHOHead.Date_Modified = MultipleDBDAL.GetIndianDateTime().Date; // DateTime.Now.Date; objRcptHOHead.Year_Idno = objMtrlRcptHOHead.Year_Idno; db.SaveChanges(); } List <tblChlnDelvDetl> ChlnDetl = db.tblChlnDelvDetls.Where(rd => rd.ChlnDelvHead_Idno == RcptHeadIdno).ToList(); foreach (tblChlnDelvDetl rgd in ChlnDetl) { db.tblChlnDelvDetls.DeleteObject(rgd); db.SaveChanges(); } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl(); objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]); objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]); objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]); objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]); objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]); objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]); objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]); objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]); objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno; db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl); db.SaveChanges(); } } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(Dr["Gr_Idno"]); TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault(); if (objTblGrHead != null) { objTblGrHead.Gr_Delv = true; objTblGrHead.ChlnDelv_Idno = RcptHeadIdno; db.SaveChanges(); } } } } } } catch (Exception ex) { } return(RcptHeadIdno); }
public Int64 InsertMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp) { Int64 RcptHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno)).FirstOrDefault(); if (RH != null) { RcptHeadIdno = -1; } else { db.tblChlnDelvHeads.AddObject(objMtrlRcptHOHead); db.SaveChanges(); RcptHeadIdno = objMtrlRcptHOHead.ChlnDelvHead_Idno; if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { // ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "Weight", "", "String", "Amount", "String", "Delv_Qty", "String", "Reamrk", "String"); tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl(); objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]); objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]); objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]); objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]); objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]); objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]); objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]); objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]); objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno; db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl); db.SaveChanges(); } } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(Dr["Gr_Idno"]); TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault(); if (objTblGrHead != null) { objTblGrHead.Gr_Delv = true; objTblGrHead.ChlnDelv_Idno = RcptHeadIdno; db.SaveChanges(); } } } } } catch { return(0); } return(RcptHeadIdno); } }