public Int64 Insert(Int64 FuelSlip_No, DateTime?FuelSlip_Date, Int64 Loc_Idno, Int64 Truck_Idno, Int64 Pump_Idno, Int64 Driver_Idno, Int64 Year_Idno, DateTime?Date_Added, double NetAmnt, DataTable dtDetail, string InvoiceNo) { Int64 FuelSlip_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblFuelSlipHead objFuelSlipHead = db.tblFuelSlipHeads.Where(bill => (bill.FuelSlip_No == FuelSlip_No) && (bill.Year_Idno == Year_Idno) && (bill.Loc_Idno == Loc_Idno)).FirstOrDefault(); if (objFuelSlipHead == null) { objFuelSlipHead = new tblFuelSlipHead(); objFuelSlipHead.FuelSlip_No = FuelSlip_No; objFuelSlipHead.FuelSlip_Date = FuelSlip_Date; objFuelSlipHead.Loc_Idno = Loc_Idno; objFuelSlipHead.Truck_Idno = Truck_Idno; objFuelSlipHead.Pump_Idno = Pump_Idno; objFuelSlipHead.Driver_Idno = Driver_Idno; objFuelSlipHead.Year_Idno = Year_Idno; objFuelSlipHead.Date_Added = Date_Added; objFuelSlipHead.Net_Amnt = NetAmnt; objFuelSlipHead.Invoice_No = InvoiceNo; db.tblFuelSlipHeads.AddObject(objFuelSlipHead); db.SaveChanges(); FuelSlip_Idno = objFuelSlipHead.FuelSlip_Idno; if (FuelSlip_Idno > 0) { foreach (DataRow dr in dtDetail.Rows) { tblFuelSlipDetl objFuelSlipDetl = new tblFuelSlipDetl(); objFuelSlipDetl.FuelSlipHead_Idno = FuelSlip_Idno; objFuelSlipDetl.Iteam_Idno = Convert.ToInt64(dr["ItemNameIdno"]); objFuelSlipDetl.Item_Qty = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Qty"]))); objFuelSlipDetl.Item_Rate = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Rate"]))); objFuelSlipDetl.Item_Amnt = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Amount"]))); db.tblFuelSlipDetls.AddObject(objFuelSlipDetl); db.SaveChanges(); } } } else { return(FuelSlip_Idno); } } catch (Exception ex) { return(-1); } return(FuelSlip_Idno); } }
public Int64 Update(Int64 FuelSlipHead_Idno, Int64 FuelSlip_No, DateTime?FuelSlip_Date, Int64 Loc_Idno, Int64 Truck_Idno, Int64 Pump_Idno, Int64 Driver_Idno, Int64 Year_Idno, DateTime?Date_Updated, double NetAmnt, DataTable dtDetail, string InvoiceNo) { Int64 FuelSlip_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblFuelSlipHead objFuelSlipHead = db.tblFuelSlipHeads.Where(bill => (bill.FuelSlip_No == FuelSlip_No) && (bill.FuelSlip_Idno != FuelSlipHead_Idno) && (bill.Year_Idno == Year_Idno) && (bill.Loc_Idno == Loc_Idno)).FirstOrDefault(); if (objFuelSlipHead == null) { tblFuelSlipHead tblFuelSlipHead1 = db.tblFuelSlipHeads.Where(rh => rh.FuelSlip_Idno == FuelSlipHead_Idno).FirstOrDefault(); if (tblFuelSlipHead1 != null) { tblFuelSlipHead1.FuelSlip_Date = FuelSlip_Date; tblFuelSlipHead1.Loc_Idno = Loc_Idno; tblFuelSlipHead1.Truck_Idno = Truck_Idno; tblFuelSlipHead1.Pump_Idno = Pump_Idno; tblFuelSlipHead1.Driver_Idno = Driver_Idno; tblFuelSlipHead1.Year_Idno = Year_Idno; tblFuelSlipHead1.Date_Modified = Date_Updated; tblFuelSlipHead1.Year_Idno = Year_Idno; tblFuelSlipHead1.Invoice_No = InvoiceNo; tblFuelSlipHead1.Net_Amnt = NetAmnt; db.SaveChanges(); FuelSlip_Idno = tblFuelSlipHead1.FuelSlip_Idno; if (FuelSlip_Idno > 0) { List <tblFuelSlipDetl> lstFuelSlipDetl = db.tblFuelSlipDetls.Where(obj => obj.FuelSlipHead_Idno == FuelSlip_Idno).ToList(); if (lstFuelSlipDetl.Count > 0) { foreach (tblFuelSlipDetl obj in lstFuelSlipDetl) { db.tblFuelSlipDetls.DeleteObject(obj); } db.SaveChanges(); } foreach (DataRow row in dtDetail.Rows) { tblFuelSlipDetl objFuelSlipDetl = new tblFuelSlipDetl(); objFuelSlipDetl.FuelSlipHead_Idno = Convert.ToInt64(FuelSlip_Idno); objFuelSlipDetl.Iteam_Idno = Convert.ToInt64(row["ItemNameIdno"]); objFuelSlipDetl.Item_Qty = Convert.ToDouble(row["Qty"]); objFuelSlipDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objFuelSlipDetl.Item_Amnt = Convert.ToDouble(row["Amount"]); db.tblFuelSlipDetls.AddObject(objFuelSlipDetl); db.SaveChanges(); } } } } else { FuelSlip_Idno = -1; } } catch (Exception Ex) { FuelSlip_Idno = 0; } } return(FuelSlip_Idno); }