public clsEntDesignationDetails readerforDesignationDetails(int designationID)
{
clsEntDesignationDetails objEnt = new clsEntDesignationDetails();
SqlDataReader reader;
try
{
if (objDataAccess.Connection.State == ConnectionState.Closed)
{
objDataAccess.Connection.Open();
}
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@designationID", designationID) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_DESIGNATION_CHECK, CommandType.StoredProcedure, pram);
while (reader.Read())
{
objEnt.DesigntionName = reader.GetValue(0).ToString();
objEnt.AgencyId = int.Parse(reader.GetValue(1).ToString());
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
desigID = Request.QueryString["desigID"];
agencyID = Request.QueryString["agencyID"];
if (!IsPostBack)
{
if (Utility.CheckAccess("DesignationDetailsAddEdit") == false)
{
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
if (desigID != null)
{
btnSubmit.Visible = false;
btnReset.Visible = false;
if (IsPostBack != true)
{
objEnt = objDesignationDetails.readerforDesignationDetails(int.Parse(desigID));
txtDesigName.Text = objEnt.DesigntionName;
drpAgencyBind.DataSource = objComm.getDropDownList(clsConstant.SP_GET_AGENCY, null);
drpAgencyBind.DataTextField = "DisplayFieldText";
drpAgencyBind.DataValueField = "ValueFieldText";
drpAgencyBind.DataBind();
drpAgencyBind.SelectedValue = objEnt.AgencyId.ToString();
}
}
else
{
if (IsPostBack == false)
{
btnUpdate.Visible = false;
btnCancelUpdate.Visible = false;
drpAgencyBind.DataSource = objComm.getDropDownList(clsConstant.SP_GET_AGENCY, null);
drpAgencyBind.DataTextField = "DisplayFieldText";
drpAgencyBind.DataValueField = "ValueFieldText";
drpAgencyBind.DataBind();
}
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
