protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.PreApprovalReportTableAdapter preApprovalRpt = new LoanDSTableAdapters.PreApprovalReportTableAdapter(); LoanDS.PreApprovalReportDataTable tblpreApproval = preApprovalRpt.GetPreApprovalReport(MySessionManager.AppID, MySessionManager.ClientID); if (!(tblpreApproval.Rows.Count > 0)) { preApprovalRpt.InsertPreApprovalReport(txtDescription.Value.Trim(), MySessionManager.ClientID, MySessionManager.AppID, MySessionManager.CurrentUser.UserID); this.editskip.Value = "1"; } else { int id = Convert.ToInt32(tblpreApproval[0].datID.ToString()); preApprovalRpt.UpdatePreApprovalReport(txtDescription.Value.Trim(), MySessionManager.ClientID, MySessionManager.AppID, 1, MySessionManager.CurrentUser.UserID, id); this.editskip.Value = "1"; } } }
public void loadPreliminaryRpt() { LoanDSTableAdapters.PreApprovalReportTableAdapter preliminaryRpt = new LoanDSTableAdapters.PreApprovalReportTableAdapter(); LoanDS.PreApprovalReportDataTable tblPreliminaryRpt = preliminaryRpt.GetPreApprovalReport(MySessionManager.AppID, MySessionManager.ClientID); if (tblPreliminaryRpt.Rows.Count > 0) { txtDescription.Value = Convert.ToString(tblPreliminaryRpt[0].datDescription); } this.editskip.Value = "2"; }