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 int Delete(int intFuelSlipIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblFuelSlipHead objItemMast = (from mast in db.tblFuelSlipHeads
where mast.FuelSlip_Idno == intFuelSlipIdno
select mast).FirstOrDefault();
if (objItemMast != null)
{
db.tblFuelSlipHeads.DeleteObject(objItemMast);
db.SaveChanges();
intValue = 1;
}
List <tblFuelSlipDetl> Detl = (from M in db.tblFuelSlipDetls where M.FuelSlipHead_Idno == intFuelSlipIdno select M).ToList();
if (Detl != null && Detl.Count > 0)
{
foreach (var D in Detl)
{
db.tblFuelSlipDetls.DeleteObject(D);
}
db.SaveChanges();
}
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
objclsAccountPosting.DeleteAccountPosting(intFuelSlipIdno, "FS");
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);
}
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);
}
