public ActionResult updatecontent(string id, string title, string desc, string due_date, string required_hours, string priority)
{
string div = "";
using (taskdb db = new taskdb())
{
try
{
title = title.Replace("`~`~`", "''");
desc = desc.Replace("`~`~`", "''");
due_date = due_date.Replace("`~`~`", "''");
required_hours = required_hours.Replace("`~`~`", "''");
priority = priority.Replace("`~`~`", "''");
var cls = (from a in db.task where a.id.ToString() == id select a).Single();
cls.title = title;
cls.description = desc;
cls.due_date = DateTime.ParseExact(due_date, "d/M/yyyy", CultureInfo.InvariantCulture);
cls.required_hours = required_hours;
cls.priority = priority;
db.SaveChanges();
div = "added";
}
catch (Exception ex)
{
}
}
return(Content(div, "text/html"));
}
public ActionResult delcontent(string idd)
{
using (taskdb db = new taskdb())
{
var cls = (from a in db.task where a.id.ToString() == idd select a).ToList();
foreach (var item in cls)
{
db.task.Remove(item);
db.SaveChanges();
}
}
return(Content("deleted", "text/html"));
}
public ActionResult addcontent(string title, string desc, string due_date, string required_hours, string priority)
{
string div = "";
{
using (taskdb db = new taskdb())
{
int count = (from a in db.task where a.title == title select a).Count();
if (count == 0)
{
try
{
title = title.Replace("`~`~`", "''");
desc = desc.Replace("`~`~`", "''");
due_date = due_date.Replace("`~`~`", "''");
required_hours = required_hours.Replace("`~`~`", "''");
priority = priority.Replace("`~`~`", "''");
div = "added";
task obj = new task();
obj.title = title;
obj.description = desc;
obj.due_date = DateTime.ParseExact(due_date, "d/M/yyyy", CultureInfo.InvariantCulture);
obj.required_hours = required_hours;
obj.priority = priority;
db.task.Add(obj);
db.SaveChanges();
}
catch (Exception ex)
{
}
}
else
{
div = "exist";
}
}
return(Content(div, "text/html"));
}
}
