public void getdetail(string name, string city, MainInternal internalData)
{
DataTable max_id = internalData.customer.get(new e_columns[] { e_columns.e_id }, e_db_operation.e_getAll, string.Format("name = '{0}' and city = '{1}'", name, city));
if (max_id.Rows.Count == 0 || (name.Trim() == "" && city.Trim() == ""))
{
txt_acntname.Text = name;
cmb_city.Text = city;
cmb_acnttype.Text = "CUSTOMER";
txt_openbal.Focus();
txt_openbal.Select();
return;
}
DataTable dt = internalData.customer.get(new e_columns[] { e_columns.e_name,
e_columns.e_note,
e_columns.e_address,
e_columns.e_city,
e_columns.e_pincode,
e_columns.e_phno_1,
e_columns.e_phno_2,
e_columns.e_openbalance,
e_columns.e_debcredit,
e_columns.e_date,
e_columns.e_type,
e_columns.e_accounttype,
e_columns.e_accountnumber,
e_columns.e_id },
e_db_operation.e_getAll,
string.Format("name = '{0}' and city = '{1}'", name, city));
txt_acntname.Text = dt.Rows[0][0].ToString();
//string abc = comboBox4.Text;
cmb_city.Text = dt.Rows[0][3].ToString();
//comboBox4.Text = abc;
txt_openbal.Text = dt.Rows[0][7].ToString();
dtp_balancedate.Text = dt.Rows[0][9].ToString();
txt_address.Text = dt.Rows[0][2].ToString();
txt_pincode.Text = dt.Rows[0][4].ToString();
txt_phno_1.Text = dt.Rows[0][5].ToString();
txt_phno_2.Text = dt.Rows[0][6].ToString();
txt_note.Text = dt.Rows[0][1].ToString();
txt_bank_acnt_no.Text = dt.Rows[0][12].ToString();
cmb_acnttype.Text = dt.Rows[0][10].ToString();
cmb_bank_acnt_type.Text = dt.Rows[0][11].ToString();
lblid.Text = dt.Rows[0][13].ToString();
splt_customer_search.Visible = true;
btn_save.Text = "Update";
txt_acntname.ReadOnly = true;
cmb_city.Enabled = false;
}
public ListManualBills(MainInternal t_internalData)
{
InitializeComponent();
internalData = t_internalData;
}
