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(); }