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); } }