public bool Insert(WAMS_REQUISITION_MASTER entity, List <WAMS_REQUISITION_DETAILS> entityDetails)
{
_repository.Add(entity);
_unitOfWork.CommitChanges();
foreach (var detail in entityDetails)
{
var detailEntity = new WAMS_REQUISITION_DETAILS
{
vMRF = entity.Id,
vStockID = detail.vStockID,
fQuantity = detail.fQuantity,
fTobePurchased = detail.fTobePurchased,
Remark = detail.Remark,
iFollowUpRequired = 1,
iPurchased = 0,
iSent = 0,
vStatus = "Open",
iEnable = true,
dDateAssign = entity.dCreated,
dCreated = entity.dCreated,
iCreated = entity.iCreated
};
_repositoryDetail.Add(detailEntity);
}
_unitOfWork.CommitChanges();
return(true);
}
public ActionResult Create(int?id)
{
var userName = System.Web.HttpContext.Current.User.Identity.Name;
var user = _systemService.GetUserAndRole(0, userName);
if (user == null)
{
return(RedirectToAction("Index", "Login"));
}
if (user.RequisitionR == 0)
{
return(RedirectToAction("Index", "Home"));
}
var item = new WAMS_REQUISITION_MASTER();
if (id.HasValue)
{
item = _service.GetByKey(id.Value);
}
else
{
item.vMRF =
(Convert.ToInt32(_service.GetCodeLastest()) + 1).ToString(CultureInfo.InvariantCulture);
}
var model = new RequisitionViewModel
{
Id = item.Id,
vMRF = item.vMRF,
vFrom = item.vFrom,
iStore = item.iStore,
vDeliverLocation = item.vDeliverLocation,
vProjectID = item.vProjectID,
Timestamp = item.Timestamp,
UserLogin = user,
Stores = new SelectList(_systemService.StoreList(), "Id", "Name"),
Projects = new SelectList(_systemService.ProjectList(), "Id", "vProjectID"),
ProjectNames = new SelectList(_systemService.ProjectList(), "Id", "vProjectName")
};
if (id.HasValue)
{
var temp = _service.ListConditionDetail(id.Value, "1");
model.GetRequisitionDetailsVResults = temp;
model.TotalRecords = temp.Count;
}
if (item.dDeliverDate.HasValue)
{
model.DeliverDateTemp = item.dDeliverDate.Value.ToString("dd/MM/yyyy");
}
return(View(model));
}
public bool Update(WAMS_REQUISITION_MASTER entity, List <WAMS_REQUISITION_DETAILS> entityDetails, string LstDeleteDetailItem)
{
_repository.Update(entity);
foreach (var detail in entityDetails)
{
if (detail.ID != 0)
{
var detailEntity = _repositoryDetail.GetByKey(detail.ID);
detailEntity.vStockID = detail.vStockID;
detailEntity.fQuantity = detail.fQuantity;
detailEntity.fTobePurchased = detail.fTobePurchased;
detailEntity.Remark = detail.Remark;
detailEntity.dModified = DateTime.Now;
detailEntity.iModified = entity.iModified;
_repositoryDetail.Update(detailEntity);
}
else
{
var detailEntity = new WAMS_REQUISITION_DETAILS
{
vMRF = entity.Id,
vStockID = detail.vStockID,
fQuantity = detail.fQuantity,
fTobePurchased = detail.fTobePurchased,
Remark = detail.Remark,
iFollowUpRequired = 1,
iPurchased = 0,
iSent = 0,
vStatus = "Open",
iEnable = true,
dDateAssign = entity.dCreated,
dCreated = entity.dCreated,
iCreated = entity.iCreated
};
_repositoryDetail.Add(detailEntity);
}
}
if (!string.IsNullOrEmpty(LstDeleteDetailItem))
{
var listStrLineElements = LstDeleteDetailItem.Split(';').ToList();
foreach (var itemDetail in listStrLineElements)
{
_customRepository.DeleteDetail(Convert.ToInt32(itemDetail));
}
}
_unitOfWork.CommitChanges();
return(true);
}