public async Task Validate(string email)
{
ResultEmail = email.ToLower().Trim();
var eml = FixCommon(ResultEmail.Replace(",", ".").TrimEnd('.', ',', ';'));
if (RegExValidate(eml))
{
Probable = true;
}
else
{
eml = CleanSpelling(eml);
}
if (await MxCheckDomain(eml))
{
DomainExists = true;
Valid = true;
}
PopulateData(eml);
if (!ResultEmail.Equals(eml))
{
ResultEmail = eml;
Corrected = true;
}
}
public static ResultEmail EmailRegex(string email)
{
var results = new ResultEmail();
const string pattern = @"^[A-Z0-9._%+-]+@[A-Z0-9.-]+.(com|org|net|edu|gov|mil|biz|info|mobi)(.[A-Z]{2})?$";
Regex regex = new Regex(pattern, RegexOptions.IgnoreCase);
var result = regex.IsMatch(email);
if (result)
{
results.ResultEmailList.Add(email);
}
else
{
results.ResultErrorList.Add(email);
}
return(results);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string aid=Request.QueryString["aid"].ToString();
ResultEmail resultEmail = new ResultEmail();
resultEmail = resultEmail.GetResultEmailByAOID(Convert.ToInt32(aid));
if (resultEmail == null)
{
lblULR.Text = "Please Fill up Contents for Result Email First.";
lblULR.ForeColor = System.Drawing.Color.Red;
}
else
{
string asseeementURL = System.Web.Configuration.WebConfigurationManager.AppSettings["asseeementURL"].ToString();
//lblULR.Text = "http://localhost/CVTC/Exam.aspx?aid=" + aid;
//lblULR.Text = "http://iss.cvtc.edu/CVTC/Exam.aspx?aid=" + aid;
lblULR.Text = asseeementURL+"CVTC/Exam.aspx?aid=" + aid;
lblULR.ForeColor = System.Drawing.Color.Green;
}
//LabelAssessmentName.Text
Session["aid"] = aid;
HiddenFieldAOID.Value = aid;
Initialize(Convert.ToInt32(aid));
if (Session["CurrentUser"] != null)
{
User u = (User)Session["CurrentUser"];
HiddenFieldCurrentUser.Value = u.UserOID.ToString();
}
}
}
private void PrintIntervention(int aid, string studentID,string StuEmail)
{
try
{
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(aid);
ResultEmail resultEmail = new ResultEmail();
resultEmail = resultEmail.GetResultEmailByAOID(aid);
if (resultEmail == null)
return;
Student student = new Student().GetStudentByStudentOID(studentID);
StringBuilder sb = new StringBuilder();
sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:100%; margin:0px 30px 0px 30px'>");
sb.Append("<tr>");
sb.Append("<td align='center' style='font-size:24px; font-weight:bold;'> " + ass.AssessmentName + " Feedback Report</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>CVTC applicant: <b>" + student.FullName + "</b> Program Interest: <b>" + student.MajorProgramEnrollment + "</b></td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td > <br />" + resultEmail.Header + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td ><br /><b>*Your individual Inventory of Student Success assessment results suggest . . .</b><br /></td>");
sb.Append("</tr>");
StudentRank studentRank = new StudentRank();
Collection<StudentRank> studentRankList = studentRank.GetStudentRankBySOIDandAOID(student.StudentOID, ass.AssessmentOID);
int i = 0;
string txtSign = "", txtComments = "";
sb.Append("<td>");
sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:80%;'>");
foreach (StudentRank SR in studentRankList)
{
txtComments = SR.Comment;
foreach (Section s in ass.SectionList)
{
if (SR.SectionOID == s.SectionOID)
{
if (SR.Rank >= s.Medium)
{
txtSign = "+";
}
else if ((SR.Rank < s.Medium) && (SR.Rank >= s.Low))
{
txtSign = "~";
}
else if ((SR.Rank < s.Low))
{
txtSign = "-";
}
//else
//{
// txtSign = "-";
// //txtComments = "";
//}
break;
}
}
if (i % 2 == 0)
{
sb.Append("<tr>");
sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>");
sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + txtComments + " </td>");
//sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + SR.Rank + " </td>");
}
else
{
sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>");
sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + txtComments + " </td>");
//sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + SR.Rank + " </td>");
sb.Append("</tr>");
}
i++;
txtSign = "";
txtComments = "";
}
if (studentRankList.Count % 2 == 0)
{
sb.Append("<tr>");
sb.Append("<td colspan='4'><br />*( +above average ~average -below average )</td>");
sb.Append("</tr>");
}
else
{
sb.Append("<td colspan='2'><br /> *( +above average ~average -below average )</td>");
sb.Append("</tr>");
}
sb.Append("</table>");
sb.Append("</td>");
sb.Append("<tr>");
sb.Append("<td > <br />" + resultEmail.ShowAboveResult + "</td>");
sb.Append("</tr>");
sb.Append("</table>");
string StudentEmail=null;
if (ConfigurationManager.AppSettings["productionMode"].ToString() == "OFF")
{
StudentEmail = System.Web.Configuration.WebConfigurationManager.AppSettings["asseeementEmail"].ToString();
}
else if (ConfigurationManager.AppSettings["productionMode"].ToString() == "ON")
{
StudentEmail = StuEmail;
if (StudentEmail == null || StudentEmail == "")
{
StudentEmail = System.Web.Configuration.WebConfigurationManager.AppSettings["asseeementEmail"].ToString();
}
}
this.SendMail(StudentEmail, "Assesment feedback report ", sb.ToString());
//this.SendMail("*****@*****.**", "Assesment feedback report ", sb.ToString());
}
catch (Exception ex)
{ }
}
public ActionResult Index(Send Savemail)
{
List <SelectListItem> ulkekodu = (from i in db.TelKodu.ToList()
select new SelectListItem
{
Text = i.UlkeKodu,
Value = i.Id.ToString()
}).ToList();
ViewBag.bag = ulkekodu;
try
{
try
{
string[] email = Savemail.Kime.Split(';');
for (int i = 0; i < email.Count(); i++)
{
results = EmailExtension.EmailRegex(email[i]);
}
if (results.ResultErrorList.Count > 0)
{
ModelState.AddModelError("Kime", "Email girişlerinde hatalı bir email mevcut");
return(View(Savemail));
}
else
{
foreach (var item in email)
{
var senderEmail = new MailAddress("*****@*****.**", "Edanur");
var receiverEmail = new MailAddress(item, "Receiver");
var password = "******";
var sub = Savemail.Konu;
var body = Savemail.Mesaj + " " + Savemail.Kim + " " + Savemail.Telefon;
var smtp = new SmtpClient()
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(senderEmail.Address, password)
};
using (var mess = new MailMessage(senderEmail, receiverEmail)
{
Subject = Savemail.Konu,
Body = body
})
smtp.Send(mess);
db.Send.Add(Savemail);
db.SaveChanges();
}
}
return(View());
}
catch (NullReferenceException exception)
{
ModelState.AddModelError("Kime", "Email alanı boş olamaz");
return(View());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultEmail GetResultEmailByOID(int OID)
{
ResultEmail resultEmail = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL ResultEmail_ByOID(?)}";
command.CommandType = CommandType.StoredProcedure;
//Set Parameter Value
command.Parameters.AddWithValue("@AssessmentResultOID", OID);
//Open connection
connection.Open();
//Read using reader
using (OdbcDataReader dataReader = command.ExecuteReader())
{
ResultEmailDetail eDetail = new ResultEmailDetail();
if (dataReader.Read())
{
resultEmail = new ResultEmail();
resultEmail.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]);
resultEmail.AssessmentResultOID = Convert.ToInt32(dataReader["AssessmentResultOID"]);
resultEmail.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
resultEmail.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
resultEmail.Header = Convert.ToString(dataReader["Header"]);
resultEmail.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]);
resultEmail.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]);
resultEmail.ShowAboveResult = Convert.ToString(dataReader["ShowAboveResult"]);
resultEmail.ResultDetail = eDetail.GetEmailDetailByEmailOID(resultEmail.AssessmentResultOID);
}
}
}
}
return resultEmail;
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
int aid = 0;
try
{
User user=(User)Session["CurrentUser"];
if (user == null) return;
System.Collections.ObjectModel.Collection<ResultEmailDetail> _list = new System.Collections.ObjectModel.Collection<ResultEmailDetail>();
ResultEmailDetail emailDetail=null;
aid = (Session["aid"] != null) ? (Convert.ToInt32(Session["aid"])) : 0;
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(aid);
ResultEmail resultEmail = new ResultEmail();
//resultEmail.Header = TextBoxHeader.Text;
//resultEmail.ShowAboveResult = TextBoxShowAboveResult.Text;
resultEmail.Header = TextBoxHeaderHtml;
resultEmail.ShowAboveResult = TextBoxShowAboveResultHtml;
resultEmail.AssessmentOID = aid;
resultEmail.CreatedBy = user.UserOID;
resultEmail.LastModifiedBy = user.UserOID;
//Result Detail
ResultEmail rEmail = resultEmail.GetResultEmailByAOID(aid);
//TextBox txt;
string val = "";
foreach (Section s in ass.SectionList)
{
emailDetail = new ResultEmailDetail();
////Positive Result
//val = Request.Form["txtPositive" + s.SectionOID.ToString()];
//emailDetail.PositiveResult = val;
////Negative Result
//val = Request.Form["txtNegative" + s.SectionOID.ToString()];
//emailDetail.NegativeResult = val;
//Low Result
val = Request.Form["txtLow" + s.SectionOID.ToString()];
emailDetail.LowResult = val;
//Medium Result
val = Request.Form["txtMedium" + s.SectionOID.ToString()];
emailDetail.MediumResult = val;
//High Result
val = Request.Form["txtHigh" + s.SectionOID.ToString()];
emailDetail.HighResult = val;
emailDetail.SectionOID = s.SectionOID;
emailDetail.LastModifiedBy = user.UserOID;
emailDetail.CreatedBy = user.UserOID;
_list.Add(emailDetail);
}
resultEmail.ResultDetail = _list;
//check whether It is exist or not
if (rEmail == null)
{
if (resultEmail.AddResultEmail())
{
LabelMessage.Text = "Saved Successfully.";
}
else
{
LabelMessage.Text = "Not Saved.";
}
}
else
{
resultEmail.AssessmentResultOID = rEmail.AssessmentResultOID;
for (int i = 0; i < rEmail.ResultDetail.Count; i++)
{
resultEmail.ResultDetail[i].ResultSectionOID = rEmail.ResultDetail[i].ResultSectionOID;
}
if (resultEmail.UpdateResultEmail())
{
LabelMessage.Text = "Update Successfully.";
}
else
{
LabelMessage.Text = "Update Failed.";
}
}
TextBoxShowAboveResultHtml = "";
TextBoxHeaderHtml = "";
this.Initialize(aid);
}
catch (Exception ex)
{
this.Initialize(aid);
}
}
//private void PrintIntervention(int aid, string studentID)
//{
// try
// {
// Assessment ass = new Assessment();
// ass = ass.GetAssessmentByOID(aid);
// ResultEmail resultEmail = new ResultEmail();
// resultEmail = resultEmail.GetResultEmailByAOID(aid);
// Student student = new Student().GetStudentByStudentOID(studentID);
// StringBuilder sb = new StringBuilder();
// sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:100%; margin:0px 30px 0px 30px'>");
// sb.Append("<tr>");
// sb.Append("<td align='center' style='font-size:24px; font-weight:bold;'> " + ass.AssessmentName + " Feedback Report</td>");
// sb.Append("</tr>");
// sb.Append("<tr>");
// sb.Append("<td>CVTC applicant: <b>" + student.FullName + "</b> Program Interest: <b>" + student.MajorProgramEnrollment + "</b></td>");
// sb.Append("</tr>");
// sb.Append("<tr>");
// sb.Append("<td >" + resultEmail.Header + "</td>");
// sb.Append("</tr>");
// sb.Append("<tr>");
// sb.Append("<td ><b>*Your individual Inventory of Student Success assessment results suggest . . .</b></br></td>");
// sb.Append("</tr>");
// StudentRank studentRank = new StudentRank();
// Collection<StudentRank> studentRankList = studentRank.GetStudentRankBySOIDandAOID(student.StudentOID, ass.AssessmentOID);
// int i = 0;
// string txtSign="", txtComments="";
// sb.Append("<td>");
// sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:80%;'>");
// foreach (StudentRank SR in studentRankList)
// {
// txtComments = SR.Comment;
// foreach (Section s in ass.SectionList)
// {
// if (SR.SectionOID == s.SectionOID)
// {
// if (SR.Rank >= s.High)
// {
// txtSign = "+";
// }
// else if ((SR.Rank < s.High) && (SR.Rank >= s.Medium))
// {
// txtSign = "~";
// }
// else if ((SR.Rank < s.Medium) && (SR.Rank >= s.Low))
// {
// txtSign = "-";
// }
// else
// {
// txtSign = "";
// txtComments = "";
// }
// break;
// }
// }
// if (i % 2 == 0)
// {
// sb.Append("<tr>");
// sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>");
// sb.Append("<td style='width:48%; border: thin solid #000000'> " + txtComments + " </td>");
// }
// else
// {
// sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>");
// sb.Append("<td style='width:48%; border: thin solid #000000'> " + txtComments + " </td>");
// sb.Append("</tr>");
// }
// i++;
// txtSign = "";
// txtComments = "";
// }
// if (studentRankList.Count % 2 == 0)
// {
// sb.Append("<tr>");
// sb.Append("<td colspan='4'></br>*( +above average ~average -below average )</br></td>");
// sb.Append("</tr>");
// }
// else
// {
// sb.Append("<td></br>*( +above average ~average -below average )</br></td>");
// sb.Append("</tr>");
// }
// sb.Append("</table>");
// sb.Append("</td>");
// sb.Append("<tr>");
// sb.Append("<td > </br>" + resultEmail.ShowAboveResult + "</td>");
// sb.Append("</tr>");
// sb.Append("</table>");
// print_div1.InnerHtml = sb.ToString();
// }
// catch (Exception ex)
// { }
//}
private void Initialize(int aid)
{
try
{
string html = "";
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(aid);
ResultEmail resultEmail = new ResultEmail();
resultEmail = resultEmail.GetResultEmailByAOID(aid);
string txtLow, txtMedium, txtHigh;
if (resultEmail != null)
{
//TextBoxHeader.Text = resultEmail.Header;
//TextBoxShowAboveResult.Text = resultEmail.ShowAboveResult;
TextBoxHeaderHtml = resultEmail.Header;
TextBoxShowAboveResultHtml = resultEmail.ShowAboveResult;
}
ResultEmailDetail rEmailDetail=null;
html = "<table>";
foreach (Section s in ass.SectionList)
{
//PlaceHolderResult.Controls.Add(InsertLineBreaks(1));
if (s.SectionName != "NoScore")
{
if (resultEmail != null)
{
if (resultEmail.ResultDetail != null)
{
var tmp = from detail in resultEmail.ResultDetail
where detail.SectionOID == s.SectionOID
select detail;
if (tmp.Count<ResultEmailDetail>() > 0)
{
rEmailDetail = tmp != null ? tmp.First() : null;
}
else
{
rEmailDetail = null;
}
}
}
txtLow = (rEmailDetail != null) ? rEmailDetail.LowResult : "";
txtMedium = (rEmailDetail != null) ? rEmailDetail.MediumResult : "";
txtHigh = (rEmailDetail != null) ? rEmailDetail.HighResult : "";
html += "<tr>";
html += "<td colspan='3' style='font-size:6;font-weight:bold;'>" + s.SectionName + "<td>";
html += "</tr>";
html += "<tr>";
html += "<td>" + "Low Ranking <br/>" + "<input id='txtLow" + s.SectionOID.ToString() + "' name='txtLow" + s.SectionOID.ToString() + "' type='text' style='height:20px;width:250px;' value='" + txtLow + "'/>" + "<td>";
html += "<td>" + "Medium Ranking <br/>" + "<input id='txtMedium" + s.SectionOID.ToString() + "' name='txtMedium" + s.SectionOID.ToString() + "' type='text' style='height:20px;width:250px;' value='" + txtMedium + " '/>" + "<td>";
html += "<td>" + "High Ranking <br/>" + "<input id='txtHigh" + s.SectionOID.ToString() + "' name='txtHigh" + s.SectionOID.ToString() + "' type='text' style='height:20px;width:250px;' value='" + txtHigh + " '/>" + "<td>";
html += "</tr>";
#region Old Code
////Positive Result
//txtBox = new TextBox();
//lbl = new Label();
//txtBox.ID = "txtPositive" + s.SectionOID.ToString();
//txtBox.Text = (rEmailDetail != null) ? rEmailDetail.PositiveResult : "";
//lbl.ID = "lblPositive" + s.SectionOID.ToString();
//lbl.Text = "Positive Result for " + s.SectionName;
//PlaceHolderResult.Controls.Add(lbl);
//PlaceHolderResult.Controls.Add(InsertSpace(2));
//PlaceHolderResult.Controls.Add(txtBox);
//PlaceHolderResult.Controls.Add(InsertSpace(10));
////Negative Result
//txtBox = new TextBox();
//lbl = new Label();
//txtBox.ID = "txtNegative" + s.SectionOID.ToString();
//txtBox.Text = (rEmailDetail != null) ? rEmailDetail.NegativeResult : "";
//lbl.ID = "lblNegative" + s.SectionOID.ToString();
//lbl.Text = "Negative Result for "+s.SectionName;
//PlaceHolderResult.Controls.Add(lbl);
//PlaceHolderResult.Controls.Add(InsertSpace(2));
//PlaceHolderResult.Controls.Add(txtBox);
//PlaceHolderResult.Controls.Add(InsertLineBreaks(1));
#endregion
}
}
html += " </table>";
ResultHolder.InnerHtml = html;
//PlaceHolderResult.Controls.Add(html);
}
catch (Exception ex)
{ }
}