public EntityShipment SimpleVoidMethod(EntityShipment objRequest)
{
switch (objRequest.ToolKit.ID.ToUpper())
{
case "LEXIS":
LexisInterface objLexis = new LexisInterface();
objRequest = objLexis.Void(objRequest);
break;
case "LEXISGLOBAL":
LexisGlobalInterface objLexisGlobal = new LexisGlobalInterface();
objRequest = objLexisGlobal.Void(objRequest);
break;
case "CMS":
CMSInterface objCMS = new CMSInterface();
objRequest = objCMS.Void(objRequest);
break;
case "SAP":
SAPInterface objSAP = new SAPInterface();
objRequest = objSAP.Void(objRequest);
break;
}
return(objRequest);
}
private EntityShipment FillShipment(EntityShipment objES)
{
DataTable dtHeader;
if (objES.objDetails.strDeliveryDocNumber.Length > 14)
{
objES.objDetails.strDeliveryDocNumber = objES.objDetails.strDeliveryDocNumber.Substring(8, 6);
}
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
if (ContinueCheck() == false)
{
return(objES);
}
if (dtHeader != null && dtHeader.Rows.Count > 0)
{
objES.objShipTo = FillShipTo(dtHeader.Rows[0]);
objES.objDetails = FillDetails(dtHeader.Rows[0], objES.objDetails);
objES.objShipMethod = GetShipViaCode(dtHeader.Rows[0]);
objES.objShipFrom = FillShipFrom(dtHeader.Rows[0]);
objES.objBillTo = FillBillTo(dtHeader.Rows[0]);
}
else
{
lstResponse.Add(SetResponse("No Shipment Information Found!", "No Shipment Information Found!", ResponseStatusType.CRITICAL));
}
return(objES);
}
private EntityShipment FillShipment(EntityShipment objES)
{
DataTable dtHeader;
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
if (ContinueCheck() == false)
{
return(objES);
}
if (dtHeader != null && dtHeader.Rows.Count > 0)
{
if (dtHeader.Rows[0]["trknum"] != null && dtHeader.Rows[0]["trknum"].ToString().Trim() != "" && dtHeader.Rows[0]["trknum"].ToString().Trim() != "VOID")
{
lstResponse.Add(SetResponse("Record Already Shipped", "Record Already Shipped", ResponseStatusType.WARNING));
return(objES);
}
else
{
objES.objShipTo = FillShipTo(dtHeader.Rows[0]);
objES.objDetails = FillDetails(dtHeader.Rows[0], objES.objDetails);
objES.objShipMethod = GetShipViaCode(dtHeader.Rows[0]);
}
}
else
{
lstResponse.Add(SetResponse("No Shipment Information Found!", "No Shipment Information Found!", ResponseStatusType.CRITICAL));
}
return(objES);
}
private bool InsertData(EntityShipment objES)
{
DataTable dtHeader;
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
string str = "update solink set trknum = '" + objES.lstContainer[0].strTrackingNumber.Trim() + "', shipdate = '" + objES.dtShipDate.ToString("MM-dd-yyyy H:mm:ss") + "', shpcharge = '" + TotalFreightCosts(objES.lstContainer, dtHeader) + "' where shipid = '" + objES.objDetails.strDeliveryDocNumber.Trim() + "'";
return(ExecuteQuery(str));
}
public EntityShipment Void(EntityShipment objES)
{
objSQLCon = GetSqlConnection(objES.ToolKit.objConnection);
if (UpdateData(objES) == false)
{
lstResponse.Add(SetResponse("Error - During Void!", "Error - During Void! Contact System Administrator!", ResponseStatusType.CRITICAL));
}
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
public EntityShipment Void(EntityShipment objES)
{
try
{
}
catch (Exception ex)
{
lstResponse.Add(SetResponse(ex.Message, ResponseStatusType.ERROR));
}
return(objES);
}
public EntityShipment Pull(EntityShipment objES)
{
objSQLCon = GetSqlConnection(objES.ToolKit.objConnection);
if (ContinueCheck() == false)
{
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
objES = FillShipment(objES);
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
public EntityShipment Putback(EntityShipment objES)
{
try
{
}
catch (Exception ex)
{
lstResponse.Add(SetResponse(ex.Message, ResponseStatusType.ERROR));
}
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
public EntityShipment Putback(EntityShipment objES)
{
objSQLCon = GetSqlConnection(objES.ToolKit.objConnection);
if (ContinueCheck() == false)
{
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
if (InsertData(objES) == false)
{
lstResponse.Add(SetResponse("Error - During Putback!", "Error - During Putback! Contact System Administrator!", ResponseStatusType.CRITICAL));
}
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
public EntityShipment Pull(EntityShipment objES)
{
try
{
objES.objShipTo = GetShipTo();
objES.objDetails.strPONumber = "PONumber";
objES.objDetails.strInvoiceNumber = "InvNumber";
objES.objShipMethod = new EntityShipMethod();
objES.objShipMethod.strShipViaCode = "100";
objES.lstContainer = new List <EntityContainer>(); //If line items are needed...
objES.lstContainer.Add(FillLineItems());
}
catch (Exception ex)
{
lstResponse.Add(SetResponse(ex.Message + " - IE - " + ex.InnerException.Message + " - GE", ResponseStatusType.ERROR));
}
objES.lstEntityResponseStatus = lstResponse;
return(objES);
}
private void Button3_Click(object sender, EventArgs e)
{
string strInterface = lstInterface.SelectedItem.ToString().Trim();
EntityShipment objES = new EntityShipment();
//This to debug the code through xml
XmlSerializer serializer = new XmlSerializer(typeof(EntityShipment));
//objEIShipment = (EntityShipment)serializer.Deserialize(new XmlTextReader(txtXML.Text));
using (TextReader reader = new StringReader(txtXML.Text))
{
objES = (EntityShipment)serializer.Deserialize(reader);
}
switch (strInterface.ToUpper())
{
case "CMS":
CMSInterface objCMS = new CMSInterface();
objCMS.Void(objES);
break;
case "LEXIS":
LexisInterface objLexis = new LexisInterface();
objLexis.Void(objES);
break;
case "LEXISGLOBAL":
LexisGlobalInterface objLexisGlobal = new LexisGlobalInterface();
objLexisGlobal.Void(objES);
break;
case "SAP":
SAPInterface objSAP = new SAPInterface();
objSAP.Void(objES);
break;
default:
MessageBox.Show("Interface was not selected");
break;
}
}
private bool UpdateData(EntityShipment objES)
{
DataTable dtHeader;
bool UpdateStatus;
int x = 0;
int intTotalContainers = objES.lstContainer.Count();
string strInstructions = objES.objDetails.strShippingInstructions;
if (!string.IsNullOrWhiteSpace(objES.objDetails.strShippingInstructions) && objES.objDetails.strShippingInstructions.Length >= 255)
{
strInstructions = objES.objDetails.strShippingInstructions.Substring(0, 255);
}
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
do
{
string str = "INSERT INTO dbo.Shipments (Reference1, Reference2, Reference3, Reference4, Reference5, VoidIndicator, CompanyName, AttentionTo, Address1, Address2, Address3, City, ShipState, ZipCode, Country, ShippedBy, TrackingNumber, ShipWeight, TotalContainers, ThisContainer, CarrierCharge, ListCharge, SourceSystem, SQLStatus, ShipDate, LastModified, BOL, CarrierNumber, PlantNumber, PhoneNumber, ServiceType, CarrierName, ServiceName, SenderAccount, AdditionalCharge, ProcessDate, TerminalID, ProcessStatus, ThirdPartyAccount, CustomerReference, SenderEmailAddress1, SenderEmailNotify1, SenderEmailAddress2, SenderEmailNotify2, SenderEmailAddress3, SenderEmailNotify3, SenderEmailAddress4, SenderEmailNotify4, ResidentialStatus, EmailText, SignatureOption, SaturdayDelivery, PaymentType, BillToCompany, BillToAttention, BillToAddress1, BillToAddress2, BillToCity, BillToState, BillToZip, ReturnAddressCompany, ReturnAddressAttention, ReturnAddressLine1, ReturnAddressLine2, ReturnAddressCity, ReturnAddressState, ReturnAddressZip, ReturnAddressPhone, ReturnAddressEmail, Instructions) VALUES ('" +
objES.objDetails.strDeliveryDocNumber + "', '" + // Reference1
objES.objDetails.strPONumber + "', '" + // Reference2
objES.objDetails.strInvoiceNumber + "', '" + // Reference3
" " + "', '" + // Reference4
" " + "', '" + // Reference5
"Y" + "', '" + // VoidIndicator
objES.objShipTo.strCompanyName + "', '" + // CompanyName
objES.objShipTo.strContactName + "', '" + // AttentionTo
objES.objShipTo.strAddressLine1 + "', '" + // Address1
objES.objShipTo.strAddressLine2 + "', '" + // Address2
objES.objShipTo.strAddressLine3 + "', '" + // Address3
objES.objShipTo.strCity + "', '" + // City
objES.objShipTo.strState + "', '" + // ShipState
objES.objShipTo.strPostalCode + "', '" + // ZipCode
objES.objShipTo.strCountryCode + "', '" + // CountryCode
objES.strRequesterID + "', '" + // ShippedBy
objES.lstContainer[x].strTrackingNumber + "', " + // TrackingNumber
objES.lstContainer[x].dblTotalWeight + ", " + // Weight
intTotalContainers + ", " + // TotalContainers
(x + 1) + ", " + // ThisContainer
objES.lstContainer[x].objRates.dblTotalDiscountedPrice + ", " + // CarrierCharge
objES.lstContainer[x].objRates.dblTotalPublishedPrice + ", " + // ListCharge
"'ProcGlobal'," + // SourceSystem
"2, '" + // SQLStatus
objES.dtShipDate.ToString("MM/dd/yyyy") + "', '" + // ShipDate
DateTime.Now + "', " + // LastModified
0 + ", " + // BOL
0 + ", " + // CarrierNumber
0 + ", '" + // PlantNumber
objES.objShipTo.strPhoneNumber + "', '" + // PhoneNumber
objES.objShipMethod.strShipViaCode + "', '" + // ServiceType
objES.objShipMethod.strCarrier + "', '" + // CarrierName
objES.objShipMethod.strServiceLevel + "', '" + // ServiceName
objES.objShipMethod.strAccountNumber + "', '" + // SenderAccount
" " + "', '" + // AdditionalCharge
" " + "', '" + // ProcessDate
" " + "', '" + // TerminalID
" " + "', '" + // ProcessStatus
" " + "', '" + // ThirdPartyAccount
" " + "', '" + // CustomerReference
" " + "', '" + // SenderEmailAddress1
" " + "', '" + // SenderEmailNotify1
" " + "', '" + // SenderEmailAddress2
" " + "', '" + // SenderEmailNotify2
" " + "', '" + // SenderEmailAddress3
" " + "', '" + // SenderEmailNotify3
" " + "', '" + // SenderEmailAddress4
" " + "', '" + // SenderEmailNotify4
" " + "', '" + // ResidentialStatus
" " + "', '" + // EmailText
" " + "', '" + // SignatureOption
" " + "', '" + // SaturdayDelivery
PayTypeToCMS(objES.objShipMethod.strPaymentTerms) + "', '" + // PaymentType
" " + "', '" + // BillToCompany
" " + "', '" + // BillToAttention
" " + "', '" + // BillToAddress1
" " + "', '" + // BillToAddress2
" " + "', '" + // BillToCity
" " + "', '" + // BillToState
" " + "', '" + // BillToZip
objES.objShipFrom.strCompanyName + "', '" + // ReturnAddressCompany
objES.objShipFrom.strContactName + "', '" + // ReturnAddressAttention
objES.objShipFrom.strAddressLine1 + "', '" + // ReturnAddress1
objES.objShipFrom.strAddressLine2 + "', '" + // ReturnAddress2
objES.objShipFrom.strCity + "', '" + // ReturnAddressCity
objES.objShipFrom.strState + "', '" + // ReturnAddressState
objES.objShipFrom.strPostalCode + "', '" + // ReturnAddressZip
objES.objShipFrom.strPhoneNumber + "', '" + // ReturnAddressPhone
objES.objShipFrom.strEmailAddress + "', '" + // ReturnAddressEmail
strInstructions + "'" + // Instructions
")";
UpdateStatus = ExecuteQuery(str);
x++;
} while (x < intTotalContainers);
return(UpdateStatus);
}
private bool UpdateData(EntityShipment objES)
{
string str = "update solink set trknum = 'VOID' where shipid = '" + objES.objDetails.strDeliveryDocNumber.Trim() + "'";
return(ExecuteQuery(str));
}
private bool UpdateData(EntityShipment objES)
{
DataTable dtHeader;
bool UpdateStatus;
int x = 0;
int intTotalContainers = objES.lstContainer.Count();
int intBOL = 0;
int intCarrier = 0;
int intPlant = 0;
string strWorkStation = objES.strRequesterID.Substring(0, 10);
string strSQLSource = objES.objDetails.objMiscellaneous.strMisc1.Trim() + "_PS";
Int32.TryParse(objES.objDetails.objMiscellaneous.strMisc2, out intBOL);
Int32.TryParse(objES.objDetails.objMiscellaneous.strMisc3, out intCarrier);
Int32.TryParse(objES.objDetails.objMiscellaneous.strMisc4, out intPlant);
string strInstructions = objES.objDetails.strShippingInstructions;
if (!string.IsNullOrWhiteSpace(objES.objDetails.strShippingInstructions) && objES.objDetails.strShippingInstructions.Length >= 255)
{
strInstructions = objES.objDetails.strShippingInstructions.Substring(0, 255);
}
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
do
{
iDB2Command sqlCMD = objSQLCon.CreateCommand();
{
sqlCMD.Connection = objSQLCon;
sqlCMD.CommandType = CommandType.Text;
sqlCMD.CommandText = "INSERT INTO SHLIB.FRF01050 (FIREF1, FIREF2, FIREF3, FIREF4, FIREF5, FIVOID, FICOMP, FIATTN, FIADD1, FIADD2, FIADD3, FICITY, FISTAT, FIZIPC, FICNTY, FITRK, FIWGHT, FICTOT, FICTHS, FICOST, FILIST, FISRCE, FISQLSTS, FISHPD, FISQLSTAMP, FIBOL, FICARR, FIPLNT, FIPHON, FISRVT, FISHPV, FISACT, FIADCH, FIPRDT, FIWSID, FIPSTS, FIACCT, FICREF, FIEML1, FIEMN1, FIEML2, FIEMN2, FIEML3, FIEMN3, FIRSTS, FITEXT, FISIGN, FISDLV, FIRACM, FIRAAT, FIRAA1, FIRAA2, FIRACT, FIRAST, FIRAZP, FIINST, FIBTCM, FIBTAT, FIBTA1, FIBTA2, FIBTCT, FIBTST, FIBTZP) VALUES (@FIREF1, @FIREF2, @FIREF3, @FIREF4, @FIREF5, @FIVOID, @FICOMP, @FIATTN, @FIADD1, @FIADD2, @FIADD3, @FICITY, @FISTAT, @FIZIPC, @FICNTY, @FITRK, @FIWGHT, @FICTOT, @FICTHS, @FICOST, @FILIST, @FISRCE, @FISQLSTS, @FISHPD, @FISQLSTAMP, @FIBOL, @FICARR, @FIPLNT, @FIPHON, @FISRVT, @FISHPV, @FISACT, @FIADCH, @FIPRDT, @FIWSID, @FIPSTS, @FIACCT, @FICREF, @FIEML1, @FIEMN1, @FIEML2, @FIEMN2, @FIEML3, @FIEMN3, @FIRSTS, @FITEXT, @FISIGN, @FISDLV, @FIRACM, @FIRAAT, @FIRAA1, @FIRAA2, @FIRACT, @FIRAST, @FIRAZP, @FIINST, @FIBTCM, @FIBTAT, @FIBTA1, @FIBTA2, @FIBTCT, @FIBTST, @FIBTZP)";
sqlCMD.Parameters.AddWithValue("@FIREF1", TestIfNull(objES.objDetails.strDeliveryDocNumber));
sqlCMD.Parameters.AddWithValue("@FIREF2", TestIfNull(objES.objDetails.strPONumber));
sqlCMD.Parameters.AddWithValue("@FIREF3", TestIfNull(objES.objDetails.strInvoiceNumber));
sqlCMD.Parameters.AddWithValue("@FIREF4", " ");
sqlCMD.Parameters.AddWithValue("@FIREF5", " ");
sqlCMD.Parameters.AddWithValue("@FIVOID", "Y");
sqlCMD.Parameters.AddWithValue("@FICOMP", TestIfNull(objES.objShipTo.strCompanyName));
sqlCMD.Parameters.AddWithValue("@FIATTN", TestIfNull(objES.objShipTo.strContactName));
sqlCMD.Parameters.AddWithValue("@FIADD1", TestIfNull(objES.objShipTo.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@FIADD2", TestIfNull(objES.objShipTo.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@FIADD3", TestIfNull(objES.objShipTo.strAddressLine3));
sqlCMD.Parameters.AddWithValue("@FICITY", TestIfNull(objES.objShipTo.strCity));
sqlCMD.Parameters.AddWithValue("@FISTAT", TestIfNull(objES.objShipTo.strState));
sqlCMD.Parameters.AddWithValue("@FIZIPC", TestIfNull(objES.objShipTo.strPostalCode));
sqlCMD.Parameters.AddWithValue("@FICNTY", TestIfNull(objES.objShipTo.strCountryCode));
sqlCMD.Parameters.AddWithValue("@FITRK", TestIfNull(objES.lstContainer[x].strTrackingNumber));
sqlCMD.Parameters.AddWithValue("@FIWGHT", objES.lstContainer[x].dblTotalWeight);
sqlCMD.Parameters.AddWithValue("@FICTOT", intTotalContainers);
sqlCMD.Parameters.AddWithValue("@FICTHS", (x + 1));
sqlCMD.Parameters.AddWithValue("@FICOST", objES.lstContainer[x].objRates.dblTotalDiscountedPrice);
sqlCMD.Parameters.AddWithValue("@FILIST", objES.lstContainer[x].objRates.dblTotalPublishedPrice);
sqlCMD.Parameters.AddWithValue("@FISRCE", strSQLSource);
sqlCMD.Parameters.AddWithValue("@FISQLSTS", "R");
sqlCMD.Parameters.AddWithValue("@FISHPD", objES.dtShipDate.ToString("MM/dd/yyyy"));
sqlCMD.Parameters.AddWithValue("@FISQLSTAMP", DateTime.Now);
sqlCMD.Parameters.AddWithValue("@FIBOL", intBOL);
sqlCMD.Parameters.AddWithValue("@FICARR", intCarrier);
sqlCMD.Parameters.AddWithValue("@FIPLNT", intPlant);
sqlCMD.Parameters.AddWithValue("@FIPHON", TestIfNull(objES.objShipTo.strPhoneNumber));
sqlCMD.Parameters.AddWithValue("@FISRVT", TestIfNull(objES.objShipMethod.strShipViaCode));
sqlCMD.Parameters.AddWithValue("@FISHPV", TestIfNull(objES.objShipMethod.strServiceLevel));
sqlCMD.Parameters.AddWithValue("@FISACT", TestIfNull(objES.objShipMethod.strAccountNumber));
sqlCMD.Parameters.AddWithValue("@FIADCH", " ");
sqlCMD.Parameters.AddWithValue("@FIPRDT", " ");
sqlCMD.Parameters.AddWithValue("@FIWSID", TestIfNull(strWorkStation));
sqlCMD.Parameters.AddWithValue("@FIPSTS", " ");
sqlCMD.Parameters.AddWithValue("@FICREF", " ");
sqlCMD.Parameters.AddWithValue("@FIEML1", " ");
sqlCMD.Parameters.AddWithValue("@FIEMN1", " ");
sqlCMD.Parameters.AddWithValue("@FIEML2", " ");
sqlCMD.Parameters.AddWithValue("@FIEMN2", " ");
sqlCMD.Parameters.AddWithValue("@FIEML3", " ");
sqlCMD.Parameters.AddWithValue("@FIEMN3", " ");
sqlCMD.Parameters.AddWithValue("@FIRSTS", " ");
sqlCMD.Parameters.AddWithValue("@FITEXT", " ");
sqlCMD.Parameters.AddWithValue("@FISIGN", " ");
sqlCMD.Parameters.AddWithValue("@FISDLV", " ");
sqlCMD.Parameters.AddWithValue("@FIPMTT", PayTypeToCMS(objES.objShipMethod.strPaymentTerms));
if (objES.objBillTo != null)
{
sqlCMD.Parameters.AddWithValue("@FIACCT", TestIfNull(objES.objBillTo.strAccountNumber));
sqlCMD.Parameters.AddWithValue("@FIBTCM", TestIfNull(objES.objBillTo.strCompanyName));
sqlCMD.Parameters.AddWithValue("@FIBTAT", TestIfNull(objES.objBillTo.strContactName));
sqlCMD.Parameters.AddWithValue("@FIBTA1", TestIfNull(objES.objBillTo.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@FIBTA2", TestIfNull(objES.objBillTo.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@FIBTCT", TestIfNull(objES.objBillTo.strCity));
sqlCMD.Parameters.AddWithValue("@FIBTST", TestIfNull(objES.objBillTo.strState));
sqlCMD.Parameters.AddWithValue("@FIBTZP", TestIfNull(objES.objBillTo.strPostalCode));
}
else
{
sqlCMD.Parameters.AddWithValue("@FIACCT", " ");
sqlCMD.Parameters.AddWithValue("@FIBTCM", " ");
sqlCMD.Parameters.AddWithValue("@FIBTAT", " ");
sqlCMD.Parameters.AddWithValue("@FIBTA1", " ");
sqlCMD.Parameters.AddWithValue("@FIBTA2", " ");
sqlCMD.Parameters.AddWithValue("@FIBTCT", " ");
sqlCMD.Parameters.AddWithValue("@FIBTST", " ");
sqlCMD.Parameters.AddWithValue("@FIBTZP", " ");
}
sqlCMD.Parameters.AddWithValue("@FIRACM", TestIfNull(objES.objShipFrom.strCompanyName));
sqlCMD.Parameters.AddWithValue("@FIRAAT", TestIfNull(objES.objShipFrom.strContactName));
sqlCMD.Parameters.AddWithValue("@FIRAA1", TestIfNull(objES.objShipFrom.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@FIRAA2", TestIfNull(objES.objShipFrom.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@FIRACT", TestIfNull(objES.objShipFrom.strCity));
sqlCMD.Parameters.AddWithValue("@FIRAST", TestIfNull(objES.objShipFrom.strState));
sqlCMD.Parameters.AddWithValue("@FIRAZP", TestIfNull(objES.objShipFrom.strPostalCode));
sqlCMD.Parameters.AddWithValue("@FIINST", TestIfNull(strInstructions));
string strQuery = sqlCMD.CommandText;
foreach (iDB2Parameter p in sqlCMD.Parameters)
{
strQuery = strQuery.Replace(p.ParameterName, p.Value.ToString());
}
try
{
lstResponse.Add(SetResponse(strQuery, string.Empty, ResponseStatusType.LOG));
if (objSQLCon.State == ConnectionState.Closed)
{
objSQLCon.Open();
}
int recordsAffected = sqlCMD.ExecuteNonQuery();
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
UpdateStatus = true;
}
catch (iDB2Exception ex)
{
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
lstResponse.Add(SetResponse(strQuery, ex.Message, ResponseStatusType.CRITICAL));
UpdateStatus = false;
}
catch (Exception ex)
{
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
lstResponse.Add(SetResponse(strQuery, ex.Message, ResponseStatusType.CRITICAL));
UpdateStatus = false;
}
}
x++;
} while (x < intTotalContainers);
return(UpdateStatus);
}
private void Button1_Click(object sender, EventArgs e)
{
string strInterface = lstInterface.SelectedItem.ToString().Trim();
EntityShipment objES = new EntityShipment
{
objDetails = new EntityShipmentDetails
{
strDeliveryDocNumber = txtOrder.Text
}
};
EntityConnection objConnection = new EntityConnection();
if (radioButtonDev.Checked == true)
{
switch (strInterface.ToUpper())
{
case "CMS":
objConnection.strDSNName = "Systema";
objConnection.strServer = "SystemA.cadmus.com";
objConnection.strDatabase = "SHLIB";
objConnection.strUserID = "CENPROUSER";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXIS":
objConnection.strDSNName = @"dvsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXISGLOBAL":
objConnection.strDSNName = @"dvsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "SAP":
objConnection.strDSNName = @"dvsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
default:
MessageBox.Show("Interface was not selected");
break;
}
}
if (radioButtonQA.Checked == true)
{
switch (strInterface.ToUpper())
{
case "CMS":
objConnection.strDSNName = "Sysatr";
objConnection.strServer = "Sysatr.cadmus.com";
objConnection.strDatabase = "SHLIB";
objConnection.strUserID = "ODBCUSER";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXIS":
objConnection.strDSNName = @"qasqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXISGLOBAL":
objConnection.strDSNName = @"qasqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "SAP":
objConnection.strDSNName = @"qasqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
default:
MessageBox.Show("Interface was not selected");
break;
}
}
if (radioButtonPD.Checked == true)
{
switch (strInterface.ToUpper())
{
case "CMS":
objConnection.strDSNName = "Systemb";
objConnection.strServer = "SystemB.cadmus.com";
objConnection.strDatabase = "SHLIB";
objConnection.strUserID = "ODBCUSER";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXIS":
objConnection.strDSNName = @"pdsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "LEXISGLOBAL":
objConnection.strDSNName = @"pdsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
case "SAP":
objConnection.strDSNName = @"pdsqlmonarch.cenveo.cvo.net";
objConnection.strDatabase = "PSIntegration";
objConnection.strUserID = "service.ps";
objConnection.strPassword = "******";
objES.ToolKit = new EntityToolKit();
break;
default:
MessageBox.Show("Interface was not selected");
break;
}
}
objES.ToolKit.objConnection = objConnection;
switch (strInterface.ToUpper())
{
case "CMS":
break;
case "LEXIS":
LexisInterface objSample = new LexisInterface();
objSample.Pull(objES);
break;
case "LEXISGLOBAL":
LexisGlobalInterface objSampleLG = new LexisGlobalInterface();
objSampleLG.Pull(objES);
break;
case "SAP":
SAPInterface objSampleSAP = new SAPInterface();
objSampleSAP.Pull(objES);
break;
default:
MessageBox.Show("Interface was not selected");
break;
}
}
private bool InsertVoid(EntityShipment objES)
{
DataTable dtHeader;
bool VoidStatus;
int x = 0;
int intBOL = 0;
int intPlant = 0;
int intCarrier = 0;
int intTotalContainers = objES.lstContainer.Count();
// string strSQLSource = objES.objDetails.objMiscellaneous.strMisc1;
// Int32.TryParse(objES.objDetails.lstReference[1].strReferenceValue, out intBOL);
// Int32.TryParse(objES.objDetails.lstReference[2].strReferenceValue, out intCarrier);
// Int32.TryParse(objES.objDetails.lstReference[3].strReferenceValue, out intPlant);
string strSQLSource = "PSSAP";
string strSQLSystem = "";
switch (strSQLSource.ToUpper())
{
case "SAPUSPS":
strSQLSystem = "PSSAPUSPS";
break;
case "SAPUPS":
strSQLSystem = "PSSAPUPS";
break;
case "SAPFEDEX":
strSQLSystem = "PSSAPFedEx";
break;
default:
strSQLSystem = "PSSAP";
break;
}
dtHeader = GetShipmentInformation(objES.objDetails.strDeliveryDocNumber);
do
{
SqlCommand sqlCMD = objSQLCon.CreateCommand();
{
sqlCMD.Connection = objSQLCon;
sqlCMD.CommandType = CommandType.Text;
// sqlCMD.CommandText = "INSERT INTO dbo.Shipments (Reference1, Reference2, Reference3, Reference4, Reference5, VoidIndicator, CompanyName, AttentionTo, Address1, Address2, Address3, City, ShipState, ZipCode, Country, ShippedBy, TrackingNumber, ShipWeight, TotalContainers, ThisContainer, CarrierCharge, ListCharge, SourceSystem, SQLStatus, ShipDate, LastModified, BOL, CarrierNumber, PlantNumber, PhoneNumber, ServiceType, SenderAccount, AdditionalCharge, ProcessDate, TerminalID, ProcessStatus, ThirdPartyAccount, CustomerReference, SenderEmailAddress1, SenderEmailNotify1, SenderEmailAddress2, SenderEmailNotify2, SenderEmailAddress3, SenderEmailNotify3, SenderEmailAddress4, SenderEmailNotify4, ResidentialStatus, EmailText, SignatureOption, SaturdayDelivery, PaymentType, BillToCompany, BillToAttention, BillToAddress1, BillToAddress2, BillToCity, BillToState, BillToZip, ReturnAddressCompany, ReturnAddressAttention, ReturnAddressLine1, ReturnAddressLine2, ReturnAddressCity, ReturnAddressState, ReturnAddressZip, Instructions) VALUES (@Reference1, @Reference2, @Reference3, @Reference4, @Reference5, @VoidIndicator, @CompanyName, @AttentionTo, @Address1, @Address2, @Address3, @City, @ShipState, @ZipCode, @Country, @ShippedBy, @TrackingNumber, @ShipWeight, @TotalContainers, @ThisContainer, @CarrierCharge, @ListCharge, @SourceSystem, @SQLStatus, @ShipDate, @LastModified, @BOL, @CarrierNumber, @PlantNumber, @PhoneNumber, @ServiceType, @SenderAccount, @AdditionalCharge, @ProcessDate, @TerminalID, @ProcessStatus, @ThirdPartyAccount, @CustomerReference, @SenderEmailAddress1, @SenderEmailNotify1, @SenderEmailAddress2, @SenderEmailNotify2, @SenderEmailAddress3, @SenderEmailNotify3, @SenderEmailAddress4, @SenderEmailNotify4, @ResidentialStatus, @EmailText, @SignatureOption, @SaturdayDelivery, @PaymentType, @BillToCompany, @BillToAttention, @BillToAddress1, @BillToAddress2, @BillToCity, @BillToState, @BillToZip, @ReturnAddressCompany, @ReturnAddressAttention, @ReturnAddressLine1, @ReturnAddressLine2, @ReturnAddressCity, @ReturnAddressState, @ReturnAddressZip, @Instructions)";
sqlCMD.CommandText = "INSERT INTO dbo.Shipments (Reference1, Reference2, Reference3, Reference4, Reference5, VoidIndicator, CompanyName, AttentionTo, Address1, Address2, Address3, City, ShipState, ZipCode, Country, ShippedBy, TrackingNumber, ShipWeight, TotalContainers, ThisContainer, CarrierCharge, ListCharge, SourceSystem, SQLStatus, ShipDate, LastModified, BOL, CarrierNumber, PlantNumber, PhoneNumber, ServiceType, ServiceName, SenderAccount, AdditionalCharge, ProcessDate, TerminalID, ProcessStatus, ThirdPartyAccount, CustomerReference, SenderEmailAddress1, SenderEmailNotify1, SenderEmailAddress2, SenderEmailNotify2, SenderEmailAddress3, SenderEmailNotify3, SenderEmailAddress4, SenderEmailNotify4, ResidentialStatus, EmailText, SignatureOption, SaturdayDelivery, ReturnAddressCompany, ReturnAddressAttention, ReturnAddressLine1, ReturnAddressLine2, ReturnAddressCity, ReturnAddressState, ReturnAddressZip, Instructions) VALUES (@Reference1, @Reference2, @Reference3, @Reference4, @Reference5, @VoidIndicator, @CompanyName, @AttentionTo, @Address1, @Address2, @Address3, @City, @ShipState, @ZipCode, @Country, @ShippedBy, @TrackingNumber, @ShipWeight, @TotalContainers, @ThisContainer, @CarrierCharge, @ListCharge, @SourceSystem, @SQLStatus, @ShipDate, @LastModified, @BOL, @CarrierNumber, @PlantNumber, @PhoneNumber, @ServiceType, @ServiceName, @SenderAccount, @AdditionalCharge, @ProcessDate, @TerminalID, @ProcessStatus, @ThirdPartyAccount, @CustomerReference, @SenderEmailAddress1, @SenderEmailNotify1, @SenderEmailAddress2, @SenderEmailNotify2, @SenderEmailAddress3, @SenderEmailNotify3, @SenderEmailAddress4, @SenderEmailNotify4, @ResidentialStatus, @EmailText, @SignatureOption, @SaturdayDelivery, @ReturnAddressCompany, @ReturnAddressAttention, @ReturnAddressLine1, @ReturnAddressLine2, @ReturnAddressCity, @ReturnAddressState, @ReturnAddressZip, @Instructions)";
sqlCMD.Parameters.AddWithValue("@Reference1", TestIfNull(objES.objDetails.strDeliveryDocNumber));
sqlCMD.Parameters.AddWithValue("@Reference2", TestIfNull(objES.objDetails.strPONumber));
sqlCMD.Parameters.AddWithValue("@Reference3", " ");
sqlCMD.Parameters.AddWithValue("@Reference4", " ");
sqlCMD.Parameters.AddWithValue("@Reference5", " ");
sqlCMD.Parameters.AddWithValue("@VoidIndicator", "Y");
sqlCMD.Parameters.AddWithValue("@CompanyName", TestIfNull(objES.objShipTo.strCompanyName));
sqlCMD.Parameters.AddWithValue("@AttentionTo", TestIfNull(objES.objShipTo.strContactName));
sqlCMD.Parameters.AddWithValue("@Address1", TestIfNull(objES.objShipTo.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@Address2", TestIfNull(objES.objShipTo.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@Address3", TestIfNull(objES.objShipTo.strAddressLine3));
sqlCMD.Parameters.AddWithValue("@City", TestIfNull(objES.objShipTo.strCity));
sqlCMD.Parameters.AddWithValue("@ShipState", TestIfNull(objES.objShipTo.strState));
sqlCMD.Parameters.AddWithValue("@ZipCode", TestIfNull(objES.objShipTo.strPostalCode));
sqlCMD.Parameters.AddWithValue("@Country", TestIfNull(objES.objShipTo.strCountryCode));
sqlCMD.Parameters.AddWithValue("@ShippedBy", TestIfNull(objES.strRequesterID));
sqlCMD.Parameters.AddWithValue("@TrackingNumber", TestIfNull(objES.lstContainer[x].strTrackingNumber));
sqlCMD.Parameters.AddWithValue("@ShipWeight", objES.lstContainer[x].dblTotalWeight);
sqlCMD.Parameters.AddWithValue("@TotalContainers", intTotalContainers);
sqlCMD.Parameters.AddWithValue("@ThisContainer", (x + 1));
sqlCMD.Parameters.AddWithValue("@CarrierCharge", objES.lstContainer[x].objRates.dblTotalDiscountedPrice);
sqlCMD.Parameters.AddWithValue("@ListCharge", objES.lstContainer[x].objRates.dblTotalPublishedPrice);
sqlCMD.Parameters.AddWithValue("@SourceSystem", strSQLSystem);
sqlCMD.Parameters.AddWithValue("@SQLStatus", 2);
sqlCMD.Parameters.AddWithValue("@ShipDate", objES.dtShipDate.ToString("MM/dd/yyyy"));
sqlCMD.Parameters.AddWithValue("@LastModified", DateTime.Now);
sqlCMD.Parameters.AddWithValue("@BOL", intBOL);
sqlCMD.Parameters.AddWithValue("@CarrierNumber", intCarrier);
sqlCMD.Parameters.AddWithValue("@PlantNumber", intPlant);
sqlCMD.Parameters.AddWithValue("@PhoneNumber", TestIfNull(objES.objShipTo.strPhoneNumber));
sqlCMD.Parameters.AddWithValue("@ServiceType", TestIfNull(objES.objShipMethod.strShipViaCode));
sqlCMD.Parameters.AddWithValue("@ServiceName", TestIfNull(objES.objShipMethod.strServiceLevel));
sqlCMD.Parameters.AddWithValue("@SenderAccount", TestIfNull(objES.objShipMethod.strAccountNumber));
sqlCMD.Parameters.AddWithValue("@AdditionalCharge", " ");
sqlCMD.Parameters.AddWithValue("@ProcessDate", " ");
sqlCMD.Parameters.AddWithValue("@TerminalID", " ");
sqlCMD.Parameters.AddWithValue("@ProcessStatus", " ");
sqlCMD.Parameters.AddWithValue("@CustomerReference", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailAddress1", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailNotify1", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailAddress2", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailNotify2", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailAddress3", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailNotify3", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailAddress4", " ");
sqlCMD.Parameters.AddWithValue("@SenderEmailNotify4", " ");
sqlCMD.Parameters.AddWithValue("@ResidentialStatus", " ");
sqlCMD.Parameters.AddWithValue("@EmailText", " ");
sqlCMD.Parameters.AddWithValue("@SignatureOption", " ");
sqlCMD.Parameters.AddWithValue("@SaturdayDelivery", " ");
// sqlCMD.Parameters.AddWithValue("@PaymentType", PayTypeToCMS(objES.objShipMethod.strPaymentTerms));
if (objES.objBillTo != null)
{
sqlCMD.Parameters.AddWithValue("@ThirdPartyAccount", TestIfNull(objES.objBillTo.strAccountNumber));
sqlCMD.Parameters.AddWithValue("@BillToCompany", TestIfNull(objES.objBillTo.strCompanyName));
sqlCMD.Parameters.AddWithValue("@BillToAttention", TestIfNull(objES.objBillTo.strContactName));
sqlCMD.Parameters.AddWithValue("@BillToAddress1", TestIfNull(objES.objBillTo.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@BillToAddress2", TestIfNull(objES.objBillTo.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@BillToCity", TestIfNull(objES.objBillTo.strCity));
sqlCMD.Parameters.AddWithValue("@BillToState", TestIfNull(objES.objBillTo.strState));
sqlCMD.Parameters.AddWithValue("@BillToZip", TestIfNull(objES.objBillTo.strPostalCode));
}
else
{
sqlCMD.Parameters.AddWithValue("@ThirdPartyAccount", " ");
sqlCMD.Parameters.AddWithValue("@BillToCompany", " ");
sqlCMD.Parameters.AddWithValue("@BillToAttention", " ");
sqlCMD.Parameters.AddWithValue("@BillToAddress1", " ");
sqlCMD.Parameters.AddWithValue("@BillToAddress2", " ");
sqlCMD.Parameters.AddWithValue("@BillToCity", " ");
sqlCMD.Parameters.AddWithValue("@BillToState", " ");
sqlCMD.Parameters.AddWithValue("@BillToZip", " ");
}
sqlCMD.Parameters.AddWithValue("@ReturnAddressCompany", TestIfNull(objES.objShipFrom.strCompanyName));
sqlCMD.Parameters.AddWithValue("@ReturnAddressAttention", TestIfNull(objES.objShipFrom.strContactName));
sqlCMD.Parameters.AddWithValue("@ReturnAddressLine1", TestIfNull(objES.objShipFrom.strAddressLine1));
sqlCMD.Parameters.AddWithValue("@ReturnAddressLine2", TestIfNull(objES.objShipFrom.strAddressLine2));
sqlCMD.Parameters.AddWithValue("@ReturnAddressCity", TestIfNull(objES.objShipFrom.strCity));
sqlCMD.Parameters.AddWithValue("@ReturnAddressState", TestIfNull(objES.objShipFrom.strState));
sqlCMD.Parameters.AddWithValue("@ReturnAddressZip", TestIfNull(objES.objShipFrom.strPostalCode));
sqlCMD.Parameters.AddWithValue("@Instructions", " ");
string strQuery = sqlCMD.CommandText;
foreach (SqlParameter p in sqlCMD.Parameters)
{
strQuery = strQuery.Replace(p.ParameterName, p.Value.ToString());
}
try
{
lstResponse.Add(SetResponse(strQuery, string.Empty, ResponseStatusType.LOG));
if (objSQLCon.State == ConnectionState.Closed)
{
objSQLCon.Open();
}
int recordsAffected = sqlCMD.ExecuteNonQuery();
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
VoidStatus = true;
}
catch (SqlException ex)
{
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
lstResponse.Add(SetResponse(strQuery, ex.Message, ResponseStatusType.CRITICAL));
VoidStatus = false;
}
catch (Exception ex)
{
if (objSQLCon.State == ConnectionState.Open)
{
objSQLCon.Close();
}
lstResponse.Add(SetResponse(strQuery, ex.Message, ResponseStatusType.CRITICAL));
VoidStatus = false;
}
}
x++;
} while (x < intTotalContainers);
return(VoidStatus);
}
public EntityShipment GetRates(EntityShipment request)
{
throw new NotImplementedException(); //Not Used at this time.
}
