public static VolunteerApplication GetVolunteerApplicationByID(int volunteerApplicationID) { //declare object VolunteerApplication volunteerApplication = new VolunteerApplication(); //getting the database connectivity SqlConnection con = new SqlConnection(DBCon.GetDBCon()); //set command type as stored procedure SqlCommand cmd = new SqlCommand("sp_get_VolunteerApplication", con); cmd.CommandType = CommandType.StoredProcedure; // Passing parameters cmd.Parameters.AddWithValue("VolunteerApplicationID", volunteerApplicationID); con.Open(); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { //reads and set values to object volunteerApplication.VolunteerApplicationID = Convert.ToInt32(rd["VolunteerApplicationID"]); volunteerApplication.ApplicationDate = Convert.ToDateTime(rd["ApplicationDate"].ToString()); volunteerApplication.VolunteerName = rd["VolunteerName"].ToString(); volunteerApplication.ContactNumber = rd["ContactNumber"].ToString(); volunteerApplication.EmailAddress = rd["EmailAddress"].ToString(); volunteerApplication.Availability = Convert.ToInt32(rd["Availability"].ToString()); volunteerApplication.PreferredUnit = Convert.ToInt32(rd["PreferredUnit"].ToString()); volunteerApplication.Status = Convert.ToInt32(rd["Status"].ToString()); } rd.Close(); con.Close(); return(volunteerApplication); }
public static void SendEmailToApplicant(int volunteerApplicationID, int statusId) { //get applicant details VolunteerApplication applicant = GetVolunteerApplicationByID(volunteerApplicationID); //send email string status = Setting.StatusList().Find(x => x.ID == Convert.ToInt32(statusId)).Value; string message = "Your application status is updated to " + status; string emailBody = Email.PopulateBody(applicant.VolunteerName.Split(' ')[0], message); Email.SendEmail(applicant.EmailAddress, "Volunteer Application Status Updated", emailBody); }
public static void SaveVolunteerApplication(VolunteerApplication volunteerApplication) { //getting the database connectivity SqlConnection con = new SqlConnection(DBCon.GetDBCon()); //set command type as stored procedure SqlCommand cmd = new SqlCommand("sp_save_VolunteerApplication", con); cmd.CommandType = CommandType.StoredProcedure; //setting parameters cmd.Parameters.AddWithValue("VolunteerName", volunteerApplication.VolunteerName); cmd.Parameters.AddWithValue("Availability", volunteerApplication.Availability); cmd.Parameters.AddWithValue("PreferredUnit", volunteerApplication.PreferredUnit); cmd.Parameters.AddWithValue("Status", volunteerApplication.Status); cmd.Parameters.AddWithValue("ContactNumber", volunteerApplication.ContactNumber); cmd.Parameters.AddWithValue("EmailAddress", volunteerApplication.EmailAddress); cmd.Parameters.AddWithValue("ApplicationDate", volunteerApplication.ApplicationDate); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }