protected void Page_Load(object sender, EventArgs e)
{
ClsDiscoveryRequest request = new ClsDiscoveryRequest();
ClsDiscoveryRequestDetails requestDetails = new ClsDiscoveryRequestDetails();
ClsDiscoveryRequestDetails requestDetailsWest = new ClsDiscoveryRequestDetails();
if (Request.QueryString["requestID"] != null)
{
try
{
int requestID = Convert.ToInt32(Request.QueryString["requestID"].Trim());
ClsDiscoveryRequest dr = new ClsDiscoveryRequest();
request = dr.GetDiscoveryRequest(requestID);
ClsDiscoveryRequestDetails drd = new ClsDiscoveryRequestDetails();
requestDetails = drd.GetDiscoveryRequestDetails(requestID, "");
if (request.WPKEastWestSplitFlag == true)
{
requestDetailsWest = drd.GetDiscoveryRequestDetails(requestID, "West");
}
fillInData(request, requestDetails, requestDetailsWest);
}
catch (Exception ex)
{
pnlDanger.Visible = true;
lblDanger.Text = ex.Message.ToString();
}
}
}
//UPDATE A REQUEST
public string UpdateDiscoveryRequestDetails(ClsDiscoveryRequestDetails data, Int32 RequestID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
DateTime localDate = DateTime.Now;
try
{
// right now oExisting comes back null, need to fix this
ClsDiscoveryRequestDetails oExisting = GetDiscoveryRequestDetails(RequestID, data.ShipRecordType);
if (oExisting != null && data != null)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblDiscoveryRequestDetail>()
where qdata.idRequest == RequestID
where qdata.ShipRecordType == data.ShipRecordType
select qdata;
//// Execute the query, and change the column values
//// you want to change.
foreach (tblDiscoveryRequestDetail updRow in query)
{
updRow.CourierAcctNbr = data.CourierAcctNbr;
updRow.ShipRecordType = data.ShipRecordType;
updRow.CourierPinPrefix = data.CourierPinPrefix;
updRow.CourierContractNbr = data.CourierContractNbr;
updRow.CourierTransitDays = Convert.ToInt16(data.CourierTransitDays);
updRow.CourierInductionDesc = data.CourierInductionDesc;
updRow.CourierInductionAddress = data.CourierInductionAddress;
updRow.CourierInductionCity = data.CourierInductionCity;
updRow.CourierInductionState = data.CourierInductionState;
updRow.CourierInductionZip = data.CourierInductionZip;
updRow.CourierInductionCountry = data.CourierInductionCountry;
updRow.CourierFTPusername = data.CourierFTPusername;
updRow.CourierFTPpwd = data.CourierFTPpwd;
updRow.CourierFTPsenderID = data.CourierFTPsenderID;
updRow.CourierSandboxFTPusername = data.CourierSandboxFTPusername;
updRow.CourierSandboxFTPpwd = data.CourierSandboxFTPpwd;
updRow.CourierFTPCustOwnFlag = (bool?)data.CourierFTPCustOwnFlag;
updRow.LTLAcctNbr = data.LTLAcctNbr;
updRow.LTLMinProNbr = data.LTLMinProNbr;
updRow.LTLMaxProNbr = data.LTLMaxProNbr;
updRow.LTLPinPrefix = data.LTLPinPrefix;
updRow.LTLAutomatedFlag = (bool?)data.LTLAutomatedFlag;
updRow.CPCAcctNbr = data.CPCAcctNbr;
updRow.CPCSiteNbr = data.CPCSiteNbr;
updRow.CPCContractNbr = data.CPCContractNbr;
updRow.CPCInductionNbr = data.CPCInductionNbr;
updRow.CPCUsername = data.CPCUsername;
updRow.CPCpwd = data.CPCpwd;
updRow.PPSTAcctNbr = data.PPSTAcctNbr;
updRow.PPSTTransitDays = Convert.ToInt16(data.PPSTTransitDays);
updRow.PPSTInductionDesc = data.PPSTInductionDesc;
updRow.PPSTInductionAddress = data.PPSTInductionAddress;
updRow.PPSTInductionCity = data.PPSTInductionCity;
updRow.PPSTInductionState = data.PPSTInductionState;
updRow.PPSTInductionZip = data.PPSTInductionZip;
updRow.PPSTInductionCountry = data.PPSTInductionCountry;
updRow.PPlusAcctNbr = data.PPlusAcctNbr;
updRow.PPlusTransitDays = Convert.ToInt16(data.PPlusTransitDays);
updRow.PPlusInductionDesc = data.PPlusInductionDesc;
updRow.PPlusInductionAddress = data.PPlusInductionAddress;
updRow.PPlusInductionCity = data.PPlusInductionCity;
updRow.PPlusInductionState = data.PPlusInductionState;
updRow.PPlusInductionZip = data.PPlusInductionZip;
updRow.PPlusInductionCountry = data.PPlusInductionCountry;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = (DateTime?)data.UpdatedOn;
updRow.CreatedBy = data.CreatedBy;
updRow.CreatedOn = (DateTime?)data.CreatedOn;
updRow.ActiveFlag = (bool?)data.ActiveFlag;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Discovery Request with idRequest = " + "'" + data.idRequest + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
//INSERT A NEW REQUEST
public string InsertDiscoveryRequestDetails(ClsDiscoveryRequestDetails data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
//DateTime localDate = DateTime.Now;
try
{
tblDiscoveryRequestDetail oNewRow = new tblDiscoveryRequestDetail()
{
idRequest = data.idRequest,
ShipRecordType = data.ShipRecordType,
CourierAcctNbr = data.CourierAcctNbr,
CourierPinPrefix = data.CourierPinPrefix,
CourierContractNbr = data.CourierContractNbr,
CourierTransitDays = Convert.ToInt16(data.CourierTransitDays),
CourierInductionDesc = data.CourierInductionDesc,
CourierInductionAddress = data.CourierInductionAddress,
CourierInductionCity = data.CourierInductionCity,
CourierInductionState = data.CourierInductionState,
CourierInductionZip = data.CourierInductionZip,
CourierInductionCountry = data.CourierInductionCountry,
CourierFTPusername = data.CourierFTPusername,
CourierFTPpwd = data.CourierFTPpwd,
CourierFTPsenderID = data.CourierFTPsenderID,
CourierSandboxFTPusername = data.CourierSandboxFTPusername,
CourierSandboxFTPpwd = data.CourierSandboxFTPpwd,
CourierFTPCustOwnFlag = (bool?)data.CourierFTPCustOwnFlag,
LTLAcctNbr = data.LTLAcctNbr,
LTLMinProNbr = data.LTLMinProNbr,
LTLMaxProNbr = data.LTLMaxProNbr,
LTLPinPrefix = data.LTLPinPrefix,
LTLAutomatedFlag = (bool?)data.LTLAutomatedFlag,
CPCAcctNbr = data.CPCAcctNbr,
CPCSiteNbr = data.CPCSiteNbr,
CPCContractNbr = data.CPCContractNbr,
CPCInductionNbr = data.CPCInductionNbr,
CPCUsername = data.CPCUsername,
CPCpwd = data.CPCpwd,
PPSTAcctNbr = data.PPSTAcctNbr,
PPSTTransitDays = Convert.ToInt16(data.PPSTTransitDays),
PPSTInductionDesc = data.PPSTInductionDesc,
PPSTInductionAddress = data.PPSTInductionAddress,
PPSTInductionCity = data.PPSTInductionCity,
PPSTInductionState = data.PPSTInductionState,
PPSTInductionZip = data.PPSTInductionZip,
PPSTInductionCountry = data.PPSTInductionCountry,
PPlusAcctNbr = data.PPlusAcctNbr,
PPlusTransitDays = Convert.ToInt16(data.PPlusTransitDays),
PPlusInductionDesc = data.PPlusInductionDesc,
PPlusInductionAddress = data.PPlusInductionAddress,
PPlusInductionCity = data.PPlusInductionCity,
PPlusInductionState = data.PPlusInductionState,
PPlusInductionZip = data.PPlusInductionZip,
PPlusInductionCountry = data.PPlusInductionCountry,
PPSTRoute = data.PPSTRoute,
UpdatedBy = data.UpdatedBy,
UpdatedOn = (DateTime?)data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
ActiveFlag = (bool?)data.ActiveFlag
};
puroTouchContext.GetTable <tblDiscoveryRequestDetail>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idRequest;
data.idRequest = newID;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public ClsDiscoveryRequestDetails GetDiscoveryRequestDetails(int idRequest, string shipType)
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
ClsDiscoveryRequestDetails oReq = (from data in puroTouchContext.GetTable <tblDiscoveryRequestDetail>()
join req in puroTouchContext.GetTable <tblDiscoveryRequest>() on data.idRequest equals req.idRequest
where data.idRequest == idRequest
where data.ShipRecordType == shipType
where req.ActiveFlag != false
select new ClsDiscoveryRequestDetails
{
idRequest = data.idRequest,
idRequestDetails = data.idRequestDetails,
ShipRecordType = data.ShipRecordType,
CourierAcctNbr = data.CourierAcctNbr,
CourierPinPrefix = data.CourierPinPrefix,
CourierContractNbr = data.CourierContractNbr,
CourierTransitDays = Convert.ToInt16(data.CourierTransitDays),
CourierInductionDesc = data.CourierInductionDesc,
CourierInductionAddress = data.CourierInductionAddress,
CourierInductionCity = data.CourierInductionCity,
CourierInductionState = data.CourierInductionState,
CourierInductionZip = data.CourierInductionZip,
CourierInductionCountry = data.CourierInductionCountry,
CourierFTPusername = data.CourierFTPusername,
CourierFTPpwd = data.CourierFTPpwd,
CourierFTPsenderID = data.CourierFTPsenderID,
CourierSandboxFTPusername = data.CourierSandboxFTPusername,
CourierSandboxFTPpwd = data.CourierSandboxFTPpwd,
CourierFTPCustOwnFlag = (bool?)data.CourierFTPCustOwnFlag,
LTLAcctNbr = data.LTLAcctNbr,
LTLMinProNbr = data.LTLMinProNbr,
LTLMaxProNbr = data.LTLMaxProNbr,
LTLPinPrefix = data.LTLPinPrefix,
LTLAutomatedFlag = (bool?)data.LTLAutomatedFlag,
CPCAcctNbr = data.CPCAcctNbr,
CPCSiteNbr = data.CPCSiteNbr,
CPCContractNbr = data.CPCContractNbr,
CPCInductionNbr = data.CPCInductionNbr,
CPCUsername = data.CPCUsername,
CPCpwd = data.CPCpwd,
PPSTAcctNbr = data.PPSTAcctNbr,
PPSTTransitDays = Convert.ToInt16(data.PPSTTransitDays),
PPSTInductionDesc = data.PPSTInductionDesc,
PPSTInductionAddress = data.PPSTInductionAddress,
PPSTInductionCity = data.PPSTInductionCity,
PPSTInductionState = data.PPSTInductionState,
PPSTInductionZip = data.PPSTInductionZip,
PPSTInductionCountry = data.PPSTInductionCountry,
PPlusAcctNbr = data.PPlusAcctNbr,
PPlusTransitDays = Convert.ToInt16(data.PPlusTransitDays),
PPlusInductionDesc = data.PPlusInductionDesc,
PPlusInductionAddress = data.PPlusInductionAddress,
PPlusInductionCity = data.PPlusInductionCity,
PPlusInductionState = data.PPlusInductionState,
PPlusInductionZip = data.PPlusInductionZip,
PPlusInductionCountry = data.PPlusInductionCountry,
PPSTRoute = data.PPSTRoute,
UpdatedBy = data.UpdatedBy,
UpdatedOn = (DateTime?)data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
ActiveFlag = (bool?)data.ActiveFlag
}).FirstOrDefault();
return(oReq);
}
protected void fillInData(ClsDiscoveryRequest request, ClsDiscoveryRequestDetails requestDetails, ClsDiscoveryRequestDetails requestDetailsWest)
{
//HEADER
string rtype = "";
if (request.flagNewRequest == false)
{
rtype = "Existing Relationship";
}
else
{
rtype = "New Relationship";
}
lblCustomerName.Text = "" + request.CustomerName + " - " + rtype;
lblSalesProfessional.Text = request.SalesRepName + " - " + request.District + " District" + " [" + request.SalesRepEmail + "]";
lblSubmittedBy.Text = request.CreatedBy;
lblUpdatedBy.Text = request.UpdatedBy;
lblUpdatedOn.Text = request.UpdatedOn.ToString();
//CUSTOMER INFO
lblAnnualRevenue.Text = request.ProjectedRevenue.ToString("$###,###,###.00");
lblAdress.Text = request.Address;
lblCommodity.Text = request.Commodity;
lblCityStateZip.Text = request.City + ", " + request.State + " " + request.Zipcode + " " + request.Country;
if (request.CustomerWebsite == "")
{
lblWebsitel.Visible = false;
}
else
{
lblWebsite.Text = request.CustomerWebsite;
}
//CONTACT INFO
//lblBusContactName.Text = request.CustomerBusContact;
//lblITContactName.Text = request.CustomerITContact;
//lblBusTitle.Text = request.CustomerBusTitle;
//lblITtitle.Text = request.CustomerITTitle;
//lblBusPhone.Text = request.CustomerBusPhone;
//lblITPhone.Text = request.CustomerITPhone;
//lblBusEmail.Text = request.CustomerBusEmail;
//lblITEmail.Text = request.CustomerITEmail;
//CURRENT SOLUTION
lblCurrentSolution.Text = request.CurrentSolution;
//PROPOSED SERVICES
if (request.SalesComments != "" && request.SalesComments != null)
{
lblSalesNotesl.Visible = true;
lblSalesNotes.Visible = true;
lblSalesNotes.Text = request.SalesComments;
}
lblCustoms.Text = request.ProposedCustoms;
String potentialDates = "";
DateTime pdate;
if (request.CallDate1 != null)
{
pdate = (DateTime)request.CallDate1;
potentialDates = pdate.ToString("MM/dd/yyyy");
}
if (request.CallDate2 != null)
{
pdate = (DateTime)request.CallDate2;
potentialDates = potentialDates + " or " + pdate.ToString("MM/dd/yyyy");
}
if (request.CallDate3 != null)
{
pdate = (DateTime)request.CallDate3;
potentialDates = potentialDates + " or " + pdate.ToString("MM/dd/yyyy");
}
if (potentialDates != "")
{
lblCallDatesl.Visible = true;
lblCallDates.Visible = true;
lblCallDates.Text = potentialDates;
}
//PROFILE
lblITBA.Text = "ITBA: " + request.ITBA;
string TargetDate = "";
if (request.TargetGoLive != null)
{
DateTime td;
td = (DateTime)request.TargetGoLive;
TargetDate = TargetDate + td.ToString("MM/dd/yyyy");
}
else
{
lblTargetGoLivel.Visible = false;
}
if (request.ActualGoLive != null)
{
DateTime ad;
ad = (DateTime)request.ActualGoLive;
//TargetDate = " - Actual Go-Live Date: " + ad.ToString("MM/dd/yyyy");
lblActualGoLive.Visible = true;
lblGoLiveDate.Text = ad.ToString("MM/dd/yyyy");
}
lblTargetGoLive.Text = TargetDate;
if (request.SolutionSummary == "")
{
lblSolutionSummaryl.Visible = false;
}
else
{
lblSolutionSummary.Text = request.SolutionSummary;
}
lblPhase.Text = request.OnboardingPhase;
if (request.ShippingChannel == null)
{
request.ShippingChannel = "";
}
if (request.ShippingChannel != "")
{
lblShippingChannel.Text = request.ShippingChannel;
}
else
{
lblShippingChannell.Visible = false;
}
//WPK
if (request.worldpakFlag == true)
{
lblWPK.Text = "WorkPak Solution";
}
//else
//{
// if (request.worldpakFlag != null)
// lblWPK.Text = "NON-WorldPak Solution";
//}
string othertype = "";
if (request.thirdpartyFlag == true)
{
othertype = "Third Party Vendor";
}
if (request.ThirdPartyVendor != null && request.ThirdPartyVendor != "")
{
othertype = othertype + " - " + request.ThirdPartyVendor;
}
if (request.customFlag == true)
{
othertype = othertype + " *Customized Solution*";
}
lblOtherType.Text = othertype;
//proposed services
PuroTouchRepository rep = new PuroTouchRepository();
List <ClsDiscoveryRequestSvcs> svcList = rep.GetProposedServices(request.idRequest);
string serviceList = "";
serviceList = "<table><tr><td style='text-decoration:underline'>Service</td><td style='text-decoration:underline'>Volume</td></tr>";
foreach (ClsDiscoveryRequestSvcs svc in svcList)
{
serviceList = serviceList + "<tr><td >" + svc.serviceDesc + "</td><td>" + svc.volume.ToString() + "</td></tr>";
}
serviceList = serviceList + "</table>";
lblProposedServices.Text = serviceList;
//customs
if (request.customsFlag == null)
{
request.customsFlag = false;
}
if (request.customsFlag == false)
{
lblCustomsNotSupported.Visible = true;
lblBrokerName.Visible = false;
}
else
{
lblCustomsNotSupported.Visible = false;
request.customsBroker = request.customsBroker.Trim();
if (request.customsBroker != null && request.customsBroker != "")
{
lblCustomsNotSupported.Visible = false;
lblBrokerName.Visible = false;
if (request.customsBroker != "")
{
lblBrokerName.Visible = true;
lblCustomsBroker.Text = request.customsBroker;
}
}
if (request.BrokerNumber != null && request.BrokerNumber != "")
{
lblBrokerNumberl.Visible = true;
lblBrokerNumber.Visible = true;
lblBrokerNumber.Text = request.BrokerNumber;
}
if (request.elinkFlag == null)
{
request.elinkFlag = false;
}
if (request.elinkFlag == true)
{
lblElinkSupported.Text = "ELINK Supported";
}
if (request.PARS != null && request.PARS.Trim() != "")
{
lblPars.Text = "PARS#: " + request.PARS;
}
if (request.PASS != null && request.PASS.Trim() != "")
{
lblPass.Text = "PASS#: " + request.PASS;
}
}
//proposed products
List <ClsDiscoveryRequestProds> prodList = rep.GetProposedProducts(request.idRequest);
if (prodList.Count > 0)
{
string productList = "";
productList = "<table>";
foreach (ClsDiscoveryRequestProds prd in prodList)
{
productList = productList + "<tr><td >" + prd.productDesc + "</td></tr>";
}
productList = productList + "</table>";
lblProducts.Text = productList;
}
else
{
lblProposedProd.Visible = false;
}
//equipment needed
if (request.WPKEquipmentFlag != true)
{
lblequipneeded.Visible = false;
}
else
{
List <ClsDiscoveryRequestEquip> equipList = rep.GetProposedEquipment(request.idRequest);
string equipmentList = "";
equipmentList = "<table>";
foreach (ClsDiscoveryRequestEquip equip in equipList)
{
equipmentList = equipmentList + "<tr><td >" + equip.EquipmentDesc + "</td><td>" + equip.number.ToString() + "</td></tr>";
}
equipmentList = equipmentList + "</table>";
lblEquipment.Text = equipmentList;
}
//Billing
if (request.invoiceType == null)
{
request.invoiceType = "";
}
if (request.billtoAccount == null)
{
request.billtoAccount = "";
}
if (request.invoiceType != "" || request.billtoAccount != "")
{
lblBillingInfo.Visible = true;
lblInvoiceTypel.Visible = true;
lblInvoiceType.Text = request.invoiceType;
lblBillTol.Visible = true;
lblBillTo.Text = request.billtoAccount;
if (request.EDICustomizedFlag == true)
{
lblInvoiceType.Text = lblInvoiceType.Text + " *Custom EDI*";
}
}
//EDI
if (request.invoiceType == "EDI")
{
//show EDI requests
List <ClsDiscoveryRequestEDI> edilst = rep.GetProposedEDI(request.idRequest);
string ediList = "";
ediList = "<table>";
foreach (ClsDiscoveryRequestEDI edi in edilst)
{
ediList = ediList + "<tr><td >" + edi.Solution + "</td><td>" + edi.FileFormat + " / " + edi.CommunicationMethod + "</td></tr>";
}
if (request.FTPUsername != null)
{
ediList = ediList + "<tr><td colspan='2'>FTP Username: "******"</td></tr>";
ediList = ediList + "<tr><td colspan='2'>FTP Password: "******"</td></tr>";
}
ediList = ediList + "</table>";
lblEDIRequests.Text = ediList;
lblEDIRequests.Visible = true;
}
else
{
lblEdiLabel.Visible = false;
}
//WorldPak
if (request.worldpakFlag == false)
{
lblWPKDetails.Visible = false;
lblDataEntrylbl.Visible = false;
lblSandboxlbl.Visible = false;
lblProdCredlbl.Visible = false;
}
else
{
lblWPKDetails.Visible = false;
if (request.WPKDataEntryMethod == null)
{
request.WPKDataEntryMethod = "";
}
if (request.WPKSandboxUsername == null)
{
request.WPKSandboxUsername = "";
}
if (request.WPKSandboxPwd == null)
{
request.WPKSandboxPwd = "";
}
if (request.WPKProdUsername == null)
{
request.WPKProdUsername = "";
}
if (request.WPKProdPwd == null)
{
request.WPKProdPwd = "";
}
string otherText = "";
if (request.WPKCustomExportFlag == true)
{
otherText = otherText + " *Custom Export File* ";
}
if (request.WPKAddressUploadFlag == true)
{
otherText = otherText + " *Address Book Upload* ";
}
if (request.WPKProductUploadFlag == true)
{
otherText = otherText + " *Product File Upload* ";
}
if (request.WPKGhostScanFlag == true)
{
otherText = otherText + " *Ghost Scan* ";
}
if (request.WPKEastWestSplitFlag == true)
{
otherText = otherText + " *East/West Split* ";
}
if (request.DataScrubFlag == true)
{
otherText = otherText + " *Data Scrubbing* ";
}
if (request.WPKDataEntryMethod != "" || request.WPKSandboxUsername != "" || request.WPKProdUsername != "" || otherText != "")
{
lblWPKDetails.Visible = true;
}
if (request.WPKDataEntryMethod != "")
{
lblDataEntrylbl.Visible = true;
lbldataEntry.Text = request.WPKDataEntryMethod;
}
if (request.WPKSandboxUsername != "")
{
lblSandboxlbl.Visible = true;
lblSandbox.Text = request.WPKSandboxUsername + " / " + request.WPKSandboxPwd;
}
if (request.WPKProdUsername != "")
{
lblProdCredlbl.Visible = true;
lblWPKProd.Text = request.WPKProdUsername + " / " + request.WPKProdPwd;
}
lblWPKOther.Text = otherText;
}
//East West Splits
if (request.WPKEastWestSplitFlag == true)
{
lblEWSplitl.Visible = true;
lblewselectl.Visible = true;
lblewselect.Visible = true;
lblewselect.Text = request.EWSelectBy;
string ewflags = "";
if (request.EWSortCodeFlag == true)
{
ewflags = ewflags + "*Using Sort Codes*";
lblewesrtl.Visible = true;
lblewesrt.Visible = true;
lblewesrt.Text = request.EWEastSortCode;
lblewwsrtl.Visible = true;
lblewwsrt.Visible = true;
lblewwsrt.Text = request.EWWestSortCode;
}
if (request.EWSepCloseoutFlag == true)
{
ewflags = ewflags + " *Separate Closeout*";
}
if (request.EWSepPUFlag == true)
{
ewflags = ewflags + " *Separate Pick Up*";
}
lblewflags.Visible = true;
lblewflags.Text = ewflags;
lblewsortdetailsl.Visible = true;
lblewmissortl.Visible = true;
lblewsortdetails.Visible = true;
lblewmissort.Visible = true;
lblewsortdetails.Text = request.EWSortDetails;
lblewmissort.Text = request.EWMissortDetails;
}
//Contract Info
if (request.ContractNumber == null)
{
request.ContractNumber = "";
}
if (request.ContractCurrency == null)
{
request.ContractCurrency = "";
}
if (request.ContractNumber == "" && request.ContractStartDate == null && request.ContractEndDate == null && request.ContractCurrency == "")
{
lblContractNuml.Visible = false;
lblConStartl.Visible = false;
lblConEndl.Visible = false;
lblConCurl.Visible = false;
lblPaymentTermsl.Visible = false;
lblContractInfo.Visible = false;
}
else
{
lblContractNum.Text = request.ContractNumber;
if (request.ContractStartDate != null)
{
DateTime startdate = Convert.ToDateTime(request.ContractStartDate);
lblConStart.Text = startdate.ToString("MM/dd/yyyy");
}
if (request.ContractStartDate != null)
{
DateTime enddate = Convert.ToDateTime(request.ContractEndDate);
lblConEnd.Text = enddate.ToString("MM/dd/yyyy");
}
lblConCur.Text = request.ContractCurrency;
lblPaymentTerms.Text = request.PaymentTerms;
}
//Account SUpport
if (request.ControlBranch == null)
{
request.ControlBranch = "";
}
if (request.SupportUser == null)
{
request.SupportUser = "";
}
if (request.SupportGroup == null)
{
request.SupportGroup = "";
}
if (request.Office == null)
{
request.Office = "";
}
if (request.Group == null)
{
request.Group = "";
}
if (request.CRR == null)
{
request.CRR = "";
}
if (request.ControlBranch == "" && request.SupportUser == "" && request.SupportGroup == "" && request.Office == "" && request.Group == "" && request.CRR == "")
{
lblControlBranchl.Visible = false;
lblSupportUserl.Visible = false;
lblSupportGroupl.Visible = false;
lblOfficel.Visible = false;
lblGroupl.Visible = false;
lblCRRl.Visible = false;
lblAcctSupport.Visible = false;
}
else
{
lblControlBranch.Text = request.ControlBranch;
lblSupportUser.Text = request.SupportUser;
lblSupportGroup.Text = request.SupportGroup;
lblOffice.Text = request.Office;
lblGroup.Text = request.Group;
lblCRR.Text = request.CRR;
}
//Migration Details
if (request.PreMigrationSolution == null)
{
request.PreMigrationSolution = "";
}
if (request.PostMigrationSolution == null)
{
request.PostMigrationSolution = "";
}
if (request.MigrationDate != null || request.PreMigrationSolution != "" || request.PostMigrationSolution != "")
{
lblMigration.Visible = true;
if (request.MigrationDate != null)
{
DateTime mdate = Convert.ToDateTime(request.MigrationDate);
lblMigrationDate.Text = mdate.ToString("MM/dd/yyyy");
lblMigrationDate.Visible = true;
lblMigDate.Visible = true;
}
lblPre.Visible = true;
lblPremigration.Visible = true;
lblPremigration.Text = request.PreMigrationSolution;
lblPost.Visible = true;
lblPostmigration.Visible = true;
lblPostmigration.Text = request.PostMigrationSolution;
}
//SHIPPINT DETAILS
//CanadaPost
if (requestDetails.CPCAcctNbr != "" || requestDetails.CPCContractNbr != "" || requestDetails.CPCSiteNbr != "" || requestDetails.CPCInductionNbr != "" || requestDetails.CPCUsername != "" || requestDetails.CPCpwd != "")
{
lblCPCDetails.Visible = true;
lblCPCAcctl.Visible = true;
lblCPCAcct.Visible = true;
lblCPCAcct.Text = requestDetails.CPCAcctNbr;
lblCPCContractl.Visible = true;
lblCPCContract.Visible = true;
lblCPCContract.Text = requestDetails.CPCContractNbr;
lblCPCSitel.Visible = true;
lblCPCSite.Visible = true;
lblCPCSite.Text = requestDetails.CPCSiteNbr;
lblCPCIndl.Visible = true;
lblCPCInd.Visible = true;
lblCPCInd.Text = requestDetails.CPCInductionNbr;
lblCPCUserl.Visible = true;
lblCPCUser.Visible = true;
lblCPCUser.Text = requestDetails.CPCUsername;
lblCPCPwdl.Visible = true;
lblCPCPwd.Visible = true;
lblCPCPwd.Text = requestDetails.CPCpwd;
}
//Courier
if (requestDetails.CourierAcctNbr != "" || requestDetails.CourierContractNbr != "" || requestDetails.CourierPinPrefix != "" || requestDetails.CourierTransitDays > 0 || requestDetails.CourierInductionAddress != "")
{
lblCourierDetail.Visible = true;
lblCourierAcctl.Visible = true;
lblCourierAcct.Visible = true;
lblCourierAcct.Text = requestDetails.CourierAcctNbr;
lblCourierContractl.Visible = true;
lblCourierContract.Visible = true;
lblCourierContract.Text = requestDetails.CourierContractNbr;
lblCourierPinl.Visible = true;
lblCourierPin.Visible = true;
lblCourierPin.Text = requestDetails.CourierPinPrefix;
lblCourierTransitl.Visible = true;
lblCourierTransit.Visible = true;
lblCourierTransit.Text = requestDetails.CourierTransitDays.ToString();
lblCourierIndl.Visible = true;
lblCourierInd.Visible = true;
lblCourierInd.Text = requestDetails.CourierInductionDesc;
lblCourierIndAddress.Visible = true;
lblCourierIndAddress.Text = requestDetails.CourierInductionAddress;
lblCourierIndCSZ.Visible = true;
lblCourierIndCSZ.Text = requestDetails.CourierInductionCity;
if (requestDetails.CourierInductionState != "")
{
lblCourierIndCSZ.Text = lblCourierIndCSZ.Text + ", " + requestDetails.CourierInductionState + " " + requestDetails.CourierInductionZip + " " + requestDetails.CourierInductionCountry;
}
lblCourierftpuserl.Visible = true;
lblCourierftpuser.Visible = true;
lblCourierftpuser.Text = requestDetails.CourierFTPusername;
lblCourierftppwdl.Visible = true;
lblCourierftppwd.Visible = true;
lblCourierftppwd.Text = requestDetails.CourierFTPpwd;
lblCourierftpsenderl.Visible = true;
lblCourierftpsender.Visible = true;
lblCourierftpsender.Text = requestDetails.CourierFTPsenderID;
if (requestDetails.CourierFTPCustOwnFlag == true)
{
lblCourierFTPFlag.Text = "*Customer Own FTP*";
lblCourierFTPFlag.Visible = true;
}
if (requestDetails.CourierSandboxFTPusername != "" && requestDetails.CourierSandboxFTPusername != null)
{
lblCourierftpuserSandboxl.Visible = true;
lblCourierftpuserSandbox.Visible = true;
lblCourierftpuserSandbox.Text = requestDetails.CourierSandboxFTPusername;
lblCourierftppwdSandboxl.Visible = true;
lblCourierftppwdSandbox.Visible = true;
lblCourierftppwdSandbox.Text = requestDetails.CourierSandboxFTPpwd;
}
}
//LTL
if (requestDetails.LTLAcctNbr != "" || requestDetails.LTLMinProNbr != "" || requestDetails.LTLMaxProNbr != "")
{
lblLTLDetails.Visible = true;
lblLTLAcctl.Visible = true;
lblLTLAcct.Visible = true;
lblLTLAcct.Text = requestDetails.LTLAcctNbr;
lblLTLMinl.Visible = true;
lblLTLMin.Visible = true;
lblLTLMin.Text = requestDetails.LTLMinProNbr;
lblLTLMaxl.Visible = true;
lblLTLMax.Visible = true;
lblLTLMax.Text = requestDetails.LTLMaxProNbr;
lblLTLPinPrefixl.Visible = true;
lblLTLPinPrefix.Visible = true;
lblLTLPinPrefix.Text = requestDetails.LTLPinPrefix;
if (requestDetails.LTLAutomatedFlag == true)
{
lblLTLAutoFlag.Text = " *LTL Automated Process* ";
}
}
//PuroPost
if (requestDetails.PPSTAcctNbr != "" || requestDetails.PPSTTransitDays > 0 || requestDetails.PPSTInductionAddress != "")
{
lblPuroPostDetails.Visible = true;
lblPPSTAcctl.Visible = true;
lblPPSTAcct.Visible = true;
lblPPSTAcct.Text = requestDetails.PPSTAcctNbr;
lblPPSTTransitl.Visible = true;
lblPPSTTransit.Visible = true;
lblPPSTTransit.Text = requestDetails.PPSTTransitDays.ToString();
lblPPSTInductionl.Visible = true;
lblPPSTInduction.Visible = true;
lblPPSTInduction.Text = requestDetails.PPSTInductionDesc;
lblPPSTIndAddr.Visible = true;
lblPPSTIndAddr.Text = requestDetails.PPSTInductionAddress;
lblPPSTIndCSZ.Visible = true;
lblPPSTIndCSZ.Text = requestDetails.PPSTInductionCity;
if (requestDetails.PPSTInductionState != "")
{
lblPPSTIndCSZ.Text = lblPPSTIndCSZ.Text + ", " + requestDetails.PPSTInductionState + " " + requestDetails.PPSTInductionZip + " " + requestDetails.PPSTInductionCountry;
}
}
//PuroPost Plus
if (requestDetails.PPlusAcctNbr == null)
{
requestDetails.PPlusAcctNbr = "";
}
if (requestDetails.PPlusInductionAddress == null)
{
requestDetails.PPlusInductionAddress = "";
}
if (requestDetails.PPlusAcctNbr != "" || requestDetails.PPlusTransitDays > 0 || requestDetails.PPlusInductionAddress != "")
{
lblPuroPostPlusDetails.Visible = true;
lblPPlusAcctl.Visible = true;
lblPPlusAcct.Visible = true;
lblPPlusAcct.Text = requestDetails.PPlusAcctNbr;
lblPPlusTransitl.Visible = true;
lblPPlusTransit.Visible = true;
lblPPlusTransit.Text = requestDetails.PPlusTransitDays.ToString();
lblPPlusInductionl.Visible = true;
lblPPlusInduction.Visible = true;
lblPPlusInduction.Text = requestDetails.PPlusInductionDesc;
lblPPlusIndAddr.Visible = true;
lblPPlusIndAddr.Text = requestDetails.PPlusInductionAddress;
lblPPlusIndCSZ.Visible = true;
lblPPlusIndCSZ.Text = requestDetails.PPlusInductionCity;
if (requestDetails.PPlusInductionState != "")
{
lblPPlusIndCSZ.Text = lblPPlusIndCSZ.Text + ", " + requestDetails.PPlusInductionState + " " + requestDetails.PPlusInductionZip + " " + requestDetails.PPlusInductionCountry;
}
}
//East West Splits
if (request.WPKEastWestSplitFlag == true)
{
lblCPCDetails.Text = "Canada Post East";
lblCourierDetail.Text = "Courier East";
lblLTLDetails.Text = "LTL East";
lblPuroPostDetails.Text = "PuroPost East";
lblPuroPostPlusDetails.Text = "PuroPost Plus East";
ClsDiscoveryRequestDetails drd = new ClsDiscoveryRequestDetails();
//Courier West
if (requestDetailsWest.CourierAcctNbr != "" || requestDetailsWest.CourierContractNbr != "" || requestDetailsWest.CourierPinPrefix != "" || requestDetailsWest.CourierTransitDays > 0 || requestDetailsWest.CourierInductionAddress != "")
{
lblCourierDetailWest.Visible = true;
lblCourierAcctlWest.Visible = true;
lblCourierAcctWest.Visible = true;
lblCourierAcctWest.Text = requestDetailsWest.CourierAcctNbr;
lblCourierContractlWest.Visible = true;
lblCourierContractWest.Visible = true;
lblCourierContractWest.Text = requestDetailsWest.CourierContractNbr;
lblCourierPinlWest.Visible = true;
lblCourierPinWest.Visible = true;
lblCourierPinWest.Text = requestDetailsWest.CourierPinPrefix;
lblCourierTransitlWest.Visible = true;
lblCourierTransitWest.Visible = true;
lblCourierTransitWest.Text = requestDetailsWest.CourierTransitDays.ToString();
lblCourierIndlWest.Visible = true;
lblCourierIndWest.Visible = true;
lblCourierIndWest.Text = requestDetailsWest.CourierInductionDesc;
lblCourierIndAddressWest.Visible = true;
lblCourierIndAddressWest.Text = requestDetailsWest.CourierInductionAddress;
lblCourierIndCSZWest.Visible = true;
lblCourierIndCSZWest.Text = requestDetailsWest.CourierInductionCity;
if (requestDetailsWest.CourierInductionState != "")
{
lblCourierIndCSZWest.Text = lblCourierIndCSZWest.Text + ", " + requestDetailsWest.CourierInductionState + " " + requestDetailsWest.CourierInductionZip + " " + requestDetailsWest.CourierInductionCountry;
}
lblCourierftpuserlWest.Visible = true;
lblCourierftpuserWest.Visible = true;
lblCourierftpuserWest.Text = requestDetailsWest.CourierFTPusername;
lblCourierftppwdlWest.Visible = true;
lblCourierftppwdWest.Visible = true;
lblCourierftppwdWest.Text = requestDetailsWest.CourierFTPpwd;
lblCourierftpsenderlWest.Visible = true;
lblCourierftpsenderWest.Visible = true;
lblCourierftpsenderWest.Text = requestDetailsWest.CourierFTPsenderID;
if (requestDetailsWest.CourierFTPCustOwnFlag == true)
{
lblCourierFTPFlagWest.Text = "*Customer Own FTP*";
lblCourierFTPFlagWest.Visible = true;
}
if (requestDetailsWest.CourierSandboxFTPusername != "" && requestDetailsWest.CourierSandboxFTPusername != null)
{
lblCourierftpuserSandboxlWest.Visible = true;
lblCourierftpuserSandboxWest.Visible = true;
lblCourierftpuserSandboxWest.Text = requestDetailsWest.CourierSandboxFTPusername;
lblCourierftppwdSandboxlWest.Visible = true;
lblCourierftppwdSandboxWest.Visible = true;
lblCourierftppwdSandboxWest.Text = requestDetailsWest.CourierSandboxFTPpwd;
}
}
//LTL West
if (requestDetailsWest.LTLAcctNbr != "" || requestDetailsWest.LTLMinProNbr != "" || requestDetailsWest.LTLMaxProNbr != "")
{
lblLTLDetailsWest.Visible = true;
lblLTLAcctlWest.Visible = true;
lblLTLAcctWest.Visible = true;
lblLTLAcctWest.Text = requestDetails.LTLAcctNbr;
lblLTLMinlWest.Visible = true;
lblLTLMinWest.Visible = true;
lblLTLMinWest.Text = requestDetails.LTLMinProNbr;
lblLTLMaxlWest.Visible = true;
lblLTLMaxWest.Visible = true;
lblLTLMaxWest.Text = requestDetails.LTLMaxProNbr;
lblLTLPinPrefixlWest.Visible = true;
lblLTLPinPrefixWest.Visible = true;
lblLTLPinPrefixWest.Text = requestDetails.LTLPinPrefix;
}
//CPC West
if (requestDetailsWest.CPCAcctNbr != "" || requestDetailsWest.CPCContractNbr != "" || requestDetailsWest.CPCSiteNbr != "" || requestDetailsWest.CPCInductionNbr != "" || requestDetailsWest.CPCUsername != "" || requestDetailsWest.CPCpwd != "")
{
lblCPCDetailsWest.Visible = true;
lblCPCAcctlWest.Visible = true;
lblCPCAcctWest.Visible = true;
lblCPCAcctWest.Text = requestDetailsWest.CPCAcctNbr;
lblCPCContractlWest.Visible = true;
lblCPCContractWest.Visible = true;
lblCPCContractWest.Text = requestDetailsWest.CPCContractNbr;
lblCPCSitelWest.Visible = true;
lblCPCSiteWest.Visible = true;
lblCPCSiteWest.Text = requestDetailsWest.CPCSiteNbr;
lblCPCIndlWest.Visible = true;
lblCPCIndWest.Visible = true;
lblCPCIndWest.Text = requestDetailsWest.CPCInductionNbr;
lblCPCUserlWest.Visible = true;
lblCPCUserWest.Visible = true;
lblCPCUserWest.Text = requestDetailsWest.CPCUsername;
lblCPCPwdlWest.Visible = true;
lblCPCPwdWest.Visible = true;
lblCPCPwdWest.Text = requestDetailsWest.CPCpwd;
}
//PuroPost West
if (requestDetailsWest.PPSTAcctNbr != "" || requestDetailsWest.PPSTTransitDays > 0 || requestDetailsWest.PPSTInductionAddress != "")
{
lblPuroPostDetailsWest.Visible = true;
lblPPSTAcctlWest.Visible = true;
lblPPSTAcctWest.Visible = true;
lblPPSTAcctWest.Text = requestDetailsWest.PPSTAcctNbr;
lblPPSTTransitlWest.Visible = true;
lblPPSTTransitWest.Visible = true;
lblPPSTTransitWest.Text = requestDetailsWest.PPSTTransitDays.ToString();
lblPPSTInductionlWest.Visible = true;
lblPPSTInductionWest.Visible = true;
lblPPSTInductionWest.Text = requestDetailsWest.PPSTInductionDesc;
lblPPSTIndAddrWest.Visible = true;
lblPPSTIndAddrWest.Text = requestDetailsWest.PPSTInductionAddress;
lblPPSTIndCSZWest.Visible = true;
lblPPSTIndCSZWest.Text = requestDetailsWest.PPSTInductionCity;
if (requestDetailsWest.PPSTInductionState != "")
{
lblPPSTIndCSZWest.Text = lblPPSTIndCSZWest.Text + ", " + requestDetailsWest.PPSTInductionState + " " + requestDetailsWest.PPSTInductionZip + " " + requestDetailsWest.PPSTInductionCountry;
}
}
//PuroPost Plus West
if (requestDetailsWest.PPlusAcctNbr != "" || requestDetailsWest.PPlusTransitDays > 0 || requestDetailsWest.PPlusInductionAddress != "")
{
lblPuroPostPlusDetailsWest.Visible = true;
lblPPlusAcctlWest.Visible = true;
lblPPlusAcctWest.Visible = true;
lblPPlusAcctWest.Text = requestDetailsWest.PPlusAcctNbr;
lblPPlusTransitlWest.Visible = true;
lblPPlusTransitWest.Visible = true;
lblPPlusTransitWest.Text = requestDetailsWest.PPlusTransitDays.ToString();
lblPPlusInductionlWest.Visible = true;
lblPPlusInductionWest.Visible = true;
lblPPlusInductionWest.Text = requestDetailsWest.PPlusInductionDesc;
lblPPlusIndAddrWest.Visible = true;
lblPPlusIndAddrWest.Text = requestDetailsWest.PPlusInductionAddress;
lblPPlusIndCSZWest.Visible = true;
lblPPlusIndCSZWest.Text = requestDetailsWest.PPlusInductionCity;
if (requestDetailsWest.PPlusInductionState != "")
{
lblPPlusIndCSZWest.Text = lblPPlusIndCSZWest.Text + ", " + requestDetailsWest.PPlusInductionState + " " + requestDetailsWest.PPlusInductionZip + " " + requestDetailsWest.PPlusInductionCountry;
}
}
}
//Returns
if (request.ReturnsAcctNbr == null)
{
request.ReturnsAcctNbr = "";
}
if (request.ReturnsAcctNbr != "")
{
lblReturndDetals.Visible = true;
lblReturnsAcctl.Visible = true;
lblReturnsAcct.Visible = true;
lblReturnsAcct.Text = request.ReturnsAcctNbr;
lblReturnsAddressl.Visible = true;
lblReturnsAddress.Visible = true;
lblReturnsAddress.Text = request.ReturnsAddress;
lblReturnsCSZ.Visible = true;
lblReturnsCSZ.Text = request.ReturnsCity;
if (request.ReturnsState != "")
{
lblReturnsCSZ.Text = lblReturnsCSZ.Text + ", " + request.ReturnsState + " " + request.ReturnsZip + " " + request.ReturnsCountry;
}
string flagText = "";
if (request.ReturnsDestroyFlag == true)
{
flagText = "*Returns Are Destroyed* ";
}
if (request.ReturnsCreateLabelFlag == true)
{
flagText = flagText + " *Returns Labels Created with Shipments*";
}
if (flagText != "")
{
lblReturnsFlags.Text = flagText;
}
}
//NOTES
ClsNotes cn = new ClsNotes();
List <ClsNotes> notesList = rep.GetNotes(request.idRequest);
if (notesList.Count > 0)
{
string noteString = "";
noteString = "<table><tr style='background-color:gray'><td style='vertical-align:top;text-decoration:underline'>Date</td><td style='vertical-align:top;text-decoration:underline'>Entered By</td><td style='text-decoration:underline'>Note</td></tr>";
DateTime notedate;
string notevalue = "";
string bgcolor = "";
int num = 0;
foreach (ClsNotes note in notesList)
{
num = num + 1;
if (num % 2 == 1)
{
bgcolor = "lightgray";
}
else
{
bgcolor = "white";
}
notedate = (DateTime)note.noteDate;
notevalue = note.publicNote;
notevalue = notevalue.Replace("\n", "<br>");
noteString = noteString + "<tr style='background-color:" + bgcolor + " !important; -webkit-print-color-adjust: exact'><td style='vertical-align:top;font-family:Calibri'>" + notedate.ToString("MM/dd/yyyy") + "</td><td style='vertical-align:top;font-family:Calibri'>" + note.CreatedBy + "</td><td style='color:blue;'>" + notevalue + "</td></tr>";
}
noteString = noteString + "</table>";
lblNotes.Text = noteString;
}
else
{
lblNotesl.Visible = false;
}
}
