private void btnLogin_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
String Passcode;
SqlConnection con = new SqlConnection();
con.ConnectionString = Properties.Settings.Default.PointOfSaleConString;
con.Open();
SqlDataAdapter cmd = new SqlDataAdapter("SELECT Passcode FROM [Employee] WHERE Passcode = @pass", con);
cmd.SelectCommand.Parameters.AddWithValue("@pass", txtPassCode.Text);
cmd.Fill(dt);
if (dt.Rows.Count > 0)
{
StaffUserPanel StaffPanel = new StaffUserPanel();
StaffPanel.Show();
}
con.Close();
}
}//btnEncode_Click
private void btnGenerateNumber_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
Random random = new Random();
int voucherNumber = random.Next(1000, 1000000);
SqlConnection con = new SqlConnection();
con.ConnectionString = Properties.Settings.Default.PointOfSaleConString;
con.Open();
SqlDataAdapter cmd = new SqlDataAdapter(("SELECT VoucherNumber from Voucher Where VoucherNumber = @Voucher", con);
cmd.Parameters.AddWithValue("@Voucher", voucherNumber);
cmd.ExecuteScalar();
cmd.Fill(dt);
if (dt.Rows.Count > 0)
{
StaffUserPanel StaffPanel = new StaffUserPanel();
StaffPanel.Show();
}
}
public frmLookupItem(StaffUserPanel LookupItem)
{
InitializeComponent();
this.LookupItem = LookupItem;
}
public frmCashPayment(StaffUserPanel GetTotal)
{
InitializeComponent();
this.GetTotal = GetTotal;
}
