//public static string GetSpecialCarrierName(ref DispatchData dispatch_data)
//{
// string specialState = Helper.GetSpecialState(ref dispatch_data);
// if (specialState.ToUpper().Equals("HI"))
// {
// return "H2O LOGISTICS";
// }
// if (specialState.ToUpper().Equals("AK"))
// {
// return "AMERICAN FAST FREIGHT";
// }
// return "";
//}
#endregion
#region GetInterimCompanyDetails
public static Company GetInterimCompanyDetails(ref DispatchData dispatch_data)
{
Company comp = new Company();
string specialState = GetSpecialState(ref dispatch_data);
if (specialState.ToUpper().Equals("HI"))
{
comp.CompName = "H2O LOGISTICS";
//comp.Addr1 = "16920 South Main Street";
//comp.Addr2 = "";
//comp.City = "Gardena";
//comp.State = "CA";
//comp.Zip = "90248";
comp.Phone = "310-324-8955";
comp.Addr1 = "23601 S WILMINGTON AVE";
comp.Addr2 = "";
comp.City = "CARSON";
comp.State = "CA";
comp.Zip = "90745";
// 23601 S WILMINGTON AVE CARSON CA 90745
}
if (specialState.ToUpper().Equals("AK"))
{
comp.CompName = "American Fast Freight";
comp.Addr1 = "7400 45th Street Ct East";
comp.Addr2 = "";
comp.City = "Tacoma";
comp.State = "WA";
comp.Zip = "98424";
comp.Phone = "800-642-6664";
}
return(comp);
}
//public static string GetSpecialState()
//{
// string originState = "";
// string destState = "";
// try
// {
// if (!String.IsNullOrEmpty(requestedValues["oCityState"]))
// {
// string[] arrPCityState = requestedValues["oCityState"].Split(',');
// originState = arrPCityState[1].Trim();
// }
// else if (Session["oState"] != null)
// {
// originState = Session["oState"].ToString();
// }
// else if (!String.IsNullOrEmpty(requestedValues["q_OCity"]))
// {
// string[] arrPCityState = requestedValues["q_OCity"].Split(',');
// originState = arrPCityState[1].Trim();
// }
// if (!String.IsNullOrEmpty(requestedValues["dCityState"]))
// {
// string[] arrPCityState = requestedValues["dCityState"].Split(',');
// originState = arrPCityState[1].Trim();
// }
// else if (Session["dState"] != null)
// {
// destState = Session["dState"].ToString();
// }
// else if (!String.IsNullOrEmpty(requestedValues["q_DCity"]))
// {
// string[] arrDCityState = requestedValues["q_DCity"].Split(',');
// destState = arrDCityState[1].Trim();
// }
// }
// catch (Exception myException)
// {
// HelperFuncs.writeToSiteErrors("dispatch getSpecialState", string.Concat("oCityState: ", requestedValues["oCityState"], " q_OCity: ",
// requestedValues["q_OCity"], " dCityState: ", requestedValues["dCityState"], " q_DCity: ", requestedValues["q_DCity"]));
// throw new Exception(myException.ToString());
// }
// if (originState.ToUpper().Equals("HI") || originState.ToUpper().Equals("AK"))
// {
// return originState;
// }
// if (destState.ToUpper().Equals("HI") || destState.ToUpper().Equals("AK"))
// {
// return destState;
// }
// return "";
//}
#endregion
#region GetSpecialState
public static string GetSpecialState(ref DispatchData dispatch_data)
{
string originState = "";
string destState = "";
try
{
if (!String.IsNullOrEmpty(dispatch_data.oCityState))
{
string[] arrPCityState = dispatch_data.oCityState.Split(',');
originState = arrPCityState[1].Trim();
}
else if (dispatch_data.oState != null)
{
originState = dispatch_data.oState;
}
else if (!String.IsNullOrEmpty(dispatch_data.q_OCity))
{
string[] arrPCityState = dispatch_data.q_OCity.Split(',');
originState = arrPCityState[1].Trim();
}
if (!String.IsNullOrEmpty(dispatch_data.dCityState))
{
string[] arrPCityState = dispatch_data.dCityState.Split(',');
originState = arrPCityState[1].Trim();
}
else if (dispatch_data.dState != null)
{
destState = dispatch_data.dState;
}
else if (!String.IsNullOrEmpty(dispatch_data.q_DCity))
{
string[] arrDCityState = dispatch_data.q_DCity.Split(',');
destState = arrDCityState[1].Trim();
}
}
catch (Exception myException)
{
HelperFuncs.writeToSiteErrors("dispatch getSpecialState",
string.Concat("oCityState: ", dispatch_data.oCityState, " q_OCity: ",
dispatch_data.q_OCity, " dCityState: ", dispatch_data.dCityState, " q_DCity: ",
dispatch_data.q_DCity));
throw new Exception(myException.ToString());
}
if (originState.ToUpper().Equals("HI") || originState.ToUpper().Equals("AK"))
{
return(originState);
}
if (destState.ToUpper().Equals("HI") || destState.ToUpper().Equals("AK"))
{
return(destState);
}
return("");
}
public static int GetInterimCarrierCompanyID(ref DispatchData dispatch_data)
{
object objTempID;
int intInterimCarrierCompID;
string strSQL = "";
Company interimCompany = Helper.GetInterimCompanyDetails(ref dispatch_data);
strSQL = "select top 1 CompID from tbl_Company where CompName=" + DB.GetSingleQuoteValue(interimCompany.CompName)
+ "and Carrier=1 "
+ "and Addr1=" + DB.GetSingleQuoteValue(interimCompany.Addr1)
+ "and Addr2=" + DB.GetSingleQuoteValue(interimCompany.Addr2)
+ "and City=" + DB.GetSingleQuoteValue(interimCompany.City)
+ "and State=" + DB.GetSingleQuoteValue(interimCompany.State)
+ "and Zip=" + DB.GetSingleQuoteValue(interimCompany.Zip)
+ "and Phone=" + DB.GetSingleQuoteValue(interimCompany.Phone)
+ "and Fax=" + DB.GetSingleQuoteValue("");
//comm.CommandText = strSQL;
objTempID = HelperFuncs.ExecuteScalar(AppCodeConstants.connStringAesData, ref strSQL,
"Dispatch GetInterimCarrierCompanyID");
//
//
if (objTempID != null)
{
intInterimCarrierCompID = Convert.ToInt32(objTempID);
}
else
{
strSQL = "insert into tbl_Company(CompName,Carrier,Addr1,Addr2,City,State,Zip,Phone,Fax)"
+ " values("
+ DB.GetSingleQuoteValue(interimCompany.CompName) + ",1"
+ DB.GetCommaSingleQuoteValue(interimCompany.Addr1) + DB.GetCommaSingleQuoteValue(interimCompany.Addr2)
+ DB.GetCommaSingleQuoteValue(interimCompany.City) + DB.GetCommaSingleQuoteValue(interimCompany.State)
+ DB.GetCommaSingleQuoteValue(interimCompany.Zip) + DB.GetCommaSingleQuoteValue(interimCompany.Phone)
+ DB.GetCommaSingleQuoteValue("")
+ ")";
//comm.CommandText = strSQL;
//comm.ExecuteNonQuery();
//intInterimCarrierCompID = HelperFuncs.GetLastAutogeneratedID(comm);
intInterimCarrierCompID = HelperFuncs.ExecuteNonQuery_GetLastAutogeneratedID(
AppCodeConstants.connStringAesData, ref strSQL, "Dispatch GetInterimCarrierCompanyID");
}
return(intInterimCarrierCompID);
}
public static void SetItemDescriptions(ref DispatchData dispatch_data, ref string Desc1, ref string Desc2, ref string Desc3, ref string Desc4)
{
#region Set Item descriptions
// If session is null here fall back on txtDesc.Text
if (dispatch_data.DimsCubeDesc1 != null && dispatch_data.DimsCubeDesc1.ToString().Trim().Length > 0)
{
// Make sure dims are in format: customer description // dims
Desc1 = Desc1.Replace(dispatch_data.DimsCubeDesc1.ToString().Trim(), " ") +
dispatch_data.DimsCubeDesc1.ToString();
}
//else
//{
// HelperFuncs.writeToSiteErrors("Dispatch", "Session Desc1 was null");
//}
if (dispatch_data.DimsCubeDesc2 != null && dispatch_data.DimsCubeDesc2.ToString().Trim().Length > 0)
{
Desc2 = Desc2.Replace(dispatch_data.DimsCubeDesc2.ToString().Trim(), " ") +
dispatch_data.DimsCubeDesc2.ToString();
}
//else
//{
// HelperFuncs.writeToSiteErrors("Dispatch", "Session Desc2 was null");
//}
if (dispatch_data.DimsCubeDesc3 != null && dispatch_data.DimsCubeDesc3.ToString().Trim().Length > 0)
{
Desc3 = Desc3.Replace(dispatch_data.DimsCubeDesc3.ToString().Trim(), " ") +
dispatch_data.DimsCubeDesc3.ToString();
}
//else
//{
// HelperFuncs.writeToSiteErrors("Dispatch", "Session Desc3 was null");
//}
if (dispatch_data.DimsCubeDesc4 != null && dispatch_data.DimsCubeDesc4.ToString().Trim().Length > 0)
{
Desc4 = Desc4.Replace(dispatch_data.DimsCubeDesc4.ToString().Trim(), " ") +
dispatch_data.DimsCubeDesc4.ToString();
}
//else
//{
// HelperFuncs.writeToSiteErrors("Dispatch", "Session Desc4 was null");
//}
#endregion
}
private static void Get_Accessorial_ID_and_insert(ref DispatchData dispatch_data, ref ArrayList services,
string service_name, string LkUpValue)
{
services.Add(service_name);
string strSQL = string.Concat("select LkUpID from tbl_LKUP where LkUpValue='", LkUpValue, "'");
using (SqlConnection conn = new SqlConnection(AppCodeConstants.connStringLTLRater))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
command.CommandText = strSQL;
object objID;
objID = command.ExecuteScalar();
if (objID != null)
{
Repository.InsertAdditionalService(dispatch_data.intSegmentID, Convert.ToInt32(objID));
}
}
}
}
public static void InsertInsuranceCost(ref DispatchData dispatch_data, double shipmentValue, int intRQID)
{
string strSQL;
int intServiceID = 291;
double insuranceCost = shipmentValue * AppCodeConstants.InsuranceSellRate;
if (insuranceCost < dispatch_data.minInsuranceCost)
{
insuranceCost = dispatch_data.minInsuranceCost;
}
SetInsuranceMinimum(ref dispatch_data, ref insuranceCost, ref shipmentValue);
strSQL = "insert into tbl_ACCDetail(SEGMENTID,LKUPID_ACC,ACCType,ChargeAmt,RQID)"
+ " values("
+ dispatch_data.intSegmentID + "," + intServiceID + DB.GetCommaSingleQuoteValue("SEG") + "," +
insuranceCost + "," + intRQID
+ ")";
HelperFuncs.ExecuteNonQuery(AppCodeConstants.connStringAesData, ref strSQL,
"dispatch InsertInsuranceCost");
}
public Logger(ref DispatchData dispatch_data, ref StringBuilder sb)
{
this.dispatch_data = dispatch_data;
this.sb = sb;
}
public RequestParser(ref FormDataCollection form, ref DispatchData dispatch_data)
{
this.form = form;
this.dispatch_data = dispatch_data;
}
public static void SetInsuranceMinimum(ref DispatchData dispatch_data, ref double insuranceCost, ref double dblShipmentValue)
{
if (dispatch_data.commodityName != null)
{
HelperFuncs.writeToSiteErrors("requestedValues commodityName",
dispatch_data.commodityName);
if (dispatch_data.commodityName.Contains("Antiques, Artwork, Sculpture"))
{
HelperFuncs.writeToSiteErrors("requestedValues commodityName Contains Antiques",
dispatch_data.commodityName);
insuranceCost = dblShipmentValue * .0125;
if (insuranceCost < 65.00)
{
insuranceCost = 65.00;
}
}
}
if (dispatch_data.Commodity1 != null)
{
HelperFuncs.writeToSiteErrors("Session Commodity1", dispatch_data.Commodity1.ToString());
if ((dispatch_data.Commodity1 != null && dispatch_data.Commodity1 != "" && dispatch_data.Commodity1.ToString().Contains("Antiques, Artwork, Sculpture")) ||
(dispatch_data.Commodity2 != null && dispatch_data.Commodity2 != "" && dispatch_data.Commodity2.ToString().Contains("Antiques, Artwork, Sculpture")) ||
(dispatch_data.Commodity3 != null && dispatch_data.Commodity3 != "" && dispatch_data.Commodity3.ToString().Contains("Antiques, Artwork, Sculpture")) ||
(dispatch_data.Commodity4 != null && dispatch_data.Commodity4 != "" && dispatch_data.Commodity4.ToString().Contains("Antiques, Artwork, Sculpture")))
{
HelperFuncs.writeToSiteErrors("Session[Commodity1].ToString()", dispatch_data.Commodity1.ToString());
insuranceCost = dblShipmentValue * .0125;
if (insuranceCost < 65.00)
{
insuranceCost = 65.00;
}
}
}
#region For HHG, set insurance cost
// If household goods
if ((dispatch_data.Commodity1 != null && dispatch_data.Commodity1 != "" && dispatch_data.Commodity1.ToString() == "Household Goods") ||
(dispatch_data.Commodity2 != null && dispatch_data.Commodity2 != "" && dispatch_data.Commodity2.ToString() == "Household Goods") ||
(dispatch_data.Commodity3 != null && dispatch_data.Commodity3 != "" && dispatch_data.Commodity3.ToString() == "Household Goods") ||
(dispatch_data.Commodity4 != null && dispatch_data.Commodity4 != "" && dispatch_data.Commodity4.ToString() == "Household Goods"))
{
insuranceCost = dblShipmentValue * .0125;
if (insuranceCost < 65.00)
{
insuranceCost = 65.00;
}
}
#endregion
//bool.TryParse(dispatch_data.isUSED, out isUSED);
//HelperFuncs.writeToSiteErrors("dispatch IsUSED", isUSED.ToString());
//
bool isRESDEL = false;
if (dispatch_data.q_ResDel != null)
{
bool.TryParse(dispatch_data.q_ResDel, out isRESDEL);
}
HelperFuncs.writeToSiteErrors("dispatch isRESDEL", isRESDEL.ToString());
if (dispatch_data.isUSED.Equals(true) && isRESDEL.Equals(true))
{
if (insuranceCost < 65.00)
{
insuranceCost = 65.00;
}
}
HelperFuncs.writeToSiteErrors("dispatch insuranceCost", insuranceCost.ToString());
}
public static void InsertAccessorialsIntoAccDetailsTable(ref DispatchData dispatch_data, ref ArrayList services, ref string strSQL)
{
bool blnResult;
#region Not used
//string rateType = dispatch_data.rateType.ToString(), AMPM = "";
//if (rateType == "GUARANTEEDAM")
//{
// AMPM = "Noon";
//}
// else if (rateType == "GUARANTEEDPM")
#endregion
#region Logging
if (dispatch_data.carrier != null)
{
HelperFuncs.writeToSiteErrors("carrier", dispatch_data.carrier);
}
else
{
HelperFuncs.writeToSiteErrors("carrier", "was null");
}
#endregion
#region Insert all accessorials
if (dispatch_data.rateType.Equals("GUARANTEEDPM")) //dispatch_data.carrier.Contains("R+L GDD QT:") ||
{
HelperFuncs.writeToSiteErrors("adding guaranteed", "adding guaranteed");
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "GSD", "GUARANTEED SERVICE");
}
if (dispatch_data.q_ResPick != null && bool.TryParse(dispatch_data.q_ResPick, out blnResult))
{
//Get the lookup ID for Residential Pickup.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "RSP", "RESIDENTIAL PICKUP");
}
}
if (dispatch_data.q_ResDel != null && bool.TryParse(dispatch_data.q_ResDel, out blnResult))
{
//Get the lookup ID for Residential Delivery.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "RSD", "RESIDENTIAL DELIVERY");
}
}
if (dispatch_data.q_ConstPick != null && bool.TryParse(dispatch_data.q_ConstPick, out blnResult))
{
//Get the lookup ID for NON COMMERCIAL Pickup.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "CSP", "NON COMMERCIAL PICKUP");
}
}
if (dispatch_data.q_ConstDel != null && bool.TryParse(dispatch_data.q_ConstDel, out blnResult))
{
//Get the lookup ID for NON COMMERCIAL Delivery.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "CSD", "NON COMMERCIAL DELIVERY");
}
}
if (dispatch_data.q_TradePick != null && bool.TryParse(dispatch_data.q_TradePick, out blnResult))
{
//Get the lookup ID for Tradeshow Pickup.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "TSP", "TRADESHOW PICKUP");
}
}
if (dispatch_data.q_TradeDel != null && bool.TryParse(dispatch_data.q_TradeDel, out blnResult))
{
//Get the lookup ID for Residential Delivery.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "TSD", "TRADESHOW DELIVERY");
}
}
if (dispatch_data.q_TailPick != null && bool.TryParse(dispatch_data.q_TailPick, out blnResult))
{
//Get the lookup ID for LIFTGATE PICKUP.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "TGP", "LIFTGATE PICKUP");
}
}
if (dispatch_data.q_TailDel != null && bool.TryParse(dispatch_data.q_TailDel, out blnResult))
{
//Get the lookup ID for LIFTGATE DELIVERY.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "TGD", "LIFTGATE DELIVERY");
}
}
if (dispatch_data.q_AppPick != null && bool.TryParse(dispatch_data.q_AppPick, out blnResult))
{
//Get the lookup ID for NOTIFICATION PICKUP.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "AMP", "DELIVERY APPT.");
}
}
if (dispatch_data.q_AppDel != null && bool.TryParse(dispatch_data.q_AppDel, out blnResult))
{
//Get the lookup ID for NOTIFICATION DELIVERY.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "AMD", "DELIVERY APPT.");
}
}
if (dispatch_data.q_InsDel != null && bool.TryParse(dispatch_data.q_InsDel, out blnResult))
{
//Get the lookup ID for INSIDE DELIVERY.
if (blnResult)
{
Get_Accessorial_ID_and_insert(ref dispatch_data, ref services, "ISD", "INSIDE DELIVERY");
}
}
#endregion
}