protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); string stage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string role = util.displayValue("opt_levels", MySessionManager.CurrentUser.RoleID.ToString()); string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetSpecificComments(MySessionManager.AppID, MySessionManager.ClientID, appStage); if (!(tblComments.Rows.Count > 0)) { comments.InsertComment(role, stage, txtDescription.Value.Trim(), MySessionManager.ClientID, MySessionManager.AppID, MySessionManager.CurrentUser.UserID); this.editskip.Value = "1"; } else { int id = Convert.ToInt32(tblComments[0].datID.ToString()); comments.UpdateComment(txtDescription.Value.Trim(), id); this.editskip.Value = "1"; } } }
public void loadComments() { LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetComments(MySessionManager.AppID, MySessionManager.ClientID); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); if (tblComments.Rows.Count > 0) { string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string stage = ""; foreach (LoanDS.CommentsRow r in tblComments) { stage = r.datStage; if (stage == appStage) { id = r.datID; txtDescription.Value = r.datDescription.ToString(); } } this.editskip.Value = "2"; } }