private void CalculateAverage() { var baseDate = DateTime.Now; var span = new DateTime(); var fwd = baseDate.AddDays(-(int)baseDate.DayOfWeek); var lwd = fwd.AddDays(7).AddSeconds(-1); var firstWeekday = fwd.ToString("MM/dd/yyyy"); var lastWeekDay = lwd.ToString("MM/dd/yyyy"); SQL_search.RunQuery("db_Harbor", "SELECT IN_TIME, OUT_TIME FROM DS_SCHEDULE WHERE SCHEDULE_TIME BETWEEN '" + firstWeekday + " 00:00:00.00' AND '" + lastWeekDay + " 23:59:59.999' AND LOAD_TIME > '00:05:00' AND LOCATION = '" + MachineData.appLocation + "'"); if (SQL_search.RecordCount > 0) { for (var i = 0; i < SQL_search.RecordCount; i++) { var inTime = DateTime.Parse(SQL_search.Ds.Tables[0].Rows[i]["IN_TIME"].ToString(), new CultureInfo("en-US", true)); var outTime = DateTime.Parse(SQL_search.Ds.Tables[0].Rows[i]["OUT_TIME"].ToString(), new CultureInfo("en-US", true)); span += outTime - inTime; } var avgSpan = new TimeSpan(span.Ticks / SQL_search.RecordCount); HeaderAverage = DateTime.MinValue.Add(avgSpan).ToString("H:mm:ss"); } else { HeaderAverage = "00:00:00"; } }
private void ReadConfig() { var waypt = new Waypoint(); if (VerifyDatabaseConnection()) { SQL_search.RunQuery("db_Harbor", "SELECT * FROM [@profiles] WHERE COMPUTER ='" + Environment.MachineName + "'"); if (SQL_search.RecordCount > 0) { var dbId = SQL_search.Ds.Tables[0].Rows[0]["ID"].ToString(); var dbVersion = SQL_search.Ds.Tables[0].Rows[0]["VERSION"].ToString(); MachineData.appLocation = SQL_search.Ds.Tables[0].Rows[0]["LOCATION"].ToString(); LoadApplication(SQL_search.Ds.Tables[0].Rows[0]["APPLICATION"].ToString()); //checks for recorded version number ------- if (MachineData.appVersion == dbVersion) { return; } //updates new version number ----------- SQL_general.UpdateComputer("db_Harbor", MachineData.appVersion, dbId); } else { waypt.Show(); } } else { waypt.Show(); } }
public static string Get_FileUrl(string part, string container) { SQL_search.RunQuery("db_Harbor", "SELECT * FROM MO_FILE_LISTING WHERE PART = '" + part + "' AND CONTAINER = '" + container + "'"); if (SQL_search.RecordCount <= 0) { return(null); } var url = SQL_search.Ds.Tables[0].Rows[0]["MASTER"].ToString(); return(url.Contains(".pdf") ? CreateTempFile(url, ".pdf") : CreateTempFile(url + ".pdf", ".pdf")); }
public static string Get_BoMsUrl(string part) { const string location = "S:/Information Systems/@Developer Resources/Applications/Harbor/Bill of Material.rpt"; if (!File.Exists(location)) { return(null); } SQL_search.RunQuery("db_Harbor", "EXEC Bill_of_Materials '" + part + "'"); return(SQL_search.RecordCount > 0 ? CreateTempFile(location, ".rpt") : null); }
public void LoadRecords() { SQL_search.RunQuery("db_lighthouse", $"SELECT TOP {MAX_ENTRIES} * FROM SUMMARY_REMITS ORDER BY ID DESC"); recordsFound = SQL_search.RecordCount; if (recordsFound <= 0) { return; } for (var i = 0; i < recordsFound; i++) { var dr = SQL_search.Ds.Tables[0].Rows[i]; RecordRow(dr); } }
public MachineOperations_VM() { if (!SQL_search.HasConnection("db_Harbor")) { return; } SQL_search.RunQuery("db_Harbor", "SELECT * FROM [@profiles] WHERE COMPUTER = '" + Environment.MachineName + "'"); if (SQL_search.RecordCount <= 0) { return; } //MachineData.Number = SQL_search.Ds.Tables[0].Rows[0]["NUMBER"].ToString(); MachineData.Number = SQL_search.Ds.Tables[0].Rows[0]["ID"].ToString(); }
private void DockLocationArray() { SQL_search.RunQuery("db_Sandbar", "SELECT * FROM DS_CAT_LOCATIONS WHERE LOCATION = '" + MachineData.appLocation + "'"); if (SQL_search.RecordCount <= 0) { return; } AddDockToList.Clear(); var dockMax = Convert.ToInt32(SQL_search.Ds.Tables[0].Rows[0]["DOCK"]); for (var i = 1; i <= dockMax; i++) { AddDockToList.Add(i.ToString()); } }
//''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' //'''''''''''''''''''''''''''''''''''' PANEL BUTTONS '''''''''''''''''''''''''''''''''''' //''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' public void Action_UpdateRow(object sender, EventArgs e) { DSInteractiveEntry dsie = sender as DSInteractiveEntry; DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData; string id = data.PairId; var now = DateTime.Now; if (data.Action == DSInteractiveEntryData.MARK_ARRIVED) { //LATE ARRIVAL HIGHLIGHT------------------------- SQL_search.RunQuery("db_Sandbar", $"SELECT * FROM DS_entries WHERE ID = {id}"); var scheduleTime = SQL_search.Ds.Tables[0].Rows[0]["SCHEDULE_TIME"].ToString(); var displayTime = DateTime.Parse(scheduleTime, new CultureInfo("en-US", true)); if (DateTime.Now > displayTime) { data.MarkLate(); } //----------------------------------------------- data.Action = DSInteractiveEntryData.SENT_TO_DOCK; data.ArrivedValue = now.ToShortTimeString(); SQL_dockSchedule.InsertTime("ARRIVAL_TIME", id); } else if (data.Action == DSInteractiveEntryData.SENT_TO_DOCK) { data.Action = DSInteractiveEntryData.ARRIVED_AT_DOCK; data.STDValue = now.ToShortTimeString(); SQL_dockSchedule.InsertTime("SENT_TIME", id); } else if (data.Action == DSInteractiveEntryData.ARRIVED_AT_DOCK) { data.Action = DSInteractiveEntryData.DEPARTED_DOCK; data.TimeInValue = now.ToShortTimeString(); SQL_dockSchedule.InsertTime("IN_TIME", id); } else if (data.Action == DSInteractiveEntryData.DEPARTED_DOCK) { SQL_dockSchedule.InsertTime("OUT_TIME", id); LoadDailySchedule(); } }
public void LoadDailySchedule() { if (DateLock == false) { var regDate = DateTime.Now; DateStamp = regDate.ToString("MM/dd/yyyy"); } SQL_search.RunQuery("db_Harbor", $"SELECT TOP {MAX_ENTRIES} * FROM DS_SCHEDULE WHERE CONVERT(varchar, SCHEDULE_TIME, 101) = '" + DateStamp + "' AND (OUT_TIME IS NULL AND CANCELLED_TIME IS NULL) AND LOCATION = '" + MachineData.appLocation + "' ORDER BY SCHEDULE_TIME ASC"); // SQL_search.RunQuery("db_Harbor", $"SELECT TOP {MAX_ENTRIES} * FROM DS_SCHEDULE WHERE CONVERT(varchar, SCHEDULE_TIME, 101) = '09/30/2019' AND (OUT_TIME IS NULL AND CANCELLED_TIME IS NULL) AND LOCATION = '" + MachineData.appLocation + "' ORDER BY SCHEDULE_TIME ASC"); ScheduledRows = SQL_search.RecordCount; if (ScheduledRows > 0) { _parent._parent._vm.ShowMessage(""); DateLock = true; int i = 0; DataRow dr; for (; i < ScheduledRows; i++) { dr = SQL_search.Ds.Tables[0].Rows[i]; ScheduleRow(i, dr); } for (; i < MAX_ENTRIES; i++) { ScheduleRow(i, null); } } else { for (int i = 0; i < MAX_ENTRIES; i++) { ScheduleRow(i, null); } _parent._parent._vm.ShowMessage("complete"); DateLock = false; ScheduledRows = 0; } }