public bool SaveIncome(tblIncomeSource income)
{
long maxId = context.tblIncomeSources.Select(cc => cc.ID).DefaultIfEmpty(0).Max();
income.ID = ++maxId;
context.tblIncomeSources.Add(income);
return(context.SaveChanges() > 0);
}
public bool SaveCar(tblCar objcar)
{
int maxId = context.tblCars.Select(p => p.ID).DefaultIfEmpty(0).Max();
objcar.ID = ++maxId;
context.tblCars.Add(objcar);
return(context.SaveChanges() > 0);
}
public bool SaveConsumption(tblCostingSource consumption)
{
long maxId = context.tblCostingSources.Select(cc => cc.ID).DefaultIfEmpty(0).Max();
consumption.ID = ++maxId;
context.tblCostingSources.Add(consumption);
return(context.SaveChanges() > 0);
}
public bool EditProduct(tblProduct product)
{
var existProd = context.tblProducts.Where(pp => pp.ID >= product.ID).FirstOrDefault();
existProd.productName = product.productName;
existProd.parentId = product.parentId;
return(context.SaveChanges() > 0);
}
public bool SaveSector(tblCommonElement sector)
{
int maxId = context.tblCommonElements.Select(cc => cc.ID).DefaultIfEmpty(0).Max();
sector.ID = ++maxId;
//sector.elementCode = 3;
context.tblCommonElements.Add(sector);
return(context.SaveChanges() > 0);
}
// just try to avoid opening values
public Employee SaveEmp(Employee employee)
{
try
{
long maxId = context.Employees.Select(p => p.ID).DefaultIfEmpty(0).Max();
employee.ID = ++maxId;
context.Employees.Add(employee);
return(context.SaveChanges() > 0 ? employee : null);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public long SaveBalancePaddy(tblDue objDue)
{
try
{
#region save dueable
long maxId = context.tblDues.Select(p => p.ID).DefaultIfEmpty(0).Max();
objDue.ID = ++maxId;
objDue.isActive = 1;
var lastDueId =
context.tblDues.Where(p => p.partyId == objDue.partyId)
.Select(p => p.ID)
.DefaultIfEmpty()
.Max();
if (lastDueId > 0)
{
var lastdue = context.tblDues.Where(p => p.ID == lastDueId).FirstOrDefault();
lastdue.isActive = 0;
objDue.openingBalance = lastdue.openingBalance + objDue.amount;
}
else
{
objDue.openingBalance = objDue.amount;
}
context.tblDues.Add(objDue);
#endregion
return(context.SaveChanges() > 0 ? objDue.ID : 0);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public bool SaveLoaner(tblLoanar loaner)
{
int maxId = context.tblLoanars.Select(p => p.ID).DefaultIfEmpty(0).Max();
loaner.ID = ++maxId;
context.tblLoanars.Add(loaner);
return(context.SaveChanges() > 0);
}
public BagTransaction SaveBag(BagTransaction objBag)
{
long maxId = context.BagTransactions.Select(s => s.ID).DefaultIfEmpty(0).Max();
var results = from sack in context.BagTransactions
where sack.partyId == objBag.partyId.Value && sack.date <= objBag.date && (sack.rcvPrice == 0 || sack.rcvPrice == null) && (sack.sentPrice == 0 || sack.sentPrice == null)
orderby sack.date descending, sack.ID descending
select sack;
var prevDue = results.FirstOrDefault();
var pric = (from sack in context.BagTransactions
where sack.partyId == objBag.partyId.Value && sack.date <= objBag.date && (sack.rcvPrice > 0 || sack.sentPrice > 0)
orderby sack.date descending, sack.ID descending
select sack);
var prevprice = pric.FirstOrDefault();
if (objBag.sentPrice > 0)
{
int bag = objBag.comSentBag > 0 ? objBag.comSentBag.Value : 1;
objBag.priceDues = prevprice.priceDues - objBag.sentPrice * bag;
var nextprices = from sack in context.BagTransactions
where sack.partyId == objBag.partyId.Value && sack.date > objBag.date && (sack.rcvPrice > 0 || sack.sentPrice > 0)
select sack;
foreach (var item in nextprices)
{
item.priceDues -= objBag.sentPrice * bag;
}
}
else
{
objBag.bagDues = prevDue.bagDues - objBag.comSentBag;
var nextBags = from sack in context.BagTransactions
where sack.partyId == objBag.partyId.Value && sack.date > objBag.date && (sack.rcvPrice == 0 || sack.rcvPrice == null) && (sack.sentPrice == 0 || sack.sentPrice == null)
select sack;
foreach (var item in nextBags)
{
item.bagDues -= objBag.comSentBag;
}
}
objBag.ID = ++maxId;
context.BagTransactions.Add(objBag);
return(context.SaveChanges() > 0 ? objBag : null);
}
public long SavePaddyTransfer(STK_Balance objStkBalance)
{
var transferFrom =
context.STK_Balance.Where(
ss => ss.stockId == objStkBalance.stockId && ss.productId == objStkBalance.productId && ss.sackWeight == objStkBalance.sackWeight).FirstOrDefault();
transferFrom.sackQuantity = transferFrom.sackQuantity - objStkBalance.sackQuantity;
if (transferFrom.sackQuantity < 0)
{
return(0);
}
var transferTo = context.STK_Balance.Where(
ss => ss.stockId == objStkBalance.targetStockId && ss.productId == objStkBalance.productId && ss.sackWeight == objStkBalance.sackWeight).FirstOrDefault();
if (transferTo != null)
{
transferTo.sackQuantity += objStkBalance.sackQuantity;
}
else
{
var maxId = context.STK_Balance.Select(ss => ss.ID).DefaultIfEmpty(0).Max();
STK_Balance stockTo = new STK_Balance();
stockTo.ID = ++maxId;
stockTo.stockId = objStkBalance.targetStockId;
stockTo.sackWeight = objStkBalance.sackWeight;
context.STK_Balance.Add(stockTo);
}
#region paddy transaction
var maxTransId = context.PaddyTransactions.Select(ss => ss.ID).DefaultIfEmpty(0).Max();
PaddyTransaction exstRlsStk = context.PaddyTransactions.Where(pp => pp.prodId == objStkBalance.productId && pp.stockId == objStkBalance.stockId && pp.bagWeight == objStkBalance.sackWeight).FirstOrDefault();
PaddyTransaction objTransRls = new PaddyTransaction();
objTransRls.ID = ++maxTransId;
objTransRls.date = objStkBalance.date;
objTransRls.bagWeight = objStkBalance.sackWeight;
objTransRls.stockId = objStkBalance.stockId.Value;
objTransRls.prodId = objStkBalance.productId.Value;
objTransRls.releaseQty = objStkBalance.sackQuantity;
objTransRls.openingStock = exstRlsStk == null ? 0 : exstRlsStk.openingStock - objStkBalance.sackQuantity.Value;
context.PaddyTransactions.Add(objTransRls);
PaddyTransaction exstRcvStk = context.PaddyTransactions.Where(pp => pp.prodId == objStkBalance.productId && pp.stockId == objStkBalance.targetStockId && pp.bagWeight == objStkBalance.sackWeight).FirstOrDefault();
PaddyTransaction objTransRcv = new PaddyTransaction();
objTransRcv.ID = ++maxTransId;
objTransRcv.date = objStkBalance.date;
objTransRcv.bagWeight = objStkBalance.sackWeight;
objTransRcv.stockId = objStkBalance.targetStockId;
objTransRcv.prodId = objStkBalance.productId.Value;
objTransRcv.rcvQty = objStkBalance.sackQuantity;
objTransRcv.openingStock = exstRcvStk == null ? 0 : exstRcvStk.openingStock + objStkBalance.sackQuantity.Value;
objTransRcv.serial = objStkBalance.serial;
objTransRcv.millCost = objStkBalance.millCost;
objTransRcv.fromStock = objStkBalance.stockId;
context.PaddyTransactions.Add(objTransRcv);
#endregion
return(context.SaveChanges() > 0 ? objTransRcv.ID : 0);
}
public bool EditStock(STK_tblStock stk)
{
var existStk = context.STK_tblStock.Where(ss => ss.ID >= stk.ID).FirstOrDefault();
existStk.stockName = stk.stockName;
existStk.stockAddress = stk.stockAddress;
return(context.SaveChanges() > 0);
}
public tblCostingSource Save(tblCostingSource withdraw)
{
try
{
long maxId = context.tblCostingSources.Select(p => p.ID).DefaultIfEmpty(0).Max();
withdraw.ID = ++maxId;
context.tblCostingSources.Add(withdraw);
return(context.SaveChanges() > 0 ? withdraw : null);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public long Save(tblCostingSource objLoanCostingSource)
{
try
{
long maxId = context.tblCostingSources.Select(ss => ss.ID).DefaultIfEmpty(0).Max();
long maxDueId = context.tblDues.Select(pp => pp.ID).DefaultIfEmpty(0).Max();
objLoanCostingSource.ID = ++maxId;
objLoanCostingSource.srcDescription = "ধান ক্রয় বাবদ ব্যায় পরিশোধ";
objLoanCostingSource.sourceName = "ধান";
objLoanCostingSource.srcDescId = 23;
objLoanCostingSource.isDue = 1;
context.tblCostingSources.Add(objLoanCostingSource);
tblDue latestDue =
context.tblDues.Where(ss => ss.partyId == objLoanCostingSource.partyId && ss.date <= objLoanCostingSource.date).OrderByDescending(ss => ss.date).ThenByDescending(ss => ss.ID).FirstOrDefault();
List <tblDue> nextDues = context.tblDues.Where(dd => dd.partyId == objLoanCostingSource.partyId && dd.date > objLoanCostingSource.date).ToList();
//dueChange.isActive = 0;
tblDue newDue = new tblDue();
newDue.ID = ++maxDueId;
//newDue.isActive = 1;
newDue.costingId = objLoanCostingSource.ID;
newDue.amount = (-1) * objLoanCostingSource.amount;
if (latestDue == null)
{
newDue.openingBalance = newDue.amount;
}
else
{
newDue.openingBalance = latestDue.openingBalance + newDue.amount;
}
newDue.date = objLoanCostingSource.date;
newDue.partyId = objLoanCostingSource.partyId.Value;
if (nextDues != null)
{
foreach (var item in nextDues)
{
item.openingBalance += newDue.amount;
}
}
context.tblDues.Add(newDue);
return(context.SaveChanges() > 0 ? objLoanCostingSource.ID : 0);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public long Save(tblIncomeSource objDueIncomeSource)
{
try
{
long maxId = context.tblIncomeSources.Select(ss => ss.ID).DefaultIfEmpty(0).Max();
long maxPayId = context.tblPayables.Select(pp => pp.ID).DefaultIfEmpty(0).Max();
objDueIncomeSource.ID = ++maxId;
if (objDueIncomeSource.description != null)
{
objDueIncomeSource.description = objDueIncomeSource.sourceName + " বকেয়া বাবদ আয়" + "," + objDueIncomeSource.description;
}
else
{
objDueIncomeSource.description = objDueIncomeSource.sourceName + " বকেয়া বাবদ আয়";
}
objDueIncomeSource.isDue = 1;
context.tblIncomeSources.Add(objDueIncomeSource);
tblPayable payableChange =
context.tblPayables.Where(ss => ss.partyId == objDueIncomeSource.partyId && ss.isActive == 1).FirstOrDefault();
payableChange.isActive = 0;
tblPayable newPayable = new tblPayable();
newPayable.ID = ++maxPayId;
newPayable.isActive = 1;
newPayable.amount = (-1) * objDueIncomeSource.amount;
newPayable.openingBalance = payableChange.openingBalance - objDueIncomeSource.amount;
newPayable.date = objDueIncomeSource.date;
newPayable.partyId = objDueIncomeSource.partyId.Value;
newPayable.incSrcId = objDueIncomeSource.ID;
context.tblPayables.Add(newPayable);
return(context.SaveChanges() > 0 ? objDueIncomeSource.ID : 0);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public bool SaveUser(tblUser user)
{
user.password = Md5.CalculateMD5Hash(user.password);
context.tblUsers.Add(user);
return(context.SaveChanges() > 0);
}
// just try to avoid opening values
public long SavePaddy(tblBuy paddyInfo)
{
try
{
long maxId = context.tblBuys.Select(p => p.ID).DefaultIfEmpty(0).Max();
paddyInfo.ID = ++maxId;
if (paddyInfo.amount > 0 || paddyInfo.labourCostPerBag > 0 || paddyInfo.transportCost > 0)
{
#region costing source
long cstId = context.tblCostingSources.Select(i => i.ID).DefaultIfEmpty(0).Max();
tblCostingSource costObj = new tblCostingSource();
costObj.ID = ++cstId;
costObj.sourceName = "ধান"; // shoul be come from commonelement
costObj.srcDescId = 23; // should be come from commonelemnt
costObj.srcDescription = "ধান ক্রয় বাবদ খরচ";
// costObj.amount = paddyInfo.amount + labCost* paddyInfo.noOfBag+ paddyInfo.transportCost ?? 0;
costObj.labourCostPerBag = paddyInfo.labourCostPerBag ?? 0;
if (paddyInfo.transportCostInclude)
{
costObj.transportCost = paddyInfo.transportCost ?? 0;
}
else
{
costObj.transportCost = 0;
}
costObj.amount = paddyInfo.amount;
costObj.date = paddyInfo.date;
costObj.partyId = paddyInfo.partyId;
costObj.buyId = paddyInfo.ID;
context.tblCostingSources.Add(costObj);
#endregion
}
#region save dues
long maxdueId = context.tblDues.Select(i => i.ID).DefaultIfEmpty(0).Max();
tblDue objDue = new tblDue();
objDue.ID = ++maxdueId;
objDue.partyId = paddyInfo.partyId;
objDue.buyId = paddyInfo.ID;
objDue.date = paddyInfo.date;
//tblDue dueItem = context.tblDues.Where(bb => bb.date <= paddyInfo.date && bb.partyId == paddyInfo.partyId).OrderByDescending(oo => oo.date).ThenByDescending(ii => ii.ID).FirstOrDefault();
//List<tblDue> dueItems = context.tblDues.Where(bb => bb.date > paddyInfo.date && bb.partyId == paddyInfo.partyId).ToList();
double?totalPr = paddyInfo.price * paddyInfo.quantityPerBag / 40 * paddyInfo.noOfBag;
var due = totalPr - paddyInfo.amount;
objDue.amount = due;
//if (dueItem == null)
//{
// objDue.openingBalance = objDue.amount;
//}
//else
//{
// objDue.openingBalance = dueItem.openingBalance + objDue.amount;
//}
//if (dueItems != null)
//{
// foreach (var item in dueItems)
// {
// item.openingBalance += objDue.amount;
// }
//}
context.tblDues.Add(objDue);
#endregion
context.tblBuys.Add(paddyInfo);
#region stock balance
STK_Balance padStk = context.STK_Balance.Where(ss => ss.stockId == paddyInfo.stockId && ss.productId == paddyInfo.productId && ss.sackWeight == paddyInfo.quantityPerBag).FirstOrDefault();
if (padStk != null)
{
padStk.sackQuantity += paddyInfo.noOfBag;
}
else
{
STK_Balance newStk = new STK_Balance();
int maxbalId = context.STK_Balance.Select(p => p.ID).DefaultIfEmpty(0).Max();
newStk.ID = ++maxbalId;
newStk.productId = paddyInfo.productId;
newStk.stockId = paddyInfo.stockId;
newStk.sackWeight = paddyInfo.quantityPerBag;
newStk.sackQuantity = paddyInfo.noOfBag;
context.STK_Balance.Add(newStk);
}
#endregion
#region stock transaction
long maxprdstkId = context.PaddyTransactions.Select(p => p.ID).DefaultIfEmpty(0).Max();
long laststkId = context.PaddyTransactions.Where(s => s.stockId == paddyInfo.stockId && s.prodId == paddyInfo.productId && s.bagWeight == paddyInfo.quantityPerBag).Select(l => l.ID).DefaultIfEmpty(0).Max();
var lastTrans = context.PaddyTransactions.Where(ll => ll.ID == laststkId).FirstOrDefault();
PaddyTransaction objStkTrans = new PaddyTransaction();
objStkTrans.ID = maxprdstkId + 1;
objStkTrans.date = paddyInfo.date;
objStkTrans.rcvQty = paddyInfo.noOfBag;
objStkTrans.releaseQty = 0;
objStkTrans.stockId = paddyInfo.stockId;
objStkTrans.prodId = paddyInfo.productId;
objStkTrans.buyId = paddyInfo.ID;
objStkTrans.bagWeight = paddyInfo.quantityPerBag;
objStkTrans.openingStock = lastTrans == null ? paddyInfo.noOfBag : lastTrans.openingStock + paddyInfo.noOfBag;
context.PaddyTransactions.Add(objStkTrans);
#endregion
#region BagTransactions
long maxBagId = context.BagTransactions.Select(b => b.ID).DefaultIfEmpty(0).Max();
if (paddyInfo.bagPrice > 0)
{
BagTransaction prevItem = context.BagTransactions.Where(bb => bb.date <= paddyInfo.date && bb.partyId == paddyInfo.partyId && (bb.rcvPrice > 0 || bb.sentPrice > 0)).OrderByDescending(oo => oo.date).ThenByDescending(ii => ii.ID).FirstOrDefault();
List <BagTransaction> nextItems = context.BagTransactions.Where(bb => bb.date > paddyInfo.date && bb.partyId == paddyInfo.partyId && (bb.rcvPrice > 0 || bb.sentPrice > 0)).ToList();
//int bagCnt = paddyInfo.noOfBag > 0 ? paddyInfo.noOfBag : 1;
double?curPriceDue = prevItem == null ? paddyInfo.noOfBag * paddyInfo.bagPrice : prevItem.priceDues + paddyInfo.noOfBag * paddyInfo.bagPrice;
BagTransaction bagTrans = new BagTransaction();
bagTrans.ID = ++maxBagId;
bagTrans.partyId = paddyInfo.partyId;
bagTrans.rcvId = paddyInfo.ID;
bagTrans.comRcvBag = paddyInfo.noOfBag;
bagTrans.rcvPrice = paddyInfo.bagPrice;
bagTrans.comSentBag = 0;
bagTrans.sentPrice = 0;
bagTrans.priceDues = curPriceDue;
bagTrans.bagDues = 0;
bagTrans.date = paddyInfo.date;
context.BagTransactions.Add(bagTrans);
if (nextItems != null)
{
foreach (var item in nextItems)
{
item.priceDues += curPriceDue;
}
}
}
else
{
BagTransaction prevItem = context.BagTransactions.Where(bb => bb.date <= paddyInfo.date && bb.partyId == paddyInfo.partyId && (bb.rcvPrice == 0 || bb.rcvPrice == null) && (bb.sentPrice == 0 || bb.sentPrice == null)).OrderByDescending(oo => oo.date).ThenByDescending(ii => ii.ID).FirstOrDefault();
List <BagTransaction> nextItems = context.BagTransactions.Where(bb => bb.date > paddyInfo.date && bb.partyId == paddyInfo.partyId && (bb.rcvPrice == 0 || bb.rcvPrice == null) && (bb.sentPrice == 0 || bb.sentPrice == null)).ToList();
int?curBagDue = prevItem == null ? paddyInfo.noOfBag : prevItem.bagDues + paddyInfo.noOfBag;
BagTransaction bagTrans = new BagTransaction();
bagTrans.ID = ++maxBagId;
bagTrans.partyId = paddyInfo.partyId;
bagTrans.rcvId = paddyInfo.ID;
bagTrans.comRcvBag = paddyInfo.noOfBag;
bagTrans.rcvPrice = 0;
bagTrans.comSentBag = 0;
bagTrans.sentPrice = 0;
bagTrans.priceDues = 0;
bagTrans.bagDues = curBagDue;
bagTrans.date = paddyInfo.date;
context.BagTransactions.Add(bagTrans);
if (nextItems != null)
{
foreach (var item in nextItems)
{
item.bagDues += curBagDue;
}
}
}
#endregion
return(context.SaveChanges() > 0 ? paddyInfo.ID : 0);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public tblSell SaveHusk(tblSell huskInfo)
{
try
{
long maxId = context.tblSells.Select(p => p.ID).DefaultIfEmpty(0).Max();
huskInfo.ID = ++maxId;
if (huskInfo.paidAmount > 0)
{
#region income source
long incId = context.tblIncomeSources.Select(i => i.ID).DefaultIfEmpty(0).Max();
tblIncomeSource incomeObj = new tblIncomeSource();
incomeObj.ID = ++incId;
incomeObj.partyId = huskInfo.partyId;
incomeObj.sourceName = "তুষ"; // shoul be come from commonelement
incomeObj.srcDescId = 21; // should be come from commonelemnt
incomeObj.description = "তুষ বিক্রয় বাবদ আয়";
incomeObj.amount = huskInfo.paidAmount;
incomeObj.date = huskInfo.date;
context.tblIncomeSources.Add(incomeObj);
#endregion
huskInfo.incSrcId = incomeObj.ID;
}
#region save payable
double?totalPr = 0;
if (huskInfo.transportCostInclude)
{
totalPr = huskInfo.noOfBag * huskInfo.unitPrice * huskInfo.quantity + huskInfo.transportCost;
}
else
{
totalPr = huskInfo.noOfBag * huskInfo.unitPrice * huskInfo.quantity;
if (huskInfo.transportCost > 0)
{
#region costing source
tblCostingSource objTblCostingSource = new tblCostingSource();
long maxCost = context.tblCostingSources.Select(i => i.ID).DefaultIfEmpty(0).Max();
objTblCostingSource.ID = ++maxCost;
objTblCostingSource.partyId = huskInfo.partyId;
objTblCostingSource.amount = Convert.ToDouble(huskInfo.transportCost);
objTblCostingSource.sourceName = "তুষ";
objTblCostingSource.srcDescription = "তুষ বিক্রয়ের পরিবহন খরচ";
objTblCostingSource.srcDescId = 21;
objTblCostingSource.date = huskInfo.date;
objTblCostingSource.sellId = huskInfo.ID;
context.tblCostingSources.Add(objTblCostingSource);
#endregion
}
}
if (totalPr > 0)
{
long maxpayId = context.tblPayables.Select(i => i.ID).DefaultIfEmpty(0).Max();
tblPayable objTblPayable = new tblPayable();
objTblPayable.ID = ++maxpayId;
objTblPayable.partyId = huskInfo.partyId;
objTblPayable.date = huskInfo.date;
objTblPayable.sellId = huskInfo.ID;
var lastPayable = context.tblPayables.Where(p => p.partyId == huskInfo.partyId && p.isActive == 1).FirstOrDefault();
var loan = totalPr - huskInfo.paidAmount;
objTblPayable.amount = loan;
if (lastPayable != null)
{
lastPayable.isActive = 0;
objTblPayable.openingBalance = objTblPayable.amount + lastPayable.openingBalance;
}
else
{
objTblPayable.openingBalance = objTblPayable.amount;
}
objTblPayable.isActive = 1;
context.tblPayables.Add(objTblPayable);
}
#endregion
context.tblSells.Add(huskInfo);
#region substract husk from stock
STK_Balance huskStk = context.STK_Balance.Where(ss => ss.stockId == huskInfo.stockId && ss.productId == huskInfo.productId).FirstOrDefault();//&& ss.sackWeight==huskInfo.quantity
if (huskStk == null)
{
var maxStkBalId = context.STK_Balance.Select(p => p.ID).DefaultIfEmpty(0).Max();
STK_Balance stkBal = new STK_Balance();
stkBal.ID = ++maxStkBalId;
stkBal.productId = huskInfo.productId;
stkBal.stockId = huskInfo.stockId;
stkBal.sackQuantity = -huskInfo.noOfBag;
context.STK_Balance.Add(stkBal);
}
else
{
huskStk.sackQuantity -= huskInfo.noOfBag;
}
#endregion
#region stock transaction
long maxprdstkId = context.STK_Transaction.Select(p => p.ID).DefaultIfEmpty(0).Max();
//long laststkId = context.STK_Transaction.Where(s => s.stockId == huskInfo.stockId && s.prodId == huskInfo.productId).Select(l => l.ID).DefaultIfEmpty(0).Max();
STK_Transaction objStkTrans = new STK_Transaction();
objStkTrans.ID = maxprdstkId + 1;
objStkTrans.date = huskInfo.date;
objStkTrans.rcvQty = 0;
objStkTrans.sellQty = huskInfo.noOfBag;
objStkTrans.stockId = huskInfo.stockId.Value;
objStkTrans.prodId = huskInfo.productId;
objStkTrans.operation = 1;
objStkTrans.sellId = huskInfo.ID;
if (huskStk == null)
{
objStkTrans.openingStock = -huskInfo.noOfBag;
}
else
{
objStkTrans.openingStock = huskStk.sackQuantity.Value;
}
//var lastTrans = context.STK_Transaction.Where(ll => ll.ID == laststkId).FirstOrDefault();
//objStkTrans.openingStock = lastTrans == null ? 0 - huskInfo.noOfBag : lastTrans.openingStock - huskInfo.noOfBag;
context.STK_Transaction.Add(objStkTrans);
#endregion
tblSell newSell = new tblSell();
newSell.ID = huskInfo.ID;
newSell.incSrcId = huskInfo.incSrcId;
return(context.SaveChanges() > 0 ? newSell : null);
}
catch (Exception exc)
{
throw new Exception(exc.Message);
}
}
public bool SaveParty(tblParty party)
{
context.tblParties.Add(party);
return(context.SaveChanges() > 0);
}