//
// GET: /StockItemPurchase/Details/5
public ActionResult Details(int id, int rowid)
{
Session["rowid"] = rowid;
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
model.ItemPurchaseDetailList = pro.GetPurchaseDetail(id);
return(View(model.ItemPurchaseDetailList));
}
public ActionResult Report(int id)
{
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
EHMSEntities ent = new EHMSEntities();
var objpurchase = (from pm in ent.StockItemPurchases
join po in ent.StockPurchaseOrders on
pm.ItemOrderId equals po.PurchaseOrderNo
where pm.ItemPurchaseId == id
select new { pm, po }).SingleOrDefault();
ViewBag.purodno = objpurchase.po.PurchaseOrderNo;
ViewBag.billno = objpurchase.pm.ItemBillNo;
ViewBag.seno = objpurchase.pm.StockEntryNo;
ViewBag.sup = objpurchase.pm.StockSupplierId;
ViewBag.poid = objpurchase.po.PurchaseOrderId;
model.ItemPurchaseDetailList = new List <StockItemPurchaseDetailModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemPurchaseDetail>, IEnumerable <StockItemPurchaseDetailModel> >(ent.StockItemPurchaseDetails).Where(x => x.ItemPurchaseId == id));
return(View(model));
}
public ActionResult SupplierWiseReport(string fromdate, string todate, string seno, int?supplier)
{
EHMSEntities ent = new EHMSEntities();
List <StockItemPurchaseDetailModel> modelllist = new List <StockItemPurchaseDetailModel>();
if (seno == "" && supplier == null && (fromdate == "" || todate == ""))
{
var list = (from ip in ent.StockItemPurchases
join ipd in ent.StockItemPurchaseDetails
on ip.ItemPurchaseId equals ipd.ItemPurchaseId
where ip.Status == true
select new { ip, ipd }).ToList();
foreach (var item in list)
{
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
model.StockItemEntryId = item.ipd.StockItemEntryId;
model.Quantity = item.ipd.Quantity;
model.Rate = item.ipd.Rate;
model.TotalAmount = item.ipd.Quantity * item.ipd.Rate;
model.SupplierId = item.ipd.SupplierId;
model.SeNo = item.ip.StockEntryNo;
model.PurchaseDate = item.ip.CreatedDate.ToShortDateString();
modelllist.Add(model);
}
}
else if (fromdate != "" && todate != "")
{
DateTime fd = Convert.ToDateTime(fromdate).AddDays(-1);
DateTime td = Convert.ToDateTime(todate).AddDays(1);
var list = (from ip in ent.StockItemPurchases
join ipd in ent.StockItemPurchaseDetails
on ip.ItemPurchaseId equals ipd.ItemPurchaseId
where ip.Status == true
where ip.CreatedDate >= fd && ip.CreatedDate <= td
select new { ip, ipd }).ToList();
foreach (var item in list)
{
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
model.StockItemEntryId = item.ipd.StockItemEntryId;
model.Quantity = item.ipd.Quantity;
model.Rate = item.ipd.Rate;
model.TotalAmount = item.ipd.Quantity * item.ipd.Rate;
model.SupplierId = item.ipd.SupplierId;
model.SeNo = item.ip.StockEntryNo;
model.PurchaseDate = item.ip.CreatedDate.ToShortDateString();
modelllist.Add(model);
}
}
else if (seno != "")
{
var list = (from ip in ent.StockItemPurchases
join ipd in ent.StockItemPurchaseDetails
on ip.ItemPurchaseId equals ipd.ItemPurchaseId
where ip.Status == true
where ip.StockEntryNo == seno
select new { ip, ipd }).ToList();
foreach (var item in list)
{
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
model.StockItemEntryId = item.ipd.StockItemEntryId;
model.Quantity = item.ipd.Quantity;
model.Rate = item.ipd.Rate;
model.TotalAmount = item.ipd.Quantity * item.ipd.Rate;
model.SupplierId = item.ipd.SupplierId;
model.SeNo = item.ip.StockEntryNo;
model.PurchaseDate = item.ip.CreatedDate.ToShortDateString();
modelllist.Add(model);
}
}
else if (supplier != null)
{
var list = (from ip in ent.StockItemPurchases
join ipd in ent.StockItemPurchaseDetails
on ip.ItemPurchaseId equals ipd.ItemPurchaseId
where ip.Status == true
where ip.StockSupplierId == supplier
select new { ip, ipd }).ToList();
foreach (var item in list)
{
StockItemPurchaseDetailModel model = new StockItemPurchaseDetailModel();
model.StockItemEntryId = item.ipd.StockItemEntryId;
model.Quantity = item.ipd.Quantity;
model.Rate = item.ipd.Rate;
model.TotalAmount = item.ipd.Quantity * item.ipd.Rate;
model.SupplierId = item.ipd.SupplierId;
model.SeNo = item.ip.StockEntryNo;
model.PurchaseDate = item.ip.CreatedDate.ToShortDateString();
modelllist.Add(model);
}
}
return(View(modelllist));
}
