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