private void CCMSearchbtn_Click(object sender, EventArgs e)
{
string CCM = Machinetxt.Text;
string CCM_Querystr = "select CCMID from CCM where CCMID=@ID";
SqlCommand CCMQ_Query = new SqlCommand(CCM_Querystr, con);
CCMQ_Query.Parameters.AddWithValue("@ID", CCM);
SqlDataAdapter da = new SqlDataAdapter(CCMQ_Query);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
if (Machinetxt.Text.Count() < 9)
{
CCMpanel.Show();
ABCPanel.Hide();
CCMID = Machinetxt.Text;
}
else
{
ABCPanel.Show();
CCMpanel.Hide();
CCM_ABCID = Machinetxt.Text;
}
}
else
{
MessageBox.Show("Incorrect Machine Number, Try Again");
}
}
private void button1_Click(object sender, EventArgs e)
{
foreach (Usuario registro in Lusuarios)
{
if (tbUsuario.Text == registro.id && tbpass.Text == registro.password)
{
MessageBox.Show("Bienvenido");
LogInPanel.Hide();
ABCPanel.Show();
return;
}
}
MessageBox.Show("Nombre de usuario O contraseña incorrectos");
}
private void Cashier_Load(object sender, EventArgs e)
{
//Session Connection
SqlCommand session_query = new SqlCommand("insert into Session(Date, UserID, ShortDate) values(@d, @u, @sd)", con);
session_query.Parameters.AddWithValue("@d", nowSession);
session_query.Parameters.AddWithValue("@sd", DateTime.Today.ToShortDateString());
session_query.Parameters.AddWithValue("@u", Convert.ToInt16(loggedIn_lbl.Text));
session_query.ExecuteNonQuery();
SqlCommand session_get = new SqlCommand("select SessionID from Session where Date=@d and UserID = @u", con);
session_get.Parameters.AddWithValue("@d", nowSession);
session_get.Parameters.AddWithValue("@u", Convert.ToInt16(loggedIn_lbl.Text));
sessionID = (int)session_get.ExecuteScalar();
SessionID_lbl.Text = sessionID.ToString();
datetoday_lbl.Text = DateTime.Today.ToShortDateString();
ABCPanel.Hide();
CCMpanel.Hide();
}
