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); } }