private static bool addTask(string workoutName, string taskName, string descriptionTask, string timeTask, string revTask) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if task exist in DB task newTask = findTask(taskName); if (newTask != null) { return(false); } newTask = new task(); //if task not exist create new task newTask.workoutName = workoutName; newTask.taskName = taskName; newTask.description = descriptionTask; newTask.time = timeTask; newTask.rev = revTask; newTask.workout = null; db.tasks.Add(newTask); db.SaveChanges(); return(true); }
//query function to check if workout exist in DB private static workout findWorkout(string workoutName) { social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get workout by workoutName workout _workout = db.workouts.Where(x => x.workoutName == workoutName).SingleOrDefault(); db.Dispose(); //check if workout exist if (_workout == null) { return(null); } return(_workout); }
//query function to check if task exist in DB private static task findTask(string taskName) { social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get task by taskName task _task = db.tasks.Where(x => x.taskName == taskName).SingleOrDefault(); db.Dispose(); //check if task exist if (_task == null) { return(null); } return(_task); }
//query function to check if user exist in DB private static user findUser(string userName) { social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get user by userName user user = db.users.Where(x => x.userName == userName).SingleOrDefault(); //check if user exist if (user == null) { return(null); } db.Dispose(); return(user); }
//query function to check if workout exist in DB private static workout findWorkoutByUsername(string _userName, string _workoutName) { social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get workout by workoutName //workout _workout = db.workouts.Where(x => x.userName == userName).Select(s => s.workoutName == workoutName).SingleOrDefault(); workout _workout = db.workouts.Where(x => x.workoutName == _workoutName && x.userName == _userName).SingleOrDefault(); db.Dispose(); //check if workout exist if (_workout == null) { return(null); } return(_workout); }
public static ItemTaskModel taskByNameResult(String _taskName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); task _task = db.tasks.Where(x => x.taskName == _taskName).SingleOrDefault(); db.Dispose(); ItemTaskModel taskModel = new ItemTaskModel { result = true, itemTask = _task }; return(taskModel); }
public static workoutModelList workoutsRessult(String _userName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); List <String> names = db.workouts.Where(s => s.userName == _userName).Select(s => s.workoutName).ToList(); db.Dispose(); workoutModelList workoutModel = new workoutModelList { result = true, workouts = names }; return(workoutModel); }
private static task checkTask(string taskName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get workout by workoutName task _task = db.tasks.Where(x => x.taskName == taskName).SingleOrDefault(); db.Dispose(); //check if workout exist and if workoutName is correct //if (_user == null || !Equals(user.password, CryptHelper.getHash(password))) if (_task == null || !workout.Equals(taskName, taskName)) { return(null); } return(_task); }
private static workout checkWorkout(string workoutName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get workout by workoutName workout _workout = db.workouts.Where(x => x.workoutName == workoutName).SingleOrDefault(); db.Dispose(); //check if workout exist and if workoutName is correct //if (_user == null || !Equals(user.password, CryptHelper.getHash(password))) if (_workout == null || !workout.Equals(workoutName, workoutName)) { return(null); } return(_workout); }
private static user checkLogin(string userName, string password) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //get user by userName user _user = db.users.Where(x => x.userName == userName).SingleOrDefault(); db.Dispose(); //check if user exist and if password is correct //if (_user == null || !Equals(user.password, CryptHelper.getHash(password))) if (_user == null || !user.Equals(password, password)) { return(null); } return(_user); }
public static taskModelList tasksRrssult(String _workoutName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); List <String> names = db.tasks.Where(s => s.workoutName == _workoutName).Select(s => s.taskName).ToList(); db.Dispose(); taskModelList taskModel = new taskModelList { result = true, tasksList = names }; return(taskModel); }
private static bool deleteTask(string workoutName, string taskName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if task exist in DB task delTask = findTask(workoutName); if (delTask == null) { return(false); } //if (delTask.workoutName == workoutName && delTask.taskName == taskName) //{ db.tasks.Remove(delTask); db.SaveChanges(); return(true); //} //return false; }
private static bool addWorkout(string userName, string workoutName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if workout exist in DB workout newWorkout = findWorkout(workoutName); if (newWorkout != null) { return(false); } newWorkout = new workout(); //if workout not exist create new workout newWorkout.userName = userName; newWorkout.workoutName = workoutName; db.workouts.Add(newWorkout); db.SaveChanges(); return(true); }
//query function to add new user to DB private static bool changeProfile(string firstName, string lastName, string userName, string password) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if user exist in DB user user = findUser(userName); if (user == null) { return(false); } //if user exist change user profile user.firstName = firstName; user.lastName = lastName; user.password = password; // CryptHelper.getHash(password); db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(true); }
private static bool deleteWorkout(string userName, string workoutName) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if workout exist in DB workout delWorkout = findWorkoutByUsername(userName, workoutName); task delTask = findTask(workoutName); if (delWorkout == null) // && delTask == null) { return(false); } //if (delWorkout.userName == userName && delWorkout.workoutName == workoutName)// && delTask.workoutName == workoutName) //{ db.workouts.Remove(delWorkout); //db.tasks.Remove(delTask); db.SaveChanges(); return(true); //} //return false; }
//query function to add new user to DB private static bool addUser(string firstName, string lastName, string userName, string password) { //connect to db social_workout_app_dbEntities db = new social_workout_app_dbEntities(); //check if user exist in DB user user = findUser(userName); if (user != null) { return(false); } user = new user(); //if user not exist create new user user.firstName = firstName; user.lastName = lastName; user.password = password; // CryptHelper.getHash(password); user.userName = userName; db.users.Add(user); db.SaveChanges(); return(true); }