public ActionResult Create(int?id)
{
EHMSEntities ent = new EHMSEntities();
StockPurchaseOrderModel model = new StockPurchaseOrderModel();
try
{
var obj = ent.StockPurchaseOrders.Where(x => x.PurchaseOrderId == ent.StockPurchaseOrders.Max(y => y.PurchaseOrderId)).SingleOrDefault();
string[] nums = obj.PurchaseOrderNo.Split('O');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.PurchaseOrderNo = "PO" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.PurchaseOrderNo = "PO001";
}
model.DemandId = (int)id;
var demandlist = ent.ItemDemandDetails.Where(x => x.ItemDemandID == id).ToList();
foreach (var item in demandlist)
{
StockPurchaseItemEntry itementry = new StockPurchaseItemEntry();
try
{
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;
}
catch { }
model.StockPurchaseItemEntryList.Add(itementry);
}
return(View(model));
}
public ActionResult Create(StockPurchaseOrderModel model)
{
StockPurchaseOrderProvider pro = new StockPurchaseOrderProvider();
if (model.StockPurchaseItemEntryList == null || model.StockPurchaseItemEntryList.Count == 0)
{
TempData["message"] = "Add Purchase Items!";
return(View(model));
}
if (ModelState.IsValid)
{
try
{
// TODO: Add insert logic here
int i = pro.Insert(model);
TempData["message"] = "Successfully Saved!";
model.PurchaseOrderId = i;
return(RedirectToAction("OrderReport", model));
}
catch
{
return(View(model));
}
}
else
{
return(View(model));
}
}
public ActionResult Print(int id)
{
EHMSEntities ent = new EHMSEntities();
StockPurchaseOrderModel model = new StockPurchaseOrderModel();
var obj = ent.StockPurchaseOrders.Where(x => x.PurchaseOrderId == id).SingleOrDefault();
AutoMapper.Mapper.Map(obj, model);
return(RedirectToAction("OrderReport", model));
}
public ActionResult OrderReport(StockPurchaseOrderModel model)
{
StockPurchaseOrderProvider pro = new StockPurchaseOrderProvider();
model.StockPurchaseOrderDetailsModel = new StockPurchaseOrderDetailsModel();
model.StockPurchaseOrderDetailsModel.StockPurchaseOrderDetailsModelList = new List <StockPurchaseOrderDetailsModel>();
model.StockPurchaseOrderDetailsModel.StockPurchaseOrderDetailsModelList = pro.GetPurchaseDetail(model.PurchaseOrderId);
return(View(model));
}
//
// GET: /StockPurchaseOrder/
//public ActionResult Index()
//{
// return View();
//}
public ActionResult Index()
{
ViewBag.rowid = Session["rowid"];
Session["rowid"] = null;
StockPurchaseOrderModel model = new StockPurchaseOrderModel();
StockPurchaseOrderProvider pro = new StockPurchaseOrderProvider();
model.StockPurchaseOrderModelList = pro.GetList();
return(View(model));
}
public ActionResult CreateView()
{
EHMSEntities ent = new EHMSEntities();
StockPurchaseOrderModel model = new StockPurchaseOrderModel();
if (ent.StockPurchaseOrders.Any())
{
model.PurchaseOrderNo = "PO" + ent.StockPurchaseOrders.Max(x => x.PurchaseOrderId + 1);
}
else
{
model.PurchaseOrderNo = "PO1";
}
model.StockPurchaseItemEntryList = Session["purchaseitementrylist"] as List <StockPurchaseItemEntry>;
Session["purchaseitementrylist"] = null;
return(View("Create", model));
}
public ActionResult Edit(int id, StockPurchaseOrderModel model)
{
StockPurchaseOrderProvider pro = new StockPurchaseOrderProvider();
//if (model.StockPurchaseItemEntryList == null || model.StockPurchaseItemEntryList.Count == 0)
//{
// TempData["message"] = "Add Purchase Items!";
// return View(model);
//}
if (ModelState.IsValid)
{
// TODO: Add update logic here
pro.Udate(id, model);
TempData["message"] = "Successfully Updated!";
return(RedirectToAction("Index"));
}
return(View(model));
}
public void Udate(int id, StockPurchaseOrderModel model)
{
EHMSEntities ent = new EHMSEntities();
var obj = ent.StockPurchaseOrders.Where(x => x.PurchaseOrderId == id).SingleOrDefault();
model.PurchaseOrderId = obj.PurchaseOrderId;
AutoMapper.Mapper.Map(model, obj);
obj.Status = true;
obj.CreatedBy = 1;
obj.CreatedDate = DateTime.Now;
ent.Entry(obj).State = System.Data.EntityState.Modified;
ent.SaveChanges();
foreach (var item in ent.StockPurchaseOrderDetails.Where(x => x.PurchaseOrderId == model.PurchaseOrderId).ToList())
{
ent.StockPurchaseOrderDetails.Remove(item);
ent.SaveChanges();
}
try
{
foreach (var item in model.StockPurchaseItemEntryList)
{
StockPurchaseOrderDetail PurchaseDetail = new StockPurchaseOrderDetail();
PurchaseDetail.PurchaseOrderId = id;
PurchaseDetail.ItemId = item.StockItemEntryId;
PurchaseDetail.Quantity = Convert.ToInt32(item.Quantity);
PurchaseDetail.QuotationPrice = item.QuatationPrice;
PurchaseDetail.TotalAmount = item.Quantity * item.QuatationPrice;
PurchaseDetail.SupplierId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.ManufactorerId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.VendorId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.Status = true;
ent.StockPurchaseOrderDetails.Add(PurchaseDetail);
}
}
catch
{
}
ent.SaveChanges();
}
public int Insert(StockPurchaseOrderModel model)
{
EHMSEntities ent = new EHMSEntities();
var obj = AutoMapper.Mapper.Map <StockPurchaseOrderModel, StockPurchaseOrder>(model);
obj.Status = true;
obj.CreatedBy = 1;
obj.CreatedDate = DateTime.Now;
ent.StockPurchaseOrders.Add(obj);
ent.SaveChanges();
int id = ent.StockPurchaseOrders.Where(x => x.PurchaseOrderId == ent.StockPurchaseOrders.Max(y => y.PurchaseOrderId)).SingleOrDefault().PurchaseOrderId;
foreach (var item in model.StockPurchaseItemEntryList)
{
decimal VatAmountTotal = Convert.ToDecimal(0);
if (item.VatAmount > 0)
{
VatAmountTotal = ((item.QuatationPrice * item.Quantity) * item.VatAmount / 100);
}
StockPurchaseOrderDetail PurchaseDetail = new StockPurchaseOrderDetail();
PurchaseDetail.PurchaseOrderId = id;
PurchaseDetail.ItemId = item.StockItemEntryId;
PurchaseDetail.Quantity = Convert.ToInt32(item.Quantity);
PurchaseDetail.QuotationPrice = item.QuatationPrice;
PurchaseDetail.TotalAmount = (item.Quantity * item.QuatationPrice) + VatAmountTotal;
PurchaseDetail.SupplierId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.ManufactorerId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.VendorId = model.StockPurchaseOrderDetailsModel.SupplierId;
PurchaseDetail.Status = true;
PurchaseDetail.VatAmount = ((item.QuatationPrice * item.Quantity) * item.VatAmount / 100);
ent.StockPurchaseOrderDetails.Add(PurchaseDetail);
}
ent.SaveChanges();
return(obj.PurchaseOrderId);
}
public ActionResult Edit(int id)
{
//Session["rowid"] = rowid;
EHMSEntities ent = new EHMSEntities();
StockPurchaseOrderModel model = new StockPurchaseOrderModel();
var obj = ent.StockPurchaseOrders.Where(x => x.PurchaseOrderId == id).SingleOrDefault();
AutoMapper.Mapper.Map(obj, model);
var PurchaseDetailList = ent.StockPurchaseOrderDetails.Where(x => x.PurchaseOrderId == id).ToList();
foreach (var item in PurchaseDetailList)
{
StockPurchaseItemEntry itementry = new StockPurchaseItemEntry();
itementry.StockCategoryId = item.SetupStockItemEntry.SetupStockCategory.StockCategoryID;
itementry.StockSubCategoryId = item.SetupStockItemEntry.SetupStockSubCategory.StockSubCategoryID;
itementry.StockItemEntryId = item.ItemId;
itementry.Quantity = item.Quantity;
itementry.QuatationPrice = item.QuotationPrice;
model.StockPurchaseItemEntryList.Add(itementry);
}
return(View(model));
}
public ActionResult Index(DemandMasterModel model)
{
EHMSEntities ent = new EHMSEntities();
string s = "";
//ViewBag.datef = datefrom;
//ViewBag.datet = dateto;
//ViewBag.dmdno = demandno;
//if (saveDetails != null)
//{
// if (demandno == "")
// {
// model.DemandMasterList = pro.GetCustomDemandList(model.DepartmentID, datefrom, dateto);
// }
foreach (var item in model.DemandDetailList)
{
if (item.CancellationStatus == false && item.isSelected == false && item.QuantityIssued == 0)
{
TempData["message"] = "Enter quantity to be dispatched!";
return(View(model));
}
}
s = proA.Insert(model);
if (s != "")
{
TempData["message"] = s;
foreach (var item in model.DemandDetailList)
{
if (ent.ItemDemandDetails.Any(x => x.ItemID == item.ItemID && x.ItemDemandID == item.ItemDemandID && x.DispatchStatus == true))
{
model.DemandDetailList = model.DemandDetailList.Where(x => x.ItemID != item.ItemID && x.ItemDemandID != item.ItemDemandID).ToList();
}
}
return(View(model));
}
if (model.isSelected == true)
{
StockPurchaseOrderModel purchasemodel = new StockPurchaseOrderModel();
purchasemodel.StockPurchaseItemEntryList = new List <StockPurchaseItemEntry>();
foreach (var item in model.DemandDetailList)
{
if (item.isSelected == true)
{
StockPurchaseItemEntry itementry = new StockPurchaseItemEntry();
var obj = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault();
itementry.StockCategoryId = obj.StockCategoryId;
itementry.StockSubCategoryId = obj.StockSubCategoryId;
itementry.StockItemEntryId = obj.StockItemEntryId;
purchasemodel.StockPurchaseItemEntryList.Add(itementry);
}
}
Session["purchaseitementrylist"] = purchasemodel.StockPurchaseItemEntryList;
return(RedirectToAction("CreateView", "StockPurchaseOrder"));
}
//}
//model.DemandDetailList = new List<DemandDetailModel>();
//if (demandno != "")
//{
// var objList = (from dd in ent.ItemDemandDetail
// join dm in ent.ItemDemandMaster
// on dd.ItemDemandID equals dm.ItemDemandID
// where dm.ItemDemandNo == demandno && dd.DispatchStatus == false
// select dd).ToList();
// try
// {
// int i = objList[0].ItemDemandID;
// model.ItemDemandNo = ent.ItemDemandMaster.Where(x => x.ItemDemandID == i).SingleOrDefault().ItemDemandNo;
// AutoMapper.Mapper.Map(objList, model.DemandDetailList);
// }
// catch { }
// try
// {
// string num = ent.ItemAllotmentMaster.Max(x => x.ItemAllotmentNo);
// string[] nums = num.Split('N');
// RecordNumGen rcnum = new RecordNumGen(nums[1]);
// model.ItemAllotmentNo = "AN" + rcnum.RecNumGen();
// }
// catch (Exception e)
// {
// model.ItemAllotmentNo = "AN001";
// }
//}
//else
//{
// model.DemandMasterList = pro.GetCustomDemandList(model.DepartmentID, datefrom, dateto);
// if (DemandId != "")
// {
// model.DemandDetailList = pro.GetCDemandDetails(Convert.ToInt32(DemandId));
// try
// {
// int i = model.DemandDetailList[0].ItemDemandID;
// model.ItemDemandNo = ent.ItemDemandMaster.Where(x => x.ItemDemandID == i).SingleOrDefault().ItemDemandNo;
// }
// catch { }
// try
// {
// string num = ent.ItemAllotmentMaster.Max(x => x.ItemAllotmentNo);
// string[] nums = num.Split('N');
// RecordNumGen rcnum = new RecordNumGen(nums[1]);
// model.ItemAllotmentNo = "AN" + rcnum.RecNumGen();
// }
// catch (Exception e)
// {
// model.ItemAllotmentNo = "AN001";
// }
// }
//}
return(RedirectToAction("AllotmentMaster"));
}
