public SaveResult <POEntryModel> Save(PODTO pODTO, DateTime dateStamp)
{
if (pODTO.Status_FK == 0)
{
pODTO.Status_FK = 1;
}
ModelValidationResult validationResult = POValidator.Validate(pODTO);
bool success = false;
POEntryModel model = null;
if (validationResult.IsValid)
{
tblT_PO po = Insert(pODTO, dateStamp);
Db.SaveChanges();
pODTO.PO_PK = po.PO_PK;
success = true;
model = POEntryDataProvider.Get(pODTO.PO_PK);
}
return(new SaveResult <POEntryModel>
{
Success = success,
Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.",
Model = model,
ValidationResult = validationResult
});
}
public void UpdatePO(PODTO pODTO, DateTime dateStamp)
{
if (pODTO == null)
{
throw new ArgumentNullException("PO model is null.");
}
tblT_PO user = pOFactory.CreateFromDbAndUpdateFromDTO(pODTO, dateStamp);
}
public tblT_PO Insert(PODTO pODTO, DateTime dateStamp)
{
if (pODTO == null)
{
throw new ArgumentNullException("User model is null.");
}
tblT_PO pO = POFactory.CreateFromDTO(pODTO, dateStamp);
return(Db.tblT_PO.Add(pO));
}
private POEntryModel GetCreateStateModel()
{
POEntryFormData formData = new POEntryFormData();
PODTO pODTO = new PODTO();
return(new POEntryModel()
{
FormData = formData,
Model = new PODTO(),
});
}
public tblT_PO AddPO(PODTO poDTO, DateTime dateStamp)
{
if (poDTO == null)
{
throw new ArgumentNullException("PO model is null.");
}
tblT_PO po = poFactory.CreateFromDTO(poDTO, dateStamp);
po = Db.tblT_PO.Add(po);
Db.SaveChanges();
poDTO.PO_PK = po.PO_PK;
return(po);
}
private POEntryModel GetUpdateStateModel(int po_PK)
{
POEntryFormData formData = new POEntryFormData();
PODTO pODTO = POQuery.GetByPrimaryKey(po_PK);
if (pODTO == null)
{
throw new KairosException($"Record with primary key '{po_PK}' is not found.");
}
return(new POEntryModel()
{
FormData = formData,
Model = pODTO
});
}
public SaveResult <POEntryModel> Save(PODTO pODTO, DateTime dateStamp)
{
ModelValidationResult validationResult = pOValidator.Validate(pODTO);
bool success = false;
POEntryModel model = null;
if (validationResult.IsValid)
{
success = true;
UpdatePO(pODTO, dateStamp);
Db.SaveChanges();
model = pOEntryDataProvider.Get(pODTO.PO_PK);
}
return(new SaveResult <POEntryModel>
{
Success = success,
Message = validationResult.IsValid ? "Data successfully updated." : "Validation error occured.",
Model = model,
ValidationResult = validationResult
});
}
// Author: Hanh Nguyen, KyawThiha
//
public string POListApi()
{
var dTOs = new List <PODTO>();
var pOs = _context.POs
.Where(p => p.POStatus == POStatus.Processing || p.POStatus == POStatus.Completed).ToList();
foreach (var po in pOs)
{
var dTO = new PODTO();
dTO.Id = po.Id;
dTO.POStatus = po.POStatus;
dTO.SupplierName = po.Supplier.Name;
dTO.OrderDate = po.OrderDate;
dTO.ReceiveDate = po.ReceiveDate;
dTO.poDetails = new List <PODetailsDTO>();
foreach (PODetail pdto in po.PODetails)
{
PODetailsDTO p = new PODetailsDTO();
p.Id = pdto.Id;
p.poID = pdto.PO.Id;
p.stationery = pdto.SupplierDetail.Stationery;
p.predictionQty = pdto.prdictedAmount;
p.Qty = pdto.Qty;
p.unitPrice = pdto.SupplierDetail.UnitPrice;
p.supplierDetailId = pdto.SupplierDetail.Id;
dTO.poDetails.Add(p);
}
dTOs.Add(dTO);
}
return(JsonSerializer.Serialize(new
{
poS = dTOs
}));
}
public PODTO GetByPrimaryKey(int primaryKey)
{
PODTO record = GetQuery().FirstOrDefault(user => user.PO_PK == primaryKey);
return(record);
}
public PODTO CreatePODTO(IXLRow row)
{
const int statusOnProgress = 1;
const int statusDone = 2;
var pO_PK = (row.Cell(1).Value.ToString() == "") ? 0 : int.Parse(row.Cell(1).Value.ToString());
var account = row.Cell(2).Value.ToString();
var projectCode = row.Cell(3).Value.ToString();
var siteIDImp = row.Cell(4).Value.ToString();
var siteID = row.Cell(5).Value.ToString();
var siteName = row.Cell(6).Value.ToString();
var dUID = row.Cell(7).Value.ToString();
var pMOUniq = row.Cell(8).Value.ToString();
var sOWAct = row.Cell(9).Value.ToString();
var system = row.Cell(10).Value.ToString();
var sOWPO = row.Cell(11).Value.ToString();
var itemDesc = row.Cell(12).Value.ToString();
var pONo = row.Cell(13).Value.ToString();
var shipmentNo = row.Cell(14).Value.ToString();
var qty = (row.Cell(15).Value.ToString() == "") ? 0 : int.Parse(row.Cell(15).Value.ToString());
var value = (row.Cell(16).Value.ToString() == "") ? 0 : int.Parse(row.Cell(16).Value.ToString());
var paymentTerm = row.Cell(17).Value.ToString();
var workStatus = row.Cell(18).Value.ToString();
var remarks = row.Cell(19).Value.ToString();
//Esar 1st
var esarSubmit1st = row.Cell(20).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(20).Value);
var vsSubmit1st = row.Cell(21).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(21).Value);
var quantity1st = (row.Cell(22).Value.ToString() == "") ? 0 : decimal.Parse(row.Cell(22).Value.ToString());
var invoiceSubmit1st = row.Cell(23).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(23).Value);
var paidDate1st = row.Cell(24).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(24).Value);
var esarStatus1st = statusOnProgress;
//Esar 2nd
var esarSubmit2nd = row.Cell(26).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(26).Value);
var vsSubmit2nd = row.Cell(27).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(27).Value);
var quantity2nd = (row.Cell(28).Value.ToString() == "") ? 0 : decimal.Parse(row.Cell(28).Value.ToString());
var invoiceSubmit2nd = row.Cell(29).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(29).Value);
var paidDate2nd = row.Cell(30).Value.ToString() == "" ? null : (DateTime?)Convert.ToDateTime(row.Cell(30).Value);
var esarStatus2nd = statusOnProgress;
//esarStatus1st & esarStatud2nd
var poStatus = statusOnProgress;
//Esar done definition
var isDone1st = esarSubmit1st != null && vsSubmit1st != null && quantity1st > 0 && invoiceSubmit1st != null && paidDate1st != null;
if (isDone1st)
{
esarStatus1st = statusDone;
}
var isDone2nd = esarSubmit2nd != null && vsSubmit2nd != null && quantity2nd > 0 && invoiceSubmit2nd != null && paidDate2nd != null;
if (isDone2nd)
{
esarStatus2nd = statusDone;
}
var poStatusIsDone = (isDone1st && quantity1st == 1) || (isDone1st && isDone2nd);
if (poStatusIsDone)
{
poStatus = statusDone;
}
var po = new PODTO()
{
PO_PK = pO_PK,
Account = account,
ProjectCode = projectCode,
SiteIDImp = siteIDImp,
SiteID = siteID,
SiteName = siteName,
DUID = dUID,
PMOUniq = pMOUniq,
SOWAct = sOWAct,
System = system,
SOWPO = sOWPO,
ItemDesc = itemDesc,
PONo = pONo,
ShipmentNo = shipmentNo,
Qty = qty,
POStatus = poStatus,
PaymentTerm = paymentTerm,
WorkStatus = workStatus,
Remarks = remarks,
EsarStatus1st = esarStatus1st,
EsarStatus2nd = esarStatus2nd,
InvoiceSubmit1st = invoiceSubmit1st,
InvoiceSubmit2nd = invoiceSubmit2nd,
EsarSubmit1st = esarSubmit1st,
EsarSubmit2nd = esarSubmit2nd,
Quantity1st = quantity1st,
Quantity2nd = quantity2nd,
PaidDate1st = paidDate1st,
PaidDate2nd = paidDate2nd,
VsSubmit1st = vsSubmit1st,
VsSubmit2nd = vsSubmit2nd,
Value = value
};
return(po);
}
