protected void btnAssociate_Click(object sender, EventArgs e)
{
Page.Validate();
if (Page.IsValid)
{
string associateCategory = tvCategoriesRoot.SelectedNode.Text;
int libraryCategoryId = int.Parse(tvCategoriesRoot.SelectedNode.Value);
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolBasicInformation.UpdateLibraryCategoriesId(int.Parse(ViewState["serviceId"].ToString()), libraryCategoryId);
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
Response.Write("<script language='javascript'> {window.close();}</script>");
}
}
protected void btnUnassociate_Click(object sender, EventArgs e)
{
SaveTemp();
PostPageChanges();
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolBasicInformation.UpdateLibraryCategoriesId(int.Parse(hdfSelectedSRId.Value), null);
ViewState["update"] = "no";
btnUnassociate.Visible = false;
btnAssociate.Visible = true;
tbxCategoryAssocited.Text = "";
}
private void UpdateDatabase()
{
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDSForServices);
libraryFilesGateway.Update();
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int serviceId = Int32.Parse(hdfSelectedSRId.Value);
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolBasicInformation.Save(companyId);
// Save costs information
ServiceRequestsManagerToolCostInformation serviceRequestsManagerToolCostInformation = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolCostInformation.Save((int)serviceId, companyId);
// Save notes information
ServiceInformationServiceNoteGateway serviceInformationServiceNoteGateway = new ServiceInformationServiceNoteGateway(serviceInformationTDS);
ServiceInformationServiceNote serviceInformationServiceNote = new ServiceInformationServiceNote(serviceInformationTDS);
foreach (ServiceInformationTDS.NoteInformationRow rowNotes in (ServiceInformationTDS.NoteInformationDataTable)serviceInformationServiceNoteGateway.Table)
{
if (!rowNotes.IsLIBRARY_FILES_IDNull())
{
if (rowNotes.LIBRARY_FILES_ID == 0 && rowNotes.FILENAME != "")
{
libraryFilesGateway.LoadByFileName(rowNotes.FILENAME, companyId);
int newLibraryFilesId = libraryFilesGateway.GetlibraryFilesId(rowNotes.FILENAME);
rowNotes.LIBRARY_FILES_ID = newLibraryFilesId;
}
}
}
// Save notes information
serviceInformationServiceNote.Save(companyId);
DB.CommitTransaction();
// Store datasets
serviceRequestsManagerToolTDS.AcceptChanges();
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
// Store datasets
libraryTDSForServices.AcceptChanges();
serviceInformationTDS.AcceptChanges();
Session["serviceInformationTDSForManagerTool"] = serviceInformationTDS;
Session["libraryTDSForServices"] = libraryTDSForServices;
Session.Remove("libraryTDSForServices");
Session.Remove("serviceInformationTDSForManagerTool");
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP2 - STEPS INFORMATION - METHODS
//
private void StepStepsInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "";
// Load data for selected service request
int serviceId = Int32.Parse(hdfSelectedSRId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
ServiceRequestsManagerToolCostInformation serviceRequestsManagerToolCostInformation = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS);
if (Session["dialogOpenedServicesManagerTool"] == null)
{
// ... Load basic data
serviceRequestsManagerToolBasicInformation.LoadByServiceId(serviceId, companyId);
// ... Load costs
serviceRequestsManagerToolCostInformation.LoadByServiceId(serviceId, companyId);
//... Load notes
serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId);
}
else
{
ServiceRequestsManagerToolBasicInformationGateway serviceRequestsManagerToolBasicInformationGateway2 = new ServiceRequestsManagerToolBasicInformationGateway(serviceRequestsManagerToolBasicInformation.Data);
Session.Remove("dialogOpenedServicesManagerTool");
if (serviceRequestsManagerToolBasicInformationGateway2.GetAcceptedDateTime(serviceId).HasValue) ckbxAcceptSR.Checked = true;
if (serviceRequestsManagerToolBasicInformationGateway2.GetStartWorkDateTime(serviceId).HasValue) ckbxStartSR.Checked = true;
if (serviceRequestsManagerToolBasicInformationGateway2.GetUnitOutOfServiceDate(serviceId).HasValue) tkrdpStartWorkUnitOutOfServiceDate.SelectedDate = serviceRequestsManagerToolBasicInformationGateway2.GetUnitOutOfServiceDate(serviceId);
tbxStartWorkStartMileage.Text = serviceRequestsManagerToolBasicInformationGateway2.GetStartWorkMileage(serviceId);
if (serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDateTime(serviceId).HasValue) ckbxCompleteSR.Checked = true;
if (serviceRequestsManagerToolBasicInformationGateway2.GetUnitBackInServiceDate(serviceId).HasValue) tkrdpCompleteWorkUnitBackInServiceDate.SelectedDate = serviceRequestsManagerToolBasicInformationGateway2.GetUnitBackInServiceDate(serviceId);
tbxCompleteWorkCompleteMileage.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkMileage(serviceId);
tbxCompleteWorkDataDescription.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailDescription(serviceId);
ckbxPreventableTPV.Checked = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailPreventable(serviceId);
tbxCompleteWorkDataLabourHours.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailTMLabourHours(serviceId).ToString();
}
ServiceRequestsManagerToolBasicInformationGateway serviceRequestsManagerToolBasicInformationGateway = new ServiceRequestsManagerToolBasicInformationGateway(serviceRequestsManagerToolBasicInformation.Data);
// Validate panels and information
string state = serviceRequestsManagerToolBasicInformationGateway.GetServiceStateOriginal(serviceId);
hdfState.Value = state;
hdfServiceNumber.Value = serviceRequestsManagerToolBasicInformationGateway.GetServiceNumberOriginal(serviceId);
hdfServiceDescription.Value = serviceRequestsManagerToolBasicInformationGateway.GetServiceDescriptionOriginal(serviceId);
string originalThirdsPartyVendor = serviceRequestsManagerToolBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
int? unitId = null;
if (serviceRequestsManagerToolBasicInformationGateway.GetUnitId(serviceId).HasValue)
{
unitId = (int)serviceRequestsManagerToolBasicInformationGateway.GetUnitId(serviceId);
hdfUnitId.Value = unitId.ToString();
}
// ... Validate vehicle information
if (unitId.HasValue)
{
UnitsGateway unitsGateway = new UnitsGateway();
unitsGateway.LoadByUnitId((int)unitId, companyId);
string unitType = unitsGateway.GetType((int)unitId);
hdfUnitType.Value = unitType;
int companyLevel = unitsGateway.GetCompanyLevelId((int)unitId);
hdfCompanyLevel.Value = unitsGateway.GetCompanyLevelId((int)unitId).ToString();
CompanyLevelGateway companyLevelGateway = new CompanyLevelGateway();
companyLevelGateway.LoadByCompanyLevelId(companyLevel, companyId);
hdfMileageUnitOfMeasurement.Value = companyLevelGateway.GetUnitsUnitOfMeasurement(companyLevel);
lblStartWorkStartMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value;
lblCompleteWorkCompleteMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value;
if (unitType == "Vehicle")
{
lblStartWorkStartMileage.Visible = true;
tbxStartWorkStartMileage.Visible = true;
lblCompleteWorkCompleteMileage.Visible = true;
tbxCompleteWorkCompleteMileage.Visible = true;
lblStartWorkStartMileageUnitOfMeasurement.Visible = true;
lblCompleteWorkCompleteMileageUnitOfMeasurement.Visible = true;
}
else
{
lblStartWorkStartMileage.Visible = false;
tbxStartWorkStartMileage.Visible = false;
lblStartWorkStartMileageUnitOfMeasurement.Visible = false;
lblCompleteWorkCompleteMileage.Visible = false;
tbxCompleteWorkCompleteMileage.Visible = false;
lblCompleteWorkCompleteMileageUnitOfMeasurement.Visible = false;
}
}
// ... Validate visible internal panels (complete work info)
if (state == "Unassigned")
{
if (!rbtnAssignToThirdPartyVendor.Checked)
{
pnlAssignTeamMember.Visible = true;
pnlAssignThirdPartyVendor.Visible = false;
}
else
{
pnlAssignThirdPartyVendor.Visible = true;
pnlAssignTeamMember.Visible = false;
}
}
else
{
bool teamMemberAssigned = serviceRequestsManagerToolBasicInformationGateway.GetAssignTeamMember(serviceId);
if (teamMemberAssigned)
{
pnlAssignTeamMember.Visible = true;
pnlAssignThirdPartyVendor.Visible = false;
}
else
{
pnlAssignThirdPartyVendor.Visible = true;
pnlAssignTeamMember.Visible = false;
}
}
// ... Validate panels
switch (state)
{
case "Unassigned":
pnlAssignmentInformation.Visible = true;
acceptInformationSeparator.Visible = true;
pnlAcceptInformation.Visible = true;
startWorkSeparator.Visible = true;
pnlStartWorkInformation.Visible = true;
completeWorkSeparator.Visible = true;
pnlCompleteWorkInformation.Visible = true;
break;
case "Assigned":
pnlAssignmentInformation.Visible = false;
acceptInformationSeparator.Visible = false;
pnlAcceptInformation.Visible = true;
startWorkSeparator.Visible = true;
pnlStartWorkInformation.Visible = true;
completeWorkSeparator.Visible = true;
pnlCompleteWorkInformation.Visible = true;
break;
case "Rejected":
pnlAssignmentInformation.Visible = true;
acceptInformationSeparator.Visible = true;
pnlAcceptInformation.Visible = true;
startWorkSeparator.Visible = true;
pnlStartWorkInformation.Visible = true;
completeWorkSeparator.Visible = true;
pnlCompleteWorkInformation.Visible = true;
break;
case "Accepted":
pnlAssignmentInformation.Visible = false;
acceptInformationSeparator.Visible = false;
pnlAcceptInformation.Visible = false;
startWorkSeparator.Visible = false;
pnlStartWorkInformation.Visible = true;
completeWorkSeparator.Visible = true;
pnlCompleteWorkInformation.Visible = true;
break;
case "In Progress":
pnlAssignmentInformation.Visible = false;
acceptInformationSeparator.Visible = false;
pnlAcceptInformation.Visible = false;
startWorkSeparator.Visible = false;
pnlStartWorkInformation.Visible = false;
completeWorkSeparator.Visible = false;
pnlCompleteWorkInformation.Visible = true;
break;
default:
throw new Exception("The option for " + wzServices.ActiveStep.Name + " step in services_manager_tool.Wizard_ActiveStepChanged function does not exist");
}
hdfPnlAcceptInformation.Value = pnlAcceptInformation.Visible.ToString();
hdfPnlAssignmentInformation.Value = pnlAssignmentInformation.Visible.ToString();
hdfPnlStartWorkInformation.Value = pnlStartWorkInformation.Visible.ToString();
hdfPnlCompleteWorkInformation.Value = pnlCompleteWorkInformation.Visible.ToString();
// ... Load resource library
int? libraryCategoriesId = null; if (serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId).HasValue) libraryCategoriesId = (int)serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId);
if (libraryCategoriesId.HasValue)
{
ViewState["libraryCategoriesId"] = (int)libraryCategoriesId;
tbxCategoryAssocited.Text = GetFullCategoryName((int)libraryCategoriesId, companyId);
btnAssociate.Visible = false;
btnUnassociate.Visible = true;
}
else
{
tbxCategoryAssocited.Text = "";
btnAssociate.Visible = true;
btnUnassociate.Visible = false;
}
// Store session
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
}
private void PostPageChanges()
{
ServiceRequestsManagerToolBasicInformationGateway serviceRequestsManagerToolBasicInformationGateway = new ServiceRequestsManagerToolBasicInformationGateway(serviceRequestsManagerToolTDS);
// basic variables
int companyId = Int32.Parse(hdfCompanyId.Value);
int serviceId = Int32.Parse(hdfSelectedSRId.Value);
int? libraryCategoriesId = null; if (serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId).HasValue) libraryCategoriesId = (int)serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId);
// Service state
string serviceState = "Assigned";
string checklistState = "In Progress";
if (ckbxAcceptSR.Checked) serviceState = "Accepted";
if (ckbxStartSR.Checked) serviceState = "In Progress";
if (ckbxCompleteSR.Checked)
{
serviceState = "Completed";
checklistState = "Healthy";
}
// Get Assignment information
DateTime? assignDeadlineDate = null;
bool assignTeamMember = false;
int? assignTeamMemberId = null;
string assignThirdPartyVendor = "";
DateTime? assignDateTime = null;
if (hdfPnlAssignmentInformation.Value == "True")
{
// If data is modified
if (hdfDeadlineDate.Value != "") assignDeadlineDate = DateTime.Parse(hdfDeadlineDate.Value);
if ((hdfAssignToMyself.Value == "True") || (hdfAssignToTeamMember.Value == "True"))
{
assignTeamMember = true;
assignTeamMemberId = Int32.Parse(hdfTeamMemberId.Value);
}
if (hdfThirdPartyVendor.Value != "")
{
assignThirdPartyVendor = hdfThirdPartyVendor.Value;
}
assignDateTime = DateTime.Now;
}
else
{
// If data is not modified
assignTeamMember = serviceRequestsManagerToolBasicInformationGateway.GetAssignTeamMember(serviceId);
assignTeamMemberId = serviceRequestsManagerToolBasicInformationGateway.GetAssignTeamMemberId(serviceId);
assignThirdPartyVendor = serviceRequestsManagerToolBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
assignDeadlineDate = serviceRequestsManagerToolBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
assignDateTime = serviceRequestsManagerToolBasicInformationGateway.GetAssignmentDateTime(serviceId);
}
// Get acceptance information
DateTime? acceptDateTime = null;
DateTime? rejectDateTime = null;
string rejectReason = "";
if (hdfPnlAcceptInformation.Value == "True")
{
// If data is modified
if (hdfAcceptSR.Value == "True")
{
acceptDateTime = DateTime.Now;
}
}
else
{
// If data is not modified
acceptDateTime = serviceRequestsManagerToolBasicInformationGateway.GetAcceptedDateTime(serviceId);
rejectDateTime = serviceRequestsManagerToolBasicInformationGateway.GetRejectDateTime(serviceId);
rejectReason = serviceRequestsManagerToolBasicInformationGateway.GetRejectReason(serviceId);
}
// Get start work information
DateTime? startWorkDateTime = null;
DateTime? unitOutOfServiceDate = null;
string unitOutOfServiceTime = "";
string startWorkMileage = "";
if (hdfPnlStartWorkInformation.Value == "True")
{
// If data is modified
if (hdfStartSR.Value == "True")
{
startWorkDateTime = DateTime.Now;
if (hdfUnitOutOfServiceDate.Value != "") unitOutOfServiceDate = DateTime.Parse(hdfUnitOutOfServiceDate.Value);
unitOutOfServiceTime = hdfUnitOutOfServiceTime.Value;
if (hdfStartMileage.Value != "") startWorkMileage = hdfStartMileage.Value;
}
}
else
{
// If data is not modified
startWorkDateTime = serviceRequestsManagerToolBasicInformationGateway.GetStartWorkDateTime(serviceId);
unitOutOfServiceDate = serviceRequestsManagerToolBasicInformationGateway.GetUnitOutOfServiceDate(serviceId);
unitOutOfServiceTime = serviceRequestsManagerToolBasicInformationGateway.GetUnitOutOfServiceTime(serviceId);
startWorkMileage = serviceRequestsManagerToolBasicInformationGateway.GetStartWorkMileage(serviceId);
}
// Get complete work information
DateTime? completeWorkDateTime = null;
DateTime? unitBackInServiceDate = null;
string unitBackInServiceTime = "";
string completeWorkDetailDescription = "";
bool completeWorkDetailPreventable = false;
Decimal? completeWorkDetailTMLabourHours = null;
Decimal? completeWorkDetailTMCost = null;
string completeWorkInvoiceNumber = "";
Decimal? completeWorkInvoiceAmount = null;
string completeWorkMileage = "";
if (hdfPnlCompleteWorkInformation.Value == "True")
{
// If data is modified
if (ckbxCompleteSR.Checked)
{
completeWorkDateTime = DateTime.Now;
if (hdfUnitBackInServiceDate.Value != "") unitBackInServiceDate = DateTime.Parse(hdfUnitBackInServiceDate.Value);
unitBackInServiceTime = hdfUnitBackInServiceTime.Value;
completeWorkDetailDescription = hdfCompleteWorkDescription.Value;
completeWorkDetailPreventable = Boolean.Parse(hdfCompleteWorkPreventable.Value);
if (hdfCompleteWorkLabourHours.Value != "") completeWorkDetailTMLabourHours = decimal.Parse(hdfCompleteWorkLabourHours.Value);
if (hdfCompleteWorkCosts.Value != "") completeWorkDetailTMCost = decimal.Parse(hdfCompleteWorkCosts.Value);
if (hdfInvoiceNumber.Value != "") completeWorkInvoiceNumber = hdfInvoiceNumber.Value;
if (hdfInvoiceAmount.Value != "") completeWorkInvoiceAmount = decimal.Parse(hdfInvoiceAmount.Value);
if (hdfCompleteWorkMileage.Value != "") completeWorkMileage = hdfCompleteWorkMileage.Value;
}
}
else
{
// If data is not modified
completeWorkDateTime = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDateTime(serviceId);
unitBackInServiceDate = serviceRequestsManagerToolBasicInformationGateway.GetUnitBackInServiceDate(serviceId);
unitBackInServiceTime = serviceRequestsManagerToolBasicInformationGateway.GetUnitBackInServiceTime(serviceId);
completeWorkDetailDescription = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailDescription(serviceId);
completeWorkDetailPreventable = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailPreventable(serviceId);
completeWorkDetailTMLabourHours = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailTMLabourHours(serviceId);
completeWorkDetailTMCost = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailTMCost(serviceId);
completeWorkInvoiceNumber = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailTPVInvoiceNumber(serviceId);
completeWorkInvoiceAmount = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkDetailTPVInvoiceAmout(serviceId);
completeWorkMileage = serviceRequestsManagerToolBasicInformationGateway.GetCompleteWorkMileage(serviceId);
}
// Insert to dataset
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolBasicInformation.Update(serviceId, serviceState, assignDateTime, assignDeadlineDate, assignTeamMember, assignTeamMemberId, assignThirdPartyVendor, acceptDateTime, startWorkDateTime, unitOutOfServiceDate, unitOutOfServiceTime, completeWorkDateTime, unitBackInServiceDate, unitBackInServiceTime, completeWorkDetailDescription, completeWorkDetailPreventable, completeWorkDetailTMLabourHours, completeWorkDetailTMCost, completeWorkInvoiceNumber, completeWorkInvoiceAmount, startWorkMileage, completeWorkMileage, checklistState, false, companyId, libraryCategoriesId);
// Store session
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
}
