/// <summary>
/// UpdateForDashboard
/// </summary>
/// <param name="companyId">companyId</param>
public void UpdateForDashboard(int companyId)
{
foreach (DashboardTDS.DashboardInProgressServiceRequestsRow row in (DashboardTDS.DashboardInProgressServiceRequestsDataTable)Table)
{
// Get ruleId for the each service
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway();
serviceInformationBasicInformationGateway.LoadByServiceId(row.ServiceID, companyId);
int? ruleId = serviceInformationBasicInformationGateway.GetRuleId(row.ServiceID);
if (ruleId.HasValue)
{
RuleGateway ruleGateway = new RuleGateway();
ruleGateway.LoadAllByRuleId((int)ruleId, companyId);
if (ruleGateway.Table.Rows.Count > 0)
{
// Get ruleName for each service if exists
string ruleName = ruleGateway.GetName((int)ruleId);
row.InProgressServicesCompleteName = row.InProgressServicesCompleteName + " - " + ruleName;
}
}
}
}
/// <summary>
/// UpdateDataForNavigator
/// </summary>
private void UpdateDataForNavigator()
{
foreach (ServicesNavigatorTDS.ServicesNavigatorRow row in (ServicesNavigatorTDS.ServicesNavigatorDataTable)Table)
{
if (row.IsAssignedToNull())
{
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway();
serviceInformationBasicInformationGateway.LoadByServiceId(row.ServiceID, row.COMPANY_ID);
if (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(row.ServiceID) != "")
{
row.AssignedTo = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(row.ServiceID);
}
}
if (row.IsMTONull()) row.MTO = false;
if (row.IsCompleteWorkDetailPreventableNull()) row.CompleteWorkDetailPreventable = false;
}
}
private void TagPage()
{
hdfCompanyId.Value = Session["companyID"].ToString();
hdfServiceId.Value = Request.QueryString["service_id"];
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
int companyId = Int32.Parse(hdfCompanyId.Value);
int serviceId = Int32.Parse(hdfServiceId.Value);
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGatewayForId = new ServiceInformationBasicInformationGateway();
serviceInformationBasicInformationGatewayForId.LoadByServiceId(serviceId, companyId);
int? unitId = serviceInformationBasicInformationGatewayForId.GetUnitID(serviceId);
UnitsGateway unitsGateway = new UnitsGateway();
unitsGateway.LoadByUnitId((int)unitId, companyId);
hdfUnitType.Value = unitsGateway.GetType((int)unitId);
hdfCompanyLevel.Value = unitsGateway.GetCompanyLevelId((int)unitId).ToString();
int companyLevel = Int32.Parse(hdfCompanyLevel.Value);
CompanyLevelGateway companyLevelGateway = new CompanyLevelGateway();
companyLevelGateway.LoadByCompanyLevelId(companyLevel, companyId);
hdfMileageUnitOfMeasurement.Value = companyLevelGateway.GetUnitsUnitOfMeasurement(companyLevel);
lblPnlStartWorkStartMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value;
lblPnlCompleteWorkCompleteMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value;
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByServiceId
/// </summary>
/// <param name="serviceId">serviceId</param>
/// <param name="companyId">companyId</param>
public void LoadByServiceId(int serviceId, int companyId)
{
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(Data);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
}
private void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "You have assigned service requests.";
string body = "";
int employeeId = Int32.Parse(ddlPnlAssignAssignToTeamMember.SelectedValue);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadForMailsByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int companyLevel = Int32.Parse(hdfCompanyLevel.Value);
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following service request has been assigned to you. \n";
body = body + "\n Unit: " + serviceInformationBasicInformationGateway.GetUnitCode(serviceId) + " - " + serviceInformationBasicInformationGateway.GetUnitDescription(serviceId) + "\n";
body = body + "\n Fixed Date: ";
if (serviceInformationBasicInformationGateway.GetMtoDto(serviceId)) body = body + "Yes "; else body = body + "No ";
string unitType = hdfUnitType.Value;
if (unitType == "Vehicle")
{
body = body + "\n Mileage: " + serviceInformationBasicInformationGateway.GetMileage(serviceId) + " " + hdfMileageUnitOfMeasurement.Value;
}
body = body + "\n Problem Description: " + serviceInformationBasicInformationGateway.GetServiceDescription(serviceId);
if (tkrdpPnlAssignDeadlineDate.SelectedDate.HasValue)
{
DateTime deadlineDate = tkrdpPnlAssignDeadlineDate.SelectedDate.Value;
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + " \n Deadline date: " + deadlineDateText;
}
else
{
body = body + " \n Deadline date: ";
}
int registeredByLoginId = Convert.ToInt32(Session["loginID"]);
employeesGateway.LoadByLoginId(registeredByLoginId);
int registeredByEmployeeId = employeesGateway.GetEmployeIdByLoginId(registeredByLoginId);
if (employeesGateway.Table.Rows.Count > 0)
{
body = body + "\n Assigned By: " + employeesGateway.GetFirstName(registeredByEmployeeId) + " " + employeesGateway.GetLastName(registeredByEmployeeId);
}
//Send Mail
SendMail(mailTo, subject, body);
}
private void SendMailFleetManagerAcceptRejectCompleted(string subject, string title)
{
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int companyLevel = Int32.Parse(hdfCompanyLevel.Value);
// MailtTo, nameTo
int companyLevelId = Int32.Parse(hdfCompanyLevel.Value);
Employee employees = new Employee();
employees.LoadByFleetManager(companyLevelId);
mailTo = employees.GetAllFleetManagersEMails();
nameTo = employees.GetAllFleetManagersNames();
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
// Mails body
body = body + "\nHi " + nameTo + ",\n\n" + title + " \n";
body = body + "\n Service: " + serviceInformationBasicInformationGateway.GetServiceNumber(serviceId) + " - " + serviceInformationBasicInformationGateway.GetServiceDescription(serviceId);
body = body + "\n Unit: " + serviceInformationBasicInformationGateway.GetUnitCode(serviceId) + " - " + serviceInformationBasicInformationGateway.GetUnitDescription(serviceId);
body = body + "\n Fixed Date: ";
if (serviceInformationBasicInformationGateway.GetMtoDto(serviceId)) body = body + "Yes "; else body = body + "No ";
string unitType = hdfUnitType.Value;
if (unitType == "Vehicle")
{
body = body + "\n Mileage: " + serviceInformationBasicInformationGateway.GetMileage(serviceId) + " " + hdfMileageUnitOfMeasurement.Value;
}
body = body + "\n Problem Description: " + serviceInformationBasicInformationGateway.GetServiceDescription(serviceId);
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + "\n Deadline Date: " + deadlineDateText;
}
// Asignation
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
int employeeId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadByEmployeeId(employeeId);
string assignedTo = "";
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
assignedTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
body = body + "\n Assigned Team Member: " + assignedTo;
}
// ... Start work information
if (serviceInformationBasicInformationGateway.GetStartWorkDateTime(serviceId).HasValue)
{
DateTime startWorkDate = (DateTime)serviceInformationBasicInformationGateway.GetStartWorkDateTime(serviceId);
body = body + "\n Start Work Date & Time: " + startWorkDate;
}
// ... Complete work information
if (serviceInformationBasicInformationGateway.GetCompleteWorkDateTime(serviceId).HasValue)
{
DateTime completeWorkDate = (DateTime)serviceInformationBasicInformationGateway.GetCompleteWorkDateTime(serviceId);
body = body + "\n Complete Work Date & Time: " + completeWorkDate;
}
//Send Mail
SendMail(mailTo, subject, body);
}
private void SendMailFleetManager( string subject, string title)
{
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int companyLevel = Int32.Parse(hdfCompanyLevel.Value);
// MailtTo, nameTo
int companyLevelId = Int32.Parse(hdfCompanyLevel.Value);
Employee employees = new Employee();
employees.LoadByFleetManager(companyLevelId);
mailTo = employees.GetAllFleetManagersEMails();
nameTo = employees.GetAllFleetManagersNames();
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
// Mails body
body = body + "\nHi " + nameTo + ",\n\n"+ title + " \n";
body = body + "\n Unit: " + serviceInformationBasicInformationGateway.GetUnitCode(serviceId) + " - " + serviceInformationBasicInformationGateway.GetUnitDescription(serviceId);
body = body + "\n Fixed Date: ";
if (serviceInformationBasicInformationGateway.GetMtoDto(serviceId)) body = body + "Yes "; else body = body + "No ";
string unitType = hdfUnitType.Value;
if (unitType == "Vehicle")
{
body = body + "\n Mileage: " + serviceInformationBasicInformationGateway.GetMileage(serviceId) + " " + hdfMileageUnitOfMeasurement.Value;
}
body = body + "\n Problem Description: " + serviceInformationBasicInformationGateway.GetServiceDescription(serviceId);
if (tkrdpPnlAssignDeadlineDate.SelectedDate.HasValue)
{
DateTime deadlineDate = tkrdpPnlAssignDeadlineDate.SelectedDate.Value;
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + " \n Deadline date: " + deadlineDateText;
}
else
{
body = body + " \n Deadline date: ";
}
if(rbtnPnlAssignToTeamMember.Checked)
{
int employeeId = Int32.Parse(ddlPnlAssignAssignToTeamMember.SelectedValue);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadForMailsByEmployeeId(employeeId);
string assignedTo = "";
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
assignedTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
body = body + "\n Assigned Team Member: " + assignedTo;
}
if (rbtnPnlAssignToThirdPartyVendor.Checked)
{
body = body + "\n Assigned Third Party Vendor: " + tbxPnlAssignAssignToThirdPartyVendor.Text;
}
//Send Mail
SendMail(mailTo, subject, body);
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["state"] == null) || ((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["service_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_state.aspx");
}
// Tag page
TagPage();
// If coming from services_summary.aspx
if ((string)Request.QueryString["source_page"] == "services_summary.aspx")
{
// Store Navigator State and Update control
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Get project record
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
if (serviceInformationBasicInformationGateway.GetRuleId(serviceId).HasValue)
{
RuleGateway ruleGateway = new RuleGateway();
int? ruleId = serviceInformationBasicInformationGateway.GetRuleId(serviceId);
ruleGateway.LoadAllByRuleId(ruleId.Value, Int32.Parse(hdfCompanyId.Value));
int? serviceRequestDays = ruleGateway.GetServiceRequestDays(ruleId.Value);
if (serviceRequestDays.HasValue)
{
DateTime serviceRequestCreationDate = serviceInformationBasicInformationGateway.GetDateTime_(serviceId);
tkrdpPnlAssignDeadlineDate.SelectedDate = serviceRequestCreationDate.AddDays(Convert.ToDouble(serviceRequestDays.Value));
}
}
// Store datasets
Session["serviceInformationTDS"] = serviceInformationTDS;
}
// If coming from wucSRUnassigned.aspx
if ((string)Request.QueryString["source_page"] == "wucSRUnassigned.ascx")
{
// Store Navigator State and Update control
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Get project record
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
serviceInformationTDS = new ServiceInformationTDS();
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
if (serviceInformationBasicInformationGateway.GetRuleId(serviceId).HasValue)
{
RuleGateway ruleGateway = new RuleGateway();
int? ruleId = serviceInformationBasicInformationGateway.GetRuleId(serviceId);
ruleGateway.LoadAllByRuleId(ruleId.Value, Int32.Parse(hdfCompanyId.Value));
int? serviceRequestDays = ruleGateway.GetServiceRequestDays(ruleId.Value);
if (serviceRequestDays.HasValue)
{
DateTime serviceRequestCreationDate = serviceInformationBasicInformationGateway.GetDateTime_(serviceId);
tkrdpPnlAssignDeadlineDate.SelectedDate = serviceRequestCreationDate.AddDays(Convert.ToDouble(serviceRequestDays.Value));
}
}
// Store datasets
Session["serviceInformationTDS"] = serviceInformationTDS;
}
// Restore dataset
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
LoadMileage();
}
else
{
// Restore dataset
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
}
}
private bool IsDeletedSR(int serviceId, int companyId)
{
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway();
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
if (serviceInformationBasicInformationGateway.Table.Rows.Count > 0)
{
int loginId = Convert.ToInt32(Session["loginID"]);
bool serviceAdmin = Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_ADMIN"]);
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
int ownerId = serviceInformationBasicInformationGateway.GetOwnerID(serviceId);
if (!(serviceInformationBasicInformationGateway.GetRuleId(serviceId).HasValue) && ((employeeId == ownerId) || (serviceAdmin)))
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}