public void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "This proposal is promoted to project.";
string body = "";
foreach (ListItem lst in cbxlEmployee.Items)
{
int employeeId = int.Parse(lst.Value);
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);
}
}
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following project was promoted to active state. \n";
// ... for client and project
body = body + "\n " + lblTitleClientName.Text;
body = body + "\n Project: " + lblTitleProjectName.Text;
//Send Mail
SendMail(mailTo, subject, body);
}
private void LoadWorkData(int workId, int assetId)
{
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(fullLengthLiningTDS);
if (fullLengthLiningWorkDetailsGateway.Table.Rows.Count > 0)
{
// For Header
tbxVideoLength.Text = fullLengthLiningWorkDetailsGateway.GetVideoLength(workId);
// Load full length lining general data
tbxGeneralClientId.Text = fullLengthLiningWorkDetailsGateway.GetClientId(workId);
ckbxGeneralIssueIdentified.Checked = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workId);
ckbxGeneralLfsIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workId);
ckbxGeneralClientIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueClient(workId);
ckbxGeneralSalesIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueSales(workId);
ckbxGeneralIssueGivenToClient.Checked = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workId);
ckbxGeneralIssueResolved.Checked = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workId);
ckbxGeneralIssueInvestigation.Checked = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workId);
// ... Load Dates
if (fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId).HasValue)
{
tkrdpGeneralProposedLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId).HasValue)
{
tkrdpGeneralDeadlineLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetP1Date(workId).HasValue)
{
tkrdpPrepDataP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
tkrdpGeneralP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM1Date(workId).HasValue)
{
tkrdpM1DataM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
tkrdpGeneralM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM2Date(workId).HasValue)
{
tkrdpGeneralM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
tkrdpM2DataM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetInstallDate(workId).HasValue)
{
tkrdpGeneralInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
tkrdpInstallDataInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId).HasValue)
{
tkrdpGeneralFinalVideo.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
tkrdpInstallDataFinalVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
}
// ... for RA data
if (fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId).HasValue)
{
tkrdpGeneralPreFlushDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
tkrdpGeneralPreFlushDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId).HasValue)
{
tkrdpGeneralPreVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
tkrdpGeneralPreVideoDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
}
// For FullLengthLiningP1 data
tbxPrepDataCXIsRemoved.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).ToString();
ckbxPrepDataRoboticPrepCompleted.Checked = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workId);
if (fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue)
{
tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
}
ckbxPrepDataP1Completed.Checked = fullLengthLiningWorkDetailsGateway.GetP1Completed(workId);
// For FullLengthLiningM1 data
// ... for material
ddlM1DataMaterial.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMaterial(workId);
// ... form m1 data
tbxM1DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId);
ddlM1DataTrafficControl.SelectedValue = fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId);
if(fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId) == "") ddlM1DataSiteDetails.SelectedIndex = 0; else ddlM1DataSiteDetails.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId);
if (fullLengthLiningWorkDetailsGateway.GetAccessType(workId) == "") ddlM1DataAccessType.SelectedIndex = 0; else ddlM1DataAccessType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetAccessType(workId);
ckbxM1DataPipeSizeChange.Checked = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workId);
ckbxM1DataStandardBypass.Checked = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workId);
tbxM1DataStandardBypassComments.Text = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId);
tbxM1DataTrafficControlDetails.Text = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId);
ddlM1DataMeasurementType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId);
ddlM1DataMeasuredFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
tbxM1DataMeasuredFromMh.Text = ""; fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
ddlM1DataVideoDoneFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
tbxM1DataVideoDoneFromMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
ddlM1DataVideoDoneToMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
tbxM1DataVideoDoneToMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
// For FullLengthLiningM2 data
tbxM2DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId);
ckbxM2DataDropPipe.Checked = fullLengthLiningWorkDetailsGateway.GetDropPipe(workId);
tbxM2DataDropPipeInvertdepth.Text = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId);
tbxM2DataCappedLaterals.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).HasValue) tbxM2DataCappedLaterals.Text = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).ToString();
tbxM2DataLineWidthId.Text = fullLengthLiningWorkDetailsGateway.GetLineWithId(workId);
tbxM2DataHydrantAddress.Text = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId);
ddlM2DataHydroWireWithin10FtOfInversionMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId);
tbxM2DataDistanceToInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId);
if (fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId) == "") ddlM2DataSurfaceGrade.SelectedIndex = 0; else ddlM2DataSurfaceGrade.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId);
cbxM2DataHydroPulley.Checked = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workId);
cbxM2DataFridgeCart.Checked = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workId);
cbxM2DataTwoPump.Checked = fullLengthLiningWorkDetailsGateway.GetTwoPump(workId);
cbxM2DataSixBypass.Checked = fullLengthLiningWorkDetailsGateway.GetSixBypass(workId);
cbxM2DataScaffolding.Checked = fullLengthLiningWorkDetailsGateway.GetScaffolding(workId);
cbxM2DataWinchExtension.Checked = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workId);
cbxM2DataExtraGenerator.Checked = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workId);
cbxM2DataGreyCableExtension.Checked = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workId);
cbxM2DataEasementMats.Checked = fullLengthLiningWorkDetailsGateway.GetEasementMats(workId);
cbxM2DataRampsRequired.Checked = fullLengthLiningWorkDetailsGateway.GetRampRequired(workId);
cbxM2DataCameraSkid.Checked = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workId);
// For FullLengthLiningWetOut data
int companyId = Int32.Parse(hdfCompanyId.Value);
// ... ... tube size = confirmed Size
Distance confirmedSizeDistance = new Distance(tbxConfirmedSize.Text);
double confirmedSize = 0;
string[] confirmedSizeString = confirmedSizeDistance.ToStringInEng1().Split('\"');
if (!confirmedSizeDistance.ToStringInEng1().Contains("'"))
{
if (Validator.IsValidDouble(tbxConfirmedSize.Text))
{
confirmedSize = double.Parse(tbxConfirmedSize.Text);
}
else
{
confirmedSize = double.Parse(confirmedSizeString[0]);
}
}
else
{
confirmedSize = Math.Ceiling(confirmedSizeDistance.ToDoubleInEng3()*12);
tbxConfirmedSize.Text = confirmedSize.ToString();
}
// ... Verify if work has wet out information
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
// ... setup data
ddlWetOutDataLinerTube.SelectedValue = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
if (ddlWetOutDataLinerTube.SelectedValue != "(Select)")
{
ckbxWetOutDataIncludeWetOutInformation.Checked = true;
}
else
{
ckbxWetOutDataIncludeWetOutInformation.Checked = false;
}
ddlWetOutDataResins.SelectedValue = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
tbxWetOutDataExcessResin.Text = fullLengthLiningWorkDetailsGateway.GetExcessResin(workId).ToString();
ddlWetOutDataPoundsDrums.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPoundsDrums(workId);
tbxWetOutDataDrumDiameter.Text = fullLengthLiningWorkDetailsGateway.GetDrumDiameter(workId).ToString();
tbxWetOutDataHoistMaximumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMaximumHeight(workId).ToString();
tbxWetOutDataHoistMinimumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMinimumHeight(workId).ToString();
tbxWetOutDataDownDropTubeLength.Text = fullLengthLiningWorkDetailsGateway.GetDownDropTubeLenght(workId).ToString();
tbxWetOutDataPumpHeightAboveGround.Text = fullLengthLiningWorkDetailsGateway.GetPumpHeightAboveGround(workId).ToString();
tbxWetOutDataTubeResinToFeltFactor.Text = fullLengthLiningWorkDetailsGateway.GetTubeResinToFeltFactor(workId).ToString();
// ... wet out sheet
DateTime wetOutDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxWetOutDataDateOfSheet.Text = wetOutDataDateOfSheet.Month.ToString() + "/" + wetOutDataDateOfSheet.Day.ToString() + "/" + wetOutDataDateOfSheet.Year.ToString();
ddlWetOutDataMadeBy.SelectedValue = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
hdfRunDetails.Value = fullLengthLiningWorkDetailsGateway.GetRunDetails(workId);
ddlWetOutDataRunDetails2.SelectedValue = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tkrdpWetOutDataWetOutDate.SelectedDate = fullLengthLiningWorkDetailsGateway.GetWetOutDate(workId);
tbxWetOutDataInstallDate.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? wetOutDataInstallDate = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime wetOutDataInstallDateDateTime = (DateTime)wetOutDataInstallDate;
tbxWetOutDataInstallDate.Text = wetOutDataInstallDateDateTime.Month.ToString() + "/" + wetOutDataInstallDateDateTime.Day.ToString() + "/" + wetOutDataInstallDateDateTime.Year.ToString();
}
tbxWetOutDataTubeThickness.Text = fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxWetOutDataPlusExtra.Text = fullLengthLiningWorkDetailsGateway.GetPlusExtra(workId).ToString();
tbxWetOutDataForTurnOffset.Text = fullLengthLiningWorkDetailsGateway.GetForTurnOffset(workId).ToString();
tbxWetOutDataLengthtToWetOut.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
tbxWetOutDataTubeMaxColdHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHead(workId).ToString();
tbxWetOutDataTubeMaxColdHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHeadPsi(workId).ToString();
tbxWetOutDataTubeMaxHotHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHead(workId).ToString();
tbxWetOutDataTubeMaxHotHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHeadPsi(workId).ToString();
tbxWetOutDataTubeIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHead(workId).ToString();
tbxWetOutDataTubeIdealHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHeadPsi(workId).ToString();
tbxWetOutDataNetResinForTube.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTube(workId).ToString();
tbxWetOutDataNetResinForTubeUsgals.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgals(workId).ToString();
tbxWetOutDataNetResinForTubeDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeDrumsIns(workId);
tbxWetOutDataNetResinForTubeLbsFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeLbsFt(workId).ToString();
tbxWetOutDataNetResinForTubeUsgFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgFt(workId).ToString();
tbxWetOutDataExtraResinForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraResinForMix(workId).ToString();
tbxWetOutDataExtraLbsForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraLbsForMix(workId).ToString();
tbxWetOutDataTotalMixQuantity.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantity(workId).ToString();
tbxWetOutDataTotalMixQuantityUsgals.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityUsgals(workId).ToString();
tbxWetOutDataTotalMixQuantityDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityDrumsIns(workId);
ddlWetOutDataInversionType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetInversionType(workId);
tbxWetOutDataDepthOfInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDepthOfInversionMH(workId).ToString();
tbxWetOutDataTubeForColumn.Text = fullLengthLiningWorkDetailsGateway.GetTubeForColumn(workId).ToString();
tbxWetOutDataTubeForStartDry.Text = fullLengthLiningWorkDetailsGateway.GetTubeForStartDry(workId).ToString();
tbxWetOutDataTotalTube.Text = fullLengthLiningWorkDetailsGateway.GetTotalTube(workId).ToString();
tbxWetOutDataDropTubeConnects.Text = fullLengthLiningWorkDetailsGateway.GetDropTubeConnects(workId);
tbxWetOutDataAllowsHeadTo.Text = fullLengthLiningWorkDetailsGateway.GetAllowsHeadTo(workId).ToString();
tbxWetOutDataRollerGap.Text = fullLengthLiningWorkDetailsGateway.GetRollerGap(workId).ToString();
tbxWetOutDataHeightNeeded.Text = fullLengthLiningWorkDetailsGateway.GetHeightNeeded(workId).ToString();
tbxWetOutDataAvailable.Text = fullLengthLiningWorkDetailsGateway.GetAvailable(workId);
tbxWetOutDataHoistHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistHeight(workId);
hdfResinId.Value = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
hdfMadeBy.Value = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
lblWetOutDataResinGray.Text = fullLengthLiningWorkDetailsGateway.GetResinsLabel(workId);
lblWetOutDataDrumContainsGray.Text = fullLengthLiningWorkDetailsGateway.GetDrumContainsLabel(workId);
lblWetOutDataLinerTubeGray.Text = fullLengthLiningWorkDetailsGateway.GetLinerTubeLabel(workId);
lblWetOutDataLbDrumsGrey.Text = fullLengthLiningWorkDetailsGateway.GetForLbDrumsLabel(workId);
lblWetOutDataNetResinGrey.Text = fullLengthLiningWorkDetailsGateway.GetNetResinLabel(workId);
lblWetOutDataCatalystGrey.Text = fullLengthLiningWorkDetailsGateway.GetCatalystLabel(workId);
// ... ... graphic labels
lblWetOutDataDimensionLabel.Text = confirmedSize + " ins x " + ddlThickness.SelectedValue + " mm Tube";
lblWetOutDataTotalTubeLengthlabel.Text = "Total Tube Length " + tbxWetOutDataTotalTube.Text + " ft";
lblWetOutDataForColumnLabel.Text = tbxWetOutDataTubeForColumn.Text + " ft for Column";
lblWetOutDataDryFtLabel.Text = "Dry " + tbxWetOutDataTubeForStartDry.Text + " ft";
lblWetOutDataWetOutLengthlabel.Text = "Wet-Out Length " + tbxWetOutDataLengthtToWetOut.Text + " ft";
lblWetOutDataDryFtEndLabel.Text = "Dry " + tbxWetOutDataTubeForColumn.Text + " ft";
lblWetOutDataTailEndlabel.Text = "Tail End";
lblWetOutDataColumnEndlabel.Text = "Column End";
lblWetOutDataRollerGapLabel.Text = "Roller Gap " + tbxWetOutDataRollerGap.Text + " mm";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxWetOutDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
tbxWetOutDataExcessResin.Text = "0.0";
ddlWetOutDataPoundsDrums.SelectedIndex = 1;
tbxWetOutDataDrumDiameter.Text = "22.5";
tbxWetOutDataHoistMaximumHeight.Text = "24";
tbxWetOutDataHoistMinimumHeight.Text = "5";
tbxWetOutDataDownDropTubeLength.Text = "19";
tbxWetOutDataPumpHeightAboveGround.Text = "6";
tbxWetOutDataTubeResinToFeltFactor.Text = "87";
tbxWetOutDataPlusExtra.Text = "3";
tbxWetOutDataForTurnOffset.Text = "0";
tbxWetOutDataExtraResinForMix.Text = "0";
tbxWetOutDataTubeForColumn.Text = "16";
tbxWetOutDataTubeForStartDry.Text = "3";
if (ddlWetOutDataInversionType.SelectedValue == "Top")
{
Distance usmhDepthDistance = new Distance(tbxM1DataUsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(usmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
if (ddlWetOutDataInversionType.SelectedValue == "Bottom")
{
Distance dsmhDepthDistance = new Distance(tbxM1DataDsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(dsmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
tbxWetOutDataDepthOfInversionMH.Text = "0";
}
}
tbxWetOutDataRollerGap.Text = "13";
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()),1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxWetOutDataInstallDate.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxWetOutDataInstallDate.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Verify if work has inversion information
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway();
workFullLengthLiningInversionGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has inversion information
if (workFullLengthLiningInversionGateway.Table.Rows.Count > 0)
{
// ... Inversion data
lblInversionDataSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
DateTime inversionDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxInversionDataDateOfSheet.Text = inversionDataDateOfSheet.Month.ToString() + "/" + inversionDataDateOfSheet.Day.ToString() + "/" + inversionDataDateOfSheet.Year.ToString();
int employeeId = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId);
tbxInversionDataInstalledOn.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? inversionDataInstalledOn = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime inversionDataInstalledOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = inversionDataInstalledOnDateTime.Month.ToString() + "/" + inversionDataInstalledOnDateTime.Day.ToString() + "/" + inversionDataInstalledOnDateTime.Year.ToString();
}
tbxInversionDataRunDetails2.Text = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tbxInversionDataCommentsEdit.Text = fullLengthLiningWorkDetailsGateway.GetInversionComment(workId);
tbxInversionDataLinerSize.Text = confirmedSizeString + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxInversionDataWetOutLenght.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
ddlInversionDataInversionPipeType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeType(workId);
if (ddlInversionDataInversionPipeType.SelectedValue != "(Select)")
{
ckbxInversionDataIncludeInversionInformation.Checked = true;
}
else
{
ckbxInversionDataIncludeInversionInformation.Checked = false;
}
ddlInversionDataPipeCondition.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeCondition(workId);
ddlInversionDataGroundMoisture.SelectedValue = fullLengthLiningWorkDetailsGateway.GetGroundMoisture(workId);
tbxInversionDataBoilerSize.Text = fullLengthLiningWorkDetailsGateway.GetBoilerSize(workId).ToString();
tbxInversionDataPumpsTotalCapacity.Text = fullLengthLiningWorkDetailsGateway.GetPumpTotalCapacity(workId).ToString();
tbxInversionDataLayflatSize.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatSize(workId).ToString();
tbxInversionDataLayflatQuantityTotal.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatQuantityTotal(workId).ToString();
tbxInversionDataWaterStartTempTs.Text = fullLengthLiningWorkDetailsGateway.GetWaterStartTemp(workId).ToString();
tbxInversionDataTempT1.Text = fullLengthLiningWorkDetailsGateway.GetTemp1(workId).ToString();
tbxInversionDataHoldAtT1For.Text = fullLengthLiningWorkDetailsGateway.GetHoldAtT1(workId).ToString();
tbxInversionDataTempT2.Text = fullLengthLiningWorkDetailsGateway.GetTempT2(workId).ToString();
tbxInversionDataCookAtT2For.Text = fullLengthLiningWorkDetailsGateway.GetCookAtT2(workId).ToString();
tbxInversionDataCoolDownFor.Text = fullLengthLiningWorkDetailsGateway.GetCoolDownFor(workId).ToString();
tbxInversionDataCoolToTemp.Text = fullLengthLiningWorkDetailsGateway.GetCoolToTemp(workId).ToString();
tbxInversionDataDropInPipeRun.Text = fullLengthLiningWorkDetailsGateway.GetDropInPipeRun(workId).ToString();
tbxInversionDataPipeSlopeOf.Text = fullLengthLiningWorkDetailsGateway.GetPipeSlopOf(workId).ToString();
lblInversionData45F120F.Text = tbxInversionDataWaterStartTempTs.Text + "°F-" + tbxInversionDataTempT1.Text + "°F (hr)";
tbxInversionData45F120F.Text = fullLengthLiningWorkDetailsGateway.GetF45F120(workId).ToString();
tbxInversionDataHold.Text = fullLengthLiningWorkDetailsGateway.GetHold(workId).ToString();
lblInversionData120F185F.Text = tbxInversionDataTempT1.Text + "°F-" + tbxInversionDataTempT2.Text + "°F (hr)";
tbxInversionData120F185F.Text = fullLengthLiningWorkDetailsGateway.GetF120F185(workId).ToString();
tbxInversionDataCookTime.Text = fullLengthLiningWorkDetailsGateway.GetCookTime(workId).ToString();
tbxInversionDataCoolTime.Text = fullLengthLiningWorkDetailsGateway.GetCoolTime(workId).ToString();
tbxInversionDataAproxTotal.Text = fullLengthLiningWorkDetailsGateway.GetAproxTotal(workId).ToString();
tbxInversionDataWaterChangesPerHour.Text = fullLengthLiningWorkDetailsGateway.GetWaterChangesPerHour(workId).ToString();
tbxInversionDataReturnWaterVelocity.Text = fullLengthLiningWorkDetailsGateway.GetReturnWaterVelocity(workId).ToString();
tbxInversionDataLayflatBackPressure.Text = fullLengthLiningWorkDetailsGateway.GetLayflatBackPressure(workId).ToString();
tbxInversionDataPumpLiftAtIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetPumpLiftAtIdealHead(workId).ToString();
tbxInversionDataWaterToFillLinerColumn.Text = fullLengthLiningWorkDetailsGateway.GetWaterToFillLinerColumn(workId).ToString();
tbxInversionDataWaterPerFit.Text = fullLengthLiningWorkDetailsGateway.GetWaterPerFit(workId).ToString();
tbxInversionDataNotesAndInstallationResults.Text = fullLengthLiningWorkDetailsGateway.GetInstallationResults(workId);
lblInversionDataLinerInfoGrey.Text = fullLengthLiningWorkDetailsGateway.GetInversionLinerTubeLabel(workId);
lblInversionDataHeadsGrey.Text = fullLengthLiningWorkDetailsGateway.GetHeadsIdealLabel(workId);
lblInversionDataPumpingCirculationSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetPumpingAndCirculationLabel(workId);
// ... ... graphic labels
lblInversionDataMaxColdForTubeLabel.Text = tbxWetOutDataTubeMaxColdHead.Text + " ft = Max Cold for tube";
lblInversionDataMaxHotForTubeLabel.Text = tbxWetOutDataTubeMaxHotHead.Text + " ft = Max Hot for tube";
lblInversionDataIdelForTubeLabel.Text = tbxWetOutDataTubeIdealHead.Text + " ft = Ideal for tube";
double maxColdForTubeEnd = double.Parse(tbxWetOutDataTubeMaxColdHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxColdForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxColdForTubeEnd.ToString()), 1).ToString() + " ft";
double maxHotForTubeEnd = double.Parse(tbxWetOutDataTubeMaxHotHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxHotForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxHotForTubeEnd.ToString()), 1).ToString() + " ft";
double idealForTubeEnd = double.Parse(tbxWetOutDataTubeIdealHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataIdelForTubeEndLabel.Text = decimal.Round(decimal.Parse(idealForTubeEnd.ToString()), 1).ToString() + " ft";
lblInversionDataPumpHeightLabel.Text = " " + tbxWetOutDataPumpHeightAboveGround.Text + " ft";
lblInversionDataLinerSizeLabel.Text = confirmedSize.ToString() + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId) + " Liner";
lblInversionDataRunLengthLabel.Text = "Run Length: " + tbxInversionDataRunLength.Text + " ft; Fall: " + tbxInversionDataDropInPipeRun.Text + " ft";
lblInversionDataDepthOfInversionMHLabel.Text = " " + tbxWetOutDataDepthOfInversionMH.Text + " ft";
lblInversionDataEndLabel.Text = "End";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxInversionDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
lblInversionData45F120F.Text = "";
lblInversionData120F185F.Text = "";
tbxInversionDataBoilerSize.Text = "7000000";
tbxInversionDataPumpsTotalCapacity.Text = "300";
tbxInversionDataLayflatSize.Text = "4";
tbxInversionDataLayflatQuantityTotal.Text = "1";
tbxInversionDataWaterStartTempTs.Text = "45";
tbxInversionDataTempT1.Text = "120";
tbxInversionDataHoldAtT1For.Text = "0.5";
tbxInversionDataTempT2.Text = "185";
tbxInversionDataCookAtT2For.Text = "2";
tbxInversionDataCoolDownFor.Text = "1";
tbxInversionDataCoolToTemp.Text = "85";
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxInversionDataInstalledOn.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Show FLL Comments + RA Comments
int flWorkId = workId;
// ... ... Get raWorkId
int raWorkId = 0;
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Rehab Assessment", companyId);
if (workGateway.Table.Rows.Count > 0)
{
raWorkId = workGateway.GetWorkId(assetId, "Rehab Assessment", projectId);
}
// ... ... Get comments
FullLengthLiningAllComments fullLengthLiningAllComments = new FullLengthLiningAllComments(fullLengthLiningTDS);
fullLengthLiningAllComments.LoadAllByFlWorkIdRaWorkId(flWorkId, raWorkId, companyId);
// ... ... Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
// ... ... Show comments
tbxCommentsDataComments.Text = fullLengthLiningAllComments.GetFLOrRAComments(companyId, fullLengthLiningAllComments.Table.Rows.Count, "\n");
}
}
protected void ddlWetOutDataMadeBy_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlWetOutDataMadeBy.SelectedValue != "(Select)")
{
int employeeId = Int32.Parse(ddlWetOutDataMadeBy.SelectedValue);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId);
}
}
// ////////////////////////////////////////////////////////////////////////
// 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["source_page"] == null) || ((string)Request.QueryString["service_id"] == null) || ((string)Request.QueryString["active_tab"] == null) || ((string)Request.QueryString["dashboard"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_edit.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfFmType.Value = "Services";
hdfServiceId.Value = Request.QueryString["service_id"].ToString();
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfDashboard.Value = Request.QueryString["dashboard"].ToString();
// Prepare initial data
Session.Remove("serviceCostsDummy");
Session.Remove("serviceNotesDummy");
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int serviceId = Int32.Parse(hdfServiceId.Value.Trim());
string fmType = hdfFmType.Value;
// ... services_navigator2.aspx, services_add_request.aspx, services_manager_tool.aspx
if ((Request.QueryString["source_page"] == "services_navigator2.aspx") || (Request.QueryString["source_page"] == "services_add_request.aspx") || (Request.QueryString["source_page"] == "services_manager_tool.aspx"))
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedServices"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
serviceInformationTDS = new ServiceInformationTDS();
ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS);
serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS);
serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS);
serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabServices"];
// Restore datasets
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
}
// ... Store dataset
Session["serviceInformationTDS"] = serviceInformationTDS;
}
// ... services_summary.aspx or services_edit
if ((Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedServices"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
if (ViewState["update"].ToString().Trim() == "yes")
{
ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS);
serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS);
serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS);
serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId);
// ... Store dataset
Session["serviceInformationTDS"] = serviceInformationTDS;
}
}
else
{
hdfActiveTab.Value = (string)Session["activeTabServices"];
}
}
// Prepare initial data
lblMissingData.Visible = false;
// ... Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTab;
// ... For total cost
ServiceInformationServiceCost serviceInformationServiceCostForTotalCost = new ServiceInformationServiceCost(serviceInformationTDS);
tbxTotalCost.Text = Decimal.Round(serviceInformationServiceCostForTotalCost.GetTotalCost(serviceId, companyId), 2).ToString();
// ... Data for current servicew
LoadServiceData(companyId);
// Databind
Page.DataBind();
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
try
{
ddlAssignmentDataAssignToTeamMember.SelectedValue = ((int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId)).ToString();
}
catch
{
ddlAssignmentDataAssignToTeamMember.SelectedIndex = 0;
}
int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
tbxAssignmentDataAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId);
}
// For thirds party vendor autocomplete
aceThirdPartyVendor.ContextKey = serviceId.ToString() + "," + hdfCompanyId.Value;
// ... For Library
if (Session["libraryTDSForServices"] != null)
{
libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"];
}
else
{
libraryTDSForServices = new LibraryTDS();
}
}
else
{
// Restore datasets
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTab;
if (Session["libraryTDSForServices"] != null)
{
libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"];
}
else
{
libraryTDSForServices = new LibraryTDS();
}
LoadNotes();
}
}
private void LoadDetailaDataAssignmentData(int serviceId, ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway)
{
// Load for Assignment Tab
// ... pnlAssignmentData
tbxAssignmentDataAssignmentDateTime.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString();
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
tkrdpAssignmentDataAssignedDeadlineDate.SelectedDate = DateTime.Parse(deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString());
}
if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = true;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = true;
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false;
}
else
{
if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = false;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = false;
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = true;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = true;
tbxAssignmentDataAssignToThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
tbxAssignmentDataAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
}
else
{
rbtnAssignmentDataToTeamMember.Checked = false;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = false;
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false;
}
}
tbxAssignmentDataAcceptedDateTime.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString();
DateTime? acceptedDateTime = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId);
if (acceptedDateTime.HasValue) tbxAssignmentDataAcceptedDateTime.Text = acceptedDateTime.ToString();
DateTime? rejectedDateTime = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId);
if (rejectedDateTime.HasValue) tbxAssignmentDataRejectedDateTime.Text = rejectedDateTime.ToString();
tbxAssignmentDataRejectedReason.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId);
// ... pnlAssignmentDataReadOnly
tbxAssignmentDataAssignmentDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString();
tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = "";
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
}
if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "")
{
// ... For team member
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = true;
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
tbxAssignmentDataReadOnlyAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId);
}
// ... For third party vendor
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false;
}
else
{
if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "")
{
// ... For team member
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false;
// ... For third party vendor
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = true;
tbxAssignmentDataReadOnlyAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
}
else
{
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false;
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false;
}
}
tbxAssignmentDataAcceptedDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString();
DateTime? acceptedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId);
if (acceptedDateTimeReadOnly.HasValue) tbxAssignmentDataAcceptedDateTimeReadOnly.Text = acceptedDateTimeReadOnly.ToString();
DateTime? rejectedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId);
if (rejectedDateTimeReadOnly.HasValue) tbxAssignmentDataRejectedDateTimeReadOnly.Text = rejectedDateTimeReadOnly.ToString();
tbxAssignmentDataRejectedReasonReadOnly.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId);
}
public void SendMailFleetManager()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "Service request has been modified.";
string body = "";
// MailtTo, nameTo
int companyLevelId = Int32.Parse(hdfCompanyLevel.Value);
Employee employees = new Employee();
employees.LoadByFleetManager(companyLevelId);
mailTo = employees.GetAllFleetManagersEMails();
nameTo = employees.GetAllFleetManagersNames();
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following service request has been modified. \n";
body = body + "\n Service Number: " + hdfServiceNumber.Value;
body = body + "\n Service Description: " + hdfServiceDescription.Value;
// ... Assignation of work
// ... ... Deadline date
if (hdfDeadlineDate.Value != "")
{
DateTime deadlineDate = DateTime.Parse(hdfDeadlineDate.Value);
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + "\n Deadline date: " + deadlineDateText;
}
else
{
body = body + "\n Deadline date: ";
}
// ... ... Assigned Personal
if (hdfAssignToTeamMember.Value == "True")
{
int employeeId = Int32.Parse(hdfTeamMemberId.Value);
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;
}
// ... ... Assigned third party vendor
if (hdfAssignToThirdPartyVendor.Value == "True")
{
body = body + "\n Assigned Third Party Vendor: " + hdfThirdPartyVendor.Value;
}
int registeredByLoginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByLoginId(registeredByLoginId);
int registeredByEmployeeId = employeeGateway.GetEmployeIdByLoginId(registeredByLoginId);
// ... ... Assigned myself
if (hdfAssignToMyself.Value == "True")
{
if (employeeGateway.Table.Rows.Count > 0)
{
body = body + "\n Assigned to myself: " + employeeGateway.GetFirstName(registeredByEmployeeId) + " " + employeeGateway.GetLastName(registeredByEmployeeId);
}
}
// Registered by
if (employeeGateway.Table.Rows.Count > 0)
{
body = body + "\n Registered By: " + employeeGateway.GetFirstName(registeredByEmployeeId) + " " + employeeGateway.GetLastName(registeredByEmployeeId);
}
// Service State
body = body + "\n\n Service State: " + hdfServiceState.Value;
//Send Mail
SendMail(mailTo, subject, body);
}
public void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "You have assigned service requests.";
string body = "";
if (hdfAssignToTeamMember.Value == "True")
{
int employeeId = Int32.Parse(hdfTeamMemberId.Value);
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);
}
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following service request has been assigned to you. \n";
body = body + "\n Service Number: " + hdfServiceNumber.Value;
body = body + "\n Service Description: " + hdfServiceDescription.Value;
if (hdfDeadlineDate.Value != "")
{
DateTime deadlineDate = DateTime.Parse(hdfDeadlineDate.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 SendMailEmployee(string newState)
{
if (newState == "Rejected")
{
// Update grid rows
foreach (GridViewRow row in grdVacations.Rows)
{
int requestId = Int32.Parse(grdVacations.DataKeys[row.RowIndex].Values["RequestID"].ToString());
if (((CheckBox)row.FindControl("cbxSelected")).Checked)
{
string rejectReason = ((TextBox)row.FindControl("tbxRejectReason")).Text;
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
string subject = "";
VacationsInformationRequestsInformationGateway vacationsInformationRequestsInformationGateway = new VacationsInformationRequestsInformationGateway(vacationsInformationTDS);
int employeeId = vacationsInformationRequestsInformationGateway.GetEmployeeID(requestId);
int rejectedById = (int)ViewState["rejected_by_id"];
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
subject = "Vacation request from " + vacationsInformationRequestsInformationGateway.GetStartDate(requestId).ToShortDateString() + " to " + vacationsInformationRequestsInformationGateway.GetEndDate(requestId).ToShortDateString();
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following vacation request has been rejected: \n\n";
body = body + "\t - Vacation request from " + vacationsInformationRequestsInformationGateway.GetStartDate(requestId).ToShortDateString() + " to " + vacationsInformationRequestsInformationGateway.GetEndDate(requestId).ToShortDateString() + "\n";
body = body + "\t - Detail: " + vacationsInformationRequestsInformationGateway.GetDetails(requestId) + "\n";
body = body + "\t - Comment: " + rejectReason;
EmployeeGateway employeeRejected = new EmployeeGateway();
employeeRejected.LoadByEmployeeId(rejectedById);
if (employeeRejected.Table.Rows.Count > 0)
{
body = body + "\n" + "\t - Rejected by: " + employeeRejected.GetFirstName(rejectedById) + " " + employeeRejected.GetLastName(rejectedById);
}
//Send Mail
SendMail(mailTo, subject, body);
}
}
}
}
/// <summary>
/// UpdateForProcess
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="companiesId">companiesId</param>
/// <param name="salesmanId">salesmanId</param>
/// <param name="projectLeadId">projectLeadId</param>
/// <param name="companyId">companyId</param>
public void UpdateForReport(int projectId, int companiesId, int salesmanId, int projectLeadId, int companyId)
{
CompaniesGateway companiesGateway = new CompaniesGateway();
AddressGateway addressGateway = new AddressGateway();
ContactsGateway contactsGateway = new ContactsGateway();
PhoneGateway phoneGateway = new PhoneGateway();
EmployeeGateway employeeGateway = new EmployeeGateway();
ProjectSynopsisReportTDS.LFS_PROJECTRow projectRow = GetProjectRow(projectId);
// Companies Name
companiesGateway.LoadAllByCompaniesId(companiesId, companyId);
projectRow.ClientName = companiesGateway.GetName(companiesId);
// Companies Address
addressGateway.LoadByCompaniesId(companiesId, companyId);
projectRow.ClientAddress = addressGateway.GetAddressByCompaniesId(companiesId);
// Submitted By
// ...If the project has a record at history
employeeGateway.LoadByEmployeeId(salesmanId);
projectRow.SubmittedBy = employeeGateway.GetLastName(salesmanId) + " " + employeeGateway.GetFirstName(salesmanId);
// ... Leaded By
if (projectLeadId > 0)
{
employeeGateway.LoadByEmployeeId(projectLeadId);
projectRow.LeadedBy = employeeGateway.GetLastName(projectLeadId) + " " + employeeGateway.GetFirstName(projectLeadId);
}
else
{
projectRow.LeadedBy = "";
}
// ... Primary contact
if (!projectRow.IsClientPrimaryContactIDNull())
{
// ... ... Primary contact name
contactsGateway.LoadAllByContactId(projectRow.ClientPrimaryContactID, companyId);
projectRow.ClientPrimaryContactName = contactsGateway.GetCompleteName(projectRow.ClientPrimaryContactID);
// ... ... Primary contact position
projectRow.ClientPrimaryContactPosition = contactsGateway.GetCompaniesPosition(projectRow.ClientPrimaryContactID);
// ... ... Phone
phoneGateway.LoadByContactId(projectRow.ClientPrimaryContactID, companyId);
projectRow.ClientPrimaryContactPhones = phoneGateway.GetPhones(projectRow.ClientPrimaryContactID);
}
// ... Secondary contact
if (!projectRow.IsClientSecondaryContactIDNull())
{
// ... ... Primary contact name
contactsGateway.LoadAllByContactId(projectRow.ClientSecondaryContactID, companyId);
projectRow.ClientSecondaryContactName = contactsGateway.GetCompleteName(projectRow.ClientSecondaryContactID);
// ... ... Primary contact position
projectRow.ClientSecondaryContactPosition = contactsGateway.GetCompaniesPosition(projectRow.ClientSecondaryContactID);
// ... ... Phone
phoneGateway.LoadByContactId(projectRow.ClientSecondaryContactID, companyId);
projectRow.ClientSecondaryContactPhones = phoneGateway.GetPhones(projectRow.ClientSecondaryContactID);
}
}
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);
}
private void SendMailEmployees(DataRow[] drEmployees)
{
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
string subject = "";
List<int> employeeIds = new List<int>();
int lastEmployeeId = 0;
int lastApprovedById = 0;
foreach (DataRow row in drEmployees)
{
lastEmployeeId = ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EmployeeID;
lastApprovedById = ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).ApprovedByID;
if (!employeeIds.Contains(lastEmployeeId))
{
employeeIds.Add(lastEmployeeId);
if (body.Length > 0)
{
EmployeeGateway employeeApproved = new EmployeeGateway();
employeeApproved.LoadByEmployeeId(lastApprovedById);
if (employeeApproved.Table.Rows.Count > 0)
{
body = body + "\n\nApproved by " + employeeApproved.GetFirstName(lastApprovedById) + " " + employeeApproved.GetLastName(lastApprovedById);
}
//Send Mail
SendMail(mailTo, subject, body);
mailTo = "";
nameTo = "";
subject = "";
body = "";
}
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadByEmployeeId(lastEmployeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(lastEmployeeId);
nameTo = employeesGateway.GetFirstName(lastEmployeeId) + " " + employeesGateway.GetLastName(lastEmployeeId);
subject = "Project Times Approved";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe followings project time has been approved: \n\n";
if (!((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsStartTimeNull() && !((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsEndTimeNull())
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", Start Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).StartTime.ToShortTimeString() + ", End Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EndTime.ToShortTimeString() + "\n";
}
else
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).WorkingDetails;
}
}
}
else
{
if (!((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsStartTimeNull() && !((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsEndTimeNull())
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", Start Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).StartTime.ToShortTimeString() + ", End Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EndTime.ToShortTimeString() + "\n";
}
else
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).WorkingDetails;
}
}
}
if (body.Length > 0)
{
EmployeeGateway employeeApproved = new EmployeeGateway();
employeeApproved.LoadByEmployeeId(lastApprovedById);
if (employeeApproved.Table.Rows.Count > 0)
{
body = body + "\n\nApproved by " + employeeApproved.GetFirstName(lastApprovedById) + " " + employeeApproved.GetLastName(lastApprovedById);
}
//Send Mail
SendMail(mailTo, subject, body);
mailTo = "";
nameTo = "";
subject = "";
body = "";
}
}
private void LoadDetailedData(int serviceId)
{
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
if (serviceInformationBasicInformationGateway.Table.Rows.Count > 0)
{
// Load for General Tab
tbxGeneralCreatedBy.Text = serviceInformationBasicInformationGateway.GetCreatedBy(serviceId);
tbxGeneralMileage.Text = serviceInformationBasicInformationGateway.GetMileage(serviceId);
lblGeneralMileageUnitOfMeasurement.Text = serviceInformationBasicInformationGateway.GetMileageUnitOfMeasurement(serviceId);
// Load for Assginment Tab
tbxAssignmentDataAssignmentDateTime.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString();
tbxAssignmentDataAssignedDeadlineDate.Text = "";
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
tbxAssignmentDataAssignedDeadlineDate.Text = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
}
if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = true;
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
tbxAssigmentDataToTeamMemberName.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId);
}
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
}
else
{
if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = false;
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = true;
tbxAssignmentDataAssignToThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
}
else
{
rbtnAssignmentDataToTeamMember.Checked = false;
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
}
}
tbxAssignmentDataAcceptedDateTime.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString();
DateTime? acceptedDateTime = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId);
if (acceptedDateTime.HasValue) tbxAssignmentDataAcceptedDateTime.Text = acceptedDateTime.ToString();
DateTime? rejectedDateTime = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId);
if (rejectedDateTime.HasValue) tbxAssignmentDataRejectedDateTime.Text = rejectedDateTime.ToString();
tbxAssignmentDataRejectedReason.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId);
// Load for StartWork Tab
tbxStartWorkDataWorkStartDateTime.Text = serviceInformationBasicInformationGateway.GetStartWorkDateTime(serviceId).ToString();
tbxStartWorkDataUnitOutOfServiceDate.Text = "";
if (serviceInformationBasicInformationGateway.GetUnitOutOfServiceDate(serviceId).HasValue)
{
DateTime outOfServiceDate = (DateTime)serviceInformationBasicInformationGateway.GetUnitOutOfServiceDate(serviceId);
tbxStartWorkDataUnitOutOfServiceDate.Text = outOfServiceDate.Month.ToString() + "/" + outOfServiceDate.Day.ToString() + "/" + outOfServiceDate.Year.ToString();
}
tbxStartWorkDataStartMileage.Text = serviceInformationBasicInformationGateway.GetStartWorkMileage(serviceId);
lblStartWorkDataMileageUnitOfMeasurement.Text = serviceInformationBasicInformationGateway.GetMileageUnitOfMeasurement(serviceId);
// Load for Complete Work Tab
tbxCompleteWorkDataCompleteWorkDateTime.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDateTime(serviceId).ToString();
tbxCompleteWorkDataUnitBackInServiceDate.Text = "";
if (serviceInformationBasicInformationGateway.GetUnitBackInServiceDate(serviceId).HasValue)
{
DateTime backInServiceDate = (DateTime)serviceInformationBasicInformationGateway.GetUnitBackInServiceDate(serviceId);
tbxCompleteWorkDataUnitBackInServiceDate.Text = backInServiceDate.Month.ToString() + "/" + backInServiceDate.Day.ToString() + "/" + backInServiceDate.Year.ToString();
}
tbxCompleteWorkDataCompleteMileage.Text = serviceInformationBasicInformationGateway.GetCompleteWorkMileage(serviceId);
lblCompleteWorkDataMileageUnitOfMeasurement.Text = serviceInformationBasicInformationGateway.GetMileageUnitOfMeasurement(serviceId);
// ... For team member
tbxCompleteWorkDataDescription.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDetailDescription(serviceId);
ckbxCompleteWorkDataPreventable.Checked = serviceInformationBasicInformationGateway.GetCompleteWorkDetailPreventable(serviceId);
tbxCompleteWorkDataLabourHours.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDetailTMLabourHours(serviceId).ToString();
// ... For third party vendor
tbxCompleteWorkDataDescriptionThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDetailDescription(serviceId);
ckbxCompleteWorkDataPreventableThirdPartyVendor.Checked = serviceInformationBasicInformationGateway.GetCompleteWorkDetailPreventable(serviceId);
tbxCompleteWorkDataInvoiceNumberThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDetailTPVInvoiceNumber(serviceId);
tbxCompleteWorkDataInvoiceAmountThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetCompleteWorkDetailTPVInvoiceAmout(serviceId).ToString();
}
}
protected string GetEmployeeName(object employeeId)
{
if (employeeId != DBNull.Value)
{
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId((int)employeeId);
if (employeeGateway.Table.Rows.Count > 0)
{
return employeeGateway.GetLastName((int)employeeId) + " " + employeeGateway.GetFirstName((int)employeeId);
}
return "";
}
return "";
}