private void button1_Click(object sender, EventArgs e)
{
//instantiate the tax form
frmUpdateTax updateTax = new frmUpdateTax();
updateTax.ShowDialog();
//function as fresh
selectClass = new clsSelect();
selectClass.selectTAx(dataGridView1);
}
private void cboSelectCurrency_SelectedIndexChanged(object sender, EventArgs e)
{
selectClass = new clsSelect();
// selectClass.selectCurrencyUsedToLabel(lblConverTo, cboSelectCurrency);
//selectClass.selectCurrencyUsedToLabel(lblcustCurrency, cboSelectCurrency);
lblcustCurrency.Text = cboSelectCurrency.Text;
// lblCurcsonvertFrom.Text = lblcustCurrency.Text;
//lblGetSymbol.Text = lblcustCurrency.Text;
label15.Text = lblcustCurrency.Text;
// lblUsedCurr.Text = lblUsedCurrency.Text;
}
/// <summary>
/// pull details by id
/// </summary>
void selectDetails()
{
try
{
clsSelect selectClass = new clsSelect();
string sql = "select proName,prodTypeName,proType, proDescrip,tax_1,tax_2,tax_3,proPrice, tax_1Amt,tax_2Amt,tax_3Amt, proNetPrice from tblProducts where Convert(varchar,prodID)='" + txtID.Text.Trim() + "'";
SqlConnection con = new SqlConnection(selectClass.dbPath);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
txtProdName.Text = reader["proName"].ToString();
cboProductType.Text = reader["prodTypeName"].ToString();
cboProSubCate.Text = reader["proType"].ToString();
txtProdDecs.Text = reader["proDescrip"].ToString();
txtTax1percsentage.Text = reader["tax_1"].ToString();
txtTax2percsentage.Text = reader["tax_2"].ToString();
txtTax3percsentage.Text = reader["tax_3"].ToString();
txtProdPrice.Text = reader["proPrice"].ToString();
txtTax1Amt.Text = reader["tax_1Amt"].ToString();
txtTax2Amt.Text = reader["tax_2Amt"].ToString();
txtTax3Amt.Text = reader["tax_3Amt"].ToString();
txtNetAmt.Text = reader["proNetPrice"].ToString();
}
else
{
txtID.Text = "";
txtProdName.Text = "";
//cboProductType.SelectedIndex = 0;
// cboProSubCate.SelectedIndex = 0;
txtProdDecs.Text = "";
txtTax1percsentage.Text = "";
txtTax2percsentage.Text = "";
txtTax3percsentage.Text = "";
txtProdPrice.Text = "";
txtTax1Amt.Text = "";
txtTax2Amt.Text = "";
txtTax3Amt.Text = "";
txtNetAmt.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show("The " + ex.Message);
}
}
/// <summary>
/// pull details by id
/// </summary>
void selectDetails()
{
try
{
clsSelect selectClass = new clsSelect();
string sql = "select fname,lname,oname,gender,dob,phone,resAddress,emailAdd,ref_fname,ref_lname,ref_phone,photo from tblEmployee where empID='" + textBox1.Text + "'";
SqlConnection con = new SqlConnection(selectClass.dbPath);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
txtFname.Text = reader["fname"].ToString();
txtLname.Text = reader["lname"].ToString();
txtOname.Text = reader["oname"].ToString();
cboGender.Text = reader["gender"].ToString();
dptBDay.Text = reader["dob"].ToString();
txtPhone.Text = reader["phone"].ToString();
txtResAddress.Text = reader["resAddress"].ToString();
txtEmail.Text = reader["emailAdd"].ToString();
txtRFname.Text = reader["ref_fname"].ToString();
txtRLname.Text = reader["ref_lname"].ToString();
txtRPhone.Text = reader["ref_phone"].ToString();
MemoryStream ms = new MemoryStream((byte[])reader["photo"]);
PicEmp.Image = new Bitmap(ms);
}
else
{
clearAll();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmSettlement_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
errorProvider1.SetError(txtAmtPAid, "Enter Amount to be paid");
cboPaymentType.SelectedIndex = 0;
selectClass = new clsSelect();
//get the methods from the select class
// selectClass.addCurrencyToComboBox(cboSelectCurrency);
// selectClass.addCurrencyToComboBox(cboPOSCurrency);
// selectClass.selectCurrencyUsedToComboBox(cboPaymentType);
//selectClass.selectCurrencyUsedFromLabel(lblCurcsonvertFrom, "Inused");
// selectClass.addElectronicCurrencyToComboBox(posEelectronicType);
// selectClass.selectCurrencyUsedToLabel(lblConverTo, cboSelectCurrency);
// selectClass.selectInitialCurrencyUsedToComboBox(cboSelectCurrency);
//selectClass.selectCurrencyUsedFromLabel(lblUsedCurrency, "Inused");
// lblGetSymbol.Text = lblcustCurrency.Text;
// lblUsedCurr.Text = lblUsedCurrency.Text;
btnCashout.Enabled = false;
}
private void frmViewTax_Load(object sender, EventArgs e)
{
selectClass = new clsSelect();
selectClass.selectTAx(dataGridView1);
}
