public JsonResult EditExpirePR1(BMLPurchaseOrderVM model)
{
var result = false;
var GetTgl = model.purchaseRequisitionHeader.DueDate;
if (GetTgl != null)
{
PurchaseRequisitionHeader purchaseRequisitionHeader = _balimoonBMLContext.PurchaseRequisitionHeader.FirstOrDefault(a => a.RequisitionHeaderId == model.purchaseRequisitionHeader.RequisitionHeaderId);
if (purchaseRequisitionHeader != null)
{
purchaseRequisitionHeader.DueDate = model.purchaseRequisitionHeader.DueDate;
purchaseRequisitionHeader.ExpirationDate = model.purchaseRequisitionHeader.DueDate;
_balimoonBMLContext.PurchaseRequisitionHeader.Update(purchaseRequisitionHeader);
_balimoonBMLContext.SaveChanges();
//Cek Line apakah ada
var Line = _balimoonBMLContext.PurchaseRequisitionLine.FirstOrDefault(i => i.RequisitionheaderId == model.purchaseRequisitionHeader.RequisitionHeaderId);
if (Line != null)
{
Line.DueDate = model.purchaseRequisitionHeader.DueDate;
Line.ExpirationDate = model.purchaseRequisitionHeader.DueDate;
_balimoonBMLContext.PurchaseRequisitionLine.Update(Line);
_balimoonBMLContext.SaveChanges();
result = true;
}
result = true;
}
else
{
result = false;
}
}
return(Json(result));
}
public static PurchaseRequisitionHeader CreatePurchaseRequisitionHeader(string requisitionNumber, global::System.DateTimeOffset defaultAccountingDate, global::System.DateTimeOffset defaultRequestedDate)
{
PurchaseRequisitionHeader purchaseRequisitionHeader = new PurchaseRequisitionHeader();
purchaseRequisitionHeader.RequisitionNumber = requisitionNumber;
purchaseRequisitionHeader.DefaultAccountingDate = defaultAccountingDate;
purchaseRequisitionHeader.DefaultRequestedDate = defaultRequestedDate;
return(purchaseRequisitionHeader);
}
public IActionResult AddNewPRHeader(PurchaseRequestViewModel model)
{
var projectCode = model.PRHeaderDetail.ShortcutDimension2Code;
if (projectCode == null)
{
projectCode = "";
}
//compare date
DateTime now = DateTime.Now;
DateTime dummy = new DateTime(1900, 1, 1);
DateTime due = Convert.ToDateTime(model.PRHeaderDetail.DueDate);
TimeSpan compare = due - now;
var getDiff = compare.Days;
if (getDiff < 14)
{
return(Json(new { status = false, message = "The minimum date of Receipt is 14 days from now" }));
}
else
{
var PRNO = newPRNO();
//Insert Data
var insert = new PurchaseRequisitionHeader
{
RequisitionNo = PRNO,
DueDate = model.PRHeaderDetail.DueDate,
RequesterId = model.PRHeaderDetail.RequesterId,
ShortcutDimension1Code = model.PRHeaderDetail.ShortcutDimension1Code,
ShortcutDimension2Code = projectCode,
ExpirationDate = dummy,
OrderDate = now,
Status = 0,
Priority = model.PRHeaderDetail.Priority,
RequestNotes = model.PRHeaderDetail.RequestNotes,
PurchaseNo = "",
RowStatus = 0,
CreatedBy = model.PRHeaderDetail.RequesterId,
CreatedTime = DateTime.Now,
LocationCode = model.PRHeaderDetail.LocationCode
};
_bmlContext.PurchaseRequisitionHeader.Add(insert);
_bmlContext.SaveChanges();
return(Json(new { status = true, message = "Data Saved succesfull" }));
}
}
