//
// GET: /ReturnInOut/Details/5
public ActionResult Details(string id)
{
EHMSEntities ent = new EHMSEntities();
StockReturnOutModel model = new StockReturnOutModel();
model.ReturnOutList = new List <StockReturnOutModel>(AutoMapper.Mapper.Map <IEnumerable <StockReturnOut>, IEnumerable <StockReturnOutModel> >(ent.StockReturnOuts.Where(x => x.Status == true && x.ReturnOutNo == id)));
return(View(model));
}
//
// GET: /ReturnInOut/
public ActionResult Index()
{
EHMSEntities ent = new EHMSEntities();
StockReturnOutModel model = new StockReturnOutModel();
StockReturnOutModel model2 = new StockReturnOutModel();
model2.ReturnOutList = new List <StockReturnOutModel>();
model.ReturnOutList = new List <StockReturnOutModel>(AutoMapper.Mapper.Map <IEnumerable <StockReturnOut>, IEnumerable <StockReturnOutModel> >(ent.StockReturnOuts.Where(x => x.Status == true)));
foreach (var item in model.ReturnOutList)
{
if (model2.ReturnOutList.Any(s => s.ReturnOutNo == item.ReturnOutNo) == false)
{
model2.ReturnOutList.Add(item);
}
}
model.ReturnOutList = model2.ReturnOutList;
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 Create(StockReturnOutModel model)
{
EHMSEntities ent = new EHMSEntities();
try
{
// TODO: Add insert logic here
foreach (var item in model.ReturnOutList)
{
if (item.ReturnOutQty != 0)
{
StockReturnOut obj = new StockReturnOut();
var objitem = ent.StockItemMasters.Where(x => x.StockItemEntryId == item.ItemId).SingleOrDefault();
obj.PurchaseId = item.PurchaseId;
obj.PurchaseOrderNo = item.PurchaseOrderNo;
obj.ItemId = item.ItemId;
obj.ReturnOutQty = item.ReturnOutQty;
obj.ReturnOutDate = model.ReturnOutDate;
obj.SupplierId = item.SupplierId;
obj.Remarks = model.Remarks;
obj.ReturnOutNo = model.ReturnOutNo;
obj.Status = true;
obj.CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId();
obj.CreatedDate = DateTime.Today;
ent.StockReturnOuts.Add(obj);
objitem.Quantity = objitem.Quantity - item.ReturnOutQty;
ent.Entry(objitem).State = System.Data.EntityState.Modified;
}
}
ent.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
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));
}
