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 Index(int?id)
{
EHMSEntities ent = new EHMSEntities();
DemandMasterModel model = new DemandMasterModel();
model.ItemDemandNo = ent.ItemDemandMasters.Where(x => x.ItemDemandID == id).SingleOrDefault().ItemDemandNo;
model.DemandMasterList = new List <DemandMasterModel>();
model.DemandDetailList = new List <DemandDetailModel>(AutoMapper.Mapper.Map <IEnumerable <ItemDemandDetail>, IEnumerable <DemandDetailModel> >(ent.ItemDemandDetails.Where(x => x.ItemDemandID == id && x.DispatchStatus == false)));
if (model.DemandDetailList.Count == 0)
{
TempData["message"] = "Items not available!!";
return(RedirectToAction("Index", "Demand"));
}
try
{
var obj = ent.ItemAllotmentMasters.Where(x => x.ItemAllotmentMasterID == ent.ItemAllotmentMasters.Max(y => y.ItemAllotmentMasterID)).SingleOrDefault();
string[] nums = obj.ItemAllotmentNo.Split('N');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.ItemAllotmentNo = "AN" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.ItemAllotmentNo = "AN001";
}
return(View(model));
}
public ActionResult Distribute()
{
EHMSEntities ent = new EHMSEntities();
StockDistributionMasterModel model = new StockDistributionMasterModel();
model.BillDate = DateTime.Today;
try
{
var obj = ent.StockDistributionMasters.Where(x => x.DistributionMasterId == ent.StockDistributionMasters.Max(y => y.DistributionMasterId)).SingleOrDefault();
string[] nums = obj.BillNo.Split('N');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.BillNo = "BN" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.BillNo = "BN001";
}
return(View(model));
}
//
// GET: /StockItemPurchase/Create
public ActionResult Create()
{
EHMSEntities ent = new EHMSEntities();
StockItemPurchaseModel model = new StockItemPurchaseModel();
try
{
var obj = ent.StockItemPurchases.Where(x => x.ItemPurchaseId == ent.StockItemPurchases.Max(y => y.ItemPurchaseId)).SingleOrDefault();
string[] nums = obj.StockEntryNo.Split('E');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.StockEntryNo = "SE" + rcnum.RecNumGen();
}
catch
{
model.StockEntryNo = "SE001";
}
//TempData["id"] = ent.SetupStockCategory.Where(x => x.Status == true).FirstOrDefault().StockCategoryID;
return(View(model));
}
//
// GET: /Demand/Create
public ActionResult Create()
{
EHMSEntities ent = new EHMSEntities();
DemandMasterModel model = new DemandMasterModel();
try
{
var obj = ent.ItemDemandMasters.Where(x => x.ItemDemandID == ent.ItemDemandMasters.Max(y => y.ItemDemandID)).SingleOrDefault();
string[] nums = obj.ItemDemandNo.Split('N');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.ItemDemandNo = "DN" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.ItemDemandNo = "DN001";
}
model.DemandDate = DateTime.Today;
return(View(model));
}
//
// GET: /ReturnInOut/Create
public ActionResult Create()
{
EHMSEntities ent = new EHMSEntities();
StockReturnOutModel model = new StockReturnOutModel();
model.ReturnOutDate = DateTime.Today;
try
{
var obj = ent.StockReturnOuts.Where(x => x.ReturnOutId == ent.StockReturnOuts.Max(y => y.ReturnOutId)).SingleOrDefault();
string[] nums = obj.ReturnOutNo.Split('O');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.ReturnOutNo = "RO" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.ReturnOutNo = "RO001";
}
return(View(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));
}
public ActionResult SearchPurchase(string SupplierId, string PurchaseOrderNo, string stockentryno, string billno, string dateto, string fromdate)
{
EHMSEntities ent = new EHMSEntities();
StockReturnOutModel model = new StockReturnOutModel();
model.ReturnOutList = new List <StockReturnOutModel>();
if (dateto != "" && fromdate != "")
{
DateTime df = Convert.ToDateTime(fromdate);
DateTime dt = Convert.ToDateTime(dateto);
df = df.AddDays(-1);
dt = dt.AddDays(1);
var objlist = (from pm in ent.StockItemPurchases
join pd in ent.StockItemPurchaseDetails
on pm.ItemPurchaseId equals pd.ItemPurchaseId
where pm.CreatedDate >= df && pm.CreatedDate <= dt
select new { pm, pd }).ToList();
foreach (var item in objlist)
{
StockReturnOutModel obj = new StockReturnOutModel();
obj.ItemId = item.pd.StockItemEntryId;
obj.PurchaseId = item.pd.ItemPurchaseId;
obj.SupplierId = item.pm.StockSupplierId;
obj.PurchaseOrderNo = item.pm.ItemOrderId;
obj.ReturnOutQty = item.pd.Quantity;
model.ReturnOutList.Add(obj);
}
}
else if (PurchaseOrderNo != "")
{
var objlist = (from pm in ent.StockItemPurchases
join pd in ent.StockItemPurchaseDetails
on pm.ItemPurchaseId equals pd.ItemPurchaseId
where pm.ItemOrderId == PurchaseOrderNo
select new { pm, pd }).ToList();
foreach (var item in objlist)
{
StockReturnOutModel obj = new StockReturnOutModel();
obj.ItemId = item.pd.StockItemEntryId;
obj.PurchaseId = item.pd.ItemPurchaseId;
obj.SupplierId = item.pm.StockSupplierId;
obj.PurchaseOrderNo = item.pm.ItemOrderId;
obj.ReturnOutQty = item.pd.Quantity;
model.ReturnOutList.Add(obj);
}
}
else if (stockentryno != "")
{
var objlist = (from pm in ent.StockItemPurchases
join pd in ent.StockItemPurchaseDetails
on pm.ItemPurchaseId equals pd.ItemPurchaseId
where pm.StockEntryNo == stockentryno
select new { pm, pd }).ToList();
foreach (var item in objlist)
{
StockReturnOutModel obj = new StockReturnOutModel();
obj.ItemId = item.pd.StockItemEntryId;
obj.PurchaseId = item.pd.ItemPurchaseId;
obj.SupplierId = item.pm.StockSupplierId;
obj.PurchaseOrderNo = item.pm.ItemOrderId;
obj.ReturnOutQty = item.pd.Quantity;
model.ReturnOutList.Add(obj);
}
}
else if (billno != "")
{
int i = Convert.ToInt32(billno);
var objlist = (from pm in ent.StockItemPurchases
join pd in ent.StockItemPurchaseDetails
on pm.ItemPurchaseId equals pd.ItemPurchaseId
where pm.ItemBillNo == i
select new { pm, pd }).ToList();
foreach (var item in objlist)
{
StockReturnOutModel obj = new StockReturnOutModel();
obj.ItemId = item.pd.StockItemEntryId;
obj.PurchaseId = item.pd.ItemPurchaseId;
obj.SupplierId = item.pm.StockSupplierId;
obj.PurchaseOrderNo = item.pm.ItemOrderId;
obj.ReturnOutQty = item.pd.Quantity;
model.ReturnOutList.Add(obj);
}
}
else
{
int i = Convert.ToInt32(SupplierId);
var objlist = (from pm in ent.StockItemPurchases
join pd in ent.StockItemPurchaseDetails
on pm.ItemPurchaseId equals pd.ItemPurchaseId
where pm.StockSupplierId == i
select new { pm, pd }).ToList();
foreach (var item in objlist)
{
StockReturnOutModel obj = new StockReturnOutModel();
obj.ItemId = item.pd.StockItemEntryId;
obj.PurchaseId = item.pd.ItemPurchaseId;
obj.SupplierId = item.pm.StockSupplierId;
obj.PurchaseOrderNo = item.pm.ItemOrderId;
obj.ReturnOutQty = item.pd.Quantity;
model.ReturnOutList.Add(obj);
}
}
model.ReturnOutDate = DateTime.Today;
try
{
string num = ent.StockReturnOuts.Max(x => x.ReturnOutNo);
string[] nums = num.Split('O');
RecordNumGen rcnum = new RecordNumGen(nums[1]);
model.ReturnOutNo = "RO" + rcnum.RecNumGen();
}
catch (Exception e)
{
model.ReturnOutNo = "RO001";
}
return(View("Create", model));
}
