Scenario:
I have 4 different dropdownlists for different purposes.
1st to get the Employee names and email addresses.
"DATATEXTFIELD = Detail(emp_code, Empnames) and DATAVALUEFIELD = email"
2nd to get the Employee authority names.
"DATATEXTFIELD = Empnames and DATAVALUEFIELD = emp_code"
3rd to get the Employee names only.
"DATATEXTFIELD = Detail(emp_code, Empnames) and DATAVALUEFIELD = emp_code"
4th to get the Priority Levels(LOW,NORMAL,HIGH,CRITICAL) only.
"DATATEXTFIELD = priorflag_desc and DATAVALUEFIELD = priorflag_id"
All I need to create a single method in another class(EXEMPCLASS.CS) and to call this method in my main class(ACCOUNT.CS) to use for every dropdownlist...
Currently I am using this thing without overloading method.
HOW TO CREATE A PERFECT SINGLE METHOD FOR ALL THESE DROPDOWNS..
here is my code..
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (HttpContext.Current.Session["empcode"] != null)
{
getauthoptions(Session["empcode"].ToString());
}
prioritydatabinding();
empemailbind();
popdata();
}
}
protected void popdata()
{
DataTable adp = new DataTable();
OracleConnection dbConn = Conn.getConnection();
string query = "select emp_code, (empname '-' emp_code)detail from TABLE1";
OracleCommand cmd = new OracleCommand(query, dbConn);
dbConn.Open();
OracleDataAdapter dr = new OracleDataAdapter(cmd);
dr.Fill(adp);
DropDownList4.DataSource = adp;
DropDownList4.DataTextField = "detail";
DropDownList4.DataValueField = "emp_code";
DropDownList4.DataBind();
dbConn.Close();
}
protected void empemailbind()
{
DataTable adp3 = new DataTable();
OracleConnection dbConn = Conn.getConnection();
string query3 = "select email, (empname '-' emp_code)detail from TABLE1";
OracleCommand cmd3 = new OracleCommand(query3, dbConn);
dbConn.Open();
OracleDataAdapter dr3 = new OracleDataAdapter(cmd3);
dr3.Fill(adp3);
DropDownList2.DataSource = adp3;
DropDownList2.DataTextField = "detail";
DropDownList2.DataValueField = "email";
DropDownList2.DataBind();
dbConn.Close();
}
protected void prioritydatabinding()
{
DataTable adp2 = new DataTable();
OracleConnection dbConn = Conn.getConnection();
string query2 = "select priorflag_id, priorflag_desc from TABLE2";
OracleCommand cmd2 = new OracleCommand(query2, dbConn);
dbConn.Open();
OracleDataAdapter dr2 = new OracleDataAdapter(cmd2);
dr2.Fill(adp2);
priority0.DataSource = adp2;
priority0.DataTextField = "priorflag_desc";
priority0.DataValueField = "priorflag_id";
priority0.DataBind();
dbConn.Close();
}
protected void getauthoptions(string empcode)
{
DataTable adp4 = new DataTable();
OracleConnection dbConn = Conn.getConnection();
string query4 = "select EMP_CODE, olphrm.get_name(emp_code) empname from TABLE1, TABLE3 where EMP_CODE = AUTHPARENT_ID and USER_ID=" + empcode + " order by 2";
OracleCommand cmd4 = new OracleCommand(query4, dbConn);
dbConn.Open();
OracleDataAdapter dr4 = new OracleDataAdapter(cmd4);
dr4.Fill(adp4);
DropDownList3.DataSource = adp4;
DropDownList3.DataTextField = "empname";
DropDownList3.DataValueField = "emp_code";
DropDownList3.DataBind();
dbConn.Close();
}
PLEASE HELP.....Code is working fine as dropdowns are getting filled perfectly but want to use this in a single Overload method.
Thanks.