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