public PlanMonitor()
{
InitializeComponent();
dataAccess = new DataAccess();
shifts = dataAccess.getShifts();
}
public ShiftCollection getShifts()
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
ShiftCollection shifts= new ShiftCollection();
String qry = String.Empty;
qry = @"SELECT * FROM shift where id <> 4 ORDER BY id";
SqlCommand cmd = new SqlCommand(qry, con);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
cmd.Dispose();
for (int i = 0; i < dt.Rows.Count; i++)
{
shifts.Add(new Shift((int)dt.Rows[i]["id"],(string)dt.Rows[i]["description"],
((TimeSpan) dt.Rows[i]["from"]),((TimeSpan) dt.Rows[i]["to"])));
}
con.Close();
con.Dispose();
return shifts;
}
public Window1()
{
InitializeComponent();
timertick = Convert.ToDouble(ConfigurationSettings.AppSettings["TIMERTICK"]);
customerLogoPath = ConfigurationSettings.AppSettings["Customer_Logo"];
string MonitorEnable = ConfigurationSettings.AppSettings["Monitor_Enabled"];
if (MonitorEnable == "Yes")
{
LineMonitor.Visibility = Visibility.Visible;
}
string quantityEnable = ConfigurationSettings.AppSettings["Quantity_Enabled"];
if (quantityEnable == "Yes")
{
LineStatsGrid.Columns[1].Visibility = Visibility.Visible;
LineStatsGrid.Columns[2].Visibility = Visibility.Visible;
}
issueMarqueeSpeed = Convert.ToDouble(ConfigurationSettings.AppSettings["ISSUE_MARQUEE_SPEED"]);
messageMarqueeSpeed = Convert.ToDouble(ConfigurationSettings.AppSettings["MESSAGE_MARQUEE_SPEED"]);
try
{
//customerLogo.Source = new BitmapImage(new Uri(customerLogoPath,UriKind.RelativeOrAbsolute));
dataAccess = new DataAccess();
dpFrom.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
catch (SqlException s)
{
MessageBox.Show("Unable to Connect to DataBase ", "ERROR",
MessageBoxButton.OK, MessageBoxImage.Error);
Application.Current.Shutdown();
}
lines = new String[3];
lines[0] = ConfigurationSettings.AppSettings["Lines_List_1"];
lines[1] = ConfigurationSettings.AppSettings["Lines_List_2"];
lines[2] = ConfigurationSettings.AppSettings["Lines_List_3"];
lineInfoTable = new DataTable[3];
lineInfoTable[0] = dataAccess.getProductionLineInfo(lines[0]);
lineInfoTable[1] = dataAccess.getProductionLineInfo(lines[1]);
lineInfoTable[2] = dataAccess.getProductionLineInfo(lines[2]);
linesInfoTable = dataAccess.getProductionLineInfo();
cmbProductionLineSelector.DataContext = linesInfoTable;
shifts = dataAccess.getShifts();
foreach (Shift s in shifts)
{
s.Sessions = dataAccess.getSessions(s.ID);
}
lineStatus = new LineStatusCollection[3];
for (int i = 0; i < 3; i++)
{
lineStatus[i] = new LineStatusCollection();
}
for (int j = 0; j < 3; j++)
{
for (int i = 0; i < lineInfoTable[j].Rows.Count; i++)
{
lineStatus[j].Add(new LineStatus((String)lineInfoTable[j].Rows[i]["description"],
(int)lineInfoTable[j].Rows[i]["id"]));
}
}
marqueeAnimation = new DoubleAnimation();
//marqueeAnimation.Completed += new EventHandler(marqueeAnimation_Completed);
issueMarqueeAnimation = new DoubleAnimation();
issueMarqueeAnimation.Completed += new EventHandler(issueMarqueeAnimation_Completed);
appTimer = new System.Timers.Timer(10);
appTimer.Elapsed += new System.Timers.ElapsedEventHandler(appTimer_Elapsed);
appTimer.AutoReset = false;
appTimer.Start();
TBLine.SelectedIndex = 1;
tbIssueMarquee_Loaded();
cmbShiftSelector.DataContext = shifts;
}
public StartPage()
{
try
{
InitializeComponent();
//_dbConnectionString = "Data Source=SAMBRAHMA\\SQLEXPRESS;database=IAS_Schneider;User id=sa; Password=mei123$%^;";
_dbConnectionString = ConfigurationSettings.AppSettings["DBConStr"];
string lineList = ConfigurationSettings.AppSettings["LINES"];
whID = Convert.ToInt32(ConfigurationSettings.AppSettings["WH_ID"]);
DataAccess.conStr = _dbConnectionString;
MainMenu _mainMenu = new MainMenu(_dbConnectionString);
_mainFrame.Navigate(_mainMenu);
dataAccess = new DataAccess();
lines = dataAccess.getLines();
lineQ = new Queue<int>();
String[] linesLst = separateCommandData(lineList);
foreach (line l in lines)
{
foreach (String s in linesLst)
{
if (l.ID == Convert.ToInt32(s))
{
lineQ.Enqueue(l.ID);
}
}
}
departmentTable = dataAccess.getDepartmentInfo("");
departmentQ = new Queue<int>();
for (int i = 0; i < departmentTable.Rows.Count; i++)
departmentQ.Enqueue((int)departmentTable.Rows[i]["id"]);
andonManager = new AndonManager(lineQ,departmentQ,AndonManager.MODE.MASTER);
shifts = dataAccess.getShifts();
contacts = dataAccess.getContacts();
xmlSerializer = new XmlSerializer(typeof(AndonAlertEventArgs));
serverType = ConfigurationSettings.AppSettings["ServerType"];
dataAccess.updateIssueMarquee();
commandTimer = new System.Timers.Timer(3 * 1000);
commandTimer.Elapsed += new System.Timers.ElapsedEventHandler(commandTimer_Elapsed);
commandTimer.AutoReset = false;
commandTimer.Start();
Issues = new Dictionary<int, Issue>();
timeout = dataAccess.getEscalationTimeout();
andonManager.andonAlertEvent += new EventHandler<AndonAlertEventArgs>(andonManager_andonAlertEvent);
andonManager.start();
}
catch( Exception e)
{
tbMsg.Text+= e.Message;
}
}
public ShiftTests()
{
_collection = new ShiftCollection(_mockHandler.Object);
}
public Monitor(Contact c )
{
try
{
timertick = Convert.ToDouble(ConfigurationSettings.AppSettings["TIMERTICK"]);
dataAccess = new DataAccess();
dt = dataAccess.GetOpenIssues();
shifts = dataAccess.getShifts();
foreach (Shift s in shifts)
{
s.Sessions = dataAccess.getSessions(s.ID);
}
lines = c.getLineAssociation();
lineInfoTable = dataAccess.getProductionLineInfo(lines);
lineStatus = new LineStatusCollection();
for (int i = 0; i < lineInfoTable.Rows.Count; i++)
{
lineStatus.Add(new LineStatus((String)lineInfoTable.Rows[i]["description"],
(int)lineInfoTable.Rows[i]["id"]));
}
appTimer = new System.Timers.Timer(10);
appTimer.Elapsed += new System.Timers.ElapsedEventHandler(appTimer_Elapsed);
appTimer.AutoReset = false;
InitializeComponent();
foreach (DepartmentAssociationInfo d in c.DepartmentAssociation)
{
if (d.IsAssociated == false)
LineStatsGrid.Columns[d.ID+2].Visibility = Visibility.Hidden;
}
appTimer.Start();
}
catch (SqlException s)
{
MessageBox.Show("DataBase Error ", "ERROR",
MessageBoxButton.OK, MessageBoxImage.Error);
Application.Current.Shutdown();
}
}
public Window1()
{
InitializeComponent();
timertick = Convert.ToDouble(ConfigurationSettings.AppSettings["TIMERTICK"]);
customerLogoPath = ConfigurationSettings.AppSettings["Customer_Logo"];
string MonitorEnable = ConfigurationSettings.AppSettings["Monitor_Enabled"];
if (MonitorEnable == "Yes")
{
LineMonitor.Visibility = Visibility.Visible;
}
string quantityEnable = ConfigurationSettings.AppSettings["Quantity_Enabled"];
if (quantityEnable == "Yes")
{
LineStatsGrid.Columns[1].Visibility = Visibility.Visible;
LineStatsGrid.Columns[2].Visibility = Visibility.Visible;
}
issueMarqueeSpeed = Convert.ToDouble(ConfigurationSettings.AppSettings["ISSUE_MARQUEE_SPEED"]);
messageMarqueeSpeed = Convert.ToDouble(ConfigurationSettings.AppSettings["MESSAGE_MARQUEE_SPEED"]);
try
{
//customerLogo.Source = new BitmapImage(new Uri(customerLogoPath,UriKind.RelativeOrAbsolute));
dataAccess = new DataAccess();
dpFrom.Text = DateTime.Now.ToShortDateString();
}
catch (SqlException s)
{
MessageBox.Show("Unable to Connect to DataBase ", "ERROR",
MessageBoxButton.OK, MessageBoxImage.Error);
Application.Current.Shutdown();
}
lines = new String[3];
lines[0] = ConfigurationSettings.AppSettings["Lines_List_1"];
lines[1] = ConfigurationSettings.AppSettings["Lines_List_2"];
lines[2] = ConfigurationSettings.AppSettings["Lines_List_3"];
lineInfoTable = new DataTable[3];
lineInfoTable[0] = dataAccess.getProductionLineInfo(lines[0]);
lineInfoTable[1] = dataAccess.getProductionLineInfo(lines[1]);
lineInfoTable[2] = dataAccess.getProductionLineInfo(lines[2]);
linesInfoTable = dataAccess.getProductionLineInfo();
cmbProductionLineSelector.DataContext = linesInfoTable;
shifts = dataAccess.getShifts();
foreach (Shift s in shifts)
{
s.Sessions = dataAccess.getSessions(s.ID);
}
lineStatus = new LineStatusCollection[3];
for (int i = 0; i < 3; i++)
{
lineStatus[i] = new LineStatusCollection();
}
for (int j = 0; j < 3; j++)
{
for (int i = 0; i < lineInfoTable[j].Rows.Count; i++)
{
lineStatus[j].Add(new LineStatus((String)lineInfoTable[j].Rows[i]["description"],
(int)lineInfoTable[j].Rows[i]["id"]));
}
}
marqueeAnimation = new DoubleAnimation();
//marqueeAnimation.Completed += new EventHandler(marqueeAnimation_Completed);
issueMarqueeAnimation = new DoubleAnimation();
issueMarqueeAnimation.Completed += new EventHandler(issueMarqueeAnimation_Completed);
appTimer = new System.Timers.Timer(10);
appTimer.Elapsed += new System.Timers.ElapsedEventHandler(appTimer_Elapsed);
appTimer.AutoReset = false;
appTimer.Start();
TBLine.SelectedIndex = 1;
tbIssueMarquee_Loaded();
cmbShiftSelector.DataContext = shifts;
}
