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));
}
