public Prq_BillPayment SetToModelObject(PrqBillPayment model) { Prq_BillPayment Entity = new Prq_BillPayment(); Entity.PaymentDate = DalCommon.SetDate(model.PaymentDate);// Convert.ToDateTime(Convert.ToDateTime(model.PaymentDate).ToString("dd/MM/yyyy")); Entity.SupplierID = model.SupplierID; Entity.SupplierAddressID = model.SupplierAddressID; Entity.PaymentType = model.PaymentType; Entity.PaymentMethod = model.PaymentMethod; Entity.Currency = model.Currency; Entity.PaymentDoc = model.PaymentDoc; Entity.BillAmount = model.BillAmount; Entity.VatPercentage = model.VatPercentage; Entity.VatAmount = model.VatAmount; Entity.DeductAmount = model.DeductAmount; Entity.PaymentAmount = model.PaymentAmount; Entity.Remarks = model.Remarks; Entity.RecordStatus = "NCF"; Entity.PurchaseYear = model.PurchaseYear; Entity.PaymentStatus = true; Entity.SetOn = DateTime.Now; Entity.SetBy = model.SetBy; Entity.IPAddress = string.Empty; return(Entity); }
public PrqBillPayment GetSupplierBillPaymentAmount(PrqBillPayment model) { PrqBillPayment modeldata = new PrqBillPayment(); if (model.BillPaymentReferenceList != null) { foreach (var BillPaymentReference in model.BillPaymentReferenceList) { //modeldata.BillAmount += Convert.ToDecimal(_context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) // .FirstOrDefault().TotalAmt == null ? 0 : _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) // .FirstOrDefault().TotalAmt); //modeldata.DeductAmount = _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID).FirstOrDefault().DiscountAmt != null ? _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID).FirstOrDefault().DiscountAmt : 0; //modeldata.DeductAmount += modeldata.DeductAmount; //modeldata.PaymentAmount = modeldata.BillAmount + modeldata.DeductAmount; //var approvedAmt = // _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) // .FirstOrDefault().ApprovedAmt == null ? 0 : _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) // .FirstOrDefault().ApprovedAmt; var approvedAmt = _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) .FirstOrDefault().ApprovedAmt == null ? 0 : _context.Prq_SupplierBill.Where(m => m.SupplierBillID == BillPaymentReference.SupplierBillID) .FirstOrDefault().PayableAmt; modeldata.BillAmount += Convert.ToDecimal(approvedAmt); modeldata.PaymentAmount = modeldata.BillAmount; //modeldata.PaymentAmount = modeldata.BillAmount + modeldata.DeductAmount; } } return(modeldata); }
public ActionResult GetBillPaymentListForSearch(string supplier) { PrqBillPayment model = new PrqBillPayment(); model.BillPaymentList = Dalobject.GetBillPaymentList().Where(m => m.SupplierName.StartsWith(supplier)).ToList(); model.Count = model.BillPaymentList.Count > 1 ? model.Count = 0 : model.Count = 1; return(Json(model, JsonRequestBehavior.AllowGet)); }
//public List<PrqBillPayment> GetBillPaymentListForSearch(string supplier) //{ // List<Prq_BillPayment> searchList = _context.Prq_BillPayment.Where(m => m.RecordStatus == "NCF").ToList(); //using table // return searchList.Select(c => SetToBussinessObject(c)).ToList<PrqBillPayment>(); //} public PrqBillPayment SetToBussinessObject(Prq_BillPayment Entity) { PrqBillPayment model = new PrqBillPayment(); model.PaymentID = Entity.PaymentID; model.PaymentDate = Entity.PaymentDate.ToString("dd/MM/yyyy"); model.SupplierID = Entity.SupplierID; model.SupplierName = _context.Sys_Supplier.Where(m => m.SupplierID == Entity.SupplierID).FirstOrDefault().SupplierName; model.SupplierCode = _context.Sys_Supplier.Where(m => m.SupplierID == Entity.SupplierID).FirstOrDefault().SupplierCode; model.SupplierAddressID = Entity.SupplierAddressID; var abc = _context.Sys_SupplierAddress.Where( q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)) .FirstOrDefault(); if (abc != null) { model.Address = _context.Sys_SupplierAddress.Where(q => q.SupplierID == Entity.SupplierID && q.IsActive.Equals(true) && q.IsDelete.Equals(false)).FirstOrDefault().Address; } model.PaymentType = Entity.PaymentType; model.PaymentTypeName = _context.Sys_PaymentType.Where(m => m.ID == Entity.PaymentType).FirstOrDefault().Name; model.PaymentMethod = Entity.PaymentMethod; model.Currency = Entity.Currency; model.PaymentDoc = Entity.PaymentDoc; model.BillAmount = Entity.BillAmount; model.VatPercentage = Entity.VatPercentage; model.VatAmount = Entity.VatAmount; model.DeductAmount = Entity.DeductAmount; model.PaymentAmount = Entity.PaymentAmount; model.Remarks = Entity.Remarks; model.PurchaseYear = Entity.PurchaseYear; model.PaymentStatus = Entity.PaymentStatus; model.Remarks = Entity.Remarks; model.RecordStatus = Entity.RecordStatus; switch (Entity.RecordStatus) { case "NCF": model.RecordStatusName = "Not Confirmed"; break; case "CNF": model.RecordStatusName = "Confirmed"; break; case "APV": model.RecordStatusName = "Approved"; break; //case "CMP": // model.RecordStatusName = "Completed"; // break; default: model.RecordStatusName = ""; break; } return(model); }
public ValidationMsg Save(PrqBillPayment model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.SetBy = userid; Prq_BillPayment tblBillPayment = SetToModelObject(model); _context.Prq_BillPayment.Add(tblBillPayment); _context.SaveChanges(); #region Save Detail Records if (model.BillPaymentReferenceList != null) { foreach ( PrqBillPaymentReference objPrqBillPaymentReference in model.BillPaymentReferenceList) { objPrqBillPaymentReference.PaymentID = tblBillPayment.PaymentID; objPrqBillPaymentReference.RecordStatus = "NCF"; Prq_BillPaymentReference tblPurchaseYearPeriod = SetToModelObject(objPrqBillPaymentReference); _context.Prq_BillPaymentReference.Add(tblPurchaseYearPeriod); } } _context.SaveChanges(); #endregion tx.Complete(); PaymentID = tblBillPayment.PaymentID; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public ValidationMsg Update(PrqBillPayment model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.ModifiedBy = userid; Prq_BillPayment CurrentEntity = SetToModelObject(model); var OriginalEntity = _context.Prq_BillPayment.First(m => m.PaymentID == model.PaymentID); OriginalEntity.PaymentDate = CurrentEntity.PaymentDate;// Convert.ToDateTime(Convert.ToDateTime(CurrentEntity.PaymentDate).ToString("dd/MM/yyyy")); OriginalEntity.SupplierID = CurrentEntity.SupplierID; OriginalEntity.SupplierAddressID = CurrentEntity.SupplierAddressID; OriginalEntity.PaymentType = CurrentEntity.PaymentType; OriginalEntity.PaymentMethod = CurrentEntity.PaymentMethod; OriginalEntity.Currency = CurrentEntity.Currency; OriginalEntity.PaymentDoc = CurrentEntity.PaymentDoc; OriginalEntity.BillAmount = CurrentEntity.BillAmount; OriginalEntity.VatPercentage = CurrentEntity.VatPercentage; OriginalEntity.VatAmount = CurrentEntity.VatAmount; OriginalEntity.DeductAmount = CurrentEntity.DeductAmount; OriginalEntity.PaymentAmount = CurrentEntity.PaymentAmount; OriginalEntity.Remarks = CurrentEntity.Remarks; OriginalEntity.ModifiedBy = userid; OriginalEntity.ModifiedOn = DateTime.Now; #region Save Detail Records if (model.BillPaymentReferenceList != null) { foreach (PrqBillPaymentReference objPrqBillPaymentReference in model.BillPaymentReferenceList) { if (objPrqBillPaymentReference.PaymentID == 0) { objPrqBillPaymentReference.PaymentID = model.PaymentID; objPrqBillPaymentReference.RecordStatus = "NCF"; Prq_BillPaymentReference tblPurchaseYearPeriod = SetToModelObject(objPrqBillPaymentReference); _context.Prq_BillPaymentReference.Add(tblPurchaseYearPeriod); } else { Prq_BillPaymentReference CurEntity = SetToModelObject(objPrqBillPaymentReference); var OrgEntity = _context.Prq_BillPaymentReference.First(m => m.PaymentID == objPrqBillPaymentReference.PaymentID && m.SupplierBillID == objPrqBillPaymentReference.SupplierBillID); OrgEntity.SupplierBillRef = CurEntity.SupplierBillRef; } } } _context.SaveChanges(); #endregion tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } return(_vmMsg); }
public ActionResult GetSupplierBillPaymentAmount(PrqBillPayment model) { var billPaymentAmount = Dalobject.GetSupplierBillPaymentAmount(model); return(Json(billPaymentAmount, JsonRequestBehavior.AllowGet)); }
public ActionResult BillPayment(PrqBillPayment model) { _vmMsg = model.PaymentID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"])) : Dalobject.Update(model, Convert.ToInt32(Session["UserID"])); return(Json(new { PaymentID = Dalobject.GetPaymentID(), msg = _vmMsg })); }