public ActionResult savetask(FormCollection fo)
{
string msg = "The task was updated successfully at " + System.DateTime.Now;;
int tin = int.Parse(fo["item.tasks_installation_number"]);
GeneralHelper helper = new GeneralHelper();
int iid = db.tasks_installation.Where(c => c.tasks_installation_number == tin).First().installation_number;
int lid = db.installations.Where(g => g.installation_number == iid).First().lead_number;
lead idk = db.leads.Where(b => b.lead_number == lid).First();
try
{
tasks_installation target = db.tasks_installation.Where(f => f.tasks_installation_number == tin).First();
target.hours = double.Parse(fo["item.hours"]);
target.m_cost = double.Parse(fo["item.m_cost"]);
target.labor_cost = helper.GetInstallationLaborRate(idk) * target.hours;
target.material_retail_cost = helper.GetInstallationMaterialRate(idk) * target.m_cost;
db.SaveChanges(lid);
}
catch (Exception e)
{
msg = "Sonething went wrong " + e.Message;
}
return(RedirectToAction("lis", new { lid = lid, msg = msg }));
}
public ActionResult handler(FormCollection fo)
{
int iid = int.Parse(fo["installation_number"]);
string msg = "The task was created successfully at " + System.DateTime.Now;;
int lid = db.installations.Where(a => a.installation_number == iid).First().lead_number;
lead idk = db.leads.Where(d => d.lead_number == lid).First();
GeneralHelper helper = new GeneralHelper();
tasks_installation target = new tasks_installation();
if (int.Parse(fo["mode"]) == 0)
{
target.hours = double.Parse(fo["hours"]);
target.task_number = int.Parse(fo["task_number"]);
target.m_cost = double.Parse(fo["m_cost"]);
target.labor_cost = helper.GetInstallationLaborRate(idk) * target.hours;
target.material_retail_cost = helper.GetInstallationMaterialRate(idk) * target.m_cost;
target.installation_number = iid;
try
{
db.tasks_installation.Add(target);
db.SaveChanges(lid);
//db.SaveChanges(lid, "create new");
}
catch (Exception e)
{
msg = e.Message;
}
}
else
{
task ctask = new task();
ctask.special_task = true;
ctask.task_main_cat = "MISC";
ctask.task_sub_cat = "Disclaimers";
ctask.task_name = fo["task_name"];
db.tasks.Add(ctask);
target.task = ctask;
target.hours = double.Parse(fo["hours"]);
target.m_cost = double.Parse(fo["m_cost"]);
target.labor_cost = helper.GetInstallationLaborRate(idk) * target.hours;
target.material_retail_cost = helper.GetInstallationMaterialRate(idk) * target.m_cost;
db.tasks_installation.Add(target);
target.installation_number = iid;
try
{
db.SaveChanges(lid);
}
catch (Exception e)
{
msg = e.Message;
}
}
return(RedirectToAction("lis", new { lid = lid, msg = msg }));
}
public ActionResult Delete(int tin, int iid)
{
int lid = db.installations.Where(q => q.installation_number == iid).First().lead_number;
string msg = "The task was deleted successfully at " + System.DateTime.Now;;
try
{
tasks_installation target = db.tasks_installation.Where(v => v.tasks_installation_number == tin).First();
db.tasks_installation.Remove(target);
db.SaveChanges(lid);
//db.SaveChanges(lid, "delete");
} catch (Exception e)
{
msg = "Sonething went wrong " + e.Message;
}
return(RedirectToAction("lis", new { lid = lid, msg = msg }));
}
