public JsonResult WorkLogsCost(string filter, string value, string value2)
{
PM_WorkLogBL tb = new PM_WorkLogBL();
value = string.IsNullOrEmpty(value) ? DateTime.Now.ToShortDateString() : value;
value2 = string.IsNullOrEmpty(value2) ? DateTime.Now.ToShortDateString() : value2;
var wlogsCostChart = tb.ToList("Work_Log_Charts", value, value2);
var wlogsCost = tb.ToList(filter, value, value2);
List <p_pm_worklog> chartsManagenData = wlogsCost.GroupBy(x => x.Name).Select(p => new p_pm_worklog
{
Name = p.Key,
childp_pm_worklog = p.GroupBy(pp => pp.LogType).Select(xc => new p_pm_worklog()
{
LogHours = xc.Sum(x => x.LogHours),
LogType = xc.Key,
Name = p.Key
}).ToList()
}).ToList();
var fnlobj = chartsManagenData.Select(x => x.childp_pm_worklog).ToList();
var result = new { WlogsCost = wlogsCost, wlogsCostChart = wlogsCostChart };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public Response GetWorklogs(Int64 projectid = 0, string workgroups = "", string users = "", string logtype = "", string startdate = "", string enddate = "")
{
Response response = new Response();
try
{
PM_WorkLogBL tb = new PM_WorkLogBL();
var wlogs = new List <PM_WorkLog>();
if (string.IsNullOrEmpty(logtype))
{
wlogs = tb.ToList("getworklogs_summary_table", projectid, workgroups, users, logtype, startdate, enddate);
}
else
{
wlogs = tb.ToList("getworklogs", projectid, workgroups, users, logtype, startdate, enddate);
}
response.Status = "true";
response.Message = "OK";
response.Value = wlogs;
return(response);
}
catch (Exception ex)
{
response.Status = "false";
response.Message = ex.Message.ToString();
return(response);
}
}
public ActionResult Edit(PM_WorkLog worklog)
{
PM_WorkLogBL bal = new PM_WorkLogBL();
var id = Session["user"];
var userId = (LoginInformation)id;
worklog.UserId = Convert.ToInt64(userId.UserId);
var result = bal.Manage("EditWorkLog", worklog);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetWorkLogList(Int64 TaskId, Int64 ProjectSiteId, string LogType, Int64 ProjectId)
{
PM_WorkLogBL WorkLogBL = new PM_WorkLogBL();
if (string.IsNullOrEmpty(LogType))
{
LogType = "Issue";
}
var WorkLogs = WorkLogBL.Get("Get_TaskWorklog", TaskId, ProjectSiteId, LogType, ProjectId);
return(Json(WorkLogs, JsonRequestBehavior.AllowGet));
}
public JsonResult GetWorklogs(string filter, string value, string value2, string SelectOption)
{
PM_WorkLogBL tb = new PM_WorkLogBL();
value = string.IsNullOrEmpty(value) ? DateTime.Now.ToShortDateString() : value;
value2 = string.IsNullOrEmpty(value2) ? DateTime.Now.ToShortDateString() : value2;
var wlogs = tb.ToList(filter, value, value2, SelectOption);
//var fcHistory = tb.FcHistoryList(filter, value, value2, ProjectId, MilestoneId, StageId);
var result = new { Worklogs = wlogs };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage New(PM_WorkLog worklog)
{
PM_WorkLogBL bal = new PM_WorkLogBL();
var result = bal.Manage("INSERT_WorkLog", worklog);
if (result)
{
return(this.Request.CreateResponse(HttpStatusCode.OK,
new { Message = "WorkLog added", Value = 1 }));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"WorkLog not added"));
}
}
public Response LookupData(int projectid = 0, Int64 userid = 0)
{
Response response = new Response();
try
{
PM_WorkLogBL WorkLogBL = new PM_WorkLogBL();
List <PM_Projects> project = new List <PM_Projects>();
var ds = WorkLogBL.LookupData("Get_LookupData", projectid, userid);
if (ds.Tables.Count > 0)
{
DataTable Project = ds.Tables[0];
if (Project != null && Project.Rows.Count > 0)
{
project = Project.ToList <PM_Projects>().ToList();
DataTable Workgroups = ds.Tables[1];
List <PM_Workgroup> workgroups = new List <PM_Workgroup>();
if (Workgroups != null && Workgroups.Rows.Count > 0)
{
workgroups = Workgroups.ToList <PM_Workgroup>().ToList();
DataTable Resources = ds.Tables[2];
List <PM_TaskEntry> resources = new List <PM_TaskEntry>();
if (Resources != null && Resources.Rows.Count > 0)
{
resources = Resources.ToList <PM_TaskEntry>().ToList();
foreach (var item in workgroups)
{
item.Resources = resources.Where(x => x.GroupId == item.WorkgroupId).ToList();
}
}
}
project[0].WorkGroups = workgroups;
}
}
response.Status = "true";
response.Message = "OK";
response.Value = project;
return(response);
}
catch (Exception ex)
{
response.Status = "false";
response.Message = ex.ToString();
return(response);
}
}
public bool ApproveWorklog(string Filter, Int32 WLogId, bool IsApproved)
{
try
{
PM_WorkLog wlog = new PM_WorkLog();
PM_WorkLogBL dal = new PM_WorkLogBL();
var id = Session["user"];
var userId = (LoginInformation)id;
wlog.WLogId = WLogId;
wlog.UserId = Convert.ToInt64(userId.UserId);
wlog.LogDate = DateTime.Now; // ApprovalDate is sent in "@LogDate" Parameter
wlog.IsApproved = IsApproved;
dal.Manage(Filter, wlog);
return(true);
}
catch
{
return(false);
}
}
public Response GetFilterDropdown(string filter = "", Int64 projectid = 0, string workgroups = "", string users = "", string logtype = "", string startdate = "", string enddate = "", string userid = "0", string sitetaskid = "0", string projectsiteid = "0", string workgroupid = "0")
{
Response response = new Response();
try
{
PM_WorkLogBL tb = new PM_WorkLogBL();
PM_WorkLogDL dal = new PM_WorkLogDL();
DataTable dt = dal.GetDataTable(filter, projectid, workgroups, users, logtype, startdate, enddate, userid, sitetaskid, projectsiteid, workgroupid);
// var wlogs = tb.ToList(filter, projectid, workgroups, users, logtype, startdate, enddate);
response.Status = "true";
response.Message = "OK";
response.Value = dt;
return(response);
}
catch (Exception ex)
{
response.Status = "false";
response.Message = ex.Message.ToString();
return(response);
}
}
public ActionResult New(List <PM_WorkLog> worklogs)
{
PM_WorkLogBL bal = new PM_WorkLogBL();
var id = Session["user"];
var userId = (LoginInformation)id;
worklogs = worklogs.Where(X => X.IsApproved == false).ToList();
foreach (var worklog in worklogs)
{
worklog.UserId = Convert.ToInt64(userId.UserId);
if (worklog.WLogId > 0)
{
var result = bal.Manage("EditWorkLog", worklog);
}
else
{
var result = bal.Manage("INSERT_WorkLog", worklog);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
