public List<Analysis> GetAnalysis(int departmentid, DateTime startdate, DateTime enddate, string stringjobid,string customer,int roleid)
{
List<Analysis> data = new List<Analysis>();
JobTracker jobtracker = new JobTracker();
List<JobTracker> joblist = new List<JobTracker>();
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
List<JobType> jobtypelist = new List<JobType>();
if (departmentid == 0)
{
//joblist = jobtracker.GetJobTrackerForAnalysis(startdate, enddate);
JobType jobtype = new JobType();
jobtypelist = jobtype.GetJobTypeListByRoleId(roleid);
}
else
{
//joblist = jobtracker.GetJobTrackerForAnalysis(departmentid, startdate, enddate);
jobtypelist = jobtypeDepartment.GetJobTypeList(departmentid);
}
for (int i = 0; i < jobtypelist.Count; i++)
{
Analysis newAnalysis = new Analysis();
newAnalysis.jobtype = jobtypelist[i].Description;
newAnalysis.jobtypeid = jobtypelist[i].Id.ToString();
newAnalysis.totalworktime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Approved", departmentid, stringjobid,customer);
newAnalysis.totalforapproval = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "For Approval", departmentid, stringjobid,customer);
newAnalysis.totaljobTime = "";
if (stringjobid.Trim() != "" || customer.Trim() != "")
{
newAnalysis.totaljobTime = jobtracker.GetTotalHours(jobtypelist[i].Id, Convert.ToDateTime("1900-01-01"), DateTime.Now, "Approved", departmentid, stringjobid, customer);
}
//newAnalysis.totalrejectedtime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Rejected", departmentid, stringjobid,customer);
//newAnalysis.totalunclosedjobs = jobtracker.GetTotalUnclosedJobs(jobtypelist[i].Id, startdate, enddate, "Pending", departmentid, stringjobid).ToString();
data.Add(newAnalysis);
}
return data;
}
protected void InitializeGridViewJobType()
{
GetMyAccessRights();
if (myAccessRights.CanAdd == true)
linkBtnAdd.Visible = true;
else
linkBtnAdd.Visible = false;
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
JobType jobtype = new JobType();
List<JobType> jobtypeList = new List<JobType>();
if (dropDownListDepartment.SelectedItem.Text == "All")
jobtypeList = jobtype.GetJobTypeList();
else
jobtypeList = jobtypeDepartment.GetJobTypeList(Convert.ToInt32(dropDownListDepartment.SelectedItem.Value));
gridViewJobType.DataSource = jobtypeList;
gridViewJobType.DataBind();
}
public List<JobType> GetJobTypeListByRoleId(int roleid)
{
TimeTrackerEntities db = new TimeTrackerEntities();
RoleDepartmentAccess deptAccess = new RoleDepartmentAccess();
var deptlist = deptAccess.GetRoleDepartmentList(roleid);
JobTypeDepartment jobtypeDept = new JobTypeDepartment();
List<JobType> data = new List<JobType>();
foreach (RoleDepartmentAccess r in deptlist)
{
var jobtypelist = jobtypeDept.GetJobTypeList(r.DepartmentId);
//data.AddRange(jobtypelist);
foreach(JobType j in jobtypelist)
{
if (data.FirstOrDefault(d => d.Id == j.Id) == null)
{
data.Add(j);
}
}
}
//data = data.Distinct().ToList();
db.Dispose();
return data;
}
protected void InitializeModalDropDownJobType(int departmentId,string selectedvalue = "")
{
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
List<JobType> jobTypelist = new List<JobType>();
jobTypelist = jobtypeDepartment.GetJobTypeList(departmentId);
modalDropDownJobType.DataSource = jobTypelist;
modalDropDownJobType.DataTextField = "Description";
modalDropDownJobType.DataValueField = "Id";
modalDropDownJobType.DataBind();
if (selectedvalue != null && selectedvalue.Trim() != "")
{
foreach (ListItem i in modalDropDownJobType.Items)
{
if (i.Value.Trim() == selectedvalue.Trim())
{
i.Selected = true;
break;
}
}
}
}
//protected void InitializeModal()
//{
// JobType jobtype = new JobType();
// var data = jobtype.GetJobTypeList(Convert.ToInt32(Session["DepartmentId"]));
// modalDropDownJobType.DataSource = data;
// modalDropDownJobType.DataTextField = "Description";
// modalDropDownJobType.DataValueField = "Id";
// modalDropDownJobType.DataBind();
// Time time = new Time();
// var starttime = time.GetStartTimeList();
// modalDropDownStartTime.DataSource = starttime;
// modalDropDownStartTime.DataTextField = "Description";
// modalDropDownStartTime.DataValueField = "C24hrConversion";
// modalDropDownStartTime.DataBind();
// bool hasSelected = false;
// foreach (ListItem i in modalDropDownStartTime.Items)
// {
// TimeSpan selectedTime = TimeSpan.Parse(i.Value);
// TimeSpan curtime = TimeSpan.Parse(DateTime.Now.Hour + ":" + DateTime.Now.Minute);
// if (selectedTime >= curtime && hasSelected == false)
// {
// i.Selected = true;
// hasSelected = true;
// }
// else
// i.Selected = false;
// }
// var endtime = time.GetEndTimeList(modalDropDownStartTime.SelectedValue);
// modalDropDownEndTime.DataSource = endtime;
// modalDropDownEndTime.DataTextField = "Description";
// modalDropDownEndTime.DataValueField = "C24hrConversion";
// modalDropDownEndTime.DataBind();
//}
private void InitializeModalJobType(string value = "")
{
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
var data = jobtypeDepartment.GetJobTypeList(Convert.ToInt32(Session["DepartmentId"]));
modalDropDownJobType.DataSource = data;
modalDropDownJobType.DataTextField = "Description";
modalDropDownJobType.DataValueField = "Id";
modalDropDownJobType.DataBind();
if (value.Trim() != "")
{
foreach (ListItem i in modalDropDownJobType.Items)
{
if (i.Value.Trim() == value.Trim())
{
i.Selected = true;
//if (jobType != null)
//{
// //modalTxtBoxJobId.Enabled = Convert.ToBoolean(jobType.RequiredJobId);
// modalReqJobId.Enabled = Convert.ToBoolean(jobType.RequiredJobId);
//}
//if (modalTxtBoxJobId.Enabled == false)
//{
// modallabelCustomer.Text = "";
// modallabelBoxJobDescription.Text = "";
// modalTxtBoxJobId.Text = "";
// modalLabelError.Visible = false;
//}
break;
}
}
}
int jobtypeId = Convert.ToInt32(modalDropDownJobType.SelectedValue);
JobType jobType = new JobType();
jobType = jobType.GetJobType(jobtypeId);
if (jobType != null)
{
modalReqJobId.Enabled = Convert.ToBoolean(jobType.RequiredJobId);
modalReqJobStatus.Enabled = Convert.ToBoolean(jobType.ComputeTime); //If time is computed, require Job Status, otherwise do not require it.
//modalDropDownJobStatus.Enabled = Convert.ToBoolean(jobType.RequiredJobId);
}
}
