protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
int loanID, sectorID, agencyID, stateID;
lblSelectionError.Text = string.Empty;
if (drpLoanNumber.SelectedIndex > 0 || drpAgency.SelectedIndex > 0 || drpSector.SelectedIndex > 0 || drpState.SelectedIndex > 0 || drpOnlyOpen.SelectedIndex > 0)
{
dt = new DataTable();
performanceLoan = new PerformanceLoan();
loanID = Convert.ToInt32(drpLoanNumber.SelectedValue);
sectorID = Convert.ToInt32(drpSector.SelectedValue);
agencyID = Convert.ToInt32(drpAgency.SelectedValue);
stateID = Convert.ToInt32(drpState.SelectedValue);
ds = performanceLoan.PerformanceLoanFilter(loanID, sectorID, agencyID, stateID, drpState.SelectedItem.Text, drpOnlyOpen.SelectedIndex);
dt = ds.Tables[0];
grdPeformaceLoan.DataSource = dt;
grdPeformaceLoan.DataBind();
Session[clsConstant.SESS_TABLE] = dt;
}
else
{
lblSelectionError.Text = "Please select some above criteria";
lblSelectionError.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../Logout.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("LoanDetailsAddEdit") == false)
{
pnlInvalid.Visible = true;
MainDiv.Visible = true;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
loanID = Request.QueryString["loanID"];
if (loanID != null && IsPostBack == false)
{
loanDetails = new LoanDetails();
performanceLoan = new PerformanceLoan();
loanDetails = performanceLoan.GetApprovalClosingDate(Convert.ToInt32(loanID));
LoanBinding();
drpLoanNumber.Items.FindByValue(loanID).Selected = true;
AutoFill();
checkForPMU();
lnkProjBriefSheet.Visible = true;
}
else
{
lnkProjBriefSheet.Visible = false;
}
if (IsPostBack != true && loanID == null)
{
LoanBinding();
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void drpLnNumber_SelectedIndexChanged(object sender, EventArgs e)
{
performanceLoan = new PerformanceLoan();
loanDetails = new LoanDetails();
loanDetails = performanceLoan.GetApprovalClosingDate(Convert.ToInt32(drpLoanNumber.SelectedValue));
AutoFill();
lblPromptMessage.Text = string.Empty;
if (drpLoanNumber.SelectedIndex != 0)
{
lnkProjBriefSheet.Visible = true;
}
else
{
lnkProjBriefSheet.Visible = false;
}
}
protected void grdPeformaceLoan_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
performanceLoan = new PerformanceLoan();
grdPeformaceLoan.PageIndex = e.NewPageIndex;
ds = performanceLoan.PerformanceLoanFilter(Convert.ToInt32(drpLoanNumber.SelectedValue), Convert.ToInt32(drpSector.SelectedValue), Convert.ToInt32(drpAgency.SelectedValue), Convert.ToInt32(drpState.SelectedValue), drpState.SelectedItem.Text, drpOnlyOpen.SelectedIndex);
grdPeformaceLoan.DataSource = ds.Tables[0];
grdPeformaceLoan.DataBind();
Session[clsConstant.SESS_TABLE] = ds.Tables[0];
}
catch (Exception ex)
{
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string pmuDate = "";
try
{
if (txtEST_PMU.Text == "Yes")
{
pmuDate = txtApprovalDate.Text;
}
else
{
pmuDate = DateTime.Now.ToString();
}
performanceLoan = new PerformanceLoan();
approvalDate = txtApprovalDate.Text.ToString();
signingDate = txtSigningDate.Text;
effectivenessDate = txtEffectivenessDate.Text;
EST_PMUDate = txtEST_PMU.Text.ToString();
firstContractAwardDate = txtFirstContractAwardDate.Text.ToString();
closingDate = txtClosingDate.Text.ToString();
revisedClosingDate = txtRevisedClosingDate.Text;
performanceLoan.UpdatePerformanceLoan(Convert.ToInt32(drpLoanNumber.SelectedValue), signingDate,
effectivenessDate, pmuDate, approvalDate, firstContractAwardDate, closingDate, revisedClosingDate);
if (loanID != null)
{
Response.Redirect("LoanDetailsList.aspx");
}
else
{
ut = new Utility();
}
lblPromptMessage.Text = "Data Updated Sucessfully";
ut.ResetFormControl(reSetDiv);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
if (IsPostBack)
{
Preview.Style.Add("display", "none");
}
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../Logout.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("LoanDetailsList") == false)
{
//urlWrapper["pageaccesserr"] = "1";
//urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
//urlWrapper.PassParameters();
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (IsPostBack != true)
{
dt = new DataTable();
comnFunctionObj = new CommonFunction();
performanceLoan = new PerformanceLoan();
drpLoanNumber.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.Items.RemoveAt(0);
drpLoanNumber.Items.Insert(0, new ListItem("----------ENTER NAME/NO----------", "0"));
drpAgency.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_AGENCY, null);
drpAgency.DataTextField = "DisplayFieldText";
drpAgency.DataValueField = "ValueFieldText";
drpAgency.DataBind();
drpSector.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_DOC_CATEGORY, null);
drpSector.DataTextField = "DisplayFieldText";
drpSector.DataValueField = "ValueFieldText";
drpSector.DataBind();
drpState.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_AGENCY_BY_STATE, null);
drpState.DataTextField = "DisplayFieldText";
drpState.DataValueField = "ValueFieldText";
drpState.DataBind();
//status = false;
ds = performanceLoan.PerformanceLoanFilter(Convert.ToInt32(drpLoanNumber.SelectedValue), Convert.ToInt32(drpSector.SelectedValue),
Convert.ToInt32(drpAgency.SelectedValue), Convert.ToInt32(drpState.SelectedValue), drpState.SelectedItem.Text,
drpOnlyOpen.SelectedIndex);
dt = new DataTable();
dt = ds.Tables[0];
grdPeformaceLoan.DataSource = dt;
grdPeformaceLoan.DataBind();
#region callpreview
CallToPerformanceTrack(ds.Tables[1], "Loan Details");
#endregion
#region Contract Award Date
#endregion
if (!IsPostBack)
{
info.AddMergedColumns(new int[] { 7, 8, 9, 10, 11 }, "<b>Date</b>");
}
Session[clsConstant.SESS_TABLE] = dt;
drpSector.SelectedIndex = 0;
drpSector.Enabled = false;
drpState.SelectedIndex = 0;
drpState.Enabled = false;
drpAgency.SelectedIndex = 0;
drpAgency.Enabled = false;
if (Request.QueryString["Rprt"] == "pR")
{
grdPeformaceLoan.Columns[12].Visible = false;
HyperLink1.Visible = false;
}
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
