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