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