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 Add(ShiftViewModel model) { if (ModelState.IsValid) { tblShift ts = new tblShift(); ts.ShiftName = model.ShiftName; ts.FromTime = model.FromTime; ts.ToTime = model.ToTime; db.tblShifts.Add(ts); db.SaveChanges(); ViewBag.Message = "Shift Added"; } return(View()); }
public ActionResult Add(AttendanceViewModel atv) { if (ModelState.IsValid) { tblAttendance tbat = db.tblAttendances.Where(a => a.MemberId == atv.MemberId && a.AttendanceDate == DateTime.Today).FirstOrDefault(); if (tbat != null) { ViewBag.Message = "Attendance Already Done"; } else { tblAttendance tb = new tblAttendance(); tb.MemberId = atv.MemberId; tb.Status = atv.Status; tb.AttendanceDate = atv.AttendanceDate; db.tblAttendances.Add(tb); db.SaveChanges(); ViewBag.Message = "Attendance Done Successfully"; } } List <MemberViewModel> lstmemvm = new List <MemberViewModel>(); var users = db.tblUsers.Where(u => u.Usertype == "User").ToList(); foreach (var item in users) { tblMembership tbm = db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault(); if (tbm != null) { lstmemvm.Add(new MemberViewModel() { MemberId = tbm.MembershipId, Fullname = item.Fullname }); } } ViewBag.Fullname = lstmemvm; return(View()); }
public ActionResult ViewProfile(UserViewModel tbu) { if (ModelState.IsValid) { tblUser uvm = _db.tblUsers.Where(u => u.UserId == tbu.UserId).FirstOrDefault(); HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName == "") { uvm.Photo = tbu.Photo; } else { uvm.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/MemberPhoto/" + fup.FileName)); } } int userid = Convert.ToInt32(Session["userid"].ToString()); uvm.Fullname = tbu.Fullname; uvm.Email = tbu.Email; uvm.Phone = tbu.Phone; uvm.Gender = tbu.Gender; _db.SaveChanges(); ViewBag.Message = "Profile Updated Successfully"; } return(View(tbu)); }
public ActionResult Add(ProteinViewModel model) { if (ModelState.IsValid) { List <ProteinViewModel> lstprotein = new List <ProteinViewModel>(); if (ModelState.IsValid) { tblProtein tb = new tblProtein(); tb.ProteinName = model.ProteinName; tb.Price = model.Price; tb.Description = model.Description; db.tblProteins.Add(tb); db.SaveChanges(); ViewBag.Message = "Protein Added"; } } return(View()); }
public ActionResult Add(MeasurementViewModel model) { if (ModelState.IsValid) { tblMeasurement tb = new tblMeasurement(); tb.MemberId = model.MemberId; tb.Weight = model.Weight; tb.Chest = model.Chest; tb.Weist = model.Weist; tb.Hip = model.Hip; tb.Thigh = model.Thigh; tb.Bicep = model.Bicep; tb.Forearm = model.Forearm; tb.MeasurementDate = model.MeasurementDate; db.tblMeasurements.Add(tb); db.SaveChanges(); ViewBag.Message = "Measurement Added"; } List <MemberViewModel> lstmemvm = new List <MemberViewModel>(); var users = db.tblUsers.ToList(); foreach (var item in users) { tblMembership tbm = db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault(); if (tbm != null) { lstmemvm.Add(new MemberViewModel() { MemberId = tbm.MembershipId, Fullname = item.Fullname }); } } ViewBag.Message = "Measurement Added Successfully"; ViewBag.Fullname = lstmemvm; return(View()); }
public ActionResult Add(GalleryViewModel model) { if (ModelState.IsValid) { tblGallery tb = new tblGallery(); tb.Title = model.Title; tb.Description = model.Description; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { tb.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/Gallery/" + fup.FileName)); } db.tblGalleries.Add(tb); db.SaveChanges(); ViewBag.Message = "Photo Saved"; } return(View()); }
public ActionResult ChangePassword(ChangePasswordViewModel ch) { int userid = Convert.ToInt32(Session["userid"].ToString()); tblUser us = _db.tblUsers.Where(u => u.UserId == userid && u.Password == ch.OldPassword).FirstOrDefault(); if (us != null) { us.Password = ch.NewPassword; _db.SaveChanges(); ViewBag.Message = "Password Changed Successfully"; } else { ViewBag.Message = "Wrong Old Password"; } ModelState.Clear(); return(View()); }
public ActionResult Create(MemberViewModel mem) { tblUser checkuser = _db.tblUsers.Where(u => u.Username == mem.Username).FirstOrDefault(); if (checkuser != null) { ViewBag.Message = "Username Already Taken"; } else { tblUser checkEmail = _db.tblUsers.Where(u => u.Email == mem.Email).FirstOrDefault(); if (checkEmail != null) { ViewBag.Message = "Email Already Taken"; } else { tblUser tb = new tblUser(); tb.Fullname = mem.Fullname; tb.Email = mem.Email; tb.Phone = mem.Phone; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { tb.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/MemberPhoto/" + fup.FileName)); } tb.Gender = mem.Gender; tb.Username = mem.Username; tb.Password = mem.Password; _db.tblUsers.Add(tb); _db.SaveChanges(); tblMembership tbm = new tblMembership(); tbm.UserId = tb.UserId; tbm.MembershipTypeId = mem.MembershipTypeId; tbm.RegDate = mem.RegDate; tbm.Fees = mem.Price; tbm.ShiftId = mem.ShiftId; _db.tblMemberships.Add(tbm); _db.SaveChanges(); UserRole ur = new UserRole(); ur.RoleId = mem.RoleId; ur.UserId = tb.UserId; _db.UserRoles.Add(ur); _db.SaveChanges(); tblPayment pay = new tblPayment(); pay.MemberId = tbm.MembershipId; pay.PaidAmount = mem.Price; pay.RemainingAmount = 0.0M; pay.PaymentDate = DateTime.Today; _db.tblPayments.Add(pay); _db.SaveChanges(); ViewBag.Message = "Member Added"; } } string regdate = DateTime.Now.ToString("MM/dd/yyyy"); ViewBag.Role = _db.Roles.ToList(); ViewBag.Shift = _db.tblShifts.ToList(); ViewBag.MembershipType = _db.tblMembershipTypes.ToList(); return(View(mem)); }
public ActionResult Add(int MemberId, string SunDesc, string MonDesc, string TueDesc, string WedDesc, string ThuDesc, string FriDesc) { if (ModelState.IsValid) { int?memberid = MemberId; tblWorkout tb = new tblWorkout(); tb.MemberId = memberid; tb.WorkoutDays = "Sunday"; tb.Description = SunDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); tb.WorkoutDays = "Monday"; tb.Description = MonDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); tb.WorkoutDays = "Tuesday"; tb.Description = TueDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); tb.WorkoutDays = "Wednesday"; tb.Description = WedDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); tb.WorkoutDays = "Thursday"; tb.Description = ThuDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); tb.WorkoutDays = "Friday"; tb.Description = FriDesc; _db.tblWorkouts.Add(tb); _db.SaveChanges(); } List <MemberViewModel> lstmemvm = new List <MemberViewModel>(); var users = _db.tblUsers.ToList(); foreach (var item in users) { tblMembership tbm = _db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault(); if (tbm != null) { lstmemvm.Add(new MemberViewModel() { MemberId = tbm.MembershipId, Fullname = item.Fullname }); } } ViewBag.Fullname = lstmemvm; ViewBag.Message = "Work out Added Successfully"; return(View()); }