public void InsertWorkLog(addWorkLog wl)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
dynamic workLogobj = serializer.Deserialize <object>(wl.workLogJson);
string test = workLogobj["TaskId"];
int timeRemaining = (string.IsNullOrEmpty(Convert.ToString(workLogobj["RemainHours"]))) ? 0 : Convert.ToInt32((Convert.ToDecimal(workLogobj["RemainHours"]) * (decimal)60.0));
DateTime startingDate = Convert.ToDateTime(workLogobj["WorkDateFrom"]);
DateTime endingDate = Convert.ToDateTime(workLogobj["WorkDateTo"]);
for (DateTime date = startingDate; date <= endingDate; date = date.AddDays(1))
{
WorkLogRepository.AddWorkLog(
Guid.NewGuid(), Guid.Parse(UserRepository.GetUserId(Convert.ToString(workLogobj["UserId"]))), null, date, Convert.ToDecimal(workLogobj["WorkHours"]), System.Uri.UnescapeDataString(Convert.ToString(workLogobj["Comment"])), Guid.Parse(workLogobj["TaskId"]),
(string.IsNullOrEmpty(Convert.ToString(workLogobj["RemainHours"])) ? (int?)null : timeRemaining));
}
}
public IHttpActionResult GetAllTasksForCombo(addWorkLog aw)
{
int entity_Type_Task = 11;
DataTable dtStatus = WorkLogRepository.GetTaskStatus(entity_Type_Task);
string status = string.Empty;
if (!aw.isAllChecked)
{
foreach (DataRow dr in dtStatus.Rows)
{
if (Convert.ToInt32(dr["Status"]) < 50)
{
status = status + Convert.ToString(dr["Status"]) + ",";
}
}
}
DataSet ds = TaskListRepository.GetTasks(Convert.ToString(aw.ProjectId), status, null);
return(Ok(ds.Tables[0]));
}
