public int DeleteMembershipType(int mtid)
{
tblMembershipType tmt = _db.tblMembershipTypes.Where(m => m.MT_ID == mtid).FirstOrDefault();
_db.tblMembershipTypes.Remove(tmt);
return(_db.SaveChanges());
}
public ActionResult Edit(tblMembershipType model, int id)
{
if (ModelState.IsValid)
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(PartialView("_Details", db.tblMembershipTypes.ToList()));
}
public int UpdateMembershipType(MembershipTypeDetails mtd)
{
tblMembershipType tmt = _db.tblMembershipTypes.Where(m => m.MT_ID == mtd.MT_ID).FirstOrDefault();
tmt.MembershipType = mtd.MembershipType;
tmt.ChargesPerMonth = mtd.ChargesPerMonth;
tmt.ServiceTAX = mtd.ServiceTAX;
tmt.VAT = mtd.VAT;
return(_db.SaveChanges());
}
public int AddNewMembershipType(MembershipTypeDetails mtd)
{
tblMembershipType tmt = new tblMembershipType();
tmt.MembershipType = mtd.MembershipType;
tmt.ChargesPerMonth = mtd.ChargesPerMonth;
tmt.ServiceTAX = mtd.ServiceTAX;
tmt.VAT = mtd.VAT;
_db.tblMembershipTypes.Add(tmt);
return(_db.SaveChanges());
}
public ActionResult Add(MembershipTypeViewModel model)
{
if (ModelState.IsValid)
{
tblMembershipType tb = new tblMembershipType();
tb.MembershipName = model.MembershipName;
tb.Price = model.Price;
db.tblMembershipTypes.Add(tb);
db.SaveChanges();
return(PartialView("_Details", db.tblMembershipTypes.ToList()));
}
return(PartialView("Add", db.tblMembershipTypes.ToList()));
}
public ActionResult GetMemberTotalPaymentAmount(int memberid)
{
tblMembership tbmem = _db.tblMemberships.Where(m => m.MembershipId == memberid).FirstOrDefault();
int? membershiptypeid = tbmem.MembershipTypeId;
tblMembershipType tbmtype = _db.tblMembershipTypes.Where(mem => mem.MembershipTypeId == membershiptypeid).FirstOrDefault();
//int? month = tbmtype.AllowedMonth;
//int? totaldays = month * 30;
//SqlConnection con = new SqlConnection("Data Source=.; Integrated Security=true; Database=GymDB");
//SqlCommand cmd = new SqlCommand("select Sum(PaidAmount) as TotalAmount from tblPayment where PaymentDate>=(Getdate()-"+totaldays+") group by MemberId", con);
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//da.Fill(dt);
//var totalamount = dt.Rows[0][0].ToString();
//var states = _db.tblPayments.Where(m => m.MemberId == memberid).FirstOrDefault();
var price = tbmtype.Price;
return(Json(price, JsonRequestBehavior.AllowGet));
}
