public ActionResult Insert(MActionItem viewModel, FormCollection formCollection) { MActionItem actionItem = new MActionItem(); actionItem.SetAssignedIdTo(Guid.NewGuid().ToString()); TransferFormValuesTo(actionItem, viewModel); actionItem.ItemId = _mItemRepository.Get(formCollection["ItemId"]); actionItem.ActionId = _mActionRepository.Get(formCollection["ActionId"]); actionItem.CreatedDate = DateTime.Now; actionItem.CreatedBy = User.Identity.Name; actionItem.DataStatus = EnumDataStatus.New.ToString(); _mActionItemRepository.Save(actionItem); try { _mActionItemRepository.DbContext.CommitChanges(); } catch (Exception e) { _mActionItemRepository.DbContext.RollbackTransaction(); //throw e.GetBaseException(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
public ActionResult InsertSubGrid(MCustomerPrice viewModel, FormCollection formCollection, string itemId) { try { MCustomerPrice cp = new MCustomerPrice(); cp.CustomerId = viewModel.CustomerId; cp.ItemId = _mitemRepository.Get(itemId); cp.Price = decimal.Parse(formCollection["Price"].Replace(",", "")); //Helper.CommonHelper.ConvertToDecimal(formCollection["Price"]); cp.SetAssignedIdTo(Guid.NewGuid().ToString()); cp.CreatedDate = DateTime.Now; cp.CreatedBy = User.Identity.Name; cp.DataStatus = EnumDataStatus.New.ToString(); _mCustomerPriceRepository.Save(cp); _mCustomerPriceRepository.DbContext.CommitChanges(); } catch (Exception e) { _mCustomerPriceRepository.DbContext.RollbackTransaction(); return(Content(e.GetBaseException().Message)); } return(Content("Data Harga Konsumen berhasil disimpan.")); }
public ActionResult Insert(TTransDet viewModel, FormCollection formCollection, bool IsAddStock, string warehouseId) { //format numeric UpdateNumericData(viewModel, formCollection); // MItem item = _mItemRepository.Get(formCollection["ItemId"]); //check stock is enough or not if no add stock //return Content(IsAddStock.ToString()); if (!IsAddStock) { MWarehouse warehouse = _mWarehouseRepository.Get(warehouseId); bool isStockValid = Helper.CommonHelper.CheckStock(warehouse, item, viewModel.TransDetQty); if (!isStockValid) { return(Content("Kuantitas barang tidak cukup")); } } TTransDet transDetToInsert = new TTransDet(); TransferFormValuesTo(transDetToInsert, viewModel); transDetToInsert.SetAssignedIdTo(Guid.NewGuid().ToString()); transDetToInsert.ItemId = item; transDetToInsert.SetAssignedIdTo(viewModel.Id); transDetToInsert.CreatedDate = DateTime.Now; transDetToInsert.CreatedBy = User.Identity.Name; transDetToInsert.DataStatus = EnumDataStatus.New.ToString(); ListDetTrans.Add(transDetToInsert); return(Content("success")); }
public ActionResult Delete(MItem viewModel, FormCollection formCollection) { MItem mItemToDelete = _mItemRepository.Get(viewModel.Id); if (mItemToDelete != null) { _mItemRepository.Delete(mItemToDelete); } try { _mItemRepository.DbContext.CommitChanges(); } catch (Exception e) { _mItemRepository.DbContext.RollbackTransaction(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
private ReportDataSource GetTransDetForBudget(string itemId, string warehouseId, DateTime dateFrom, DateTime dateTo) { IList <TTransDet> dets; MItem item = null; MWarehouse warehouse = null; if (!string.IsNullOrEmpty(itemId)) { item = _mItemRepository.Get(itemId); } if (!string.IsNullOrEmpty(warehouseId)) { warehouse = _mWarehouseRepository.Get(warehouseId); } dets = _tTransDetRepository.GetByItemWarehouse(item, warehouse); var list = from det in dets select new { det.TransDetNo, det.TransDetQty, det.TransDetDesc, det.TransDetTotal, det.TransDetPrice, det.TransDetDisc, ItemId = det.ItemId.Id, det.ItemId.ItemName, WarehouseId = det.TransId.WarehouseId.Id, det.TransId.WarehouseId.WarehouseName, TotalUsed = _tTransDetRepository.GetTotalUsed(det.ItemId, det.TransId.WarehouseId, dateFrom, dateTo, EnumTransactionStatus.Using.ToString()), RealPercentValue = GetRealValue(det.TransId.WarehouseId.CostCenterId, dateFrom, dateTo) } ; ReportDataSource reportDataSource = new ReportDataSource("TransDetViewModel", list.ToList()); return(reportDataSource); }
private ReportDataSource GetTransDetForBudget(string itemId, string warehouseId) { IList <TTransDet> dets; MItem item = null; MWarehouse warehouse = null; if (!string.IsNullOrEmpty(itemId)) { item = _mItemRepository.Get(itemId); } if (!string.IsNullOrEmpty(warehouseId)) { warehouse = _mWarehouseRepository.Get(warehouseId); } dets = _tTransDetRepository.GetByItemWarehouse(item, warehouse); var list = from det in dets select new { det.TransDetNo, det.TransDetQty, det.TransDetDesc, det.TransDetTotal, det.TransDetPrice, det.TransDetDisc, ItemId = det.ItemId.Id, det.ItemId.ItemName, WarehouseId = det.TransId.WarehouseId.Id, det.TransId.WarehouseId.WarehouseName, TotalUsed = _tTransDetRepository.GetTotalUsed(det.ItemId, det.TransId.WarehouseId) } ; ReportDataSource reportDataSource = new ReportDataSource("TransDetViewModel", list.ToList()); return(reportDataSource); }