protected void grdCosts_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("costsDataEdit");
if (Page.IsValid)
{
int serviceId = (int)e.Keys["ServiceID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string partNumber = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[2].FindControl("tbxPartNumber")).Text.Trim();
string partName = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[3].FindControl("tbxPartName")).Text.Trim();
string vendor = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[4].FindControl("tbxVendor")).Text.Trim();
decimal cost = decimal.Parse(((TextBox)grdCosts.Rows[e.RowIndex].Cells[5].FindControl("tbxCost")).Text.Trim());
// Update data
ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
model.Update(serviceId, refId, partNumber, partName, vendor, cost);
// Store dataset
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation;
// Calc TotalCost
tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString();
}
else
{
e.Cancel = true;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP2 - STEPS INFORMATION
//
// ////////////////////////////////////////////////////////////////////////
// STEP2 - STEPS INFORMATION - EVENTS
//
protected void grdCosts_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Costs Gridview, if the gridview is edition mode
if (grdCosts.EditIndex >= 0)
{
grdCosts.UpdateRow(grdCosts.EditIndex, true);
}
// Delete costs
int serviceId = (int)e.Keys["ServiceID"];
int refId = (int)e.Keys["RefID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
model.Delete(serviceId, refId);
// Store dataset
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation;
// Calc TotalCost
tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString();
}
// ////////////////////////////////////////////////////////////////////////
// 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 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);
}
}
private void GrdCostsAdd()
{
if (ValidateCostsFooter())
{
Page.Validate("costsDataAdd");
if (Page.IsValid)
{
int serviceId = 1;
int companyId = Int32.Parse(hdfCompanyId.Value);
string newPartNumber = ((TextBox)grdCosts.FooterRow.FindControl("tbxPartNumberNew")).Text.Trim();
string newPartName = ((TextBox)grdCosts.FooterRow.FindControl("tbxPartNameNew")).Text.Trim();
string newVendor = ((TextBox)grdCosts.FooterRow.FindControl("tbxVendorNew")).Text.Trim();
decimal newCost = Decimal.Round(Decimal.Parse(((TextBox)grdCosts.FooterRow.FindControl("tbxCostNew")).Text.Trim()), 2);
ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
model.Insert(serviceId, newPartNumber, newPartName, newVendor, newCost, false, companyId);
Session.Remove("serviceCostsDummyManagerTool");
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation;
// Calc TotalCost
tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString();
grdCosts.DataBind();
grdCosts.PageIndex = grdCosts.PageCount - 1;
}
}
}
