public List <PremiumPaymentView> GetAllPremiumPayments() { using (var prerepo = new PremiumPaymentRepository()) { return(prerepo.GetAll().Select(x => new PremiumPaymentView() { PolicyHolderIdNo = x.IDNumber, Month = x.Month, Date = x.Date, AmountPaid = x.AmountPaid, PaymentFor = x.PaymentFor, PaymentMethod = x.PaymentMethod, PaymentId = x.PaymentId, }).ToList()); } }
public void AddPremiumPayment(PremiumPaymentView objPremiumPaymentView) { using (var premiumrepo = new PremiumPaymentRepository()) { var premium = new PremiumPayment { IDNumber = objPremiumPaymentView.PolicyHolderIdNo, AmountPaid = objPremiumPaymentView.AmountPaid, Month = objPremiumPaymentView.Month, Date = DateTime.Now, PaymentFor = "Premium Payment", PaymentMethod = "Cash", PaymentId = objPremiumPaymentView.PaymentId }; premiumrepo.Insert(premium); } }
public List <PersonalPaymentHistory> getPaymentHistory(string IDNum) { using (var pay = new PremiumPaymentRepository()) { var getMyOwn = (from i in pay.GetAll() where i.IDNumber == IDNum select i).ToList(); return(getMyOwn.Select(x => new PersonalPaymentHistory() { AmountPaid = x.AmountPaid, Date = x.Date, Month = x.Month, PaymentFor = x.PaymentFor, PaymentId = x.PaymentId, PaymentMethod = x.PaymentMethod }).ToList()); } }
//Searching public PersonalPaymentHistory getPaymentByMonth(string IDNum, string month) { using (var pay = new PremiumPaymentRepository()) { var getMyOwn = pay.GetAll().Find(x => x.IDNumber == IDNum && x.Month.ToLower() == month.ToLower()); if (getMyOwn != null) { return(new PersonalPaymentHistory() { AmountPaid = getMyOwn.AmountPaid, Date = getMyOwn.Date, Month = getMyOwn.Month, PaymentFor = getMyOwn.PaymentFor, PaymentId = getMyOwn.PaymentId, PaymentMethod = getMyOwn.PaymentMethod }); } return(null); } }