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