//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)));
}
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)));
}
//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)));
}
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 + " | ");
}
}
