// GET: Inventories/Edit
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InventoryViewModel inventoryViewModel = InventoryDAO.GetInventoryByItemNo(id);
if (inventoryViewModel == null)
{
return(View("~/Views/Shared/Error.cshtml"));
}
;
// drop down list
List <String> listItem = new List <string>();
listItem.Add("Dozen");
listItem.Add("Box");
listItem.Add("Each");
listItem.Add("Set");
listItem.Add("Packet");
ViewBag.unitMeasure = new SelectList(listItem, inventoryViewModel.unitMeasure);
// drop down list
var categories = InventoryDAO.getAllCategoryId();
ViewBag.category = new SelectList(categories, inventoryViewModel.category);
// push to view
return(View(inventoryViewModel));
}
public ActionResult Create(string itemNo, string supplierId, int?poId, string category)
{
ViewBag.poId = poId;
ViewBag.category = category;
ViewBag.categoryList = new SelectList(InventoryDAO.getAllCategoryId(), category);
if (itemNo != null && supplierId != null)
{
switch (poId)
{
// new po
case null:
var li = Session["pocartItems"] as List <PurchaseOrderViewModel>;
PurchaseOrderDAO.IncreasePOList(itemNo, supplierId, ref li);
Session["pocartItems"] = li;
break;
// existed po
default:
int count = PurchaseOrderDAO.addPODetail(itemNo, (int)poId);
ViewBag.DetailItemCount = count;
break;
}
}
List <PurchaseOrderViewModel> list = null;
if (!string.IsNullOrEmpty(category) && category != "0")
{
// only for this category
if (poId == null)
{
list = PurchaseOrderDAO.getAllPOVM(category);
}
else
{
list = PurchaseOrderDAO.getAllPOVM((int)poId, category);
}
}
else
{
if (poId == null)
{
list = PurchaseOrderDAO.getAllPOVM();
}
else
{
list = PurchaseOrderDAO.getAllPOVM((int)poId);
}
}
return(View(list));
}
public ActionResult Store(string itemNo, int?requestId, string category)
{
ViewBag.requestId = requestId;
ViewBag.category = category;
ViewBag.categoryList = new SelectList(InventoryDAO.getAllCategoryId(), category);
// Click add to cart
if (itemNo != null)
{
switch (requestId)
{
// New request (store in session)
case null:
{
var li = Session["cartItems"] as List <string>;
IncreaseStringList(ref li, itemNo);
Session["cartItems"] = li;
}
break;
// Existed request (store in database
default:
{
// insert the request detail
RequestViewModel rd = new RequestViewModel()
{
itemNo = itemNo,
requestId = Convert.ToInt32(requestId),
quantityNeed = 1,
status_requestDetail = "unfulfilled"
};
int count = RequestDAO.InsertRequestDetail(rd);
ViewBag.RequestItemCount = count;
}
break;
}
}
List <InventoryViewModel> items = null;
if (!string.IsNullOrEmpty(category) && category != "0")
{
items = InventoryDAO.GetInventories(category);
}
else
{
items = InventoryDAO.GetInventories();
}
return(View(items));
}
// GET: StockCard/ViewStockCard
public ActionResult ViewStockCard(string category)
{
List <string> categories = InventoryDAO.getAllCategoryId();
ViewBag.categoryList = new SelectList(categories, category);
List <InventoryViewModel> list = new List <InventoryViewModel>();
if (!String.IsNullOrEmpty(category) && category.ToLower() != "all")
{
list = InventoryDAO.GetInventories(category);
}
else
{
list = InventoryDAO.GetInventories();
}
return(View(list));
}
public ActionResult Edit(InventoryViewModel inventoryViewModel)
{
if (!ModelState.IsValidField(nameof(InventoryViewModel.itemNo)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.category)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.description)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.unitMeasure)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.reorderQuantity)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.reorderLevel)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.stdPrice)) ||
!ModelState.IsValidField(nameof(InventoryViewModel.balance))
)
{
// drop down list
List <String> listItem = new List <string>();
listItem.Add("Dozen");
listItem.Add("Box");
listItem.Add("Each");
listItem.Add("Set");
listItem.Add("Packet");
ViewBag.unitMeasure = new SelectList(listItem, inventoryViewModel.unitMeasure);
// drop down list
var categories = InventoryDAO.getAllCategoryId();
ViewBag.category = new SelectList(categories, inventoryViewModel.category);
return(View(inventoryViewModel));
}
// biz logic here...
bool bRes = AdjustmentVoucherDAO.EditInventories(inventoryViewModel);
if (bRes)
{
return(RedirectToAction("Index"));
}
else
{
return(View("~/Views/Shared/Error.cshtml"));
}
}
public List <string> ReadCategories()
{
var res = InventoryDAO.getAllCategoryId();
return(res);
}
