public JsonResult GetServiceBillList(ServiceBillModel model) { var members = db.Member_Service.Where(x => x.Service_Id == model.ServiceId && x.Status == model.Status && x.Member.Status == model.MemberStatus && x.Member.Organization_Id == model.Organization_Id).ToList(); List <ServiceBillModel> vm = members.Select(x => new ServiceBillModel { MemberName = x.Member.Name, Member_Id = x.Member_Id, Email = x.Member.Email, Phone = x.Member.Phone, GetAmountToPay = GetMonthlyServiceAmountToPayment(x.Id, model.Billing_Date), GetDueAmount = GetMonthlyServicePaidAmount(x.Id, model.Billing_Date), Id = x.Id, Billing_Date = model.Billing_Date }).ToList(); return(Json(vm, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveServiceBill(ServiceBillModel model) { var objUser = db.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault(); var findExistanceOfBill = db.MemberServiceBills.Where(x => x.MemberService_Id == model.Id && x.BillingDate == model.Billing_Date && x.BillToPay > 0).FirstOrDefault(); if (findExistanceOfBill != null) { MemberServiceBill updateMemberServiceBillDB = db.MemberServiceBills.Find(findExistanceOfBill.Id); updateMemberServiceBillDB.Received_Date = model.Received_Date; updateMemberServiceBillDB.ReceivedBy_Id = objUser.Id; updateMemberServiceBillDB.BillToPay = model.Amount; updateMemberServiceBillDB.AmountPaid = model.GetDueAmount; db.Entry(updateMemberServiceBillDB).State = EntityState.Modified; db.SaveChanges(); } else { MemberServiceBill memberServiceBillDB = new MemberServiceBill(); memberServiceBillDB.MemberService_Id = model.Id; memberServiceBillDB.BillToPay = model.Amount; memberServiceBillDB.AmountPaid = model.GetDueAmount; memberServiceBillDB.BillingDate = model.Billing_Date; memberServiceBillDB.Status = true; if (memberServiceBillDB.AmountPaid > 0) { memberServiceBillDB.Received_Date = DateTime.Now; memberServiceBillDB.ReceivedBy_Id = objUser.Id; db.MemberServiceBills.Add(memberServiceBillDB); db.SaveChanges(); } else { db.MemberServiceBills.Add(memberServiceBillDB); db.SaveChanges(); } } return(Json(JsonRequestBehavior.AllowGet)); }