//Gets the latest WorkOrder number and sets it as the _WorkOrder
public void FindLastWorkOrder()
{
DBMaster dbmaster = new DBMaster();
DataTable dt = dbmaster.queryDB(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), "WorkOrderDetails", "WorkOrder", "DateOfProduction = (select MAX(DateOfProduction) from WorkOrderDetails);");
string latestWorkOrder = dt.Rows[0][0].ToString();
_workOrder = latestWorkOrder;
}
ErrorLogger _logger = new ErrorLogger(); // The logger for this classs
public HomeForm() // The initial start up Constructor
{
InitializeComponent();
this.Icon = Icon = Icon.ExtractAssociatedIcon(System.Reflection.Assembly.GetExecutingAssembly().Location);
DBMaster dbMaster = new DBMaster();
dbMaster.GetDBNames(); // This method sets all the Database names required for the application to work
InitialConditions(); //Sets all the conditions (Mainly Display Conditions)
}
//This function gets the db logs of specific work order between the starting and ending time and a specific camera set and master number
private DataTable GetDataBaseTable(DateTime start, DateTime end, int cs, int m)
{
DBMaster dbMaster = new DBMaster();
string condition = "LogTime >= '" + Convert.ToDateTime(start).ToString("yyyy-MM-dd HH:mm:ss") + "' and LogTime <= '" + Convert.ToDateTime(end).ToString("yyyy-MM-dd HH:mm:ss") + "' and CameraSet = " + cs + " and PCNumber = " + (m - 1) + ";";
DataTable dt = dbMaster.queryDB(ConfigurationManager.AppSettings["EventLogDBName"].ToString(), "[AllEvents]", "CONVERT(varchar,LogTime,120) AS LogTime,EventMessage,CurrentWorkOrder,NextWorkOrder", condition);
return(dt);
}
public WorkOrderRangeDisplayForm(DateTime from, DateTime to)
{
InitializeComponent();
this.Icon = Icon = Icon.ExtractAssociatedIcon(System.Reflection.Assembly.GetExecutingAssembly().Location);
WorkOrderDetailsGridView.RowHeadersVisible = false;
DBMaster dbMaster = new DBMaster();
DataTable dt = dbMaster.queryDB(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), "WorkOrderDetails", "WorkOrder,ProductCode,DateOfProduction", "DateOfProduction >='" + Convert.ToDateTime(from).ToString("yyyy-MM-dd hh:mm:ss tt") + "' AND DateOfProduction <= '" + Convert.ToDateTime(to).ToString("yyyy-MM-dd hh:mm:ss tt") + "';");
WorkOrderDetailsGridView.DataSource = dt;
}
//Gets the number of Camera Sets And Masters from the DataBase
private void GetCSMasters()
{
DBMaster dbMaster = new DBMaster();
DataTable cameraSetDt = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "CameraSets", "CSID,CSNUMPCs", ConfigurationManager.AppSettings["noConditions"].ToString());
MasterComboBox.Items.Clear();
CameraSetComboBox.Items.Clear();
CheckForLoomSystem(cameraSetDt);
SetComboBoxValues(cameraSetDt);
}
//Finds the next work Order and the previous Work Order
private static DataTable getWorkOrderSequenceDetails()
{
DBMaster dbMaster = new DBMaster();
DataTable workOrderdt = dbMaster.fetchWorkOrderDetails(ConfigurationManager.AppSettings["workOrdersDBName"].ToString(), _workOrder);
_WODetails = new List <string>();
_WODetails.Add(workOrderdt.Rows[0]["NEXTWORKORDER"].ToString());
_WODetails.Add(workOrderdt.Rows[0]["PREVIOUSWORKORDER"].ToString());
return(workOrderdt);
}
//Finds the files which are relevant to be parsed in order to find the required work order
private List <string> findFiles(string key, int cs, int m, bool isLoomSystem)
{
string path = "";
DBMaster dbMaster = new DBMaster();
bool frontEnd = false;
if (cs == 0)
{
frontEnd = true;
}
if (!frontEnd)
{
string pcName = "";
if (isLoomSystem)
{
pcName = ConfigurationManager.AppSettings["genericErrorFolderPathLoomSystem"].ToString();
path = pcName;
}
else
{
//FOR PINCROFT PC1--
// pcName = "PC1CS" + cs.ToString() + "M" + m.ToString();
// FOR PINCROFT PC2--
// pcName = "PC2CS" + cs.ToString() + "M" + m.ToString();
// GENERIC PC Name
pcName = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "PC_List", "PCName", "PCName like '%CS" + cs.ToString() + "M" + m.ToString() + "'").Rows[0]["PCName"].ToString();
path = ConfigurationManager.AppSettings["genericErrorFolderPath"].ToString().Replace("XXXXX", pcName);
}
}
else
{
// Generic PC Name
string pcName = dbMaster.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "PC_List", "PCName", "PCName like '%F1'").Rows[0]["PCName"].ToString();
//FOR PENCROFT PC1
//string pcName = "PC1F1";
//FOR PENCROFT PC2
// string pcName = "PC2F1";
path = ConfigurationManager.AppSettings["genericErrorFolderPath"].ToString().Replace("XXXXX", pcName);
}
List <string> files = checkDirectory(key, path, cs, m);
return(files);
}
private DataTable GetSystemNames()
{
DataTable systemNames = new DataTable();
systemNames.Columns.Add("SystemName");
systemNames.Columns.Add("CameraSet");
systemNames.Columns.Add("Master");
DBMaster obj = new DBMaster();
DataTable cameraSetDt = obj.queryDB(ConfigurationManager.AppSettings["webSpectorDBName"].ToString(), "CameraSets", "CSID,CSNumPCs", ConfigurationManager.AppSettings["noConditions"].ToString());
if (cameraSetDt.Rows.Count > 0)
{
string frontEndName = "FrontEnd";
int cs = 0;
int m = 0;
DataRow frontEndRow = systemNames.NewRow();
frontEndRow["SystemName"] = frontEndName;
frontEndRow["CameraSet"] = cs;
frontEndRow["Master"] = m;
systemNames.Rows.Add(frontEndRow);
foreach (DataRow dr in cameraSetDt.Rows)
{
int cameraSetID = 0;
Int32.TryParse(dr["CSID"].ToString(), out cameraSetID);
int numPCs = 0;
Int32.TryParse(dr["CSNumPCs"].ToString(), out numPCs);
for (int i = 1; i <= numPCs; i++)
{
DataRow row = systemNames.NewRow();
string name = "CS" + cameraSetID + "M" + i;
row["SystemName"] = name;
row["CameraSet"] = cameraSetID;
row["Master"] = i - 1;
systemNames.Rows.Add(row);
}
}
}
return(systemNames);
}
