public ActionResult PostEditToDo(PM_Todo todo)
{
PM_TaskBL pb = new PM_TaskBL();
var result = pb.EditTodo(todo, "Edit_Todo");
return(Json(result == true ? "success" : "fail", JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage SaveTodo(PM_Todo todo)
{
PM_TaskBL pb = new PM_TaskBL();
if (todo.TodoId > 0)
{
bool result = pb.SaveTodo(todo, "Update_Todo");
if (result)
{
return(this.Request.CreateResponse(HttpStatusCode.OK,
new { Message = "To do List Updated", Value = 1 }));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"To do List Not Updated"));
}
}
else
{
bool result = pb.SaveTodo(todo, "Insert_Todo");
if (result)
{
return(this.Request.CreateResponse(HttpStatusCode.OK,
new { Message = "To do List Added", Value = 1 }));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"To do List Not Added"));
}
}
}
public ActionResult SaveTodo(PM_Todo todo)
{
PM_TaskBL pb = new PM_TaskBL();
todo.CreatedById = ViewBag.UserId;
todo.CreatedOn = DateTime.Now;
if (todo.TodoId == 0)
{
var result = pb.SaveTodo(todo, "Insert_Todo");
return(Json(result == true ? "success" : "fail", JsonRequestBehavior.AllowGet));
}
else
{
var result = pb.SaveTodo(todo, "Update_Todo");
return(Json(result == true ? "success" : "fail", JsonRequestBehavior.AllowGet));
}
}
public List <PM_Todo> GetTodo(string filter, Int64 projectId, Int64 UserId, string WhereClause = "", DateTime?todate = null, DateTime?fromdate = null)
{
if (todate == fromdate)
{
todate = todate.Value.AddDays(1).Date.AddSeconds(-1);
}
if (todate != null && fromdate != null)
{
// WhereClause = $" AND CONVERT(varchar, ToDoDateTime) >= '{fromdate.ToString().Trim()}' AND CONVERT(varchar, ToDoDateTime, 1) <= '{todate.ToString().Trim()}'";
WhereClause = $" AND CONVERT(datetime, " + "'" + fromdate.ToString() + "'" + ") <= ToDoDateTime AND CONVERT(datetime, " + "'" + todate.ToString() + "'" + ") >= ToDoDateTime ";
}
DataTable dt = dal.GetDataTable(filter, projectId, UserId, WhereClause);
List <PM_Todo> lst = new List <PM_Todo>();
foreach (DataRow item in dt.Rows)
{
PM_Todo todo = new PM_Todo();
todo.CreatedOn = Convert.ToDateTime(item["CreatedOn"]);
todo.Description = item["Description"].ToString();
todo.Status = item["Status"].ToString();
todo.TodoId = Convert.ToInt64(item["TodoId"].ToString());
todo.Type = item["Type"].ToString();
todo.ToDoDateTime = Convert.ToDateTime(item["ToDoDateTime"]);
todo.ToDoTitle = Convert.ToString(item["ToDoTitle"]);
todo.SiteName = Convert.ToString(item["SiteName"]);
todo.TaskName = Convert.ToString(item["TaskName"]);
todo.AssignedToIds = Convert.ToString(item["AssignedToIds"]);
todo.SiteId = !string.IsNullOrEmpty(Convert.ToString(item["SiteId"])) ? Convert.ToInt64(item["SiteId"]) : 0;
todo.TaskId = !string.IsNullOrEmpty(Convert.ToString(item["TaskId"])) ? Convert.ToInt64(item["TaskId"]) : 0;
lst.Add(todo);
}
return(lst);
}
public HttpResponseMessage UpdateEventInProjectByProjectId([FromUri] int UserId, [FromUri] int eventId, PM_Todo todo)
{
try
{
PM_TaskBL pb = new PM_TaskBL();
todo.CreatedOn = DateTime.Now;
if (todo.TodoId != 0)
{
var result = pb.SaveTodo(todo, "Edit_Todo");
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"No Data"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,
ex.Message));
}
}
public bool EditTodo(PM_Todo todo, string Filter)
{
var res = td.EditTodo(Filter, todo.TodoId, todo.Description, todo.Type, todo.Status, todo.ToDoDateTime, todo.ToDoTitle, todo.SiteId, todo.TaskId, todo.AssignedToIds);
return(res);
}
public bool SaveTodo(PM_Todo todo, string Filter)
{
var res = td.SaveTodo(Filter, todo.TodoId, todo.Description, todo.Type, todo.Status, todo.CreatedById, todo.CreatedOn, todo.ToDoDateTime, todo.ToDoTitle, todo.ProjectId, todo.SiteId, todo.TaskId, todo.AssignedToIds);
return(res);
}
