public ActionResult AssignWorkCodeActivity(int Id, String AssignedProjects)
{
try
{
List <WorkCodesActivity> workCodeActivities = this.db.WorkCodesActivities.Where(x => x.WorkCodeId == Id).ToList();
foreach (WorkCodesActivity workcode in workCodeActivities)
{
workcode.WorkCodeId = 0;
this.db.Entry(workcode).State = EntityState.Modified;
this.db.SaveChanges();
}
foreach (string activityId in AssignedProjects.Split(','))
{
if (!string.IsNullOrEmpty(activityId.Trim()))
{
int activity = Convert.ToInt32(activityId);
WorkCodesActivity workCodeActivity = this.db.WorkCodesActivities.Where(x => x.Id == activity).FirstOrDefault();
if (workCodeActivity != null)
{
workCodeActivity.WorkCodeId = Id;
this.db.Entry(workCodeActivity).State = EntityState.Modified;
this.db.SaveChanges();
}
}
}
return(Json(new { success = true }));
}
catch (Exception e)
{
return(Json(new { success = false }));
}
}
public ActionResult EditWorkCodeActivity(WorkCodesActivity model)
{
WorkCodesActivity existingwork = this.db.WorkCodesActivities.Where(x => x.Id.Equals(model.Id)).First();
existingwork.Id = model.Id;
existingwork.Name = model.Name;
existingwork.Number = model.Number;
existingwork.Billable = model.Billable;
this.db.WorkCodesActivities.Attach(existingwork);
db.Entry(existingwork).State = EntityState.Modified;
this.db.SaveChanges();
return(RedirectToAction("GetWorkCodeActivity"));
}
/// <summary>
///
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <returns></returns>
public ActionResult AddWorkCodeActivity()
{
IQueryable <WorkCodesActivity> tasks = this.db.WorkCodesActivities;
WorkCodeActivityModel LastModel = new WorkCodeActivityModel();
if (tasks != null)
{
foreach (WorkCodesActivity task in tasks)
{
LastModel.Number = task.Number;
}
}
WorkCodesActivity AddWork = new WorkCodesActivity();
AddWork.Number = (Convert.ToInt32(LastModel.Number) + 1).ToString();
return(PartialView("_PVADDWorkcodeActivity", AddWork));
}
public ActionResult EditWorkCodeActivity(int id)
{
WorkCodesActivity existingTask = this.db.WorkCodesActivities.Find(id);
return(PartialView("_PVEditWorkCodeActivity", existingTask));
}
public ActionResult AddWorkCodeActivity(WorkCodesActivity model)
{
this.db.WorkCodesActivities.Add(model);
this.db.SaveChanges();
return(RedirectToAction("GetWorkCodeActivity"));
}
