public ActionResult _Create([Bind(Include = "TaskListID,Name,ListDetail,TaskTypeID,TaskPriorityID,TaskStatusID,ListDate")] TaskList tasklist, string[] EmployeeID)
{
tasklist.ListDate = DateTime.Now;
tasklist.TaskStatusID = 1;
ViewBag.Message = "";
ViewBag.Error = "Error";
try
{
db.TaskLists.Add(tasklist);
db.SaveChanges();
foreach (string eid in EmployeeID)
{
TaskEmployee taskemployee = new TaskEmployee();
taskemployee.TaskListID = tasklist.TaskListID;
taskemployee.EmployeeID = int.Parse(eid);
db.TaskEmployees.Add(taskemployee);
db.SaveChanges();
}
ViewBag.Error = "";
ViewBag.Message = "Created Successfully, Please click REFRESH button to view";
}
catch { }
ViewBag.EmployeeID = new MultiSelectList(db.Employees.Where(e => e.EmployeeID > 1).OrderByDescending(e => e.Name), "EmployeeID", "Name");
ViewBag.TaskPriorityID = new SelectList(db.TaskPrioritys, "TaskPriorityID", "Name", tasklist.TaskPriorityID);
ViewBag.TaskTypeID = new SelectList(db.TaskTypes, "TaskTypeID", "Name", tasklist.TaskTypeID);
return(PartialView());
}
public ActionResult DeleteConfirmed(int id)
{
TaskEmployee taskemployee = db.TaskEmployees.Find(id);
db.TaskEmployees.Remove(taskemployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TaskEmployeeID,TaskListID,EmployeeID")] TaskEmployee taskemployee)
{
if (ModelState.IsValid)
{
db.Entry(taskemployee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Name", taskemployee.EmployeeID);
ViewBag.TaskListID = new SelectList(db.TaskLists, "TaskListID", "Name", taskemployee.TaskListID);
return(View(taskemployee));
}
public static TaskEmployee CreateFromServerToClient(this TaskEmployee source)
{
return(new TaskEmployee
{
TaskEmployeeId = source.TaskEmployeeId,
TaskId = source.TaskId,
EmployeeId = source.EmployeeId,
RecCreatedBy = source.RecCreatedBy,
RecCreatedDt = source.RecCreatedDt,
RecLastUpdatedBy = source.RecLastUpdatedBy,
RecLastUpdatedDt = source.RecLastUpdatedDt
});
}
public static Models.TaskEmployee CreateFromServerToClient(this TaskEmployee source)
{
return(new Models.TaskEmployee
{
TaskEmployeeId = source.TaskEmployeeId,
TaskId = source.TaskId,
EmployeeId = source.EmployeeId,
RecCreatedBy = source.RecCreatedBy,
RecCreatedDt = source.RecCreatedDt,
RecLastUpdatedBy = source.RecLastUpdatedBy,
RecLastUpdatedDt = source.RecLastUpdatedDt,
ProjectTask = source.ProjectTask.CreateFromServerToClientForEmployee()
});
}
// GET: /TaskEmployee/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TaskEmployee taskemployee = db.TaskEmployees.Find(id);
if (taskemployee == null)
{
return(HttpNotFound());
}
return(View(taskemployee));
}
public async Task <TaskEmployee> Create(TaskEmployee taskEmployee)
{
try
{
await _baseContext.TaskEmployee.AddAsync(taskEmployee);
await _baseContext.SaveChangesAsync();
return(taskEmployee);
}
catch (Exception e)
{
Debug.WriteLine(e);
throw;
}
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TaskEmployee taskemployee = db.TaskEmployees.Find(id);
if (taskemployee == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Name", taskemployee.EmployeeID);
ViewBag.TaskListID = new SelectList(db.TaskLists, "TaskListID", "Name", taskemployee.TaskListID);
return(View(taskemployee));
}
public ActionResult EditMaintenance([Bind(Include = "TaskListID,Name,ListDetail,TaskTypeID,TaskPriorityID,TaskStatusID,ListDate")] TaskList tasklist, string[] EmployeeID)
{
Session["err"] = "Error";
Session["msg"] = "";
List <int> idList = new List <int>();
try
{
db.Entry(tasklist).State = EntityState.Modified;
db.SaveChanges();
var taskemployeeList = db.TaskEmployees.Where(t => t.TaskListID == tasklist.TaskListID).ToList();
foreach (TaskEmployee te in taskemployeeList)
{
db.TaskEmployees.Remove(te);
db.SaveChanges();
}
foreach (string eid in EmployeeID)
{
TaskEmployee taskemployee = new TaskEmployee();
taskemployee.TaskListID = tasklist.TaskListID;
taskemployee.EmployeeID = int.Parse(eid);
db.TaskEmployees.Add(taskemployee);
db.SaveChanges();
}
taskemployeeList = db.TaskEmployees.Where(t => t.TaskListID == tasklist.TaskListID).ToList();
foreach (TaskEmployee te in taskemployeeList)
{
idList.Add(te.EmployeeID);
}
Session["msg"] = "Modified Successfully";
Session["err"] = "";
}
catch { }
ViewBag.EmployeeID = new MultiSelectList(db.Employees.Where(e => e.EmployeeID > 1).OrderBy(e => e.Name), "EmployeeID", "Name", idList);
ViewBag.TaskStatusID = new SelectList(db.TaskStatuss, "TaskStatusID", "Name", tasklist.TaskStatusID);
ViewBag.TaskPriorityID = new SelectList(db.TaskPrioritys, "TaskPriorityID", "Name", tasklist.TaskPriorityID);
ViewBag.TaskTypeID = new SelectList(db.TaskTypes, "TaskTypeID", "Name", tasklist.TaskTypeID);
return(RedirectToAction("EditMaintenance", "TaskList", new { id = tasklist.TaskListID }));
}
public bool EditTaskByObj(JArray castObj, int id)
{
var items = castObj.ToObject <List <ItemGridSource> >();
var emp = db.Employees.Where(i => i.EmployeeID == id).First();
foreach (var item in items)
{
var ToItemDic = item.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public).ToDictionary(prop => prop.Name, prop => prop.GetValue(item, null));
ToItemDic.Remove("Id");
ToItemDic.Remove("Name");
foreach (var day in ToItemDic)
{
if (day.Value != null)
{
var daynum = ((int)Enum.Parse(typeof(DayOfWeek), day.Key)).ToString();
var Count = db.TimeSheets.Where(e => e.Employee.EmployeeID == id && e.Task.TaskID == item.Id && e.Day.Day == daynum).Count();
if (Count != 0)
{
try
{
var tasksheets = db.TimeSheets.Include(d => d.Day).Where(e => e.Employee.EmployeeID == id && e.Task.TaskID == item.Id);
var sheets = tasksheets.Where(e => e.Day.Day == daynum).FirstOrDefault();
sheets.Hours = day.Value.ToString();
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
else
{
var task = db.Tasks.Include(t => t.TimeSheets).ThenInclude(d => ((TimeSheet)d).Day).Where(i => i.TaskID == item.Id).First();
var dayObj = db.Days.Where(d => d.Day == day.Key).FirstOrDefault();
if (dayObj == null)
{
dayObj = new Days
{
Day = ((int)Enum.Parse(typeof(DayOfWeek), day.Key)).ToString()
};
}
TimeSheet timeSheet = new TimeSheet
{
Day = dayObj,
Hours = day.Value.ToString(),
Employee = emp,
Date = DateTime.Today.ToString()
};
task.TimeSheets.Add(timeSheet);
db.SaveChanges();
var taskEmp = db.TaskEmployees.Where(t => t.TaskID == task.TaskID && t.EmployeeID == emp.EmployeeID).FirstOrDefault();
if (taskEmp == null)
{
taskEmp = new TaskEmployee
{
Employee = emp,
Task = task
};
db.TaskEmployees.Add(taskEmp);
db.SaveChanges();
}
}
}
}
}
return(true);
}
