public static FooterNotes GetFooterNotesText() { FooterNotes returnObject = new FooterNotes(); SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["TriadAdvertsConnectionString"].ToString()); string SPName = "GetFooterNotes"; SqlCommand myCommand = new SqlCommand(SPName, myConnection); myCommand.CommandType = CommandType.StoredProcedure; try { myConnection.Open(); SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); for ( ; myReader.Read(); ) { returnObject = FooterNotesDB.toObject(myReader); } myReader.Close(); } catch (Exception) { throw; } return(returnObject); }
protected void Page_Load(object sender, EventArgs e) { int Reference = DAL.To_Integer(Request.QueryString["ref"], -1); if (Reference > 1) { // Get the job details Advert JobDetails = Advert.GetByid(Reference); FooterNotes NewFooterText = FooterNotes.GetFooterNotesText(); if (JobDetails.id > 0) { StringBuilder EmailURL = new StringBuilder(); lbltitle.Text = JobDetails.Title; DetailsSpec.InnerHtml = JobDetails.Spec.Replace(char.ConvertFromUtf32(13), "<br/ >"); lblLocationRate.Text = JobDetails.Location; if (JobDetails.Salary.Length > 1) { lblLocationRate.Text = lblLocationRate.Text + " , " + JobDetails.Salary; } lblLocation.Text = JobDetails.Location; lblreference.Text = JobDetails.Reference.ToString(); lblDuration.Text = JobDetails.Duration.ToString(); lblStartDate.Text = String.Format("{0:d/M/yyyy}", JobDetails.Startdate); lblPosted.Text = String.Format("{0:d/M/yyyy}", JobDetails.UpdatedOn); EmailURL.Append("mailto:"); EmailURL.Append(JobDetails.ContactEmail.ToString()); EmailURL.Append("?subject=Job Ref: "); EmailURL.Append(JobDetails.Reference.ToString()); lnkName.Text = JobDetails.ContactName.ToString(); lnkName.NavigateUrl = EmailURL.ToString(); lnkEmail.NavigateUrl = EmailURL.ToString(); if (NewFooterText.Id > 0) { FooterTextPnl.InnerHtml = NewFooterText.FooterNotesText.ToString(); } } } }
public static FooterNotes toObject(SqlDataReader Reader) { FooterNotes returnObject = new FooterNotes(DAL.To_Integer(Reader["id"]), DAL.To_String(Reader["FooterNotes"])); return(returnObject); }