public void binddropdown()
{
gf.fillcombo("select * from customer", drpcustid, "f_name", "cust_id", "--select id--");
gf.fillcombo("select * from branch_master", drpbranchid, "branch_name", "branch_id", "--select branch--");
gf.fillcombo("select * from account_type_master", drpaccounttypeid, "account_type_name", "account_type_id", "--select account_type--");
//gf.fillcombo("select f_name+ ' '+m_name+' '+l_name 'name' ,account_no from account_master,customer where customer.cust_id=account_master.cust_id", drpaccountno, "name", "account_no", "--select customer--");
// gf.fillcombo("select * from account_master", , "account_no", "account_no", "--select no--");
}
void binddropdown()
{
try
{
gf.fillcombo("select City_Id,City_Name from City_M", ddlcity, "City_Name", "City_Id", "select");
gf.fillcombo("select securityqueid,securitytext from Securityque_M", ddlquestionid, "securitytext", "securityqueid", "select");
}
catch
{
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select City_Id,City_Name from City_M", ddlcityid, "City_Name", "City_Id", "select");
gf.fillcombo("select Hotel_Id,Hotel_Name from Hotel_M", ddlhotelid, "Hotel_Name", "Hotel_Id", "select");
}
catch
{
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select");
gf.fillcombo("select Bus_Id,Bus_Name from Bus_M", ddlbusid, "Bus_Name", "Bus_Id", "select");
gf.fillcombo("select Train_Id,Train_No from Train_M", ddltrainid, "Train_No", "Train_Id", "select");
gf.fillcombo("select Plane_Id,Plane_Name from Plane_M", ddlplaneid, "Plane_Name", "Plane_Id", "select");
gf.fillcombo("select Car_Id,Car_Name from Car_M", ddlcarid, "Car_Name", "Car_Id", "select");
}
catch
{
}
}
void binddropdown()
{
try
{
gf.fillcombo("select State_Id,State_Name from State_M", ddlstatename, "State_Name", "State_Id", "select");
}
catch
{
}
}
public void binddropdown()
{
drprequest.Items.Clear();
if (drpcheque.SelectedValue.ToString().ToLower() == "c")
{
gf.fillcombo("Select * from chequebook_transaction where status=0", drprequest, "account_no", "account_no", "select chequebook_transaction");
}
else if (drpcheque.SelectedValue.ToString().ToLower() == "p")
{
gf.fillcombo("Select * from passbook_transaction where status=0", drprequest, "account_no", "account_no", "select passbook_transaction");
}
else if (drpcheque.SelectedValue.ToString().ToLower() == "D")
{
gf.fillcombo("Select * from demanddraft_transaction where status=0", drprequest, "account_no", "account_no", "select demanddraft_transaction");
}
else if (drpcheque.SelectedValue.ToString().ToLower() == "CL")
{
gf.fillcombo("Select * from customer_loan where status=0", drprequest, "account_no", "account_no", "select customer_loan");
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select");
}
catch
{
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Customer_Id,First_Name from Customer_M where email = '" + Session["Email"].ToString() + "'", ddlcustomerid, "First_Name", "Customer_Id", "select");
gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select");
DataSet ds = new DataSet();
ds = cn.select("select * from Package_M where Package_Id='" + ddlpackageid.SelectedValue + "'");
Double amt = Convert.ToDouble(ds.Tables[0].Rows[0]["Price"].ToString());
lblamt.Text = amt.ToString();
// gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select");
}
catch
{
}
}
public void binddropdown()
{
gf.fillcombo("select * from country_master", drpcountry, "country_name", "country_id", "--select country--");
}
public void binddropdown()
{
gf.fillcombo("select * from employee_master", drpemp_id, "f_name", "emp_id", "--select employee Id--");
gf.fillcombo("select f_name+ ' '+m_name+' '+l_name 'name' ,account_no from account_master,customer where customer.cust_id=account_master.cust_id", drpaccountno, "name", "account_no", "--select employee Id--");
}
public void binddropdown()
{
gf.fillcombo("select * from city_master", drpcity_id, "city_name", "city_id", "--select city--");
gf.fillcombo("select * from branch_master", drpbranch_id, "branch_name", "branch_id", "--select branch--");
}
public void binddropdown()
{
gf.fillcombo("select * from employee_master", drpempid, "f_name", "emp_id", "--select employee Id--");
}
public void binddropdown()
{
gf.fillcombo("select * from state_master", drpstate, "state_name", "state_id", "--select country--");
}
public void binddropdown()
{
gf.fillcombo("select * from security_master", drpaecqid, "s_q_que", "s_q_id", "--select question--");
}
public void binddropdown()
{
gf.fillcombo("select * from payback_master", drppayback_id, "payback_id", "payback_id", "--select payback--");
}