public ActionResult BillDetailsByBillNo(int id = 0)
{
EntryMemberModel li = new EntryMemberModel();
if (id > 0)
{
var data = context.tbl_EntryMember_Billing.SingleOrDefault(x => x.Bill_ID == id);
li.BillNo = data.Bill_ID;
li.Name = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == data.Member_ID).Name;
li.Phone_No = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == data.Member_ID).MobileNo;
li.Total_Member = data.Members;
li.AmountPaid = data.Amount_Paid;
li.ModeOfPayment = data.Mode_Of_Payment;
li.DateofBilling = data.Date_Of_Billing;
li.TokenNo = data.TokenNo;
li.ID = Convert.ToInt32(data.Member_ID);
}
return(View(li));
}
public JsonResult SaveBill(string PayMode, int ID)
{
if (ID > 0)
{
if (context.tbl_EntryMember_Billing.Where(x => x.Member_ID == ID).Any())
{
var data = context.tbl_EntryMember_Billing.Where(x => x.Member_ID == ID).FirstOrDefault();
EntryMemberModel li = new EntryMemberModel();
li.BillNo = data.Bill_ID;
li.Name = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).Name;
li.Phone_No = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).MobileNo;
li.Total_Member = data.Members;
li.AmountPaid = data.Amount_Paid;
li.ModeOfPayment = data.Mode_Of_Payment;
li.DateofBilling = data.Date_Of_Billing;
li.GstAmount = data.Gst_Amount;
li.Total_Amount = data.Total_Amount;
li.Price_Without_Gst = data.Price_Without_Gst;
li.TokenNo = data.TokenNo == null?string.Empty:data.TokenNo;
li.Entrybillno = data.Entrybillno;
return(Json(li));
}
else
{
tbl_EntryMember_Billing model = new tbl_EntryMember_Billing();
var date = DateTime.Today;
var DateForToken = date.ToString("ddMMyyyy");
string Token = "";
Token = DateForToken + "_001";
var LastToken = context.tbl_EntryMember_Billing.ToList().LastOrDefault();
if (LastToken != null)
{
var LastTokenNumber = context.tbl_EntryMember_Billing.ToList().LastOrDefault().TokenNo;
if (LastTokenNumber.Contains(DateForToken))
{
int CurrentValue = GetTokenNo(LastTokenNumber) + 1;
model.TokenNo = DateForToken + "_00" + CurrentValue;
}
else
{
model.TokenNo = Token;
}
}
else
{
model.TokenNo = Token;
}
model.Price_With_Gst = double.Parse(context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).EntryFee);
model.Gst_Amount = Convert.ToDouble(model.Price_With_Gst) * (Convert.ToDouble(18) / (double)100);
model.Price_Without_Gst = Convert.ToDouble(model.Price_With_Gst) - Convert.ToDouble(model.Gst_Amount);
model.Members = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).qty;
model.Gst_Amount = Convert.ToDouble(model.Gst_Amount) * Convert.ToDouble(model.Members);
model.Total_Amount = double.Parse(context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).TotalAmount);
model.Amount_Paid = model.Total_Amount + model.Gst_Amount;
model.Mode_Of_Payment = PayMode;
model.Billed_By = Convert.ToInt32(Request.Cookies["UserID"].Value);
model.Member_ID = ID;
model.Entrybillno = GetBillNO();
model.Date_Of_Billing = DateTime.Now.ToString("MM/dd/yyyy");
context.tbl_EntryMember_Billing.Add(model);
context.SaveChanges();
EntryMemberModel li = new EntryMemberModel();
li.BillNo = model.Bill_ID;
li.Name = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).Name;
li.Phone_No = context.tbl_EntryMembers.SingleOrDefault(x => x.ID == ID).MobileNo;
li.Total_Member = model.Members;
li.AmountPaid = model.Amount_Paid;
li.ModeOfPayment = model.Mode_Of_Payment;
li.DateofBilling = model.Date_Of_Billing;
li.GstAmount = model.Gst_Amount;
li.Price_Without_Gst = model.Price_Without_Gst;
li.Total_Amount = model.Total_Amount;
li.TokenNo = model.TokenNo;
li.Entrybillno = model.Entrybillno;
return(Json(li));
}
}
return(Json("not Found"));
}
