public bool UpdateGym(int id, Gym gymDetails) { bool isSuccess = false; try { using (var ctx = new FitnessproEntities()) { Gym gymdetails = ctx.Gyms.Where(x => x.GymId == id).SingleOrDefault(); gymdetails.FirstName = gymDetails.FirstName; gymdetails.LastName = gymDetails.LastName; gymdetails.GymName = gymDetails.GymName; gymdetails.MobileNumber = gymDetails.MobileNumber; gymdetails.TelephoneNumber = gymDetails.TelephoneNumber; gymdetails.EnrolledDate = gymDetails.EnrolledDate; gymdetails.Email = gymDetails.Email; gymdetails.EstablishedYear = gymDetails.EstablishedYear; ctx.SaveChanges(); } } catch (Exception) { isSuccess = false; throw; } return(isSuccess); }
public bool CreateGym(Gym gymDetails) { bool isSuccess = false; try { using (var ctx = new FitnessproEntities()) { ctx.Gyms.Add(gymDetails); ctx.SaveChanges(); isSuccess = true; } } catch (Exception) { isSuccess = false; throw; } return(isSuccess); }
public IEnumerable <GymViewModel> GymList() { using (var ctx = new FitnessproEntities()) { List <GymViewModel> gymList = (from g in ctx.Gyms select new GymViewModel { GymId = g.GymId, GymName = g.GymName, FirstName = g.FirstName, LastName = g.LastName, MobileNumber = (long)g.MobileNumber, TelephoneNumber = (long)g.TelephoneNumber, EnrolledDate = (DateTime)g.EnrolledDate, Email = g.Email, EstablishedYear = (int)g.EstablishedYear, ServiceId = (int)g.ServiceId }).ToList(); return(gymList); } }