예제 #1
0
        public string Read()
        {
            string          cmdString = "SELECT job_id_seq.CURRVAL FROM Dual";
            IReadOneCommand cmd       = new ReadOneCommand();

            return(cmd.Execute(cmdString).ToString());
        }
예제 #2
0
        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;
        }
예제 #3
0
        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);
        }
예제 #4
0
 public string Read()
 {
     string cmdString = "SELECT job_id_seq.CURRVAL FROM Dual";
     IReadOneCommand cmd = new ReadOneCommand();
     return cmd.Execute(cmdString).ToString();
 }