public static void CreateTask(Task task) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { context.Tasks.Add(task); context.SaveChanges(); } }
public static void DeleteUserById(int id) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { var user = GetUserById(id); context.Users.Attach(user); if (user != null) { user.IsDeleted = true; context.SaveChanges(); } } }
public static void DeleteTaskById(int id) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { var taskResult = GetTaskById(id); context.Tasks.Attach(taskResult); if (taskResult != null) { taskResult.IsDeleted = true; context.SaveChanges(); } } }
public static void CreateTask(string t, string d, int s, DateTime? sd = null, DateTime? ed = null) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { Task task = new Task(); task.Title = t; task.Description = d; task.StatusId = s; task.StartDate = sd; task.EndDate = ed; context.Tasks.Add(task); context.SaveChanges(); } }
public static void AddTaskToUser(int userId, int taskId, DateTime? startDate = null, int? workedHours = null, DateTime? endDate = null) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { UsersTask usrTask = new UsersTask(); usrTask.UserID = userId; usrTask.TaskId = taskId; usrTask.StartDate = startDate; usrTask.WorkedHours = workedHours; usrTask.EndDate = endDate; context.UsersTasks.Add(usrTask); context.SaveChanges(); } }
public static void AddCardToDb(int usrId, int taskId, DateTime? startDate, TimeSpan hoursMin, string description, bool isFilled) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { WorkingCard wCard = new WorkingCard(); wCard.UserId = usrId; wCard.TaskId = taskId; wCard.StartDate = DateTime.Parse(startDate.Value.ToString()); wCard.WorkingHours = hoursMin; wCard.Description = description; wCard.IsFilled = isFilled; context.WorkingCard.Add(wCard); context.SaveChanges(); } }
public static void UpdateTask(int id, string t, string d, int si, DateTime? sd = null) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { var taskResult = GetTaskById(id); context.Tasks.Attach(taskResult); if (taskResult != null) { taskResult.Title = t; taskResult.Description = d; taskResult.StatusId = si; taskResult.StartDate = sd; context.SaveChanges(); } } }
public static void UpdateUsersTaskDate(int taskId, DateTime date) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { List<UsersTask> tasksToUpdate = (from usrTask in context.UsersTasks where usrTask.TaskId == taskId select usrTask).ToList<UsersTask>(); for (int i = 0; i < tasksToUpdate.Count(); i++) { tasksToUpdate[i].StartDate = date; } context.SaveChanges(); } }
public static void UpdateWoringCard(WorkingCard wCard) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { WorkingCard result = (from card in context.WorkingCard where card.Id == wCard.Id select card).FirstOrDefault<WorkingCard>(); result.StartDate = wCard.StartDate; result.WorkingHours = wCard.WorkingHours; result.Description = wCard.Description; context.SaveChanges(); } }
public static void UpdateUser(int id, string un, string fn, string ln, string p, string e) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { var user = GetUserById(id); context.Users.Attach(user); if (user != null) { user.UserName = un; user.FirstName = fn; user.LastName = ln; user.Position = p; user.Email = e; context.SaveChanges(); } } }
public static void UpdateWorkingHoursOnTask(int tskId, int hours) { Task tsk = TaskUtility.GetTaskById(tskId); using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { context.Tasks.Attach(tsk); if (hours > 0) { tsk.WorkedHoursCurrent += hours; } context.SaveChanges(); } }
public static void UpdateUserWorkingHoursOnTask(int usrId, int tskId, double hours) { using (TimeTrackerDbEntities context = new TimeTrackerDbEntities()) { UsersTask usrTask = new UsersTask(); usrTask = (from usrTsk in context.UsersTasks where usrTsk.TaskId == tskId && usrTsk.UserID == usrId select usrTsk).FirstOrDefault<UsersTask>(); context.UsersTasks.Attach(usrTask); if (!usrTask.WorkedHours.HasValue) { usrTask.WorkedHours = 0; } if (hours > 0) { usrTask.WorkedHours += hours; } context.SaveChanges(); } }