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;
}
public Collection<ResultEmailDetail> GetEmailDetailByEmailOID(int OID)
{
Collection<ResultEmailDetail> _list = new Collection<ResultEmailDetail>();
ResultEmailDetail emailDetail = null;
try
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL ResultEmailDetail_ByResutEmailOID(?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@AssessmentResultOID", OID);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{//this = new Assessment();
emailDetail = new ResultEmailDetail();
emailDetail.AssessmentResultOID = Convert.ToInt32(dataReader["AssessmentResultOID"]);
emailDetail.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
emailDetail.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
emailDetail.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]);
emailDetail.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]);
//emailDetail.NegativeResult = Convert.ToString(dataReader["NegativeResult"]);
emailDetail.MediumResult = Convert.ToString(dataReader["MediumResult"]);
emailDetail.HighResult = Convert.ToString(dataReader["HighResult"]);
emailDetail.LowResult = Convert.ToString(dataReader["LowResult"]);
emailDetail.SectionOID = Convert.ToInt32(dataReader["SectionOID"]);
emailDetail.ResultSectionOID = Convert.ToInt32(dataReader["ResultSectionOID"]);
_list.Add(emailDetail);
}
}
}
}
}
catch (Exception ex)
{ }
return _list;
}
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);
}
}
