public List <tblSell> GetHuskInfo()
{
var data = context.sp_getProductSellInfo(0, 4);// 4 is id of husk
List <tblSell> sells = new List <tblSell>();
foreach (var item in data.Take(100))
{
tblSell sellobj = new tblSell();
sellobj.ID = item.ID;
sellobj.date = item.date;
sellobj.noOfBag = item.noOfBag;
sellobj.partyId = item.partyId;
sellobj.partyName = item.partyName;
sellobj.productId = item.productId;
sellobj.productName = item.productName;
sellobj.quantity = item.quantity;
sellobj.stockId = item.stockId;
sellobj.stockName = item.stockName;
sellobj.unit = item.unit;
sellobj.unitPrice = item.unitPrice;
sellobj.paidAmount = Convert.ToDouble(item.amount);
sellobj.transportCost = item.transportCost;
sellobj.truckNumber = item.truckNumber;
sellobj.description = item.description;
sellobj.incSrcId = item.incSrcId;
sells.Add(sellobj);
}
//List<tblLoanar> results = new List<tblLoanar>();
//foreach (var item in loaners)
//{
// results.Add(new tblParty() { ID=item.ID, name=item.name, contactNo=item.contactNo, area=item.area,
// district=item.district, zoneId=item.zoneId, productId=item.productId, isCashParty=item.isCashParty});
//}
return(sells);
}
public List <object> GetHuskIncomeRpt(tblSell huskRpt)
{
int parentId = 4;// 4 for husk
var huskInfoLst = context.sp_GetHuskIncWithd(parentId, huskRpt.fromDate, huskRpt.toDate);
return(huskInfoLst.ToList <object>());
}
public List <object> GetRiceInfoRpt(tblSell riceRpt)
{
int parentId = 2;// 2 for rice
var riceInfoLst = context.sp_GetProductInfo(riceRpt.partyId, parentId, riceRpt.fromDate, riceRpt.toDate).OrderBy(ss => ss.date);
return(riceInfoLst.ToList <object>());
}
//[Authorize(Roles = "Admin,Super Admin,User")]
public ActionResult Income(string from, string to)
{
try
{
string path = Path.Combine(Server.MapPath("~/Reports"), "huskIncWithd.rdlc");
if (!System.IO.File.Exists(path) || string.IsNullOrEmpty(from) || string.IsNullOrEmpty(to))
{
return(View("rptHuskIncome"));
}
tblSell huskRpt = new tblSell();
huskRpt.fromDate = Convert.ToDateTime(from);
huskRpt.toDate = Convert.ToDateTime(to);
List <object> objLst = huskSellRepository.GetHuskIncomeRpt(huskRpt);
var reportViewModel = huskSellRepository.GetIncomeViewModel(objLst, from, to);
reportViewModel.FileName = path;
var renderedBytes = reportViewModel.RenderReport();
if (reportViewModel.ViewAsAttachment)
{
Response.AddHeader("content-disposition", reportViewModel.ReporExportFileName);
}
return(File(renderedBytes, reportViewModel.LastmimeType));
}
catch (Exception ex)
{
throw ex;
}
}
public List <tblSell> GetParticleInfo()
{
var data = context.sp_getProductSellInfo(0, 11);// 11 is id of Particle
List <tblSell> sells = new List <tblSell>();
foreach (var item in data.Take(100))
{
tblSell sellobj = new tblSell();
sellobj.ID = item.ID;
sellobj.date = item.date;
sellobj.noOfBag = item.noOfBag;
sellobj.partyId = item.partyId;
sellobj.partyName = item.partyName;
sellobj.productId = item.productId;
sellobj.productName = item.productName;
sellobj.quantity = item.quantity;
sellobj.stockId = item.stockId;
sellobj.stockName = item.stockName;
sellobj.unit = item.unit;
sellobj.unitPrice = item.unitPrice;
sellobj.incSrcId = item.incSrcId;
sells.Add(sellobj);
}
return(sells);
}
//[Authorize(Roles = "Admin,Super Admin,User")]
public ActionResult PreviewCom(string partyId, string from, string to)
{
try
{
string path = Path.Combine(Server.MapPath("~/Reports"), "riceInfoCom.rdlc");
if (!System.IO.File.Exists(path) || string.IsNullOrEmpty(partyId) || string.IsNullOrEmpty(from) || string.IsNullOrEmpty(to))
{
return(View("rptRiceInfo"));
}
int pId = Convert.ToInt32(partyId);
tblSell riceRpt = new tblSell();
riceRpt.partyId = pId;
riceRpt.fromDate = Convert.ToDateTime(from);
riceRpt.toDate = Convert.ToDateTime(to);
List <object> objLst = riceRepository.GetRiceInfoRpt(riceRpt);
var reportViewModel = riceRepository.GetRepoertViewModel(objLst, pId, from, to);
reportViewModel.FileName = path;
var renderedBytes = reportViewModel.RenderReport();
if (reportViewModel.ViewAsAttachment)
{
Response.AddHeader("content-disposition", reportViewModel.ReporExportFileName);
}
return(File(renderedBytes, reportViewModel.LastmimeType));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult SaveHuskInfo(tblSell riceInfo)
{
if (Session["role"] == null)
{
Session["userId"] = null;
Session["role"] = null;
return(Json(null, JsonRequestBehavior.AllowGet));
}
else if (Session["role"].ToString() == "Admin" || Session["role"].ToString() == "Super Admin")
{
return(Json(huskSellRepository.SaveHusk(riceInfo), JsonRequestBehavior.AllowGet));
}
else
{
Session["userId"] = null;
Session["role"] = null;
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditRiceInfo(tblSell riceInfo)
{
if (Session["role"] == null)
{
Session["userId"] = null;
Session["role"] = null;
return(Json(null, JsonRequestBehavior.AllowGet));
}
else if (Session["role"].ToString() == "Super Admin")
{
return(Json(riceRepository.EditRiceSell(riceInfo), JsonRequestBehavior.AllowGet));
}
else
{
Session["userId"] = null;
Session["role"] = null;
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
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 tblSell EditHuskInfo(tblSell huskInfo)
{
try
{
// into payable tabel column amount is 'how many amount is added with opening balance, not paidamount'
var orgHuskSell = context.tblSells.Where(ss => ss.ID == huskInfo.ID).FirstOrDefault();
#region edit husk stock
STK_Balance orgStk = context.STK_Balance.Where(ss => ss.stockId == orgHuskSell.stockId && ss.productId == orgHuskSell.productId).FirstOrDefault();// && ss.sackWeight == particleInfo.quantity
orgStk.sackQuantity += orgHuskSell.noOfBag;
STK_Balance newStk = context.STK_Balance.Where(ss => ss.stockId == huskInfo.stockId && ss.productId == huskInfo.productId).FirstOrDefault();// && ss.sackWeight == particleInfo.quantity
if (newStk == null)
{
STK_Balance stkBal = new STK_Balance();
var maxStkBal = context.STK_Balance.Select(p => p.ID).DefaultIfEmpty(0).Max();
stkBal.ID = ++maxStkBal;
stkBal.productId = huskInfo.productId;
stkBal.stockId = huskInfo.stockId;
stkBal.sackQuantity = -huskInfo.noOfBag;
context.STK_Balance.Add(stkBal);
}
else
{
newStk.sackQuantity -= huskInfo.noOfBag;
}
#endregion
double?totalPr = 0;
if (huskInfo.transportCostInclude)
{
totalPr = huskInfo.noOfBag * huskInfo.unitPrice * huskInfo.quantity + huskInfo.transportCost;
}
else
{
totalPr = huskInfo.noOfBag * huskInfo.unitPrice * huskInfo.quantity;
}
#region costing source
tblCostingSource objCostingSource = context.tblCostingSources.Where(cc => cc.sellId == huskInfo.ID).FirstOrDefault();
if (huskInfo.transportCostInclude && objCostingSource != null)
{
context.tblCostingSources.Remove(objCostingSource);
}
else if (!huskInfo.transportCostInclude && objCostingSource == null)
{
tblCostingSource newCost = new tblCostingSource();
long maxCost = context.tblCostingSources.Select(i => i.ID).DefaultIfEmpty(0).Max();
newCost.ID = ++maxCost;
newCost.amount = Convert.ToDouble(huskInfo.transportCost);
newCost.partyId = huskInfo.partyId;
newCost.sourceName = "তুষ";
newCost.srcDescription = "তুষ বিক্রয়ে পরিবহন খরচ";
newCost.srcDescId = 21;
newCost.date = huskInfo.date;
newCost.sellId = huskInfo.ID;
context.tblCostingSources.Add(newCost);
}
else if (!huskInfo.transportCostInclude && objCostingSource != null)
{
objCostingSource.amount = Convert.ToDouble(huskInfo.transportCost);
objCostingSource.date = huskInfo.date;
}
#endregion
#region edit or insert income source
var orgIncomeSrc = context.tblIncomeSources.Where(ii => ii.ID == huskInfo.incSrcId).FirstOrDefault();
if (orgIncomeSrc != null)
{
orgIncomeSrc.amount = huskInfo.paidAmount;
orgIncomeSrc.date = huskInfo.date;
orgIncomeSrc.partyId = huskInfo.partyId;
}
else if (orgIncomeSrc == null && huskInfo.paidAmount > 0)
{
long incId = context.tblIncomeSources.Select(i => i.ID).DefaultIfEmpty(0).Max();
tblIncomeSource incomeObj = new tblIncomeSource();
incomeObj.ID = ++incId;
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;
incomeObj.partyId = huskInfo.partyId;
context.tblIncomeSources.Add(incomeObj);
orgHuskSell.incSrcId = incomeObj.ID;
}
#endregion
#region edit payable
var orgPayable = context.tblPayables.Where(ss => ss.sellId == huskInfo.ID).FirstOrDefault();
//long lastpayId = context.tblPayables.Where(s => s.partyId == particleInfo.partyId).Select(l => l.ID).DefaultIfEmpty(0).Max();
//var lastPayable = context.tblPayables.Where(pp => pp.ID == lastpayId).FirstOrDefault();
if (orgPayable != null)
{
double?difference = totalPr - huskInfo.paidAmount - orgPayable.amount;
orgPayable.openingBalance = orgPayable.openingBalance + difference;
orgPayable.amount = totalPr - huskInfo.paidAmount;
var nextPayables = context.tblPayables.Where(pp => pp.partyId == huskInfo.partyId && pp.ID > orgPayable.ID);
foreach (var item in nextPayables)
{
item.openingBalance = item.openingBalance + difference;
}
}
else if (orgPayable == null && 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
#region edit stock transaction
var orgStkTrans = context.STK_Transaction.Where(ss => ss.sellId == orgHuskSell.ID).FirstOrDefault();
double diff = orgStkTrans.sellQty.Value - huskInfo.noOfBag;
orgStkTrans.openingStock = orgStkTrans.openingStock + orgStkTrans.sellQty.Value;
orgStkTrans.date = huskInfo.date;
orgStkTrans.rcvQty = 0;
orgStkTrans.sellQty = huskInfo.noOfBag;
orgStkTrans.stockId = huskInfo.stockId.Value;
orgStkTrans.prodId = huskInfo.productId;
orgStkTrans.operation = 2;
orgStkTrans.openingStock = orgStkTrans.openingStock - huskInfo.noOfBag;
var nextStkTrans = context.STK_Transaction.Where(ss => ss.ID > orgStkTrans.ID && ss.prodId == orgStkTrans.prodId && ss.stockId == orgStkTrans.stockId);
foreach (var item in nextStkTrans)
{
item.openingStock += diff;
}
#endregion
#region edit tblsell
orgHuskSell.productId = huskInfo.productId;
orgHuskSell.productName = huskInfo.productName;
orgHuskSell.noOfBag = huskInfo.noOfBag;
orgHuskSell.paidAmount = huskInfo.paidAmount;
orgHuskSell.partyId = huskInfo.partyId;
orgHuskSell.partyName = huskInfo.partyName;
orgHuskSell.quantity = huskInfo.quantity;
orgHuskSell.stockId = huskInfo.stockId;
orgHuskSell.stockName = huskInfo.stockName;
orgHuskSell.unit = huskInfo.unit;
orgHuskSell.unitPrice = huskInfo.unitPrice;
orgHuskSell.transportCost = huskInfo.transportCost;
#endregion
tblSell newSell = new tblSell();
newSell.ID = huskInfo.ID;
newSell.incSrcId = huskInfo.incSrcId;
return(context.SaveChanges() > 0 ? newSell : null);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <object> GetParticleGeneralRpt(tblSell particleRpt)
{
var particlegenLst = context.sp_rptParticleGeneral(particleRpt.fromDate, particleRpt.toDate);
return(particlegenLst.ToList <object>());
}
public List <object> GetDailySellInfoRpt(tblSell dailySellRpt)
{
var dailySellInfoLst = context.sp_GetDailySellInfo(dailySellRpt.parentProd, dailySellRpt.toDate);
return(dailySellInfoLst.ToList <object>());
}
