public void Save(ProjectLog projectLog)
{
if (projectLog.ProjectLogId <= 0)
{
Insert(projectLog);
}
else
{
Update(projectLog);
}
context.SaveChanges();
}
public void Save(Screenshots screenShot)
{
if (screenShot.ScreenshotId <= 0)
{
Insert(screenShot);
}
else
{
Update(screenShot);
}
context.SaveChanges();
}
public void Save(Project project)
{
if (project.ProjectId <= 0)
{
Insert(project);
}
else
{
Update(project);
}
context.SaveChanges();
}
public void Save(Company company)
{
if (company.CompanyId <= 0)
{
Insert(company);
}
else
{
Update(company);
}
context.SaveChanges();
}
/// <summary>
/// Add project
/// </summary>
/// <param name="project">Project</param>
/// <returns></returns>
public static bool AddProject(Project project)
{
bool isAddSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Add user
_dbContext.Projects.Add(project);
_dbContext.SaveChanges();
isAddSuccess = true;
}
return(isAddSuccess);
}
/// <summary>
/// AddUser
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool AddUser(User user)
{
bool isAddSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Add user
_dbContext.Users.Add(user);
_dbContext.SaveChanges();
isAddSuccess = true;
}
return(isAddSuccess);
}
/// <summary>
/// Delet User
/// </summary>
/// <param name="user">User</param>
/// <returns>
/// True - Update transaction done.
/// False - No transaction.
/// </returns>
public static bool DeleteUser(User user)
{
bool isUpdateSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Check if task already exist
var existingUser = _dbContext.Users
.Where(c => c.User_ID == user.User_ID)
.SingleOrDefault();
if (existingUser != null)
{
_dbContext.Users.Remove(existingUser);
_dbContext.SaveChanges();
isUpdateSuccess = true;
}
}
return(isUpdateSuccess);
}
/// <summary>
/// Update end project
/// </summary>
/// <param name="project">Project</param>
/// <returns></returns>
public static bool UpdateEndProject(Project project)
{
bool isUpdateSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Check if task already exist
var existingProject = _dbContext.Projects
.Where(c => c.Project_ID == project.Project_ID)
.SingleOrDefault();
if (existingProject != null)
{
existingProject.End_Date = project.End_Date;
_dbContext.SaveChanges();
isUpdateSuccess = true;
}
}
return(isUpdateSuccess);
}
/// <summary>
/// Update end task
/// </summary>
/// <param name="task">Task</param>
/// <returns>
/// True - Update transaction done.
/// False - No transaction.
/// </returns>
public static bool UpdateEndTask(Task task)
{
bool isUpdateSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Check if task already exist
var existingTask = _dbContext.Tasks
.Where(c => c.Task_ID == task.Task_ID)
.SingleOrDefault();
if (existingTask != null)
{
///Update tas
existingTask.End_Date = DateTime.Now.AddDays(-1);
_dbContext.SaveChanges();
isUpdateSuccess = true;
}
}
return(isUpdateSuccess);
}
/// <summary>
/// Add Update task
/// </summary>
/// <param name="task">Task</param>
/// <returns>
/// True - Update transaction done.
/// False - No transaction.
/// </returns>
public static bool AddTask(Task task)
{
bool isAddSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Check if task already exist
var existingTask = _dbContext.Tasks
.Where(c => c.Task_ID == task.Task_ID)
.SingleOrDefault();
if (existingTask == null)
{
///Add parent task if not exist
if (task.Parent_ID != null && task.Parent_ID != default(int))
{
var existingParent = _dbContext.ParentTasks
.Where(p => p.Parent_ID == task.Parent_ID)
.SingleOrDefault();
if (existingParent == null)
{
_dbContext.ParentTasks.Add(new ParentTask()
{
Parent_ID = (int)task.Parent_ID,
Parent_Task = _dbContext.Tasks.SingleOrDefault(s => s.Task_ID == task.Parent_ID).Task1
});
}
}
/// Add task
_dbContext.Tasks.Add(task);
_dbContext.SaveChanges();
isAddSuccess = true;
}
}
return(isAddSuccess);
}
/// <summary>
/// Update task
/// </summary>
/// <param name="task">Task</param>
/// <returns>
/// True - Update transaction done.
/// False - No transaction.
/// </returns>
public static bool UpdateTask(Task task)
{
bool isUpdateSuccess = false;
using (var _dbContext = new TaskManagerEntities())
{
/// Check if task already exist
var existingTask = _dbContext.Tasks
.Where(c => c.Task_ID == task.Task_ID)
.SingleOrDefault();
if (existingTask != null)
{
///Add parent task if not exist
if (task.Parent_ID != null && task.Parent_ID != default(int))
{
///Add parent task if not exist
var existingParent = _dbContext.ParentTasks
.Where(p => p.Parent_ID == task.Parent_ID)
.SingleOrDefault();
if (existingParent == null)
{
_dbContext.ParentTasks.Add(new ParentTask()
{
Parent_ID = (int)task.Parent_ID,
Parent_Task = task.Task1
});
}
}
///Update task
if (!(task.Task_ID == null || task.Task_ID == default(int)))
{
task.Task_ID = existingTask.Task_ID;
}
if (string.IsNullOrEmpty(task.Task1))
{
task.Task1 = existingTask.Task1;
}
if (task.Priority <= 0)
{
task.Priority = existingTask.Priority;
}
if (!(task.Start_Date != null && task.Start_Date != System.DateTime.MinValue))
{
task.Start_Date = existingTask.Start_Date;
}
if (!(task.End_Date != null))
{
task.End_Date = existingTask.End_Date;
}
_dbContext.Entry(existingTask).CurrentValues.SetValues(task);
}
_dbContext.SaveChanges();
isUpdateSuccess = true;
}
return(isUpdateSuccess);
}
public void Delete(User user)
{
entities.Remove(user);
context.SaveChanges();
}
