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 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(); }