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);
}