public int Add(User user, out string Error)
{
Error = string.Empty;
if (user == null)
{
Error = "Invalid User!";
return -1;
}
try
{
using (var dbContext = new ToDoListContext())
{
user.Password = Utility.Security.CreateMD5(user.Password);
dbContext.Users.Add(user);
dbContext.SaveChanges();
return user.Id;
}
}
catch (Exception ex)
{
Error = ex.Message;
return -1;
}
}
public bool Delete(int TaskId, out string Error)
{
Error = string.Empty;
try
{
using (var dbContext = new ToDoListContext())
{
var uTask = dbContext.Tasks.SingleOrDefault(t => t.Id == TaskId);
if (uTask == null)
{
Error = "Invalid Task!";
return(false);
}
dbContext.Tasks.Remove(uTask);
dbContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(false);
}
}
public bool Edit(Todo todo, out string Error)
{
Error = string.Empty;
if (todo == null)
{
Error = "Invalid Todo!";
return(false);
}
try
{
using (var dbContext = new ToDoListContext())
{
var uTodo = dbContext.Todos.SingleOrDefault(t => t.Id == todo.Id);
if (uTodo == null)
{
Error = "Invalid Todo!";
return(false);
}
uTodo.Name = todo.Name;
dbContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(false);
}
}
public bool DeleteByTodo(int TodoId, out string Error)
{
Error = string.Empty;
try
{
using (var dbContext = new ToDoListContext())
{
var dList = dbContext.Tasks.Where(t => t.Todo.Id == TodoId);
dbContext.Tasks.RemoveRange(dList);
dbContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(false);
}
}
public int Edit(Task task, out string Error)
{
Error = string.Empty;
if (task == null)
{
Error = "Invalid Task!";
return(-1);
}
try
{
using (var dbContext = new ToDoListContext())
{
var uTask = dbContext.Tasks.SingleOrDefault(t => t.Id == task.Id);
if (uTask == null)
{
Error = "Invalid Task!";
return(-1);
}
uTask.Name = task.Name;
uTask.IsDone = task.IsDone;
uTask.NotifyBeforeMin = task.NotifyBeforeMin;
uTask.StartTime = task.StartTime;
uTask.Description = task.Description;
dbContext.SaveChanges();
return(task.Id);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(-1);
}
}
public int Edit(User user, out string Error)
{
Error = string.Empty;
if (user == null)
{
Error = "Invalid User!";
return -1;
}
try
{
using (var dbContext = new ToDoListContext())
{
var uUser = dbContext.Users.SingleOrDefault(t => t.Id == user.Id);
if (uUser == null)
{
Error = "Invalid User!";
return -1;
}
uUser.Name = user.Name;
uUser.Password = Utility.Security.CreateMD5(uUser.Password);
uUser.Email = uUser.Email;
dbContext.SaveChanges();
return uUser.Id;
}
}
catch (Exception ex)
{
Error = ex.Message;
return -1;
}
}
public int Add(Task task, out string Error)
{
Error = string.Empty;
if (task == null)
{
Error = "Invalid Task!";
return(-1);
}
try
{
using (var dbContext = new ToDoListContext())
{
dbContext.Tasks.Add(task);
dbContext.SaveChanges();
return(task.Id);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(-1);
}
}
public bool Add(Todo todo, out string Error)
{
Error = string.Empty;
if (todo == null)
{
Error = "Invalid Todo!";
return(false);
}
try
{
using (var dbContext = new ToDoListContext())
{
dbContext.Todos.Add(todo);
dbContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(false);
}
}
public int Add(Log log, out string Error)
{
Error = string.Empty;
if (log == null)
{
Error = "Invalid Log!";
return(-1);
}
try
{
using (var dbContext = new ToDoListContext())
{
dbContext.Logs.Add(log);
dbContext.SaveChanges();
return(log.Id);
}
}
catch (Exception ex)
{
Error = ex.Message;
return(-1);
}
}
