public ValidationMsg Save(PrqChemLocalPurcBillPay model, int userId)
{
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
var bill = ConvertBillPayment(model, userId);
if (bill.PaymentID == 0)
{
_context.PRQ_ChemLocalPurcBillPayment.Add(bill);
_context.SaveChanges();
_mode = 1;
}
else
{
_context.SaveChanges();
_mode = 2;
}
if (model.References != null)
{
foreach (var reference in model.References)
{
var entityRef = ConvertBillPaymentReference(reference, bill.PaymentID, userId);
if (entityRef.BillPaymtRefID == 0)
{
_context.PRQ_ChemBillPymtReference.Add(entityRef);
_context.SaveChanges();
}
else
{
_context.SaveChanges();
}
}
}
tx.Complete();
if (_mode == 1)
{
_validationMsg.ReturnId = bill.PaymentID;
_validationMsg.ReturnCode = bill.PaymentNo;
_validationMsg.Type = Enums.MessageType.Success;
_validationMsg.Msg = "Saved successfully.";
}
if (_mode == 2)
{
_validationMsg.Type = Enums.MessageType.Update;
_validationMsg.Msg = "Updated successfully.";
}
}
}
}
catch
{
_validationMsg.Type = Enums.MessageType.Error;
_validationMsg.Msg = "Failed to save.";
}
return(_validationMsg);
}
public ActionResult GetBillPayById(long paymentId)
{
var bill = _unit.ChemicalLocalPurchaseBillPaymentRepository.GetByID(paymentId);
var result = new PrqChemLocalPurcBillPay
{
PaymentId = bill.PaymentID,
PaymentNo = bill.PaymentNo,
PaymentDate = string.Format("{0:dd/MM/yyyy}", bill.PaymentDate),
SupplierId = bill.SupplierID,
SupplierNo = bill.SupplierID == null
? ""
: _unit.SysSupplierRepository.GetByID(bill.SupplierID).SupplierCode,
SupplierName = bill.SupplierID == null
? ""
: _unit.SysSupplierRepository.GetByID(bill.SupplierID).SupplierName,
SupplierAddressId = bill.SupplierAddressID,
SupplierAddress = bill.SupplierAddressID == null
? ""
: _unit.SupplierAddressRepository.GetByID(bill.SupplierAddressID).Address,
PurchaseYear = bill.PurchaseYear,
PaymentType = bill.PaymentType,
PaymentMethod = bill.PaymentMethod,
Currency = bill.Currency,
PaymentDoc = bill.PaymentDoc,
BillAmount = bill.BillAmount,
VatAmount = bill.VatAmount,
DeductAmount = bill.DeductAmount,
PaymentAmount = bill.PaymentAmount,
PaymentStatus = bill.PaymentStatus,
Remarks = bill.Remarks,
RecordStatus = bill.RecordStatus,
CheckedBy = bill.CheckedBy,
CheckedByName = bill.CheckedBy == null
? ""
: _unit.SysSupplierRepository.GetByID(bill.CheckedBy).SupplierName,
CheckComments = bill.CheckComments,
ApprovedBy = bill.ApprovedBy,
ApprovedByName = bill.ApprovedBy == null
? ""
: _unit.SysSupplierRepository.GetByID(bill.ApprovedBy).SupplierName,
ApprovalAdvice = bill.ApprovalAdvice,
References =
_unit.ChemicalBillPaymentReference.Get().Where(ob => ob.PaymentID == bill.PaymentID).Select(
reff => new PrqChemBillPymtRef
{
BillPaymtRefID = reff.BillPaymtRefID,
PaymentID = reff.PaymentID,
BillID = reff.BillID,
BillNo =
reff.BillID == null
? ""
: _unit.ChemicalLocalPurchaseBillRepository.GetByID(reff.BillID).BillNo,
SupplierBillNo = reff.SupplierBillNo,
RecordStatus = reff.RecordStatus
}).ToList()
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
private PRQ_ChemLocalPurcBillPayment ConvertBillPayment(PrqChemLocalPurcBillPay model, int userId)
{
var entity = model.PaymentId == 0 ? new PRQ_ChemLocalPurcBillPayment() : (from b in _context.PRQ_ChemLocalPurcBillPayment.AsEnumerable()
where b.PaymentID == model.PaymentId
select b).FirstOrDefault();
entity.PaymentID = model.PaymentId;
entity.PaymentNo = model.PaymentNo;
entity.PaymentDate = DalCommon.SetDate(model.PaymentDate);
entity.SupplierID = model.SupplierId;
entity.SupplierAddressID = model.SupplierAddressId;
entity.PurchaseYear = model.PurchaseYear;
entity.PaymentType = model.PaymentType;
entity.PaymentMethod = model.PaymentMethod;
entity.Currency = model.Currency;
entity.PaymentDoc = model.PaymentDoc;
entity.BillAmount = model.BillAmount;
entity.VatAmount = model.VatAmount;
entity.DeductAmount = model.DeductAmount;
entity.PaymentAmount = model.PaymentAmount;
entity.PaymentStatus = model.PaymentStatus;
entity.Remarks = model.Remarks;
entity.RecordStatus = model.PaymentId == 0
? "NCF"
: _unit.ChemicalLocalPurchaseBillPaymentRepository.GetByID(model.PaymentId).RecordStatus;
entity.SetOn = model.PaymentId == 0
? DateTime.Now
: _unit.ChemicalLocalPurchaseBillPaymentRepository.GetByID(model.PaymentId).SetOn;
entity.SetBy = model.PaymentId == 0
? userId
: _unit.ChemicalLocalPurchaseBillPaymentRepository.GetByID(model.PaymentId).SetBy;
entity.ModifiedBy = model.PaymentId == 0 ? (int?)null : userId;
entity.ModifiedOn = model.PaymentId == 0 ? (DateTime?)null : DateTime.Now;
return(entity);
}
public ActionResult Save(PrqChemLocalPurcBillPay model)
{
_userId = Convert.ToInt32(Session["UserID"]);
_validationMsg = _dalPrqChemLocalPurcBillPay.Save(model, _userId);
return(Json(_validationMsg, JsonRequestBehavior.AllowGet));
}
