public NomDetails readNominationDetails(string ID, string EmailID, int check, int sFinal = 0)
{
NomDetails objEnt = null;
objDataAccess = new SqlDataAccess(clsConstant.DBCONSTRING);
SqlDataReader reader = null;
try
{
if (objDataAccess.Connection.State == ConnectionState.Closed)
{
objDataAccess.Connection.Open();
}
if (check == 0)
{
if (EmailID == string.Empty || EmailID == null)
{
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@userID", ID),
new SqlParameter("@emailID", EmailID) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_NOMINATION_CHECK, CommandType.StoredProcedure, pram);
}
else
{
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@userID", ID),
new SqlParameter("@emailID", EmailID) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_NOMINATION_CHECK, CommandType.StoredProcedure, pram);
}
}
else
if (check == 1)
{
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@nominationID", ID), new SqlParameter("@remarksCheck", check) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_NOMINATED_LIST_DEA, CommandType.StoredProcedure, pram);
}
else
{
// CHECK VALUE IS 2 AND GET THE VENUE AND LAST DATE FROM IT
SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@nominationID", ID) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_NOMINATION_VENUE_LASTDATE, CommandType.StoredProcedure, pram);
}
while (reader.Read())
{
objEnt = new NomDetails();
if (check == 0)
{
objEnt.nomLisID = int.Parse(reader.GetValue(0).ToString());
objEnt.AgencyName = reader.GetValue(1).ToString();
objEnt.LoanNumberName = reader.GetValue(2).ToString();
objEnt.FirstName = reader.GetValue(3).ToString();
objEnt.LastName = reader.GetValue(4).ToString();
objEnt.Email = reader.GetValue(5).ToString();
objEnt.Telephone = reader.GetValue(6).ToString();
objEnt.Cellphone = reader.GetValue(7).ToString();
objEnt.Fax = reader.GetValue(8).ToString();
objEnt.justification = reader.GetValue(9).ToString();
objEnt.designation = reader.GetValue(10).ToString();
}
else
if (check == 1)
{
objEnt.remarks = reader.GetValue(0).ToString();
//Entity for Selected By ADB
object objslcByADB = reader.GetValue(1);
if (DBNull.Value == objslcByADB)
{
objEnt.slcByADB = 0;
}
else
{
objEnt.slcByADB = Convert.ToInt32(objslcByADB);
}
//Entity for Approved by DEA
object objslcByDEA = reader.GetValue(2);
if (DBNull.Value == objslcByDEA)
{
objEnt.aprvByDEA = 0;
}
else
{
objEnt.aprvByDEA = Convert.ToInt32(objslcByDEA);
}
//Entity for Final
object objIsFinal = reader.GetValue(3);
if (DBNull.Value == objIsFinal)
{
objEnt.isFinal = 0;
}
else
{
objEnt.isFinal = Convert.ToInt32(objIsFinal);
}
object objIsFinalS = reader.GetValue(4);
if (DBNull.Value == objIsFinalS)
{
objEnt.isFinalS = 0;
}
else
{
objEnt.isFinalS = Convert.ToInt32(objIsFinalS);
}
}
else
{
//Entity for Venue
objEnt.venue = reader.GetValue(0).ToString();
//Entity for LastDate
objEnt.lstDate = reader.GetValue(1).ToString();
objEnt.seatsCount = int.Parse(reader.GetValue(3).ToString());
objEnt.isClose = Convert.ToBoolean(reader.GetValue(4));
}
}
reader.Close();
return(objEnt);
}
catch (Exception exMessage)
{
throw exMessage;
}
}
private void readAllInfo(string userID, string emailID)
{
NomDetails objEnt = new NomDetails();
NominationDetails objNomDetail = new NominationDetails();
objEnt = objNomDetail.readNominationDetails(userID, emailID, 0);
if (objEnt != null)
{
lblMessage.Text = "Information Available in Database";
string agency = objEnt.AgencyName;
if (agency == "")
{
drpAgency.SelectedIndex = 0;
}
else
{
if (drpAgency.Items.FindByValue(agency) != null)
{
drpAgency.SelectedIndex = 0;
drpAgency.SelectedValue = agency;
}
else
{
lblMessage.Text = "You can nominate your agency person only";
return;
}
}
string loan = objEnt.LoanNumberName;
if (loan == "")
{
this.getLoan();
drpLoanNoName.SelectedIndex = 0;
}
else
{
this.getLoan();
if (drpLoanNoName.Items.FindByValue(loan) != null)
{
drpLoanNoName.SelectedValue = loan;
}
}
string designation = objEnt.designation;
txtDesignation.Text = designation;
txtNewCandidateName.Text = objEnt.FirstName;
txtLastName.Text = objEnt.LastName;
txtEmail.Text = objEnt.Email;
txtTelephone.Text = objEnt.Telephone;
txtMobileNo.Text = objEnt.Cellphone.ToString();
txtFaxNo.Text = objEnt.Fax.ToString();
txtJustification.Text = objEnt.justification.ToString();
btnUpdate.Enabled = true;
btnUpdate.Visible = true;
}
else
{
if (userID != "")
{
if (objEnt == null)
{
lblMessage.Text = "<b>Invalid Reference ID - Please Try Again";
string Entered_RefID = txtRefID.Text;
Utility objUtil = new Utility();
objUtil.ResetFormControl(this);
this.grdReset();
txtRefID.Text = Entered_RefID;
btnUpdate.Enabled = false;
btnUpdate.Visible = false;
}
}
else
{
lblMessage.Text = "";
}
}
}
private void readAllInfo(string userID, string emailID)
{
NomDetails objEnt = new NomDetails();
NominationDetails objNomDetail = new NominationDetails();
objEnt = objNomDetail.readNominationDetails(userID, emailID, 0);
if (objEnt != null)
{
// lblMessage.Text = "Information Available in Database";
string agency = objEnt.AgencyName;
if (agency == "")
{
drpAgency.SelectedIndex = 0;
}
else
{
if (drpAgency.Items.FindByValue(agency) != null)
{
drpAgency.SelectedIndex = 0;
drpAgency.SelectedValue = agency;
}
else
{
// lblMessage.Text = "You can nominate your agency person only";
return;
}
}
string loan = objEnt.LoanNumberName;
if (loan == "")
{
// this.getLoan();
drpLoanNoName.SelectedIndex = 0;
}
else
{
// this.getLoan();
if (drpLoanNoName.Items.FindByValue(loan) != null)
{
drpLoanNoName.SelectedIndex = 0;
drpLoanNoName.SelectedValue = loan;
}
}
string designation = objEnt.designation;
txtDesignation.Text = designation;
txtNewCandidateName.Text = objEnt.FirstName;
txtLastName.Text = objEnt.LastName;
txtEmail.Text = objEnt.Email;
txtTelephone.Text = objEnt.Telephone;
txtMobileNo.Text = objEnt.Cellphone.ToString();
txtFaxNo.Text = objEnt.Fax.ToString();
txtJustification.Text = objEnt.justification.ToString();
// btnUpdate.Enabled = true;
}
else
{
if (userID != "")
{
if (objEnt == null)
{
// lblMessage.Text = "<b>Invalid Reference ID - Please Try Again";
// lblError.Text = lblMessage.Text;
// ModalPopupExtender1.Show();
//btnUpdate.Enabled = false;
}
}
else
{
}
// lblMessage.Text = "";
}
}
