public clsEntFirmDetails readerForFirmDetail(int firmID, string firmName)
{
clsEntFirmDetails objEnt = new clsEntFirmDetails();
SqlDataReader reader;
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
if (firmID != 0)
{
firmName = "";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@firmid", firmID), new SqlParameter("@firmName", firmName) };
reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_FIRM_DETAILS_CHECK, CommandType.StoredProcedure, param);
}
else
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@firmid", firmID), new SqlParameter("@firmName", firmName) };
reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_FIRM_DETAILS_CHECK, CommandType.StoredProcedure, param);
}
while (reader.Read())
{
objEnt.FirmID = Convert.ToInt32(reader.GetValue(0));
objEnt.FirmName = reader.GetValue(1).ToString();
objEnt.ContactPerson = reader.GetValue(2).ToString();
objEnt.Telephone = reader.GetValue(3).ToString();
objEnt.Cellphone = reader.GetValue(4).ToString();
objEnt.Adress = reader.GetValue(5).ToString();
objEnt.Postalcode = reader.GetValue(6).ToString();
string dtStartDate = reader.GetValue(7).ToString();
string dtEndDate = reader.GetValue(8).ToString();
if (dtStartDate == "" || dtStartDate == "01 Jan 1900")
{
objEnt.StartDate = "";
}
else
{
objEnt.StartDate = dtStartDate;
}
if (dtEndDate == "" || dtEndDate == "01 Jan 1900")
{
objEnt.EndDate = "";
}
else
{
objEnt.EndDate = dtEndDate;
}
objEnt.EmailID = reader.GetValue(9).ToString();
//objEnt.Sector = Convert.ToInt32(reader.GetValue(10).ToString());
objEnt.Sector = reader.GetValue(10).ToString() == "" ? 0 : Convert.ToInt32(reader.GetValue(10).ToString());
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
private void fillAllInfo(int firmID, string firmName)
{
try
{
if (firmID != 0)
{
objEnt = objFirmDtls.readerForFirmDetail(firmID, null);
}
else
{
objEnt = objFirmDtls.readerForFirmDetail(0, firmName);
}
if (objEnt.FirmName != null)
{
txtAdress.Text = objEnt.Adress;
txtCellphone.Text = objEnt.Cellphone;
txtTelephone.Text = objEnt.Telephone;
txtContactPerson.Text = objEnt.ContactPerson;
txtPostalcode.Text = objEnt.Postalcode;
txtFirmName.Text = objEnt.FirmName;
if (objEnt.StartDate != null)
{
if (objEnt.StartDate != "")
{
DateTime dtstartdate = DateTime.Parse(objEnt.StartDate);
txtStartDate.Text = dtstartdate.ToString(clsConstant.DATE_FORMAT);
}
}
else
{
txtStartDate.Text = "";
}
if (objEnt.EndDate != null)
{
if (objEnt.EndDate != "")
{
DateTime dtenddate = DateTime.Parse(objEnt.EndDate);
txtEndDate.Text = dtenddate.ToString(clsConstant.DATE_FORMAT);
}
}
txtEmail.Text = objEnt.EmailID;
SectorBind();
drpSector.SelectedValue = objEnt.Sector.ToString();
btnUpdate.Visible = true;
btnSubmit.Visible = false;
lblMessage.ForeColor = System.Drawing.Color.Black;
lblMessage.Text = ds.Tables[0].Rows[11][1].ToString();
}
else
{
btnUpdate.Visible = false;
btnSubmit.Visible = true;
lblMessage.Text = "";
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
