public StockItemModel GetGroupingItemDetailList()
{
StockItemModel model = new StockItemModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockGroupingItemMasters.Where(x => x.Status == true);
if (result.Count() > 0)
{
foreach (var item in result)
{
var Obj = new StockItemGroupingMasterViewModel()
{
GroupingId = (int)item.GroupingId,
StockGroupingItemMasterID = item.StockGroupingItemMasterID,
ItemId = (int)item.ItemId,
TotalItem = (int)item.TotalItem,
Narration = item.Narration,
Remarks = item.Remarks
};
model.StockItemGroupingMasterViewModelList.Add(Obj);
}
}
}
return(model);
}
public StockItemModel LocationDetails()
{
StockItemModel model = new StockItemModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemLocationSetups.Where(x => x.Status == true);
if (result.Count() > 0)
{
foreach (var item in result)
{
var ViewModel = new StockItemLocationViewModel()
{
StockItemLocationId = item.StockItemLocationId,
LocatonName = item.LocatonName,
DepartmentId = (int)item.DepartmentId,
WardID = (int)item.WardID,
BlockId = (int)item.BlockId
};
model.StockItemLocationViewModelList.Add(ViewModel);
}
}
return(model);
}
}
public StockItemModel RackDetails()
{
StockItemModel model = new StockItemModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemRackSetups.Where(x => x.Status == true);
if (result.Count() > 0)
{
foreach (var item in result)
{
var ViewModel = new StockItemRackViewModel()
{
StockItemRackSetupId = item.StockItemRackSetupId,
LocationId = (int)item.LocationId,
RackName = item.RackName,
RackNumber = (int)item.RackNumber,
};
model.StockItemRackViewModelList.Add(ViewModel);
}
}
return(model);
}
}
public ActionResult Create(StockItemModel model)
{
if (ModelState.IsValid)
{
try
{
// TODO: Add insert logic here
int i = pro.Insert(model);
if (i == 1)
{
TempData["success"] = HospitalManagementSystem.UtilityMessage.save;
}
else
{
TempData["success"] = "Record with this name already exists in database!";
return(View(model));
}
// return RedirectToAction("Index");
}
catch (Exception e)
{
return(View(model));
}
}
else
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public StockItemModel GetGroupDetails()
{
StockItemModel model = new StockItemModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemGroupSetups.Where(x => x.Status == true);
if (result.Count() > 0)
{
foreach (var item in result)
{
var ViewModel = new StockItemGroupSetupViewModel()
{
GroupName = item.GroupName,
StockGroupingId = item.StockGroupingId,
FromId = (int)item.FromId,
ToId = (int)item.ToId
};
model.StockItemGroupSetupViewModelList.Add(ViewModel);
}
}
return(model);
}
}
public ActionResult UdpateLocationDetails(StockItemModel model)
{
StockItemProvider pro = new StockItemProvider();
pro.UpdateLocationDetails(model);
return(RedirectToAction("LocationSetup"));
}
public ActionResult EditGroupDetails(StockItemModel model)
{
StockItemProvider pro = new StockItemProvider();
pro.UpdateGroupDetails(model);
return(RedirectToAction("GroupSetup"));
}
public ActionResult EditRackSetup(StockItemModel model)
{
StockItemProvider pro = new StockItemProvider();
pro.UpdateRackDetails(model);
return(RedirectToAction("RackSetup"));
}
public ActionResult ItemGroupDetailSetup()
{
StockItemProvider pro = new StockItemProvider();
StockItemModel model = new StockItemModel();
return(View(model));
}
public ActionResult ItemGroupDetailSetup(StockItemModel model)
{
StockItemProvider pro = new StockItemProvider();
pro.InsertItemGroupDetails(model);
return(View(model));
}
public StockItemModel GetGroupingItemDetails(int GroupId, int ItemId)
{
StockItemModel model = new StockItemModel();
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockGroupingItemDetails.Where(x => x.Status == true && x.GroupID == GroupId && x.ItemId == ItemId).ToList();
if (result.Count() > 0)
{
foreach (var item in result)
{
var Obj = new StockItemGroupingDetailsViewModel()
{
StockGroupItemDetailsId = item.StockGroupItemDetailsId,
GroupID = (int)item.GroupID,
ItemId = (int)item.ItemId,
SerrialNo = (int)item.SerrialNo,
Description = item.Description,
LocationId = (int)item.LocationId,
RackId = (int)item.RackId,
PartyName = item.PartyName,
Condition = item.Condition
};
model.StockItemGroupingDetailsViewModelList.Add(Obj);
}
}
}
return(model);
}
public ActionResult Index()
{
StockItemModel model = new StockItemModel();
model.StockItemList = pro.GetList();
return(View(model));
}
public IHttpActionResult UpdateStockItem(StockItemModel entity)
{
return(TryResult(
ResponseMessage(Request
.CreateResponse(HttpStatusCode.OK,
_StockItemService.Update(entity) &&
_StockItemService.Save()))));
}
public ActionResult RackSetup()
{
StockItemProvider pro = new StockItemProvider();
StockItemModel model = new StockItemModel();
model = pro.RackDetails();
return(View(model));
}
public ActionResult ShowGroupingItemIndex()
{
StockItemModel model = new StockItemModel();
StockItemProvider pro = new StockItemProvider();
model = pro.GetGroupingItemDetailList();
return(View(model));
}
public ActionResult SubGroupSetup()
{
StockItemProvider pro = new StockItemProvider();
StockItemModel model = new StockItemModel();
model = pro.GetGroupDetails();
return(View(model));
}
public ActionResult ShowGroupingItemDetails(int id, int itemId)
{
StockItemModel model = new StockItemModel();
StockItemProvider pro = new StockItemProvider();
model = pro.GetGroupingItemDetails(id, itemId);
return(View(model));
}
public ActionResult EditRackSetup(int id)
{
StockItemModel model = new StockItemModel();
StockItemProvider pro = new StockItemProvider();
model = pro.RackDetails();
model.ObjStockItemRackViewModel = model.StockItemRackViewModelList.Where(x => x.StockItemRackSetupId == id).FirstOrDefault();
return(View(model));
}
public ActionResult UdpateLocationDetails(int id)
{
StockItemProvider pro = new StockItemProvider();
StockItemModel model = new StockItemModel();
model = pro.LocationDetails();
model.ObjStockItemLocationViewModel = model.StockItemLocationViewModelList.Where(x => x.StockItemLocationId == id).FirstOrDefault();
return(View(model));
}
public ActionResult EditGroupDetails(int id)
{
StockItemModel model = new StockItemModel();
StockItemProvider pro = new StockItemProvider();
model = pro.GetGroupDetails();
model.ObjStockItemGroupSetupViewModel = model.StockItemGroupSetupViewModelList.Where(x => x.StockGroupingId == id).FirstOrDefault();
return(View(model));
}
public bool InsertRackDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var groupDtls = new StockItemRackSetup()
{
RackName = model.ObjStockItemRackViewModel.RackName,
RackNumber = model.ObjStockItemRackViewModel.RackNumber,
Status = true,
LocationId = model.ObjStockItemRackViewModel.LocationId,
Narration = "Stock Rack Setup"
};
ent.StockItemRackSetups.Add(groupDtls);
ent.SaveChanges();
return(true);
}
}
public bool InsertGroupDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var groupDtls = new StockItemGroupSetup()
{
GroupName = model.ObjStockItemGroupSetupViewModel.GroupName,
FromId = model.ObjStockItemGroupSetupViewModel.FromId,
ToId = model.ObjStockItemGroupSetupViewModel.ToId,
Status = true,
Narration = "stock Group"
};
ent.StockItemGroupSetups.Add(groupDtls);
ent.SaveChanges();
return(true);
}
}
public bool UpdateRackDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemRackSetups.Where(x => x.StockItemRackSetupId == model.ObjStockItemRackViewModel.StockItemRackSetupId).ToList();
if (result.Count() > 0)
{
var value = ent.StockItemRackSetups.Where(x => x.StockItemRackSetupId == model.ObjStockItemRackViewModel.StockItemRackSetupId).FirstOrDefault();
value.RackName = model.ObjStockItemRackViewModel.RackName;
value.RackNumber = model.ObjStockItemRackViewModel.RackNumber;
value.LocationId = model.ObjStockItemRackViewModel.LocationId;
value.Status = true;
ent.Entry(value).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
return(true);
}
}
public bool UpdateGroupDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemGroupSetups.Where(x => x.StockGroupingId == model.ObjStockItemGroupSetupViewModel.StockGroupingId).ToList();
if (result.Count() > 0)
{
var value = ent.StockItemGroupSetups.Where(x => x.StockGroupingId == model.ObjStockItemGroupSetupViewModel.StockGroupingId).FirstOrDefault();
value.GroupName = model.ObjStockItemGroupSetupViewModel.GroupName;
value.Status = true;
value.FromId = model.ObjStockItemGroupSetupViewModel.FromId;
value.ToId = model.ObjStockItemGroupSetupViewModel.ToId;
ent.Entry(value).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
return(true);
}
}
public bool UpdateLocationDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemLocationSetups.Where(x => x.StockItemLocationId == model.ObjStockItemLocationViewModel.StockItemLocationId).ToList();
if (result.Count() > 0)
{
var value = ent.StockItemLocationSetups.Where(x => x.StockItemLocationId == model.ObjStockItemLocationViewModel.StockItemLocationId).FirstOrDefault();
value.LocatonName = model.ObjStockItemLocationViewModel.LocatonName;
value.Status = true;
value.DepartmentId = model.ObjStockItemLocationViewModel.DepartmentId;
value.WardID = model.ObjStockItemLocationViewModel.WardID;
value.BlockId = model.ObjStockItemLocationViewModel.BlockId;
ent.Entry(value).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
return(true);
}
}
public bool InsertLocationDetails(StockItemModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var groupDtls = new StockItemLocationSetup()
{
LocatonName = model.ObjStockItemLocationViewModel.LocatonName,
Status = true,
DepartmentId = model.ObjStockItemLocationViewModel.DepartmentId,
WardID = model.ObjStockItemLocationViewModel.WardID,
BlockId = model.ObjStockItemLocationViewModel.BlockId,
Narration = "Stock Location Setup"
};
ent.StockItemLocationSetups.Add(groupDtls);
ent.SaveChanges();
return(true);
}
}
public ActionResult CreateGroupSetup(StockItemModel model)
{
//Frist check if number already inserted or not
using (EHMSEntities ent = new EHMSEntities())
{
var result = ent.StockItemGroupSetups.Where(x => x.Status == true).ToList();
if (result.Count() > 0)
{
foreach (var item in result)
{
bool isInRange = HospitalManagementSystem.Utility.CheckValueInRange((int)item.FromId, (int)item.ToId, (int)model.ObjStockItemGroupSetupViewModel.FromId);
bool isInRangeToId = HospitalManagementSystem.Utility.CheckValueInRange((int)item.FromId, (int)item.ToId, (int)model.ObjStockItemGroupSetupViewModel.ToId);
if (isInRange == true || isInRangeToId == true)
{
TempData["message"] = "This number is already assigned to another group";
return(RedirectToAction("CreateGroupSetup", model));
}
}
}
}
StockItemProvider pro = new StockItemProvider();
pro.InsertGroupDetails(model);
if (ModelState.IsValid)
{
}
else
{
foreach (var modelStateVal in ViewData.ModelState.Values)
{
foreach (var error in modelStateVal.Errors)
{
var errorMessage = error.ErrorMessage;
var exception = error.Exception;
// You may log the errors if you want
}
}
}
return(RedirectToAction("GroupSetup"));
}
public int Insert(StockItemModel model)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
if (ent.SetupStockItemTypes.Where(x => x.StockItemTypeName == model.StockItemTypeName).Any())
{
return(0);
}
var objToSave = AutoMapper.Mapper.Map <StockItemModel, SetupStockItemType>(model);
objToSave.Status = true;
objToSave.CreatedBy = 1;
objToSave.CreatedDate = DateTime.Now;
ent.SetupStockItemTypes.Add(objToSave);
i = ent.SaveChanges();
}
return(i);
}
public void PopulateStock()
{
stockGrid.Children.Clear();
stockGrid.RowDefinitions.Clear();
bool stockFound = false;
List <StockItemModel> models = svc.GetCurrentStock(itemId);
foreach (StockItemModel model in models)
{
stockFound = true;
stockGrid.RowDefinitions.Add(new RowDefinition());
TextBlock currentItems = new TextBlock();
currentItems.Text = model.CurrentItems.ToString();
currentItems.Margin = new Thickness(5, 0, 0, 0);
currentItems.SetValue(Grid.ColumnProperty, 0);
currentItems.SetValue(Grid.RowProperty, stockGrid.RowDefinitions.Count - 1);
stockGrid.Children.Add(currentItems);
TextBlock currentPortions = new TextBlock();
currentPortions.Text = model.CurrentPortions.ToString();
currentPortions.SetValue(Grid.ColumnProperty, 1);
currentPortions.SetValue(Grid.RowProperty, stockGrid.RowDefinitions.Count - 1);
stockGrid.Children.Add(currentPortions);
TextBlock portionsPerItem = new TextBlock();
portionsPerItem.Text = model.PortionsPerItem.ToString();
portionsPerItem.SetValue(Grid.ColumnProperty, 2);
portionsPerItem.SetValue(Grid.RowProperty, stockGrid.RowDefinitions.Count - 1);
stockGrid.Children.Add(portionsPerItem);
TextBlock costPerItem = new TextBlock();
costPerItem.Text = model.CostPerItem.ToString("#0.00");
costPerItem.SetValue(Grid.ColumnProperty, 3);
costPerItem.SetValue(Grid.RowProperty, stockGrid.RowDefinitions.Count - 1);
stockGrid.Children.Add(costPerItem);
}
if (stockFound)
{
StockItemModel model = models[models.Count - 1];
addItems.Text = model.OriginalItems.ToString();
addPortionsPerItem.Text = model.PortionsPerItem.ToString();
addCostPerItem.Text = model.CostPerItem.ToString("#0.00");
}
else
{
addItems.Text = "";
addPortionsPerItem.Text = "";
addCostPerItem.Text = "";
}
}
public ActionResult CreateRackSetup()
{
StockItemModel model = new StockItemModel();
return(View(model));
}
