//Ivan public static List <FC_LocalContract> ContractsByStatus_Populate(int status) { string query = "select * from FC_LocalContract where Contract_Status = " + status.ToString() + ";"; FC_LocalContract temp = new FC_LocalContract(); return(temp.ObjToTable(SQL.Select(temp, query))); }
// METHOD HEADER COMMENT ------------------------------------------------------------------------------- /** * \fn AtOrPastCity * \brief This method determins if a truck is currently at or past a destination city * \param[in] FC_LocalContract inContract, FC_TripTicket inTicket * \param[out] none * \return bool * ---------------------------------------------------------------------------------------------------- */ public bool AtOrPastCity(FC_LocalContract inContract, FC_TripTicket inTicket) { int OrginId = LoadCSV.ToCityID(inContract.Origin); int DestId = LoadCSV.ToCityID(inContract.Destination); int current = LoadCSV.ToCityID(inTicket.CurrentLocation); if (OrginId > DestId) { //going west if (current <= DestId) { return(true); } } else { if (current >= DestId) { return(true); } } return(false); }
// METHOD HEADER COMMENT ------------------------------------------------------------------------------- /** * \fn CreatTripInfo * \brief This inserts data into the columns for the Trip Ticket table * \param[in] FC_LocalContract inContract, FC_Carrier inCarrier, FC_TripTicket partTicket * \param[out] None * \return None * ---------------------------------------------------------------------------------------------------- */ public CreateTripInfo(FC_LocalContract inContract, FC_Carrier inCarrier, FC_TripTicket partTicket) { FC_TripTicket theTicket = new FC_TripTicket(); theTicket.FC_TripTicketID = SQL.GetNextID("FC_TripTicket"); theTicket.FC_CarrierID = inCarrier.FC_CarrierID; theTicket.Days_Passes = 0; theTicket.Size_in_Palettes = partTicket.Size_in_Palettes; theTicket.Is_Complete = 0; //0 is not done. 1 is done theTicket.CurrentLocation = inContract.Origin; SQL.Insert(theTicket); MappingClass mapping = new MappingClass(); List <FC_RouteSeg> routeSegs = mapping.GetTravelData(inContract.Origin, inContract.Destination, inContract.Job_type, theTicket.FC_TripTicketID); foreach (FC_RouteSeg x in routeSegs) { SQL.Insert(x); } FC_TripTicketLine tripTicketLine = new FC_TripTicketLine(theTicket.FC_TripTicketID, inContract.FC_LocalContractID, partTicket.Size_in_Palettes); SQL.Insert(tripTicketLine); TMSLogger.LogIt(" | " + "CreateTripInfo.cs" + " | " + "CreateTripInfo" + " | " + "CreateTripInfo" + " | " + "Confirmation" + " | " + "Trip info created" + " | "); }
public static FC_Invoice GenerateInvoice(FC_LocalContract InContract) { double OtherContractCost = GenerateInvoiceTotal(InContract); TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "GenerateInvoice" + " | " + "Confirmation" + " | " + "Invoice generated" + " | "); return(new FC_Invoice(-1, OtherContractCost)); }
public static List <FC_LocalContract> ContractsByName_Populate(string name) { string query = "select * from FC_LocalContract where Client_Name = '" + name.ToString() + "' and Contract_Status = 3;"; FC_LocalContract temp = new FC_LocalContract(); return(temp.ObjToTable(SQL.Select(temp, query))); }
public static List <FC_LocalContract> GetNominatedContracts() { string query = "select LC.FC_LocalContractID, LC.Client_Name, LC.Job_type, LC.Quantity, LC.Origin, LC.Destination, LC.Van_type, LC.Contract_Status " + "from FC_BuyerToPlannerContract as bp " + "left join FC_LocalContract as LC on LC.FC_LocalContractID = bp.FC_LocalContractID;"; FC_LocalContract n = new FC_LocalContract(); return(n.ObjToTable(SQL.Select(n, query))); }
public static int InsertInvoice(FC_Invoice inInvoice, FC_LocalContract InContract) { inInvoice.FC_InvoiceID = SQL.GetNextID("FC_Invoice"); SQL.Insert(inInvoice); FC_InvoiceContractLine newLine = new FC_InvoiceContractLine(InContract.FC_LocalContractID, inInvoice.FC_InvoiceID); SQL.Insert(newLine); return(inInvoice.FC_InvoiceID); }
//Ivan public static List <FC_LocalContract> ContractsPerTicket_Populate(FC_TripTicket temp) { string query = "select LC.FC_LocalContractID, LC.Client_Name, LC.Job_type, LC.Quantity, LC.Origin, LC.Destination, LC.Van_type, LC.Contract_Status " + "from FC_LocalContract as LC " + "left join FC_TripTicketLine as ttl on ttl.FC_LocalContractID = LC.FC_LocalContractID " + "left join FC_TripTicket as tt on tt.FC_TripTicketID = ttl.FC_TripTicketID " + "where tt.FC_TripTicketID = " + temp.FC_TripTicketID + ";"; FC_LocalContract lc = new FC_LocalContract(); return(lc.ObjToTable(SQL.Select(lc, query))); }
public static List <FC_LocalContract> GetContracts_PreInvoice(FC_Invoice inInvoice) { string query = "select c.FC_LocalContractID, c.Client_Name, c.Job_type, c.Quantity, c.Origin, c.Destination, c.Van_type, c.Contract_Status " + "from FC_Invoice as inn " + "left join FC_InvoiceContractLine as cl on cl.FC_InvoiceID = inn.FC_InvoiceID " + "left join FC_LocalContract as c on c.FC_LocalContractID = cl.FC_LocalContractID " + "where inn.FC_InvoiceID = " + inInvoice.FC_InvoiceID.ToString() + ";"; FC_LocalContract c = new FC_LocalContract(); return(c.ObjToTable(SQL.Select(c, query))); }
//Ivan public static List <FC_TripTicket> ConnectedTickets_Populate(FC_LocalContract temp) { ConnectedTickets.Clear(); string query = "select t.FC_TripTicketID, t.FC_CarrierID, t.CurrentLocation, t.Size_in_Palettes, t.Days_Passes, t.Is_Complete from FC_LocalContract as lc " + "left join FC_TripTicketLine as tt on tt.FC_LocalContractID = lc.FC_LocalContractID " + "left join FC_TripTicket as t on t.FC_TripTicketID = tt.FC_TripTicketID " + "where lc.FC_LocalContractID = " + temp.FC_LocalContractID + ";"; FC_TripTicket lc = new FC_TripTicket(); ConnectedTickets = lc.ObjToTable(SQL.Select(lc, query)); return(ConnectedTickets); }
public AttatchTicketPage(object data) : this() { FC_LocalContract ReadInContract = (FC_LocalContract)data; PassedInContract = ReadInContract; List <FC_TripTicket> ContractsTickets = PlannerClass.CreateTicketsFromContract(ReadInContract); AllTickets.ItemsSource = ContractsTickets; RefreshNomCarriers(); RefreshPossibleTickets(); }
public static void AddContractToInvoices(FC_Invoice inInvoice, FC_LocalContract InContract) { double OtherContractCost = GenerateInvoiceTotal(InContract); string query = "update FC_Invoice set TotalCost = " + Math.Round((inInvoice.TotalCost + OtherContractCost), 2) + " where FC_InvoiceID = " + inInvoice.FC_InvoiceID.ToString() + ";"; SQL.GenericFunction(query); FC_InvoiceContractLine newLine = new FC_InvoiceContractLine(InContract.FC_LocalContractID, inInvoice.FC_InvoiceID); SQL.Insert(newLine); TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "AddContractToInvoices" + " | " + "Confirmation" + " | " + "Contract added to invoices" + " | "); }
public static List <CarrierWithDepot_View> GetNomCarriers_withDepot(FC_LocalContract inContract) { if (inContract != null) { string query = "select ca.FC_CarrierID, ca.Carrier_Name, dc.CityName, dc.FTL_Availibility, dc.LTL_Availibility, dc.FTL_Rate, dc.LTL_Rate, dc.Reefer_Charge " + "from FC_BuyerToPlannerContract as bp " + "left join FC_CarrierNom as CN on CN.FC_BuyerToPlannerContractID = bp.FC_BuyerToPlannerContractID " + "left join FC_Carrier as ca on ca.FC_CarrierID = CN.FC_CarrierID " + "left join FC_DepotCity as dc on dc.FC_CarrierID = ca.FC_CarrierID " + "where bp.FC_LocalContractID = " + inContract.FC_LocalContractID.ToString() + " and dc.CityName = \"" + inContract.Origin + "\";"; CarrierWithDepot_View c = new CarrierWithDepot_View(); return(c.ObjToTable(SQL.Select(c, query))); } return(null); }
public static void DeleteNominations(FC_LocalContract InContract) { string Query = "select bp.FC_BuyerToPlannerContractID, bp.FC_LocalContractID " + "from FC_BuyerToPlannerContract as bp " + "left join FC_LocalContract on FC_LocalContract.FC_LocalContractID = bp.FC_LocalContractID " + "where FC_LocalContract.FC_LocalContractID = " + InContract.FC_LocalContractID + ";"; FC_BuyerToPlannerContract p = new FC_BuyerToPlannerContract(); List <FC_BuyerToPlannerContract> B2P = p.ObjToTable(SQL.Select(p, Query)); Query = "delete from FC_CarrierNom where FC_BuyerToPlannerContractID = " + B2P[0].FC_BuyerToPlannerContractID + ";"; SQL.GenericFunction(Query); Query = "delete from FC_BuyerToPlannerContract where FC_BuyerToPlannerContractID = " + B2P[0].FC_BuyerToPlannerContractID + ";"; SQL.GenericFunction(Query); }
public static List <FC_TripTicket> CreateTicketsFromContract(FC_LocalContract InContract) { List <FC_TripTicket> ReturnTickets = new List <FC_TripTicket>(); if (InContract != null) { int TempTickedID = -10; if (InContract.Quantity == 0 || InContract.Quantity == 26) { FC_TripTicket newTicket = new FC_TripTicket(TempTickedID, -1, InContract.Origin, 0, 0, 0); ReturnTickets.Add(newTicket); } else if (InContract.Quantity < 26) { FC_TripTicket newTicket = new FC_TripTicket(TempTickedID, -1, InContract.Origin, InContract.Quantity, 0, 0); ReturnTickets.Add(newTicket); } else if (InContract.Quantity > 26) { FC_TripTicket newTicket = new FC_TripTicket(); do { if (InContract.Quantity >= 26) { newTicket = new FC_TripTicket(TempTickedID--, -1, InContract.Origin, 0, 0, 0); } else if (InContract.Quantity < 26) { newTicket = new FC_TripTicket(TempTickedID--, -1, InContract.Origin, InContract.Quantity, 0, 0); } ReturnTickets.Add(newTicket); InContract.Quantity -= 26; } while (InContract.Quantity > 0); } } TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "CreateTicketsFromContract" + " | " + "Confirmation" + " | " + "Ticket created from contract" + " | "); return(ReturnTickets); }
// METHOD HEADER COMMENT ------------------------------------------------------------------------------- /** * \fn PushToDataBase * \brief This method inserts a new contract into the database * \param[in] none * \param[out] none * \return bool * ---------------------------------------------------------------------------------------------------- */ public bool PushToDataBase() { TheContract = new FC_LocalContract(SQL.GetNextID("FC_LocalContract"), InContract.Client_Name, InContract.Job_type, InContract.Quantity, InContract.Origin, InContract.Destination, InContract.Van_type, 0); SQL.Insert(TheContract); FC_BuyerToPlannerContract B2PC = new FC_BuyerToPlannerContract(); B2PC.FC_BuyerToPlannerContractID = SQL.GetNextID("FC_BuyerToPlannerContract"); B2PC.FC_LocalContractID = TheContract.FC_LocalContractID; SQL.Insert(B2PC); foreach (FC_Carrier x in TheCarriers) { SQL.Insert(new FC_CarrierNom(B2PC.FC_BuyerToPlannerContractID, x.FC_CarrierID)); } TMSLogger.LogIt(" | " + "NominateForPlanner.cs" + " | " + "NominateForPlanner" + " | " + "PushToDataBase" + " | " + "Confirmation" + " | " + "Contract pushed to database" + " | "); return(true); }
public static double GenerateInvoiceTotal(FC_LocalContract inContract) { List <FC_TripTicket> AllTickets = ConnectedTickets_Populate(inContract); MappingClass map = new MappingClass(); List <FC_RouteSeg> TempRouteSegs = map.GetTravelData(inContract.Origin, inContract.Destination, 1, 1); double Total_Cost = 0; foreach (FC_TripTicket x in AllTickets) { List <FC_RouteSeg> TotalContractSegments = new List <FC_RouteSeg>(); List <FC_RouteSeg> segments = RoutSegsPerTicket_Populate(x); for (int i = 0; i < TempRouteSegs.Count; i++) { TotalContractSegments.Add(segments[i]); } RouteSumData sumData = new RouteSumData(); sumData = sumData.SummerizeTrip(TotalContractSegments); string query = "select FC_CarrierID, CityName, FTL_Availibility, LTL_Availibility, FTL_Rate, LTL_Rate, Reefer_Charge " + "from FC_DepotCity " + "where FC_CarrierID = " + x.FC_CarrierID.ToString() + " and CityName = \"" + inContract.Origin + "\";"; FC_DepotCity d = new FC_DepotCity(); List <FC_DepotCity> theDepotCity = d.ObjToTable(SQL.Select(d, query)); double tempPrice = 0; if (inContract.Job_type == 0) { tempPrice = sumData.totalKM * theDepotCity[0].FTL_Rate * 1.08; } else { query = "select * from FC_TripTicketLine where FC_TripTicketID = " + x.FC_TripTicketID.ToString() + " and FC_LocalContractID = " + inContract.FC_LocalContractID.ToString() + " ;"; FC_TripTicketLine t = new FC_TripTicketLine(); List <FC_TripTicketLine> theTicketLine = t.ObjToTable(SQL.Select(t, query)); int QuantityOnTruck = theTicketLine[0].PalletsOnTicket; if (QuantityOnTruck == 0) { QuantityOnTruck = 26; } tempPrice = sumData.totalKM * theDepotCity[0].LTL_Rate * QuantityOnTruck * 1.05; } if (inContract.Van_type == 1) { tempPrice *= (theDepotCity[0].Reefer_Charge + 1); } Total_Cost += tempPrice; } try { Total_Cost = Math.Round(Total_Cost, 2); } catch (Exception e) { TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "GenerateInvoiceTotal" + " | " + e.GetType().ToString() + " | " + e.Message + " | "); } TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "GenerateInvoiceTotal" + " | " + "Confirmation" + " | " + "Invoice total generated" + " | "); return(Total_Cost); }
// METHOD HEADER COMMENT ------------------------------------------------------------------------------- /** * \fn * \brief * \param[in] * \param[out] * \return * ---------------------------------------------------------------------------------------------------- */ public NominateForPlanner() { InContract = null; TheContract = null; TheCarriers = new List <FC_Carrier>(); }
public static int AddContractToTicket(FC_TripTicket OriginalTick, FC_TripTicket TempTicket, FC_LocalContract TheContract) { string Query = "select * from FC_RouteSeg where FC_TripTicketID = " + OriginalTick.FC_TripTicketID + ";"; FC_RouteSeg r = new FC_RouteSeg(); List <FC_RouteSeg> OriginalSegs = r.ObjToTable(SQL.Select(r, Query)); MappingClass map = new MappingClass(); List <FC_RouteSeg> NewSegs = map.GetTravelData(TheContract.Origin, TheContract.Destination, 0, -1); //check that these tickets are going in the same direction if (OriginalSegs[0].CityA == NewSegs[0].CityA && OriginalSegs[0].CityB == NewSegs[0].CityB && TempTicket.Size_in_Palettes != 0) { int PalletesAddedToOgrinal = 26 - OriginalTick.Size_in_Palettes; if (PalletesAddedToOgrinal > TempTicket.Size_in_Palettes) { PalletesAddedToOgrinal = TempTicket.Size_in_Palettes; } int OrignalTickNewSize = OriginalTick.Size_in_Palettes + PalletesAddedToOgrinal; if (OrignalTickNewSize == 26) { OrignalTickNewSize = 0; } string query = "update FC_TripTicket " + "set Size_in_Palettes = " + OrignalTickNewSize + " where FC_TripTicketID = " + OriginalTick.FC_TripTicketID + ";"; SQL.GenericFunction(query); int FTL = 0; List <FC_RouteSeg> NewSegmentsFTL = new List <FC_RouteSeg>(); List <FC_RouteSeg> NewSegmentsLTL = new List <FC_RouteSeg>(); if (NewSegs.Count > OriginalSegs.Count) { string orginCity = LoadCSV.ToCityName(OriginalSegs[0].CityA); string EndOfFTL = LoadCSV.ToCityName(OriginalSegs[OriginalSegs.Count - 1].CityB); string startLTL = LoadCSV.ToCityName(NewSegs[OriginalSegs.Count].CityA); string endCity = LoadCSV.ToCityName(NewSegs[NewSegs.Count - 1].CityB); NewSegmentsFTL = map.GetTravelData(orginCity, EndOfFTL, FTL, OriginalTick.FC_TripTicketID); NewSegmentsLTL = map.GetTravelData(startLTL, endCity, 1, OriginalTick.FC_TripTicketID); } else if (NewSegs.Count < OriginalSegs.Count) { string orginCity = LoadCSV.ToCityName(OriginalSegs[0].CityA); string EndOfFTL = LoadCSV.ToCityName(NewSegs[NewSegs.Count - 1].CityB); string startLTL = LoadCSV.ToCityName(OriginalSegs[NewSegs.Count].CityA); string endCity = LoadCSV.ToCityName(OriginalSegs[OriginalSegs.Count - 1].CityB); NewSegmentsFTL = map.GetTravelData(orginCity, EndOfFTL, FTL, OriginalTick.FC_TripTicketID); NewSegmentsLTL = map.GetTravelData(startLTL, endCity, 1, OriginalTick.FC_TripTicketID); } else { string orginCity = LoadCSV.ToCityName(OriginalSegs[0].CityA); string endCity = LoadCSV.ToCityName(OriginalSegs[NewSegs.Count - 1].CityB); NewSegmentsLTL = map.GetTravelData(orginCity, endCity, FTL, OriginalTick.FC_TripTicketID); } if (NewSegmentsLTL != null) { NewSegmentsLTL[0].PickUpTime = 0; } query = "delete from FC_RouteSeg where FC_TripTicketID = " + OriginalTick.FC_TripTicketID + ";"; SQL.GenericFunction(query); foreach (FC_RouteSeg x in NewSegmentsFTL) { SQL.Insert(x); } foreach (FC_RouteSeg x in NewSegmentsLTL) { SQL.Insert(x); } FC_TripTicketLine NewLine = new FC_TripTicketLine(OriginalTick.FC_TripTicketID, TheContract.FC_LocalContractID, PalletesAddedToOgrinal); SQL.Insert(NewLine); TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "AddContractToTicket" + " | " + "Confirmation" + " | " + "Contract added to ticket" + " | "); return(PalletesAddedToOgrinal); } return(-1); }
//Duane public static void UpdateContratState(FC_LocalContract inContract, int newState) { string query = "update FC_LocalContract set Contract_Status = " + newState.ToString() + " where FC_LocalContractID = " + inContract.FC_LocalContractID + ";"; SQL.GenericFunction(query); }
public static void IncrementOneDay() { try { string FirstQuery = "Select * from FC_TripTicket where not Is_Complete = 0;"; FC_TripTicket t = new FC_TripTicket(); List <FC_TripTicket> AllTickets = t.ObjToTable(SQL.Select(t, FirstQuery)); foreach (FC_TripTicket x in AllTickets) { x.Days_Passes++; FC_RouteSeg s = new FC_RouteSeg(); string query = "Select FC_TripTicketID, CityA, CityB, PickUpTime, DropOffTime, LtlTime, DrivenTime, KM from FC_RouteSeg where FC_TripTicketID = " + x.FC_TripTicketID + ";"; List <FC_RouteSeg> AllSegments = s.ObjToTable(SQL.Select(s, query)); double totalTime = x.Days_Passes * 12; double DriveTime = x.Days_Passes * 8; int SegIndex = 0; FC_RouteSeg currentSegment = AllSegments[SegIndex]; while (true) { totalTime -= currentSegment.PickUpTime; totalTime -= currentSegment.DrivenTime; DriveTime -= currentSegment.DrivenTime; totalTime -= currentSegment.LtlTime; totalTime -= currentSegment.DropOffTime; if (totalTime <= 0 || DriveTime <= 0) { x.CurrentLocation = LoadCSV.ToCityName(currentSegment.CityA); break; } else { SegIndex++; if (SegIndex >= AllSegments.Count) { x.CurrentLocation = LoadCSV.ToCityName(currentSegment.CityB); break; } else { currentSegment = AllSegments[SegIndex]; } x.CurrentLocation = LoadCSV.ToCityName(currentSegment.CityB); } } PlannerClass.UpdateTicketLocation(x); } string Query = "select FC_LocalContractID, Client_Name, Job_type, Quantity, Origin, Destination, Van_type, Contract_Status from " + "FC_LocalContract where Contract_Status = 1"; FC_LocalContract l = new FC_LocalContract(); List <FC_LocalContract> OnrouteContracts = l.ObjToTable(SQL.Select(l, Query)); MappingClass map = new MappingClass(); foreach (FC_LocalContract x in OnrouteContracts) { bool isComplete = true; List <FC_TripTicket> theTickets = PlannerClass.ConnectedTickets_Populate(x); foreach (FC_TripTicket y in theTickets) { if (!map.AtOrPastCity(x, y)) { isComplete = false; break; } } if (isComplete) { PlannerClass.UpdateContratState(x, 2); } } string theQuery = "Select * from FC_TripTicket where Is_Complete = 1"; FC_TripTicket w = new FC_TripTicket(); List <FC_TripTicket> ActiveTickets = t.ObjToTable(SQL.Select(t, theQuery)); foreach (FC_TripTicket x in ActiveTickets) { bool foundNotComple = false; List <FC_LocalContract> ContactsPerTick = PlannerClass.ContractsPerTicket_Populate(x); foreach (FC_LocalContract y in ContactsPerTick) { if (y.Contract_Status < 2) { foundNotComple = true; } } if (!foundNotComple) { theQuery = "Update FC_TripTicket set Is_Complete = 2 where FC_TripTicketID = " + x.FC_TripTicketID + ";"; SQL.GenericFunction(theQuery); } } TMSLogger.LogIt(" | " + "TimePass.cs" + " | " + "TimePass" + " | " + "IncrementOneDay" + " | " + "Confirmation" + " | " + "Day incremented" + " | "); } catch (Exception e) { TMSLogger.LogIt(" | " + "TimePass.cs" + " | " + "TimePass" + " | " + "IncrementOneDay" + " | " + e.GetType().ToString() + " | " + e.Message + " | "); } }