//
// GET: /StockItemPurchase/Edit/5
public ActionResult Edit(int id, int rowid)
{
Session["rowid"] = rowid;
EHMSEntities ent = new EHMSEntities();
StockItemPurchaseModel model = new StockItemPurchaseModel();
var obj = ent.StockItemPurchases.Where(x => x.ItemPurchaseId == id).SingleOrDefault();
AutoMapper.Mapper.Map(obj, model);
var PurchaseDetailList = ent.StockItemPurchaseDetails.Where(x => x.ItemPurchaseId == id).ToList();
foreach (var item in PurchaseDetailList)
{
StockItemEntry itementry = new StockItemEntry();
itementry.StockCategoryId = item.SetupStockItemEntry.SetupStockCategory.StockCategoryID;
itementry.StockSubCategoryId = item.SetupStockItemEntry.SetupStockSubCategory.StockSubCategoryID;
itementry.Quantity = item.Quantity;
itementry.Rate = item.Rate;
itementry.StockItemEntryId = item.StockItemEntryId;
var orderobj = (from sip in ent.StockItemPurchases
join spo in ent.StockPurchaseOrders
on sip.ItemOrderId equals spo.PurchaseOrderNo
join spod in ent.StockPurchaseOrderDetails
on spo.PurchaseOrderId equals spod.PurchaseOrderId
where sip.ItemPurchaseId == id && spod.ItemId == item.StockItemEntryId
select spod).SingleOrDefault();
itementry.QuotQty = orderobj.Quantity;
itementry.QuotRate = orderobj.QuotationPrice;
model.StockItemEntryList.Add(itementry);
}
return(View(model));
}
public StockItemPurchaseModel GetPurchaseVoucherDetails(int PurchaseNo)
{
StockItemPurchaseModel model = new StockItemPurchaseModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemPurchaseDetails.Where(x => x.ItemPurchaseId == PurchaseNo).ToList();
foreach (var item in result)
{
var ViewModel = new StockItemEntry()
{
StockCategoryId = HospitalManagementSystem.Utility.GetCategoryIdFromItemId(item.StockItemEntryId),
Quantity = item.Quantity,
Rate = item.Rate,
StockItemEntryId = item.StockItemEntryId
};
model.StockItemEntryList.Add(ViewModel);
}
var resultModel = ent.StockItemPurchases.Where(x => x.ItemPurchaseId == PurchaseNo);
model.TotalAmount = resultModel.FirstOrDefault().TotalAmount;
model.StockSupplierId = resultModel.FirstOrDefault().StockSupplierId;
model.CreatedDate = resultModel.FirstOrDefault().CreatedDate;
model.ItemPurchaseId = PurchaseNo;
model.Amount = resultModel.FirstOrDefault().Amount;
model.Discount = resultModel.FirstOrDefault().Discount;
model.VatAmount = resultModel.FirstOrDefault().VatAmount;
}
return(model);
}
public DemandMasterModel GetDemandForEdit(int id)
{
EHMSEntities ent = new EHMSEntities();
DemandMasterModel model = new DemandMasterModel();
var obj = ent.ItemDemandMasters.Where(x => x.ItemDemandID == id).SingleOrDefault();
AutoMapper.Mapper.Map(obj, model);
var demandDetails = ent.ItemDemandDetails.Where(x => x.ItemDemandID == id).ToList();
foreach (var item in demandDetails)
{
if (item.DispatchStatus == false)
{
StockItemEntry itemEntry = new StockItemEntry();
itemEntry.StockCategoryId = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault().StockCategoryId;
itemEntry.StockSubCategoryId = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault().StockSubCategoryId;
itemEntry.StockItemEntryId = item.ItemID;
itemEntry.Quantity = item.QuantityDemand;
model.StockItemEntryList.Add(itemEntry);
}
}
return(model);
}
public ActionResult SearchOrder(int id)
{
EHMSEntities ent = new EHMSEntities();
StockItemPurchaseModel model = new StockItemPurchaseModel();
decimal v = 0;
var list = (from po in ent.StockPurchaseOrders
join pd in ent.StockPurchaseOrderDetails
on po.PurchaseOrderId equals pd.PurchaseOrderId
where po.PurchaseOrderId == id && pd.Status == true
select new { po, pd }).ToList();
foreach (var item in list)
{
StockItemEntry itementry = new StockItemEntry();
itementry.StockCategoryId = item.pd.SetupStockItemEntry.SetupStockCategory.StockCategoryID;
itementry.StockSubCategoryId = item.pd.SetupStockItemEntry.SetupStockSubCategory.StockSubCategoryID;
itementry.QuotQty = Convert.ToDecimal(item.pd.Quantity.ToString().Substring(0, item.pd.Quantity.ToString().IndexOf(".")));
try
{
v = (from sip in ent.StockItemPurchases
join sipd in ent.StockItemPurchaseDetails
on sip.ItemPurchaseId equals sipd.ItemPurchaseId
where sip.ItemOrderId == item.po.PurchaseOrderNo
where sipd.StockItemEntryId == item.pd.ItemId
select sipd
).Sum(x => x.Quantity);
}
catch
{
v = 0;
}
itementry.QuotQty = itementry.QuotQty - v;
itementry.QuotRate = item.pd.QuotationPrice;
itementry.StockItemEntryId = item.pd.ItemId;
model.StockItemEntryList.Add(itementry);
}
try
{
model.StockSupplierId = list[0].pd.SupplierId;
model.ItemOrderId = list[0].po.PurchaseOrderNo;
}
catch
{
TempData["message"] = "Items not available!!";
return(RedirectToAction("Index", "StockPurchaseOrder"));
}
try
{
string num = ent.StockItemPurchases.Max(x => x.StockEntryNo);
string[] nums = num.Split('E');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.StockEntryNo = "SE" + rcnum.RecNumGen();
}
catch
{
model.StockEntryNo = "SE001";
}
return(View("Create", model));
}
