//Insert public Int64 Insert(Int64 Slipno, DateTime?Lorry_Date, Int64 Loc_Idno, Int64 Truck_Idno, string strsupllyby, Int64 Year_Idno, Double totlfrghtamnt, Double advanceamnt, Double netamnt, DateTime?Date_Added, string strremarks, Double othercharg, Double unloading, Double detentioncharg, Double diesel, Double TDS, DataTable Dttemp) { Int64 LorryHire_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblLorryHireSlip objlorry = db.tblLorryHireSlips.Where(slipno => (slipno.Lry_Idno == Truck_Idno) && (slipno.Year_Idno == Year_Idno) && (slipno.Loc_Idno == Loc_Idno)).FirstOrDefault(); if (objlorry == null) { objlorry = new tblLorryHireSlip(); objlorry.Lry_SlipNo = Slipno; objlorry.Lry_Date = Lorry_Date; objlorry.Loc_Idno = Loc_Idno; objlorry.Lry_Idno = Truck_Idno; objlorry.SupliedTo = strsupllyby; objlorry.Year_Idno = Year_Idno; objlorry.Date_Added = Date_Added; objlorry.TotalFrghtAmnt = totlfrghtamnt; objlorry.AdvanceAmnt = advanceamnt; objlorry.Net_amnt = netamnt; objlorry.Remark = strremarks; objlorry.OtherCharges = othercharg; objlorry.Unloading = unloading; objlorry.DetectionCharges = detentioncharg; objlorry.Diesel = diesel; objlorry.TDS = TDS; db.tblLorryHireSlips.AddObject(objlorry); db.SaveChanges(); LorryHire_Idno = objlorry.LryHire_Idno; if (Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { tblLorryHireSlipGRDetl objHireSlipDetl = new tblLorryHireSlipGRDetl(); objHireSlipDetl.LryHire_Idno = LorryHire_Idno; objHireSlipDetl.GR_Idno = Convert.ToInt32(Dr["Gr_Idno"]); db.tblLorryHireSlipGRDetls.AddObject(objHireSlipDetl); db.SaveChanges(); } } } else { return(LorryHire_Idno); } } catch (Exception ex) { return(-1); } return(LorryHire_Idno); } }
// /// <summary> /// Delete record from ItemMast /// </summary> /// <param name="intItemIdno"></param> /// <returns></returns> public int Delete(int intSlipIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblLorryHireSlip objLrySlip = (from mast in db.tblLorryHireSlips where mast.LryHire_Idno == intSlipIdno select mast).FirstOrDefault(); if (objLrySlip != null) { db.tblLorryHireSlips.DeleteObject(objLrySlip); db.SaveChanges(); intValue = 1; } tblLorryHireSlipGRDetl objLrydetl = (from mast in db.tblLorryHireSlipGRDetls where mast.LryHire_Idno == intSlipIdno select mast).FirstOrDefault(); if (objLrydetl != null) { db.tblLorryHireSlipGRDetls.DeleteObject(objLrydetl); db.SaveChanges(); intValue = 1; } } } catch (Exception Ex) { if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true) { intValue = -1; } } return(intValue); }
//Update public Int64 Update(Int64 lorryhireIdno, Int64 Slipno, DateTime?Lorry_Date, Int64 Loc_Idno, Int64 Truck_Idno, string strsupllyby, Int64 Year_Idno, Double totlfrghtamnt, Double advanceamnt, Double netamnt, DateTime?Date_Modified, string strremarks, Double othercharg, Double unloading, Double detentioncharg, Double diesel, Double TDS, DataTable Dttemp) { Int64 LorryHire_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblLorryHireSlip objlorryupdate = db.tblLorryHireSlips.Where(rh => rh.LryHire_Idno == lorryhireIdno).FirstOrDefault(); if (objlorryupdate != null) { objlorryupdate.Lry_SlipNo = Slipno; objlorryupdate.Lry_Date = Lorry_Date; objlorryupdate.Loc_Idno = Loc_Idno; objlorryupdate.Lry_Idno = Truck_Idno; objlorryupdate.SupliedTo = strsupllyby; objlorryupdate.Year_Idno = Year_Idno; objlorryupdate.Date_Modified = Date_Modified; objlorryupdate.TotalFrghtAmnt = totlfrghtamnt; objlorryupdate.AdvanceAmnt = advanceamnt; objlorryupdate.Remark = strremarks; objlorryupdate.Net_amnt = netamnt; objlorryupdate.OtherCharges = othercharg; objlorryupdate.Unloading = unloading; objlorryupdate.DetectionCharges = detentioncharg; objlorryupdate.Diesel = diesel; objlorryupdate.TDS = TDS; db.SaveChanges(); LorryHire_Idno = objlorryupdate.LryHire_Idno; List <tblLorryHireSlipGRDetl> HireLorryDetl = db.tblLorryHireSlipGRDetls.Where(rd => rd.LryHire_Idno == LorryHire_Idno).ToList(); foreach (tblLorryHireSlipGRDetl rgd in HireLorryDetl) { db.tblLorryHireSlipGRDetls.DeleteObject(rgd); db.SaveChanges(); } if (Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { tblLorryHireSlipGRDetl objHireSlipDetl = new tblLorryHireSlipGRDetl(); objHireSlipDetl.LryHire_Idno = LorryHire_Idno; objHireSlipDetl.GR_Idno = Convert.ToInt32(Dr["Gr_Idno"]); db.tblLorryHireSlipGRDetls.AddObject(objHireSlipDetl); db.SaveChanges(); } // dbTran.Commit(); } } else { LorryHire_Idno = -1; } } catch (Exception ex) { LorryHire_Idno = 0; } return(LorryHire_Idno); } }