//public static string ToJSON(this object obj, int recursionDepth) //{ // JavaScriptSerializer serializer = new JavaScriptSerializer(); // serializer.RecursionLimit = recursionDepth; // return serializer.Serialize(obj); //} #endregion #region GetDLS_strSQL_ForCompID private static string GetDLS_strSQL_ForCompID(string CompName) { string sql = string.Concat("select CompID from tbl_Company where Carrier = 1 AND CompName='", CompName, "'"); HelperFuncs.writeToDispatchLogs("carNameTest RRD", sql); return(sql); }
public static string GetDLS_CarrierCompanyID(ref string strCarrierName) { string strSQL = ""; strCarrierName = strCarrierName.Replace(" Guaranteed by 5PM", ""); HelperFuncs.writeToDispatchLogs("RRD carrier LIVE", strCarrierName); switch (strCarrierName.Replace("<span style='color:Green;'></span>", "").Replace("%2C", ",")) { case "Crosscountry Courier Inc RRD": { strSQL = GetDLS_strSQL_ForCompID("Cross Country Courier"); break; } case "Con-Way RRD": { strSQL = GetDLS_strSQL_ForCompID("Con-Way Transportation Services"); break; } case "XPO Logistics Freight, Inc. RRD": { strSQL = GetDLS_strSQL_ForCompID("Con-Way Transportation Services"); break; } case "Fedex LTL Priority RRD": { strSQL = GetDLS_strSQL_ForCompID("FEDEX LTL PRIORITY"); break; } case "FedEx Freight (R) Priority RRD": { strSQL = GetDLS_strSQL_ForCompID("FEDEX LTL PRIORITY"); break; } case "Fedex LTL Economy RRD": { strSQL = GetDLS_strSQL_ForCompID("FEDEX LTL ECONOMY"); break; } case "FedEx Freight (R) Economy RRD": { strSQL = GetDLS_strSQL_ForCompID("FEDEX LTL ECONOMY"); break; } case "Central Transport RRD": { strSQL = GetDLS_strSQL_ForCompID("CENTRAL TRANSPORT"); break; } case "YRC Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("YRC"); break; } case "UPS Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("UPS FREIGHT"); break; } case "SAIA RRD": { strSQL = GetDLS_strSQL_ForCompID("Saia Motor Freight"); break; } case "Estes Express Lines RRD": { strSQL = GetDLS_strSQL_ForCompID("ESTES EXPRESS LINES"); break; } case "R & L Carriers RRD": { //strSQL = GetDLS_strSQL_ForCompID("R+L Carriers, inc."); strSQL = string.Concat("select CompID from tbl_Company where Carrier=1 AND CompID=158276"); break; } case "R $ L Carriers RRD": //R $ L Carriers RRD { //strSQL = GetDLS_strSQL_ForCompID("R+L Carriers, inc.");// strSQL = string.Concat("select CompID from tbl_Company where Carrier=1 AND CompID=158276"); break; } case "N & M Transfer Co., Inc. RRD": { strSQL = string.Concat("select CompID from tbl_Company where Carrier=1 AND CompID=40554"); break; } case "ROADRUNNER TRANSPORTATION SERVICES INC RRD": { strSQL = GetDLS_strSQL_ForCompID("ROADRUNNER TRANSPORTATION - RRTS"); break; } case "New Penn RRD": { strSQL = GetDLS_strSQL_ForCompID("NEW PENN"); break; } case "Clear Lane Freight Systems LLC RRD": { strSQL = GetDLS_strSQL_ForCompID("CLEAR LANE FREIGHT SYSTEMS"); break; } case "Pitt Ohio Express RRD": { strSQL = GetDLS_strSQL_ForCompID("PITT OHIO EXPRESS"); break; } case "Dayton Freight Lines Inc RRD": { strSQL = GetDLS_strSQL_ForCompID("DAYTON FREIGHT LINES"); break; } case "AAA Cooper RRD": { strSQL = GetDLS_strSQL_ForCompID("AAA COOPER"); break; } case "AAA Cooper Transportation RRD": { strSQL = GetDLS_strSQL_ForCompID("AAA COOPER"); break; } case "A&B Freight Line RRD": { //strSQL = GetDLS_strSQL_ForCompID("Saia Motor Freight"); break; } case "ABERDEEN EXPRESS INC. RRD": { strSQL = GetDLS_strSQL_ForCompID("ABERDEEN EXPRESS"); break; } case "ABERDEEN EXPRESS INC RRD": { strSQL = GetDLS_strSQL_ForCompID("ABERDEEN EXPRESS"); break; } case "Averitt Express Express RRD": { strSQL = GetDLS_strSQL_ForCompID("Averitt Express"); break; } case "Benjamin Best Freight Inc RRD": { strSQL = GetDLS_strSQL_ForCompID("Benjamin Best freight"); break; } case "Beaver Express RRD": { strSQL = GetDLS_strSQL_ForCompID("BEAVER EXPRESS"); break; } case "Benton Express RRD": { strSQL = GetDLS_strSQL_ForCompID("BENTON EXPRESS"); break; } case "Central Freight Lines RRD": { strSQL = GetDLS_strSQL_ForCompID("CENTRAL FREIGHT LINES"); break; } case "Central Transport Intl RRD": { strSQL = GetDLS_strSQL_ForCompID("CENTRAL TRANSPORT"); break; } case "Clear Lane Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("CLEAR LANE FREIGHT SYSTEMS"); break; } case "Dayton Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("DAYTON FREIGHT LINES"); break; } case "DHE RRD": { strSQL = GetDLS_strSQL_ForCompID("DEPENDABLE HIGHWAY EXPRESS"); break; } case "Dependable Highway Express RRD": { strSQL = GetDLS_strSQL_ForCompID("DEPENDABLE HIGHWAY EXPRESS"); break; } case "Dorhn Transfer RRD": { strSQL = GetDLS_strSQL_ForCompID("Dohrn Transfer Company"); break; } case "Dohrn Transfer RRD": { strSQL = GetDLS_strSQL_ForCompID("Dohrn Transfer Company"); break; } case "Dugan RRD": { strSQL = GetDLS_strSQL_ForCompID("Dugan Truck Line"); break; } case "Expedited Freight Systems RRD": { strSQL = GetDLS_strSQL_ForCompID("Expedited Freight Systems"); break; } case "Expedited Freight Systems, Llc RRD": { strSQL = GetDLS_strSQL_ForCompID("Expedited Freight Systems"); break; } case "Frontline Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("Frontline Freight Inc"); break; } case "LME Inc RRD": { strSQL = GetDLS_strSQL_ForCompID("LAKEVILLE MOTOR EXPRESS"); break; } case "lme inc rrd": { strSQL = GetDLS_strSQL_ForCompID("LAKEVILLE MOTOR EXPRESS"); break; } case "Lakeville Motor RRD": { strSQL = GetDLS_strSQL_ForCompID("LAKEVILLE MOTOR EXPRESS"); break; } case "Lakeville Motor Express, Inc. RRD": { strSQL = GetDLS_strSQL_ForCompID("LAKEVILLE MOTOR EXPRESS"); break; } case "Land Air Express RRD": { strSQL = GetDLS_strSQL_ForCompID("LAND AIR EXPRESS"); break; } case "Midwest Motor Express RRD": { strSQL = GetDLS_strSQL_ForCompID("MIDWEST MOTOR EXPRESS"); break; } case "New England Motor RRD": { strSQL = GetDLS_strSQL_ForCompID("NEW ENGLAND MOTOR FREIGHT"); break; } case "New England Motor Freight RRD": { strSQL = GetDLS_strSQL_ForCompID("NEW ENGLAND MOTOR FREIGHT"); break; } case "Oak Harbor RRD": { strSQL = GetDLS_strSQL_ForCompID("OAK HARBOR"); break; } case "Southeastern Freight Lines RRD": { strSQL = GetDLS_strSQL_ForCompID("SOUTHEASTERN FREIGHT LINES"); break; } case "Southwestern Motor RRD": { strSQL = GetDLS_strSQL_ForCompID("SOUTHWESTERN MOTOR TRANSPORT"); break; } case "SOUTHWESTERN MOTOR TRANSPORT INC RRD": { strSQL = GetDLS_strSQL_ForCompID("SOUTHWESTERN MOTOR TRANSPORT"); break; } case "Standard Forwarding RRD": { strSQL = GetDLS_strSQL_ForCompID("Standard Forwarding Company"); break; } case "STANDARD FORWARDING LLC RRD": { strSQL = GetDLS_strSQL_ForCompID("Standard Forwarding Company"); break; } case "USF Holland RRD": { strSQL = GetDLS_strSQL_ForCompID("USF Holland"); break; } case "USF Reddaway RRD": { strSQL = GetDLS_strSQL_ForCompID("USF Reddaway"); break; } case "Valley Cartage Company RRD": { //strSQL = GetDLS_strSQL_ForCompID("Saia Motor Freight"); break; } case "Vision Express RRD": { strSQL = GetDLS_strSQL_ForCompID("Vision Express"); break; } case "Wrag-Time Trans RRD": { strSQL = GetDLS_strSQL_ForCompID("Vision Express"); break; } case "Vision Express/Wrag-Time Trans RRD": { strSQL = GetDLS_strSQL_ForCompID("Vision Express"); break; } case "Vision Express/Wrag-TIme Transportation RRD": //Vision Express/Wrag-TIme Transportation RRD { strSQL = GetDLS_strSQL_ForCompID("Vision Express"); break; } case "Wilson Trucking Company RRD": { strSQL = GetDLS_strSQL_ForCompID("WILSON TRUCKING"); break; } case "Forward Air RRD": { strSQL = GetDLS_strSQL_ForCompID("FORWARD AIR"); break; } case "FORWARD AIR, INC. RRD": { strSQL = GetDLS_strSQL_ForCompID("FORWARD AIR"); break; } //case "FORWARD AIR%2C INC. RRD": // { // strSQL = GetDLS_strSQL_ForCompID("FORWARD AIR"); // break; // } case "Tax Airfreight, Inc. RRD": { strSQL = GetDLS_strSQL_ForCompID("Tax Airfreight Inc"); break; } default: { HelperFuncs.writeToDispatchLogs("RRD carrier not caught LIVE", strCarrierName); //HelperFuncs.writeToSiteErrors("RRD carrier not caught", strCarrierName); break; } } return(strSQL); }