private void GenerateFlowRows(ref DataTable table)
{
JobFlow jobflow = new JobFlow();
JobTypeFlow jobtypeFlow = new JobTypeFlow();
JobTracker jobtracker = new JobTracker();
//var jobflows = jobflow.GetJobOverviewJobFlow();
//var distinctProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim());
foreach (JobTracker p in distincProjectList)
{
DataRow row = table.NewRow();
row["HW No"] = p.HWNo == null ? "" : p.HWNo.Trim();
row["SW No"] = p.SWNo == null ? "" : p.SWNo.Trim();
row["Customer"] = p.Customer == null ? "" : p.Customer.Trim();
row["Description"] = p.Description == null ? "" : p.Description.Trim();
for (int x = 0; x < jobflowList.Count; x++)
{
//var jobtypes = jobtypeFlow.GetJobTypeFlowListByJobFlow(jobflowList[x].Id);
for (int i = 0; i < jobtypeflowlist[x].Count; i++)
{
JobTracker j = new JobTracker();
string deptacro = "";
if (jobtypeflowlist[x][i].DepartmentId != null)
deptacro = jobtypeflowlist[x][i].departmentAcronym;
if (jobtypeflowlist[x][i].DepartmentId != null)
{
j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(jobtypeflowlist[x][i].DepartmentId));
}
else
{
j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"));
}
if (j == null)
{
row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = "";
}
else
{
row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = j.Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy");
}
}
}
table.Rows.Add(row);
}
}
private void GenerateSummaryRows(ref DataTable table)
{
Department dept = new Department();
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
JobTracker jobtracker = new JobTracker();
//joboverviewDepartment = dept.GetJobOverviewDepartment();
distincProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim());
joboverviewRow = new List<List<List<JobTracker>>>();
for (int y = 0; y < distincProjectList.Count;y++ )
{
joboverviewRow.Add(new List<List<JobTracker>>());
DataRow row = table.NewRow();
row["HW No"] = distincProjectList[y].HWNo == null ? "" : distincProjectList[y].HWNo.Trim();
row["SW No"] = distincProjectList[y].SWNo == null ? "" : distincProjectList[y].SWNo.Trim();
row["Customer"] = distincProjectList[y].Customer == null ? "" : distincProjectList[y].Customer.Trim();
row["Description"] = distincProjectList[y].Description == null ? "" : distincProjectList[y].Description.Trim();
for (int x = 0; x < joboverviewDepartment.Count; x++)
{
List<JobTracker> jtlist = new List<JobTracker>();
for (int i = 0; i < joboverviewJobType[x].Count; i++)
{
JobTracker l = jobtracker.GetJobTrackerJobOverview(joboverviewJobType[x][i].Id, distincProjectList[y].SWNo, distincProjectList[y].HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), joboverviewDepartment[x].Id);
jtlist.Add(l);
}
joboverviewRow[y].Add(jtlist);
JobTracker j = new JobTracker();
string curstatus = "";
int curindex = -1;
for (int i = 0; i < jtlist.Count; i++)
{
if (jtlist[i] == null)
continue;
else if (jtlist[i].JobStatus.IndexOf("On Hold") > -1)
{
curstatus = "On Hold";
curindex = i;
break;
}
else if (jtlist[i].JobStatus.IndexOf("In Progress") > -1)
{
if (curstatus != "In Progress")
{
curstatus = "In Progress";
curindex = i;
}
}
else if (jtlist[i].JobStatus.IndexOf("Completed") > -1 && curindex < 0)
{
if (curstatus == "")
{
curstatus = "Completed";
curindex = i;
}
}
}
if (curindex != -1)
{
j = jtlist[curindex];
}
//JobTracker j = jobtracker.GetJobTrackerJobOverview(p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), d.Id);
if (j == null)
{
row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = "";
}
else
{
row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = joboverviewDepartment[x].Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy") + "|" + distincProjectList[y].HWNo + "|" + distincProjectList[y].SWNo;
}
}
table.Rows.Add(row);
}
}
protected void lnkBtn_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "JobOverviewDetails")
{
JobTracker j = new JobTracker();
j = j.GetJobTracker(Convert.ToInt32(e.CommandArgument),false);
modalDetailLabelName.Text = j.fullname;
modalDetailLabelJobType.Text = j.jobtype;
modalDetailLabelJobStatus.Text = j.JobStatus;
modalDetailLabelDate.Text = Convert.ToDateTime(j.ScheduleDate).ToString("dd-MMM-yyyy");
modalDetailLabelStartTime.Text = Convert.ToDateTime(j.StartTime).ToString("hh:mm tt");
modalDetailLabelEndTime.Text = Convert.ToDateTime(j.EndTime).ToString("hh:mm tt");
modalDetailTxtBoxRemarks.Text = j.Remarks;
this.programmaticModalPopupDetail.Show();
}
else if (e.CommandName == "JobOverviewSummary")
{
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
JobTracker jobtracker = new JobTracker();
string argument = e.CommandArgument.ToString();
string[] s = argument.Split('|');
var jobtypes = jobtypeDepartment.GetJobOverviewJobType(Convert.ToInt32(s[0]));
Dictionary<string, string> repeaterdata = new Dictionary<string, string>();
for (int i = 0; i < jobtypes.Count; i++)
{
JobTracker j = jobtracker.GetJobTrackerJobOverview(jobtypes[i].Id, s[2], s[1], Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(s[0]));
if (j == null)
{
repeaterdata.Add(jobtypes[i].Description, "");
}
else
{
repeaterdata.Add(jobtypes[i].Description, j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy"));
}
}
modalSummaryRepeater.DataSource = repeaterdata;
modalSummaryRepeater.DataBind();
programmaticModalPopupSummary.Show();
}
}
