public static tbl_finalStock DALGetOtherStocksDetailsSummary(int pumpid)
{
tbl_finalStock tblobj = new tbl_finalStock();
//decimal?[] cashquantity = new decimal?[] { model.cashquanity_diesel, model.cashquanity_petrol };
// UpdaeCashQuantity(cashquantity,model.pumpid);
try
{
using (var item = new GMOUMISEntity())
{
DateTime startDate = DateTime.Now.Date;
DateTime endDate = DateTime.Now.AddDays(1).Date;
tblobj = item.tbl_finalStock.Where(m => m.pumpid == pumpid && m.summary_date >= startDate && m.summary_date < endDate).FirstOrDefault();
}
}
catch (Exception ex)
{
return(null);
}
return(tblobj);
}
private static SaleReportFinal SalesReportCreation(tbl_finalStock model)
{
SaleReportFinal srf = new SaleReportFinal();
PetrolSaleReport psr = new PetrolSaleReport()
{
StartMeter = model.smeter_petrol,
EndMeter = model.emeter_petrol,
CashSale = model.cashsale_petrol,
OwnerSale = model.ownersale_petrol,
OtherSale = model.othersale_petrol,
StaffSale = model.staffsale_petrol,
CashQuantity = model.cashquanity_petrol,
StaffQuantity = model.staffquanity_petrol,
OtherQuantity = model.otherquanity_petrol,
OwnerQuanity = model.ownerquanity_petrol
};
srf.petrolsale = psr;
DieselSaleReport dsr = new DieselSaleReport()
{
StartMeter = model.smeter_diesel,
EndMeter = model.emeter_diesel,
CashSale = model.cashsale_diesel,
OwnerSale = model.ownersale_diesel,
OtherSale = model.othersale_diesel,
StaffSale = model.staffsale_diesel,
CashQuantity = model.cashquanity_diesel,
StaffQuantity = model.staffquanity_diesel,
OtherQuantity = model.otherquanity_diesel,
OwnerQuanity = model.ownerquanity_diesel
};
srf.dieselsale = dsr;
LubSaleReport lsr = new LubSaleReport()
{
CashSale = model.cashsale_lub,
OwnerSale = model.ownersale_lub,
OtherSale = model.othersale_lub,
StaffSale = model.staffsale_lub,
CashQuantity = model.cashquanity_lub,
StaffQuantity = model.staffquanity_lub,
OtherQuantity = model.otherquanity_lub,
OwnerQuanity = model.ownerquanity_lub
};
srf.lubsale = lsr;
return(srf);
}
public static bool DALInsertDailySummary(tbl_finalStock model)
{
decimal ?[] cashquantity = new decimal?[] { model.cashquanity_diesel, model.cashquanity_petrol };
// UpdaeCashQuantity(cashquantity,model.pumpid);
try
{
using (var item = new GMOUMISEntity())
{
item.tbl_finalStock.Add(model);
item.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public static bool BALInsertDailySummary(FinalSummary model)
{
tbl_finalStock obj = new tbl_finalStock()
{
pumpid = model.pumpid,
smeter_petrol = model.smeter_petrol,
emeter_petrol = model.emeter_petrol,
ownersale_petrol = model.ownersale_petrol,
cashsale_petrol = model.cashsale_petrol,
staffsale_petrol = model.staffsale_petrol,
othersale_petrol = model.othersale_petrol,
ownerquanity_petrol = model.ownerquanity_petrol,
cashquanity_petrol = model.cashquanity_petrol,
staffquanity_petrol = model.staffquanity_petrol,
otherquanity_petrol = model.otherquanity_petrol,
smeter_diesel = model.smeter_diesel,
emeter_diesel = model.emeter_diesel,
ownersale_diesel = model.ownersale_diesel,
cashsale_diesel = model.cashsale_diesel,
staffsale_diesel = model.staffsale_diesel,
othersale_diesel = model.othersale_diesel,
ownerquanity_diesel = model.ownerquanity_diesel,
cashquanity_diesel = model.cashquanity_diesel,
staffquanity_diesel = model.staffquanity_diesel,
otherquanity_diesel = model.otherquanity_diesel,
ownersale_lub = model.ownersale_lub,
cashsale_lub = model.cashsale_lub,
staffsale_lub = model.staffsale_lub,
othersale_lub = model.othersale_lub,
ownerquanity_lub = model.ownerquanity_lub,
cashquanity_lub = model.cashquanity_lub,
staffquanity_lub = model.staffquanity_lub,
otherquanity_lub = model.otherquanity_lub,
summary_date = model.summary_date,
inserted_by = model.inserted_by,
};
return(FuelRepository.DALInsertDailySummary(obj));
}
