//מתודה לעדכון מתקן
public static bool UpdateGymFacility(Gym_Facility gym_facility)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Gym_Facility gymFacility = db.Gym_Facility.SingleOrDefault(x => x.Facility_Code == gym_facility.Facility_Code);
if (gymFacility == null)
{
return(false);
}
else if (gymFacility != null)
{
gymFacility.Category = gym_facility.Category;
gymFacility.Facility_Name = gym_facility.Facility_Name;
gymFacility.Picture = gym_facility.Picture;
gymFacility.Big_Muscle = gym_facility.Big_Muscle;
try
{
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
return(false);
}
//מתודה למחיקת מתקן
public static bool DeleteGymFacility(int facility_code)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Gym_Facility gymFacility = db.Gym_Facility.SingleOrDefault(x => x.Facility_Code == facility_code);
if (gymFacility == null)
{
return(false);
}
else if (gymFacility != null)
{
try
{
db.Gym_Facility.Remove(gymFacility);
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
return(false);
}
//מתודה לעדכון קישור למתקן
public static bool UpdateFacilityVideoLink(Facility_Video_Link facility_video_link)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Facility_Video_Link facilityVideoLink = db.Facility_Video_Link.SingleOrDefault(x =>
x.Video_Link_Code == facility_video_link.Video_Link_Code);
if (facilityVideoLink == null)
{
return(false);
}
else if (facilityVideoLink != null)
{
facilityVideoLink.Video_Link = facility_video_link.Video_Link;
try
{
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
return(false);
}
//מתודה למחיקת קישור למתקן
public static bool DeleteFacilityVideoLink(int video_link_code)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Facility_Video_Link facilityVideoLink =
db.Facility_Video_Link.SingleOrDefault(x => x.Video_Link_Code == video_link_code);
if (facilityVideoLink == null)
{
return(false);
}
else if (facilityVideoLink != null)
{
try
{
db.Facility_Video_Link.Remove(facilityVideoLink);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
return(false);
}
//מתודה לעידכון פרטים של מאמן
public static bool UpdateTrainer(Trainer trainer)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainer trainerToUpdate = db.Trainers.SingleOrDefault(x => x.Trainer_Id == trainer.Trainer_Id);
if (trainerToUpdate == null)
{
return(false);
}
else if (trainerToUpdate != null)
{
trainerToUpdate.First_Name = trainer.First_Name;
trainerToUpdate.Last_Name = trainer.Last_Name;
trainerToUpdate.User_Name = trainer.User_Name;
trainerToUpdate.Password = trainer.Password;
trainerToUpdate.Phone_Number = trainer.Phone_Number;
try
{
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
return(false);
}
//מתודה לעדכון המלצה על מתקן של מתאמן מסויים
public static bool UpdateTrainerFacilityRecommendations(Trainer_Facility_Recommendation trainer_facility_recommendation)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainer_Facility_Recommendation trainerFacilityRecommendation = db.Trainer_Facility_Recommendation.SingleOrDefault(x =>
x.Facility_Recommendation_Code_For_Trainee == trainer_facility_recommendation.Facility_Recommendation_Code_For_Trainee);
if (trainerFacilityRecommendation == null)
{
return(false);
}
else if (trainerFacilityRecommendation != null)
{
trainerFacilityRecommendation.Recommended_Weight_To_Lift = trainer_facility_recommendation.Recommended_Weight_To_Lift;
trainerFacilityRecommendation.Amount_Of_Recommended_Repetitions = trainer_facility_recommendation.Amount_Of_Recommended_Repetitions;
try
{
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
return(false);
}
//מתודה להוספת מאמן חדש
public static bool AddTrainer(Trainer trainer)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainer trainerToAdd = new Trainer();
trainerToAdd.Trainer_Id = trainer.Trainer_Id;
trainerToAdd.First_Name = trainer.First_Name;
trainerToAdd.Last_Name = trainer.Last_Name;
trainerToAdd.User_Name = trainer.User_Name;
trainerToAdd.Password = trainer.Password;
trainerToAdd.Phone_Number = trainer.Phone_Number;
try
{
db.Trainers.Add(trainerToAdd);
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
try
{
}
catch (Exception)
{
throw;
}
return(true);
}
//POST Trainee Details
public static bool AddTrainee(Trainee traineeDetails)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainee trainee = new Trainee();
trainee.Trainee_Id = traineeDetails.Trainee_Id;
trainee.First_Name = traineeDetails.First_Name;
trainee.Last_Name = traineeDetails.Last_Name;
trainee.User_Name = traineeDetails.User_Name;
trainee.Password = traineeDetails.Password;
trainee.Phone_Number = traineeDetails.Phone_Number;
trainee.Date_Of_Birth = traineeDetails.Date_Of_Birth;
trainee.Height = traineeDetails.Height;
trainee.Weight = traineeDetails.Weight;
trainee.Gender = traineeDetails.Gender;
trainee.Address = traineeDetails.Address;
trainee.Amount_Of_Training_Per_Week = traineeDetails.Amount_Of_Training_Per_Week;
trainee.Perform_Exercises = traineeDetails.Perform_Exercises;
trainee.Training_Goal = traineeDetails.Training_Goal;
trainee.Fitness_Level = traineeDetails.Fitness_Level;
trainee.Body_Problem = traineeDetails.Body_Problem;
try {
db.Trainees.Add(trainee);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
//Put Trainee Program
public static bool UpdateTraineeProgram(Trainer_Facility_Recommendation update_program)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainer_Facility_Recommendation up_program = db.Trainer_Facility_Recommendation.SingleOrDefault(x => x.Facility_Recommendation_Code_For_Trainee == update_program.Facility_Recommendation_Code_For_Trainee);
if (up_program == null)
{
return(false);
}
else if (up_program != null)
{
up_program.Personal_Weight_To_Lift = update_program.Personal_Weight_To_Lift;
up_program.Amount_Of_Personal_Repetitions = update_program.Amount_Of_Personal_Repetitions;
try
{
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
return(false);
}
//מתודה להוספה של קישור למתקן
public static int AddFacilityVideoLink(Facility_Video_Link facility_video_link)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Facility_Video_Link facilityVideoLink = new Facility_Video_Link();
facilityVideoLink.Facility_Code = facility_video_link.Facility_Code;
facilityVideoLink.Video_Link = facility_video_link.Video_Link;
try
{
db.Facility_Video_Link.Add(facilityVideoLink);
db.SaveChanges();
}
catch (Exception)
{
return(-1);
}
return(facilityVideoLink.Video_Link_Code);
}
//POST Trainee Program
public static bool AddNewTraineeProgram(List <Trainer_Facility_Recommendation> add_program)
{
ComputerGymDBContext db = new ComputerGymDBContext();
for (int i = 0; i < add_program.Count; i++)
{
db.Trainer_Facility_Recommendation.Add(add_program[i]);
}
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
//Put Trainee Details
public static bool UpdateTraineeDetails(Trainee traineeDetails)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainee trainee = db.Trainees.SingleOrDefault(x => x.Trainee_Id == traineeDetails.Trainee_Id);
if (trainee == null)
{
return(false);
}
else if (trainee != null)
{
trainee.First_Name = traineeDetails.First_Name;
trainee.Last_Name = traineeDetails.Last_Name;
trainee.User_Name = traineeDetails.User_Name;
trainee.Password = traineeDetails.Password;
trainee.Phone_Number = traineeDetails.Phone_Number;
trainee.Date_Of_Birth = traineeDetails.Date_Of_Birth;
trainee.Height = traineeDetails.Height;
trainee.Weight = traineeDetails.Weight;
trainee.Gender = traineeDetails.Gender;
trainee.Address = traineeDetails.Address;
trainee.Amount_Of_Training_Per_Week = traineeDetails.Amount_Of_Training_Per_Week;
trainee.Perform_Exercises = traineeDetails.Perform_Exercises;
trainee.Training_Goal = traineeDetails.Training_Goal;
trainee.Fitness_Level = traineeDetails.Fitness_Level;
trainee.Body_Problem = traineeDetails.Body_Problem;
try
{
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
return(false);
}
//מתודה להוספת מתקן
public static int AddGymFacility(Gym_Facility gym_facility)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Gym_Facility gymFacility = new Gym_Facility();
gymFacility.Category = gym_facility.Category;
gymFacility.Facility_Name = gym_facility.Facility_Name;
gymFacility.Picture = gym_facility.Picture;
gymFacility.Big_Muscle = gym_facility.Big_Muscle;
try
{
db.Gym_Facility.Add(gymFacility);
db.SaveChanges();
}
catch (Exception)
{
return(-1);
}
return(gymFacility.Facility_Code);
}
//POST Trainee History
public static bool AddLineInHistory(Trainee_Facilities_History history)
{
ComputerGymDBContext db = new ComputerGymDBContext();
Trainee_Facilities_History add_history_trainee = new Trainee_Facilities_History();
add_history_trainee.Trainee_Id = history.Trainee_Id;
add_history_trainee.Amount_Of_Personal_Repetitions = history.Amount_Of_Personal_Repetitions;
add_history_trainee.Personal_Weight_To_Lift = history.Personal_Weight_To_Lift;
add_history_trainee.Creation_Date = DateTime.Today;
add_history_trainee.Facility_Code = history.Facility_Code;
try
{
db.Trainee_Facilities_History.Add(add_history_trainee);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
