private void fill_drpdwn_User_Group_ID()
{
try
{
SqlConnection con = new SqlConnection(constr.getconstr());
SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Dept_Name", Drp_Dept.SelectedValue);
cmd.Parameters.AddWithValue("@User_ID", Session["User_ID"].ToString());
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Drp_User_Group.DataSource = ds.Tables[0];
Drp_User_Group.DataValueField = "UserGroup_Name";
Drp_User_Group.DataBind();
con.Close();
Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0"));
Drp_Exp.SelectedValue = "0";
Drp_Gender.SelectedValue = "0";
Drp_User_Type.SelectedValue = "0";
txt_Dt_of_Join.Text = "";
Chk_Lev1_Manager.Checked = false;
Chk_Lev2_Manager.Checked = false;
lblErrorMsg.Text = "";
}
catch (Exception ex)
{
lblErrorMsg.Text = "";
lblErrorMsg.Text = ex.Message;
}
}
private void fill_drpdwn_User_Group_ID()
{
try
{
SqlConnection con = new SqlConnection(constr.getconstr());
SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Project_Name", Drp_Project_Name.SelectedItem.Text);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Drp_User_Group.DataSource = ds.Tables[0];
Drp_User_Group.DataValueField = "UserGroup_Name";
Drp_User_Group.DataBind();
Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0"));
Drp_User_Group1.DataSource = ds.Tables[0];
Drp_User_Group1.DataValueField = "UserGroup_Name";
Drp_User_Group1.DataBind();
Drp_User_Group1.Items.Insert(0, new ListItem("--Select User Group--", "0"));
con.Close();
lblErrorMsg.Text = "";
}
catch (Exception ex)
{
lblErrorMsg.Text = "";
lblErrorMsg.Text = ex.Message;
}
}
private void fill_drpdwn_User_Group_ID()
{
try
{
SqlConnection con = new SqlConnection(constr.getconstr());
SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Get_UGByUser");
cmd.Parameters.AddWithValue("@Dept_Name", Drp_Dept.SelectedValue);
cmd.Parameters.AddWithValue("@User_ID", Session["User_ID"].ToString());
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Drp_User_Group.DataSource = ds.Tables[0];
Drp_User_Group.DataValueField = "UserGroup_Name";
Drp_User_Group.DataBind();
con.Close();
Drp_Exp.SelectedValue = "0";
lblErrorMsg.Text = "";
}
catch (Exception ex)
{
lblErrorMsg.Text = "";
lblErrorMsg.Text = ex.Message;
}
}
