//
public bool AddStudent(Student student)
{
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(AddStudentSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@FirstName", System.Data.SqlDbType.VarChar);
cmd.Parameters["@FirstName"].Value = student.FirstName;
cmd.Parameters.Add("@LastName", System.Data.SqlDbType.VarChar);
cmd.Parameters["@LastName"].Value = (student.LastName == null ? "" : student.LastName);
cmd.Parameters.Add("@EmailAddress", System.Data.SqlDbType.VarChar);
cmd.Parameters["@EmailAddress"].Value = student.EmailAddress;
cmd.Parameters.Add("@Gendar", System.Data.SqlDbType.VarChar);
cmd.Parameters["@Gendar"].Value = (student.Gendar == null ? "" : student.Gendar);
cmd.Parameters.Add("@Profession", System.Data.SqlDbType.VarChar);
cmd.Parameters["@Profession"].Value = (student.Profession == null ? "" : student.Profession);
cmd.Parameters.Add("@Source", System.Data.SqlDbType.VarChar);
cmd.Parameters["@Source"].Value = (student.Source == null ? "" : student.Source);
if (cmd.ExecuteNonQuery() > 0)
{
SendMail(new EmailMessage
{
ToEmail = student.EmailAddress,
Subject = ConfigurationManager.AppSettings["CourseEmailSubject"],
Message = ConfigurationManager.AppSettings["CourseEmailMessage"]
});
return true;
}
else
{
return false;
}
}
}
}
