private static bool deleteTask(string workoutName, string taskName)
{
bool flag = false;
//connect to db
db_appEntities db = new db_appEntities();
//check if task exist in DB
task delTask = findTask(taskName);
if (delTask == null)
{
return(false);
}
try
{
db.Entry(delTask).State = EntityState.Deleted;
db.SaveChanges();
flag = true;
}
catch (Exception e)
{}
if (flag == true)
{
return(true);
}
else
{
db.Dispose();
return(false);
}
}
private static bool deleteWorkoutFromList(string _mastersUerName, string _userName, string _workoutName)
{
bool flag = false;
//connect to db
db_appEntities db = new db_appEntities();
//check if workout exist in DB
favorite delWorkout = checkFavoriteWorkout(_mastersUerName, _userName, _workoutName);
if (delWorkout == null)
{
return(false);
}
try
{
db.Entry(delWorkout).State = EntityState.Deleted;
db.SaveChanges();
flag = true;
}
catch (Exception e)
{ }
if (flag == true)
{
return(true);
}
else
{
db.Dispose();
return(false);
}
}
private static bool addToStorage(string _userName, string _workoutName, bool _inStorage)
{
bool flag = false;
//connect to db
db_appEntities db = new db_appEntities();
workout workoutToUpade = findWorkoutByUsername(_userName, _workoutName);
if (workoutToUpade == null)
{
return(false);
}
try
{
workoutToUpade.inStorage = true;
db.Entry(workoutToUpade).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
catch (Exception e)
{ }
if (flag == true)
{
return(true);
}
else
{
db.Dispose();
return(false);
}
}
public ActionResult Edit(task task)
{
if (ModelState.IsValid)
{
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(task));
}
private static bool deleteWorkout(string userName, string workoutName)
{
bool flag = false;
//connect to db
db_appEntities db = new db_appEntities();
//check if workout exist in DB
workout delWorkout = findWorkoutByUsername(userName, workoutName);
List <task> delTaskList = findAllTasks(workoutName);
if (delWorkout == null && delTaskList == null)
{
return(false);
}
try
{
db.Entry(delWorkout).State = EntityState.Deleted;
db.SaveChanges();
foreach (task element in delTaskList)
{
db.Entry(element).State = EntityState.Deleted;
}
db.SaveChanges();
flag = true;
}
catch (Exception e)
{}
if (flag == true)
{
return(true);
}
else
{
db.Dispose();
return(false);
}
}
//query function to add new user to DB
private static bool changeProfile(string firstName, string lastName, string userName, string password)
{
bool flag = false;
//connect to db
db_appEntities db = new db_appEntities();
//check if user exist in DB
user user = findUser(userName);
if (user == null)
{
return(false);
}
try
{
//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();
flag = true;
}
catch (Exception e)
{}
if (flag == true)
{
return(true);
}
else
{
db.Dispose();
return(false);
}
}