public ActionResult Index()
{
ModelRepository repository = new ModelRepository();
repository.PersonelList = db.Personels.Where(it => it.PositionID != 3).ToList();
repository.TaskList = db.Tasks.ToList();
return View(repository);
}
public ActionResult Addtoteam(ModelRepository repository)
{
var user = Int32.Parse(Request.Form.GetValues("PersonnelID").First().ToString());
db.Projects.First(it => it.ProjectID == repository.Project.ProjectID).Personels.Add(db.Personels.First(it => it.PersonnelID == user));
db.SaveChanges();
return RedirectToAction("ProjectDetail", new {id = repository.Project.ProjectID });
}
public ActionResult Create(ModelRepository repository)
{
Task task = repository.Task;
task.ProjectID = repository.Project.ProjectID;
task.PersonelID = Int32.Parse(Request.Form.GetValues("PersonelID").FirstOrDefault().ToString());
task.Status = "Standby";
if (ModelState.IsValid)
{
db.Tasks.Add(task);
var day = Request.Form.GetValues("date[]").ToList();
foreach (var item in day)
{
if(item != string.Empty)
{
int check = 0;
var workday = new WorkDay();
var datetime = DateTime.Parse(item);
if (day.Where(it => it == item).Count() > 1) check++;
if (db.WorkDays.Any(it => it.Date == datetime && it.PersonelID == task.PersonelID))
{
check++;
}
if (check == 0)
{
workday.TaskID = task.TaskID;
workday.Date = DateTime.Parse(item);
workday.PersonelID = task.PersonelID;
db.Tasks.Find(task.TaskID).WorkDays.Add(workday);
db.SaveChanges();
}
else
{
ViewBag.alert = "เวลาซ้ำกัน";
return RedirectToAction("Create", new { id = repository.Project.ProjectID });
}
}
}
return RedirectToAction("Index", new {id = repository.Project.ProjectID });
}
ViewBag.PersonelID = new SelectList(db.Projects.Find(repository.Project.ProjectID).Personels.ToList(), "PersonnelID", "Name", db.Projects.Find(repository.Project.ProjectID).Personels.First().PersonnelID);
ViewBag.ProjectID = new SelectList(db.Projects, "ProjectID", "Name", task.ProjectID);
return View(task);
}
//
// GET: /Task/Create
public ActionResult Create(int id)
{
var list = new List<Personel>();
foreach (var item in db.Projects.Find(id).Personels.ToList())
{
var count = item.Tasks.Count();
double totaltask = count / 2;
var successtask = item.Tasks.Where(it => it.Status == "Success").Count();
if (successtask >= totaltask)
{
list.Add(item);
}
}
ViewBag.PersonelID = new SelectList(list.ToList(), "PersonnelID", "Name", db.Projects.Find(id).Personels.First().PersonnelID);
ViewBag.ProjectID = new SelectList(db.Projects, "ProjectID", "Name");
var repository = new ModelRepository();
repository.Project = db.Projects.Find(id);
return View(repository);
}
public ActionResult ProjectDetail(int id)
{
var repository = new ModelRepository();
var project = db.Projects.FirstOrDefault(it => it.ProjectID == id).Personels.ToList();
var list = new List<Personel>();
foreach (var item in db.Personels.Where(it => it.PositionID != 3).ToList())
{
var count = item.Tasks.Count();
double totaltask = count / 2;
var successtask = item.Tasks.Where(it => it.Status == "Success").Count();
if (!(project.Any(it => it.PersonnelID == item.PersonnelID)))
{
if (successtask >= totaltask)
{
list.Add(item);
}
}
}
ViewBag.PersonnelID = new SelectList(list, "PersonnelID", "Name");
repository.Project = db.Projects.FirstOrDefault(it => it.ProjectID == id);
repository.PersonelList = db.Personels.ToList();
repository.ProjectCategoryList = db.ProjectCategories.ToList();
return View(repository);
}
//
// GET: /Task/
public ActionResult Index(int id)
{
var repository = new ModelRepository();
repository.TaskList = db.Tasks.Include(t => t.Personel).Include(t => t.Project).Where(it => it.ProjectID == id).ToList();
repository.Project = db.Projects.Find(id);
var task = db.Tasks.Where(it => it.ProjectID == id);
repository.WorkDayList = db.WorkDays.ToList();
foreach (var item in task)
{
if (item.Status != "Success")
{
foreach (var time in db.WorkDays.Where(it => it.TaskID == item.TaskID).ToList())
{
if (time.Date == DateTime.Now.Date)
{
item.Status = "Running";
db.Tasks.Find(item.TaskID).Status = "Running";
}
else item.Status = "Standby";
}
}
}
db.SaveChanges();
return View(repository);
}
public ActionResult Edit(int taskid = 0, int projectid = 0)
{
var repository = new ModelRepository();
Task task = db.Tasks.Find(taskid);
repository.Task = task;
repository.Project = db.Projects.Find(projectid);
repository.Task.WorkDays = db.WorkDays.Where(it => it.TaskID == task.TaskID).ToList();
if (task == null)
{
return HttpNotFound();
}
IEnumerable<status> statuslist = new List<status>(){
new status(){val = "Runing",text = "Runing"},
new status(){val = "Success",text = "Success"}
};
ViewBag.Status = new SelectList(new[] { "Running", "Success", "Standby" }
.Select(x => new { value = x, text = x }),
"value", "text", task.Status);
ViewBag.PersonelID = new SelectList(db.Projects.First(it => it.ProjectID == projectid).Personels.ToList(), "PersonnelID", "Name", task.PersonelID);
ViewBag.ProjectID = new SelectList(db.Projects, "ProjectID", "Name", task.ProjectID);
return View(repository);
}
//
// GET: /Admin/
public ActionResult Index()
{
var projects = db.Projects.Include(p => p.ProjectCategory);
var repository = new ModelRepository();
repository.ProjectsList = projects.ToList();
repository.PersonelList = db.Personels.ToList();
return View(repository);
}