protected void Page_Load(object sender, EventArgs e)
{
try
{
objConsultantDetails = new ConsultantDetails();
objEnt = new clsEntConsultantDetails();
iConsDetailsID = Request.QueryString["ConsultantID"];
if (!IsPostBack)
{
txtStartDate.Text = DateTime.Today.ToString(clsConstant.DATE_FORMAT);
if (Utility.CheckAccess("ConsultantDetailsAddEdit") == false)
{
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
// Function Binding FirmId into the DropDown Menu
if (iConsDetailsID != null)
{
objEnt = objConsultantDetails.readerForConsultantDetails(int.Parse(iConsDetailsID));
txtFirstName.Text = objEnt.FirstName;
txtLastName.Text = objEnt.LastName;
txtDateOfBirth.Text = objEnt.DateOfBirth;
txtStartDate.Text = objEnt.StartDate;
txtEndDate.Text = objEnt.EndDate;
}
}
if (iConsDetailsID != null)
{
btnSubmit.Visible = false;
btnReset.Visible = true;
btnUpdate.Visible = true;
}
else
{
btnSubmit.Visible = true;
btnReset.Visible = true;
btnUpdate.Visible = false;
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
///<summary>
/// Function for Data reader, returning Entities
///</summary>
public clsEntConsultantDetails readerForConsultantDetails(int consultantID)
{
clsEntConsultantDetails objEnt = new clsEntConsultantDetails();
SqlDataReader reader;
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@consultantID", consultantID) };
reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_CONSULTANT_MASTER_CHECK, CommandType.StoredProcedure, pram);
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
objEnt.ConsultantID = Convert.ToInt32(reader.GetValue(0));
}
if (!reader.IsDBNull(1))
{
objEnt.FirstName = reader.GetValue(1).ToString();
}
if (!reader.IsDBNull(2))
{
objEnt.LastName = reader.GetValue(2).ToString();
}
if (!reader.IsDBNull(3))
{
objEnt.DateOfBirth = Convert.ToDateTime(reader.GetValue(3)).ToString(clsConstant.DATE_FORMAT);
}
if (!reader.IsDBNull(4))
{
objEnt.StartDate = Convert.ToDateTime(reader.GetValue(4)).ToString(clsConstant.DATE_FORMAT);
}
if (!reader.IsDBNull(5))
{
objEnt.EndDate = Convert.ToDateTime(reader.GetValue(5)).ToString(clsConstant.DATE_FORMAT);
}
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
}
