public ResultLetter GetResultLetterByOID(int OID)
{
ResultLetter resultLetter = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL ResultLetter_ByOID(?)}";
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 999;
//Set Parameter Value
command.Parameters.AddWithValue("@LetterOID", OID);
//Open connection
connection.Open();
//Read using reader
using (OdbcDataReader dataReader = command.ExecuteReader())
{
ResultLetterDetail lDetail = new ResultLetterDetail();
if (dataReader.Read())
{
resultLetter = new ResultLetter();
resultLetter.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]);
resultLetter.AssessmentResultLetter = Convert.ToInt32(dataReader["AssessmentResultLetter"]);
resultLetter.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
resultLetter.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
resultLetter.Header = Convert.ToString(dataReader["Header"]);
resultLetter.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]);
resultLetter.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]);
resultLetter.ShowAboveResult = Convert.ToString(dataReader["ShowAboveResult"]);
resultLetter.LetterDetail = lDetail.GetLetterDetailByLetterOID(resultLetter.AssessmentResultLetter); ;
}
}
}
}
return resultLetter;
}
public Collection<ResultLetterDetail> GetLetterDetailByLetterOID(int OID)
{
Collection<ResultLetterDetail> _list = new Collection<ResultLetterDetail>();
ResultLetterDetail letterDetail = null;
try
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL ResultLetterDetail_ByLetterOID(?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@AssessmentLetterOID", OID);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{//this = new Assessment();
letterDetail = new ResultLetterDetail();
letterDetail.AssessmentLetterOID = Convert.ToInt32(dataReader["AssessmentLetterOID"]);
letterDetail.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
letterDetail.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
letterDetail.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]);
letterDetail.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]);
letterDetail.ResultLetterSectionCommentOID = Convert.ToInt32(dataReader["ResultLetterSectionCommentOID"]);
letterDetail.SectionDefinition = Convert.ToString(dataReader["SectionDefinition"]);
letterDetail.SectionOID = Convert.ToInt32(dataReader["SectionOID"]);
_list.Add(letterDetail);
}
}
}
}
}
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;
aid = (Session["aid"] != null) ? (Convert.ToInt32(Session["aid"])) : 0;
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(aid);
Collection<ResultLetterDetail> _list = new Collection<ResultLetterDetail>();
ResultLetterDetail letterDetail = null;
ResultLetter resultLetter = new ResultLetter();
//resultLetter = resultLetter.GetResultLetterByOID();
resultLetter.AssessmentOID = aid;
resultLetter.CreatedBy = user.UserOID;
resultLetter.LastModifiedBy = user.UserOID;
//resultLetter.Header = TextBoxHeader.Text;
//resultLetter.ShowAboveResult = TextBoxShowAboveResult.Text;
resultLetter.Header = TextBoxHeaderHtml;
resultLetter.ShowAboveResult = TextBoxShowAboveResultHtml;
//resultLetter.Header = TextBoxShowAboveResult.Text;
int HeaderTextLength = Convert.ToInt32(System.Web.Configuration.WebConfigurationManager.AppSettings["ResultLetterHeaderTextLenth"].ToString());
int FooterTextLength = Convert.ToInt32(System.Web.Configuration.WebConfigurationManager.AppSettings["ResultLetterFooterTextLenth"].ToString());
if (TextBoxHeaderHtml.Length < HeaderTextLength && TextBoxShowAboveResultHtml.Length < FooterTextLength)
{
string val = "";
foreach (Section s in ass.SectionList)
{
if (s.SectionName == "NoScore") continue;
letterDetail = new ResultLetterDetail();
val = Request.Form["txt" + s.SectionOID.ToString()];
//identifier = "txt" + s.SectionOID.ToString();
//txt = (TextBox)PlaceHolderSectionDefinition.FindControl(identifier);
//if (txt == null) continue;
letterDetail.SectionDefinition = val;
letterDetail.SectionOID = s.SectionOID;
letterDetail.LastModifiedBy = user.UserOID;
letterDetail.CreatedBy = user.UserOID;
_list.Add(letterDetail);
}
resultLetter.LetterDetail = _list;
//check whether it is existing or not
ResultLetter rletter = resultLetter.GetResultLetterByAOID(aid);
if (rletter == null)
{
if (resultLetter.AddResultLetter())
{
LabelMessage.Text = "Saved Successfully.";
}
else
{
LabelMessage.Text = "Saved Failed.";
}
}
else
{
resultLetter.AssessmentResultLetter = rletter.AssessmentResultLetter;
for (int i = 0; i < resultLetter.LetterDetail.Count; i++)
{
try
{
resultLetter.LetterDetail[i].ResultLetterSectionCommentOID = rletter.LetterDetail[i].ResultLetterSectionCommentOID;
}
catch
{
resultLetter.LetterDetail[i].ResultLetterSectionCommentOID = -1;
resultLetter.LetterDetail[i].AssessmentLetterOID = rletter.AssessmentResultLetter;
}
}
if (resultLetter.UpdateResultLetter())
{
LabelMessage.Text = "Update Successfully.";
//LabelMessage .Text ="Header:"+TextBoxHeaderHtml.Length .ToString ()+"And Footer :"+TextBoxShowAboveResultHtml.Length .ToString ();
}
else
{
LabelMessage.Text = "Update Failed.";
}
}
TextBoxHeaderHtml = "";
TextBoxShowAboveResultHtml = "";
//Initialize(aid);
}
else
{
LabelMessage.Text = "Sorry! can't Save. Header Length Must Be Less than 1000 Characters and Footer Length must be Less than 1500 Characters";
LabelMessage.ForeColor = Color.Red;
LabelMessage.Width = 350;
}
Initialize(aid);
}
catch (Exception ex)
{
Initialize(aid);
}
}
