public string Read()
{
string cmdString = "SELECT job_id_seq.CURRVAL FROM Dual";
IReadOneCommand cmd = new ReadOneCommand();
return(cmd.Execute(cmdString).ToString());
}
public DbEmail Execute(Guid sessionID, string recipientEmail, DbJob job)
{
// Get userEmail
string qry = "SELECT email FROM FDMUSER JOIN SESSIONS ON FDMUSER.user_id = SESSIONS.user_id WHERE session_guid = '" + sessionID.ToString() + "'";
ReadOneCommand cmd = new ReadOneCommand();
string userEmail = cmd.Execute(qry);
DbEmail email = new DbEmail();
email.Sender = userEmail;
email.Recipient = recipientEmail;
email.Subject = "Application for " + job.Title + " at " + job.Location;
email.Body = "Hi ";
return email;
}
public DbEmail Execute(Guid sessionID, string recipientEmail, DbJob job)
{
// Get userEmail
string qry = "SELECT email FROM FDMUSER JOIN SESSIONS ON FDMUSER.user_id = SESSIONS.user_id WHERE session_guid = '" + sessionID.ToString() + "'";
ReadOneCommand cmd = new ReadOneCommand();
string userEmail = cmd.Execute(qry);
DbEmail email = new DbEmail();
email.Sender = userEmail;
email.Recipient = recipientEmail;
email.Subject = "Application for " + job.Title + " at " + job.Location;
email.Body = "Hi ";
return(email);
}
public string Read()
{
string cmdString = "SELECT job_id_seq.CURRVAL FROM Dual";
IReadOneCommand cmd = new ReadOneCommand();
return cmd.Execute(cmdString).ToString();
}
