public ReportViewModel GetHollarConsumpViewModel(List <object> objLst, string startDate, string endDate, string stockId)
{
var reportViewModel = new ReportViewModel()
{
LeftMainTitle = "Johan Group",
LeftSubTitle = "IT",
Name = "Hollar Cost",
//ReportDate = DateTime.Now,
ReportLogo = "~/Content/logo.jpg",
//ReportTitle = "Retailerwise Sales Report",
ReportLanguage = "en-US",
//UserNamPrinting = UserPrinting,
Format = ReportViewModel.ReportFormat.PDF,
ViewAsAttachment = false
};
int stock = Convert.ToInt32(stockId);
STK_tblStock stk = context.STK_tblStock.Where(ss => ss.ID == stock).FirstOrDefault();
string stkName = stk == null ? "উভয় মিল" : stk.stockName;
//adding the dataset information to the report view model object
reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet()
{
DataSetData = objLst, DatasetName = "datset_HollarConsump"
});
reportViewModel.ReportParams.Add(new ReportParameter("startDate", startDate));
reportViewModel.ReportParams.Add(new ReportParameter("endDate", endDate));
reportViewModel.ReportParams.Add(new ReportParameter("stock", stkName));
return(reportViewModel);
}
public ReportViewModel GetRepoertViewModel(List <object> objLst, int stockId, int productId, string fromDate, string toDate)
{
var reportViewModel = new ReportViewModel()
{
LeftMainTitle = "Johan Group",
LeftSubTitle = "IT",
Name = "Stock Report",
//ReportDate = DateTime.Now,
ReportLogo = "~/Content/logo.jpg",
//ReportTitle = "Retailerwise Sales Report",
ReportLanguage = "en-US",
//UserNamPrinting = UserPrinting,
Format = ReportViewModel.ReportFormat.PDF,
ViewAsAttachment = false
};
STK_tblStock stock = context.STK_tblStock.Where(pp => pp.ID == stockId).FirstOrDefault();
tblProduct product = context.tblProducts.Where(pp => pp.ID == productId).FirstOrDefault();
string sname = stock.stockName ?? "N/A";
string pname = product.productName ?? "N/A";
//adding the dataset information to the report view model object
reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet()
{
DataSetData = objLst, DatasetName = "dataSet_GetStockInfo"
});
reportViewModel.ReportParams.Add(new ReportParameter("stockName", sname));
reportViewModel.ReportParams.Add(new ReportParameter("productName", pname));
reportViewModel.ReportParams.Add(new ReportParameter("startDate", fromDate));
reportViewModel.ReportParams.Add(new ReportParameter("endDate", toDate));
return(reportViewModel);
}
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 List <STK_tblStock> GetStock(STK_tblStock stk)
{
List <STK_tblStock> stkList = null;
if (stk == null)
{
stkList = context.STK_tblStock.ToList();
}
else if (stk.ID > 0)
{
stkList = context.STK_tblStock.Where(x => x.ID == stk.ID).ToList();
}
return(stkList);
}
public ReportViewModel GetPaddyStockViewModel(List <object> objLst, int stockId, int productId, string fromDate, string toDate)
{
var reportViewModel = new ReportViewModel()
{
LeftMainTitle = "Johan Group",
LeftSubTitle = "IT",
Name = "Stock Report",
//ReportDate = DateTime.Now,
ReportLogo = "~/Content/logo.jpg",
//ReportTitle = "Retailerwise Sales Report",
ReportLanguage = "en-US",
//UserNamPrinting = UserPrinting,
Format = ReportViewModel.ReportFormat.PDF,
ViewAsAttachment = false
};
tblProduct product = context.tblProducts.Where(pp => pp.ID == productId).FirstOrDefault();
string pname = product.productName ?? "N/A";
STK_tblStock stk = context.STK_tblStock.Where(ss => ss.ID == stockId).FirstOrDefault();
string stockName = stk.stockName ?? "N/A";
DateTime fdate = Convert.ToDateTime(fromDate);
DateTime tdate = Convert.ToDateTime(toDate);
var result = context.func_paddyparta(stockId, productId, fdate, tdate).ToList();
var prodStocks = context.STK_Balance.Where(ss => ss.stockId == stockId && ss.productId == productId).ToList();
double totBag = 0, totQty = 0;
foreach (var item in prodStocks)
{
totBag += item.sackQuantity ?? 0;
totQty += (item.sackQuantity * item.sackWeight) ?? 0;
}
double avgparta = result.Count > 0 ? result[0].Value : 0;
//adding the dataset information to the report view model object
reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet()
{
DataSetData = objLst, DatasetName = "dataSet_PaddyStockInfo"
});
reportViewModel.ReportParams.Add(new ReportParameter("stockName", stockName));
reportViewModel.ReportParams.Add(new ReportParameter("productName", pname));
reportViewModel.ReportParams.Add(new ReportParameter("startDate", fromDate));
reportViewModel.ReportParams.Add(new ReportParameter("endDate", toDate));
reportViewModel.ReportParams.Add(new ReportParameter("avgParta", avgparta.ToString())); //"#.##"
reportViewModel.ReportParams.Add(new ReportParameter("totBag", totBag.ToString())); //"#.##"
reportViewModel.ReportParams.Add(new ReportParameter("totQty", totQty.ToString())); //"#.##"
return(reportViewModel);
}
public JsonResult EditStock([System.Web.Http.FromBody] STK_tblStock stk)
{
if (Session["role"] == null)
{
Session["userId"] = null;
Session["role"] = null;
return(Json(false, JsonRequestBehavior.AllowGet));
}
else if (Session["role"].ToString() == "Super Admin")
{
return(Json(stkRepository.EditStock(stk), JsonRequestBehavior.AllowGet));
}
else
{
Session["userId"] = null;
Session["role"] = null;
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveStock(STK_tblStock stk)
{
if (Session["role"] == null)
{
Session["userId"] = null;
Session["role"] = null;
return(Json(false, JsonRequestBehavior.AllowGet));
}
else if (Session["role"].ToString() == "Admin" || Session["role"].ToString() == "Super Admin")
{
return(Json(stkRepository.SaveStock(stk), JsonRequestBehavior.AllowGet));
}
else
{
Session["userId"] = null;
Session["role"] = null;
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public List <object> GetHollarConsumpRpt(string starDate, string endDate, string stockId)
{
DateTime fromD = Convert.ToDateTime(starDate);
DateTime toD = Convert.ToDateTime(endDate);
int stock = Convert.ToInt32(stockId);
STK_tblStock hollar = context.STK_tblStock.Where(ss => ss.stockName == "হোলার").FirstOrDefault();
var hollarConsumpLst = from paddTrans in context.PaddyTransactions.Where(cc => cc.stockId == hollar.ID && cc.date >= fromD && cc.date <= toD && (stock == 0 || cc.fromStock == stock)) // here 5 is id of hollar
join prod in context.tblProducts on paddTrans.prodId equals prod.ID
//join stk in context.STK_tblStock on paddTrans.fromStock equals stk.ID
select new
{
paddTrans.date,
paddTrans.serial,
paddTrans.bagWeight,
paddTrans.rcvQty,
paddTrans.millCost,
prod.productName
//stk.stockName
};
return(hollarConsumpLst.ToList <object>());
}
public bool SaveStock(STK_tblStock stk)
{
stk.createDate = DateTime.Now;
context.STK_tblStock.Add(stk);
return(context.SaveChanges() > 0);
}
// [Authorize(Roles = "Admin,Super Admin,User")]
public JsonResult GetStock(STK_tblStock stk)
{
var stkList = stkRepository.GetStock(stk);
return(Json(stkList, JsonRequestBehavior.AllowGet));
}
