}//edit
// GET: WorkAssignments/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WorkAssignments workassdetail = db.WorkAssignments.Find(id);
if (workassdetail == null)
{
return(HttpNotFound());
}
WorkAssignmentsViewModel view = new WorkAssignmentsViewModel();
view.Id_WorkAssignment = workassdetail.Id_WorkAssignment;
view.Title = workassdetail.Title;
view.Description = workassdetail.Description;
view.Deadline = workassdetail.Deadline;
view.InProgress = workassdetail.InProgress;
view.InProgressAt = workassdetail.InProgressAt;
view.CompletedAt = workassdetail.CompletedAt;
view.Completed = workassdetail.Completed;
view.LastModifiedAt = DateTime.Now;
view.DeletedAt = DateTime.Now;
view.Active = workassdetail.Active;
view.Id_Customer = workassdetail.Customers?.Id_Customer;
view.CustomerName = workassdetail.Customers?.CustomerName;
return(View(view));
}
public ActionResult Edit(WorkAssignmentsViewModel model)
{
WorkAssignments wam = db.WorkAssignments.Find(model.Id_WorkAssignment);
wam.Title = model.Title;
wam.Description = model.Description;
wam.Deadline = model.Deadline.GetValueOrDefault();
wam.CreatedAt = model.CreatedAt.GetValueOrDefault();
wam.InProgress = model.InProgress;
wam.InProgressAt = model.InProgressAt.GetValueOrDefault();
//wam.CompletedAt = model.CompletedAt.GetValueOrDefault();
wam.CompletedAt = DateTime.Now;
wam.Completed = model.Completed;
wam.LastModifiedAt = DateTime.Now;
wam.DeletedAt = model.DeletedAt.GetValueOrDefault();
wam.Active = true;
int customerId = int.Parse(model.CustomerName);
if (customerId > 0)
{
Customers cus = db.Customers.Find(customerId);
wam.Id_Customer = cus.Id_Customer;
}
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", wam.Id_Customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
// GET: WorkAssignments/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WorkAssignments workassdetail = db.WorkAssignments.Find(id);
if (workassdetail == null)
{
return(HttpNotFound());
}
WorkAssignmentsViewModel view = new WorkAssignmentsViewModel();
view.Id_WorkAssignment = workassdetail.Id_WorkAssignment;
view.Title = workassdetail.Title;
view.Description = workassdetail.Description;
view.Deadline = workassdetail.Deadline.GetValueOrDefault();
view.CreatedAt = workassdetail.CreatedAt.GetValueOrDefault();
view.InProgress = workassdetail.InProgress;
view.InProgressAt = workassdetail.InProgressAt.GetValueOrDefault();
view.CompletedAt = workassdetail.CompletedAt.GetValueOrDefault();
view.Completed = workassdetail.Completed;
view.LastModifiedAt = workassdetail.LastModifiedAt;
view.DeletedAt = workassdetail.DeletedAt.GetValueOrDefault();
view.Active = workassdetail.Active;
view.Id_Customer = workassdetail.Customers?.Id_Customer;
view.CustomerName = workassdetail.Customers?.CustomerName;
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", view.Id_Customer);
return(View(view));
}
}//details
// GET: WorkAssignments/Create
public ActionResult Create()
{
MobileWorkDataEntities db = new MobileWorkDataEntities();
WorkAssignmentsViewModel model = new WorkAssignmentsViewModel();
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", null);
return(View(model));
}//create
// GET: WorkAssignments
public ActionResult Index()
{
List <WorkAssignmentsViewModel> model = new List <WorkAssignmentsViewModel>();
MobileWorkDataEntities entities = new MobileWorkDataEntities();
try
{
List <WorkAssignments> workAssignments = entities.WorkAssignments.OrderBy(WorkAssignments => WorkAssignments.Deadline).ToList();
CultureInfo fiFi = new CultureInfo("fi-FI");
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (WorkAssignments workAssignment in workAssignments)
{
WorkAssignmentsViewModel view = new WorkAssignmentsViewModel();
view.Id_WorkAssignment = workAssignment.Id_WorkAssignment;
view.Title = workAssignment.Title;
view.Description = workAssignment.Description;
view.Deadline = workAssignment.Deadline;
view.CreatedAt = workAssignment.CreatedAt;
view.InProgress = workAssignment.InProgress;
view.InProgressAt = workAssignment.InProgressAt;
view.CompletedAt = workAssignment.CompletedAt;
view.Completed = workAssignment.Completed;
view.LastModifiedAt = workAssignment.LastModifiedAt;
view.DeletedAt = workAssignment.DeletedAt;
view.Active = workAssignment.Active;
view.Id_Customer = workAssignment.Customers?.Id_Customer;
view.CustomerName = workAssignment.Customers?.CustomerName;
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", null);
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
}//Index
// GET: WorkAssignments/Details/5
public ActionResult Details(int?id)
{
WorkAssignmentsViewModel model = new WorkAssignmentsViewModel();
MobileWorkDataEntities entities = new MobileWorkDataEntities();
try
{
WorkAssignments workassdetail = entities.WorkAssignments.Find(id);
if (workassdetail == null)
{
return(HttpNotFound());
}
// muodostetaan näkymämalli tietokannan rivien pohjalta
WorkAssignmentsViewModel view = new WorkAssignmentsViewModel();
view.Id_WorkAssignment = workassdetail.Id_WorkAssignment;
view.Title = workassdetail.Title;
view.Description = workassdetail.Description;
view.Deadline = workassdetail.Deadline;
view.CreatedAt = workassdetail.CreatedAt;
view.InProgress = workassdetail.InProgress;
view.InProgressAt = workassdetail.InProgressAt;
view.CompletedAt = workassdetail.CompletedAt;
view.Completed = workassdetail.Completed;
view.LastModifiedAt = workassdetail.LastModifiedAt;
view.DeletedAt = workassdetail.DeletedAt;
view.Active = workassdetail.Active;
view.Id_Customer = workassdetail.Customers?.Id_Customer;
view.CustomerName = workassdetail.Customers?.CustomerName;
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", view.Id_Customer);
model = view;
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
public ActionResult Create(WorkAssignmentsViewModel model)
{
MobileWorkDataEntities db = new MobileWorkDataEntities();
WorkAssignments wam = new WorkAssignments();
wam.Title = model.Title;
wam.Description = model.Description;
wam.Deadline = model.Deadline;
wam.CreatedAt = DateTime.Now;
wam.InProgress = model.InProgress;
wam.InProgressAt = model.InProgressAt;
wam.CompletedAt = model.CompletedAt;
wam.Completed = model.Completed;
wam.LastModifiedAt = DateTime.Now;
wam.Active = true;;
db.WorkAssignments.Add(wam);
int customerId = int.Parse(model.CustomerName);
if (customerId > 0)
{
Customers cus = db.Customers.Find(customerId);
wam.Id_Customer = cus.Id_Customer;
}
ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", null);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create