protected void Show()
{
if (dtShow == null)
{
dtShow = new DataTable();
}
if (dtShow.Rows != null)
{
dtShow.Rows.Clear();
}
FollowMeDBEntities ef = new FollowMeDBEntities();
dtAllStsation = new DataTable();
dtAllStsation.Columns.Add("id", typeof(int));
dtAllStsation.Columns.Add("station", typeof(string));
for (int i = 0; i < dtOrders.Rows.Count; i++)
{
DataRow dr = dtShow.NewRow();
DataRow dr1 = dtAllStsation.NewRow();
dr["process"] = dtOrders.Rows[i][2];
dr["color"] = dtOrders.Rows[i][3];
var reader = ef.ReadingSelect(Convert.ToInt32(dtOrders.Rows[i][0]));
}
Session["dtAllStsation"] = dtAllStsation;
gvSohw.DataSource = dtShow;
gvSohw.EmptyDataText = "There are currently no data to display";
gvSohw.PageSize = 5;
gvSohw.DataBind();
gvSohw.Visible = true;
Label3.Visible = false;
//tmrTime.Interval = 60000;
}
protected void View()
{
FollowMeDBEntities ef = new FollowMeDBEntities();
company = ef.company(txtName.Text).FirstOrDefault();
if (company == null)
{
ClientScript.RegisterStartupScript(GetType(),
"completed", "<SCRIPT LANGUAGE='javascript'>alert(' Company name does not exist in the database! ')</script>");
}
else
{
btnEnter.Visible = false;
Label4.Visible = false;
if (txtPass.Text == "")
{
txtPass.Text = Session["pass"] as string;
}
pass = (string)(ef.Pass(txtPass.Text, txtName.Text)).FirstOrDefault();
if (pass == null)
{
ClientScript.RegisterStartupScript(GetType(),
"", "<SCRIPT LANGUAGE='javascript'>alert(' Password is incorrect! ')</script>");
}
else
{
Session["company"] = txtName.Text;
if (Session["pass"] == null)
{
Session["pass"] = txtPass.Text;
}
phEnter.Visible = false;
List <Int32?> lOrderId = ef.OrderIdSelect(txtPass.Text, txtName.Text).ToList();
dtOrders = new DataTable();
dtOrders.Columns.Add("OrderId");
for (int i = 0; i < lOrderId.Count; i++)
{
dtOrders.Rows.Add(dtOrders.NewRow());
dtOrders.Rows[i][0] = lOrderId[0].Value;
}
dtOrders.Columns.Add("ProcessId");
dtOrders.Columns.Add("ProcessName");
dtOrders.Columns.Add("ColorId");
for (int i = 0; i < dtOrders.Rows.Count; i++)
{
dtOrders.Rows[i][1] = ef.ProcessIdSelect(Convert.ToInt32(dtOrders.Rows[i][0])).ToList()[0];
dtOrders.Rows[i][2] = ef.ProcessIdSelect(Convert.ToInt32(dtOrders.Rows[i][0])).ToList()[1];
dtOrders.Rows[i][3] = ef.ProcessIdSelect(Convert.ToInt32(dtOrders.Rows[i][0])).ToList()[2];
}
dtShow = new DataTable();
dtShow.Columns.Add("process", typeof(string));
dtShow.Columns.Add("color", typeof(string));
dtShow.Columns.Add("timeStart", typeof(string));
dtShow.Columns.Add("minutePast", typeof(string));
dtShow.Columns.Add("minuteEnd", typeof(string));
dtShow.Columns.Add("station", typeof(string));
dtShow.Columns.Add("nextStation", typeof(string));
dtShow.Columns.Add("status", typeof(string));
Session["dtShow"] = dtShow;
Session["dtOrders"] = dtOrders;
Label3.Visible = true;
tmrTime.Interval = 10000;
tmrTime.Enabled = true;
//tmrTime.Tick += new EventHandler<EventArgs>(tmrTime_Tick);
//this.Controls.Add(tmrTime);
//Show();
if (User.IsInRole("mannager") || User.IsInRole("employee"))
{
btnBack.Visible = true;
gvShowOwners.Visible = false;
Label5.Visible = false;
}
}
}
}
