public ActionResult POList_Create([DataSourceRequest] DataSourceRequest request, TransPOViewModel vm)
{
if (vm != null && ModelState.IsValid)
{
JmInventoryTTran entity = new JmInventoryTTran();
entity.SetAssignedIdTo(Guid.NewGuid().ToString());
ConvertToJmInventoryTTran(vm, entity);
///transaction no manual input
//entity.TransNo = GetNewPONo();
entity.TransType = EnumTransType.PO.ToString();
entity.TransStatus = vm.TransStatus;
entity.TransInputBy = User.Identity.Name;
entity.TransInputDate = DateTime.Now;
entity.CreatedDate = DateTime.Now;
entity.CreatedBy = User.Identity.Name;
entity.DataStatus = EnumDataStatus.New.ToString();
_tasks.Insert(entity);
}
return(Json(new[] { vm }.ToDataSourceResult(request, ModelState)));
}
public ActionResult LogTrans_Open(string random, string TransId)
{
string msg = string.Empty;
bool success = true;
if (!string.IsNullOrEmpty(TransId))
{
try
{
//get wo by PO id
JmInventoryTTran wo = this._JmInventoryTTranTasks.One(TransId);
//save log
SaveLog(wo, EnumLogType.Trans_PO, EnumTransLog.Read);
success = true;
msg = "Log PO success";
}
catch (Exception ex)
{
success = false;
msg = ex.GetBaseException().Message;
}
}
var e = new
{
Success = success,
Message = msg
};
return(Json(e, JsonRequestBehavior.AllowGet));
}
private void CalculateTotal(string TransId, JmInventoryTTran entity)
{
var dets = this._IJmInventoryTTransDetTasks.GetListByTransId(TransId);
entity.TransSubTotal = dets.Sum(p => p.TransDetTotal);
entity.TransGrandTotal = entity.TransSubTotal;
}
public ActionResult POList_Approve(string random, string TransId, string TransStatus)
{
bool success = true;
string debug = string.Empty;
try
{
//get po by TransId
JmInventoryTTran trans = this._tasks.One(TransId);
if (trans != null)
{
if (TransStatus == EnumTransStatus.Disetujui.ToString())
{
trans.TransStatus = EnumTransStatus.Disetujui.ToString();
trans.TransApprovedBy = User.Identity.Name;
trans.TransApprovedDate = DateTime.Now;
}
else if (TransStatus == EnumTransStatus.Ditolak.ToString())
{
trans.TransStatus = EnumTransStatus.Ditolak.ToString();
trans.TransApprovedBy = User.Identity.Name;
trans.TransApprovedDate = DateTime.Now;
}
else if (TransStatus == EnumTransStatus.Diproses.ToString())
{
trans.TransStatus = EnumTransStatus.Diproses.ToString();
trans.TransApprovedBy = User.Identity.Name;
trans.TransApprovedDate = DateTime.Now;
}
trans.ModifiedDate = DateTime.Now;
trans.ModifiedBy = User.Identity.Name;
trans.DataStatus = EnumDataStatus.Updated.ToString();
_tasks.Update(trans);
//save logx
SaveLog(trans, EnumLogType.Trans_PO, EnumTransLog.Approve);
success = true;
debug = "Berhasil";
}
}
catch (Exception ex)
{
success = false;
debug = ex.GetBaseException().Message;
}
var result = new
{
Success = success.ToString(),
Message = debug
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
private void ConvertToJmInventoryTTran(TransReceiptViewModel vm, JmInventoryTTran entity)
{
entity.SupplierId = string.IsNullOrEmpty(vm.SupplierId) ? null : _JmInventoryMSupplierTasks.One(vm.SupplierId);
//entity.TransRefId = string.IsNullOrEmpty(vm.TransRefId) ? null : _JmInventoryTTranTasks.One(vm.TransRefId);
entity.TransNo = vm.TransNo;
entity.TransDate = vm.TransDate;
//entity.TransStatus = vm.TransStatus;
//entity.TransApprovedBy = vm.TransApprovedBy;
//entity.TransApprovedDate = vm.TransApprovedDate;
//entity.TransInputBy = vm.TransInputBy;
//entity.TransInputDate = vm.TransInputDate;
entity.InvoiceNo = vm.InvoiceNo;
entity.TransDesc = vm.TransDesc;
}
private void SaveLog(JmInventoryTTran trans, EnumLogType logType, EnumTransLog transLog)
{
JmInventoryTLog woLog = new JmInventoryTLog();
woLog.SetAssignedIdTo(Guid.NewGuid().ToString());
woLog.LogRefId = trans.Id;
woLog.LogType = logType.ToString();
woLog.LogUser = User.Identity.Name;
woLog.LogDate = DateTime.Now;
woLog.LogStatus = transLog.ToString();
woLog.CreatedDate = DateTime.Now;
woLog.CreatedBy = User.Identity.Name;
woLog.DataStatus = EnumDataStatus.New.ToString();
_JmInventoryTLogTasks.Insert(woLog);
}
private void ConvertToJmInventoryTTran(TransPOViewModel vm, JmInventoryTTran entity)
{
entity.SupplierId = string.IsNullOrEmpty(vm.SupplierId) ? null : _JmInventoryMSupplierTasks.One(vm.SupplierId);
//entity.TransRefId = string.IsNullOrEmpty(vm.TransRefId) ? null : _JmInventoryTTranTasks.One(vm.TransRefId);
entity.TransNo = vm.TransNo;
entity.TransDate = vm.TransDate;
//entity.TransStatus = vm.TransStatus;
//entity.TransApprovedBy = vm.TransApprovedBy;
//entity.TransApprovedDate = vm.TransApprovedDate;
//entity.TransInputBy = vm.TransInputBy;
//entity.TransInputDate = vm.TransInputDate;
entity.InvoiceNo = vm.InvoiceNo;
entity.TransDesc = vm.TransDesc;
///calculate total base on detail
CalculateTotal(vm.TransId, entity);
}
public ActionResult InputSN(string EditTransId)
{
TStockInputViewModel vm = new TStockInputViewModel();
if (string.IsNullOrEmpty(EditTransId))
{
///for first load, save first, to handle detail form input
string newId = Guid.NewGuid().ToString();
JmInventoryTTran entity = new JmInventoryTTran();
entity.SetAssignedIdTo(newId);
vm.TransId = newId;
vm.Stocks = new List <JmInventoryTStockViewModel>();
_IJmInventoryTTranTasks.Insert(entity);
}
else
{
JmInventoryTTran trans = this._IJmInventoryTTranTasks.One(EditTransId);
vm.SupplierId = trans.SupplierId != null ? trans.SupplierId.Id : string.Empty;
vm.SupplierName = trans.SupplierId != null ? trans.SupplierId.SupplierName : string.Empty;
JmInventoryMSupplierViewModel supplierVm = new JmInventoryMSupplierViewModel();
if (trans.SupplierId != null)
{
supplierVm.SupplierId = trans.SupplierId.Id;
supplierVm.SupplierName = trans.SupplierId.SupplierName;
}
//vm.SupplierIdForEdit = supplierVm;
vm.TransNo = trans.TransNo;
vm.TransDate = trans.TransDate;
//TransType = entity.TransType;
vm.TransStatus = trans.TransStatus;
vm.TransApprovedBy = trans.TransApprovedBy;
vm.TransApprovedDate = trans.TransApprovedDate;
vm.TransInputBy = trans.TransInputBy;
vm.TransInputDate = trans.TransInputDate;
vm.InvoiceNo = trans.InvoiceNo;
vm.TransDesc = trans.TransDesc;
vm.TransId = trans.Id;
vm.Stocks = new List <JmInventoryTStockViewModel>();
}
return(View(vm));
}
