protected void btn_Update(object sender, EventArgs e)
{
if (Page.IsValid)
{
objTADetails = new TADetails();
try
{
int projectID = Convert.ToInt32(drpProjectNameNumber.SelectedValue);
objTADetails.editTADetails(int.Parse(lblTAID.Text), txtTaNumber.Text, txtTaName.Text, projectID, txtStartDate.Text, txtEndDate.Text, double.Parse(txtTAAmount.Text == "" ? "0" : txtTAAmount.Text), ChkactiveTA.Checked ? 1 : 0);
lblMessage.Text = "Information Successfully Updated";
ut = new Utility();
ut.ResetFormControl(reset);
}
catch (Exception exMessage)
{
lblMessage.Text = "Consultant Detail Exist";
logger.Error(exMessage);
}
}
}
public void SavePipelinedetailsAddEditMDB()
{
try
{
if (ViewState["iPipelineID"] != null)
{
iPipelineID = ViewState["iPipelineID"].ToString();
}
else if (Request.QueryString["iPipelineID"] != null)
{
iPipelineID = Request.QueryString["iPipelineID"].ToString();
}
else
{
iPipelineID = "";
}
objTADetails = new TADetails();
if (objTADetails.AddPilelineDetailsMDB((((UserDetails)Session[clsConstant.TOKEN]).UserID).ToString(), txtProjectNumber.Text, txtProjectName.Text, txtAmount.Text, ddlWBAgency.SelectedValue,
ddlSector.SelectedValue, ddlWSSector.SelectedValue, txtSigningDate.Text, txtApprovalDate.Text, txtNegotiationDate.Text, txtClosingDate.Text, txtReviseClosingDate.Text, txtPortfolioFileNo.Text,
ddlStatus.SelectedValue, ddlTTl.SelectedValue, iPipelineID, DrpFundingAgency.SelectedValue))
{
if (iPipelineID == "")
{
this.ClearFormdata();
Alert.show("Information Successfully Saved");
}
else
{
Alert.show("Information Updated Successfully");
}
}
else
{
Alert.show("Please try after some time");
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SavePortfolioAddEditMDB()
{
try
{
if (ViewState["iPortFolioId"] != null)
{
iPortFolioId = ViewState["iPortFolioId"].ToString();
}
else if (Request.QueryString["iPortfolioID"] != null)
{
iPortFolioId = Request.QueryString["iPortfolioID"].ToString();
}
else
{
iPortFolioId = "";
}
objTADetails = new TADetails();
if (objTADetails.AddPortfolioDetailsMDB((((UserDetails)Session[clsConstant.TOKEN]).UserID).ToString(), ddlAgency.SelectedValue.ToString(), ddlPipeline.SelectedItem.ToString().Trim().Split('-')[0], ddlIDType.SelectedValue.ToString(), txtCreditID.Text, txtPortfolioAmount.Text,
ddlWBAgency.SelectedValue.ToString(), ddlSector.SelectedValue.ToString(), ddlWSSector.SelectedValue.ToString(), txtSigningDate.Text, txtApprovalDate.Text, txtNegotiationDate.Text, txtClosingDate.Text,
txtReviseClosingDate.Text, txtPortfolioFileNo.Text, ddlStatus.SelectedValue.ToString(), ddlTTl.SelectedValue.ToString(), ddlPipeline.SelectedValue.ToString(), iPortFolioId))
{
if (iPortFolioId == "")
{
this.ClearFormdata();
Alert.show("Information Successfully Saved");
}
else
{
Alert.show("Information Updated Successfully");
}
}
else
{
Alert.show("Please try after some time");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
objTADetails = new TADetails();
objEnt = new clsEntTADetails();
objComm = new CommonFunction();
iTADetailsID = Request.QueryString["iAAAID"];
if (!this.IsPostBack)
{
btnSubmit.Visible = true;
btnUpdate.Visible = false;
if (Utility.CheckAccess("AAAAddEdit") == false)
{
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
bindddlWBSector();
bindSector();
bindAgency();
this.bindTeamLeader();
if (iTADetailsID != null)
{
fillText();
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btn_Update(object sender, EventArgs e)
{
if (Page.IsValid)
{
objTADetails = new TADetails();
try
{
objTADetails.editAAADetails(int.Parse(lblAAAID.Text),
txtAAANumber.Text,
txtAAAName.Text,
double.Parse(txtAAAAmount.Text == "" ? "0" : txtAAAAmount.Text),
txtClosingDate.Text,
txtReviseClosingDate.Text,
txtAAAFileNo.Text,
Convert.ToInt32(ddlWSSector.SelectedValue),
Convert.ToInt32(ddlSector.SelectedValue), Convert.ToInt32(ddlStatus.SelectedValue), Convert.ToInt32(ddlWBAgency.SelectedValue), txtSigningDate.Text, txtApprovalDate.Text, txtNegotiationDate.Text, Convert.ToInt32(ddlTeamLeader.SelectedValue));
lblMessage.Text = "Information Successfully Updated";
ut = new Utility();
ut.ResetFormControl(reset);
}
catch (SqlException SE)
{
if (SE.Number == 2627)
{
lblMessage.Text = "This AAA Number already exist.";
}
else
{
lblMessage.Text = "AAA Detail Exist";
logger.Error(SE);
}
}
}
}
protected void grdTaDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
objTADetails = new TADetails();
//Storing the Row Index of Deleted Row
int iPortfolioID = int.Parse(grdTaDetails.DataKeys[e.RowIndex].Value.ToString());
if (grdTaDetails.Rows.Count == 0)
{
lblMessage.Text = "No Information Available";
}
//Function call for row delete
if (objTADetails.deletePortfolioDetails(iPortfolioID))
{
lblMessage.Text = "Information Deleted";
bindGrid();
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btn_Submit(object sender, EventArgs e)
{
if (Page.IsValid)
{
objTADetails = new TADetails();
try
{
txtPortfolioNumber.Text = ddlPipeline.SelectedItem.ToString().Trim().Split('-')[0];
if (objTADetails.addPortfolioDetails(txtPortfolioNumber.Text,
txtPortfolioName.Text, double.Parse(txtPortfolioAmount.Text == "" ? "0" : txtPortfolioAmount.Text),
txtClosingDate.Text,
txtReviseClosingDate.Text,
txtPortfolioFileNo.Text,
Convert.ToInt32(ddlWBAgency.SelectedValue),
((UserDetails)Session[clsConstant.TOKEN]).UserID,
Convert.ToInt32(ddlWSSector.SelectedValue), Convert.ToInt32(ddlSector.SelectedValue), Convert.ToInt32(ddlStatus.SelectedValue),
txtCreditID.Text, Convert.ToInt32(ddlPipeline.SelectedValue), txtSigningDate.Text, txtApprovalDate.Text, txtNegotiationDate.Text, Convert.ToInt32(ddlIDType.SelectedValue), ddlTTl.SelectedValue))
{
//Response.Redirect("ConsultantDetailsAddEdit.aspx");
txtPortfolioName.Text = "";
txtPortfolioNumber.Text = "";
txtClosingDate.Text = "";
txtReviseClosingDate.Text = "";
txtPortfolioAmount.Text = "";
txtPortfolioFileNo.Text = "";
ddlWSSector.ClearSelection();
ddlSector.ClearSelection();
txtCreditID.Text = "";
txtSigningDate.Text = "";
txtApprovalDate.Text = "";
txtNegotiationDate.Text = "";
ddlPipeline.ClearSelection();
ddlWBAgency.ClearSelection();
ddlIDType.ClearSelection();
ddlTTl.ClearSelection();
lblMessage.Text = "Information Successfully Saved";
}
else
{
lblMessage.Text = "Please try after some time";
}
}
catch (SqlException SE)
{
if (SE.Number == 2627)
{
lblMessage.Text = "This Portfolio Number already exist.";
}
else
{
lblMessage.Text = "Detail Exist";
logger.Error(SE);
}
}
//catch (Exception exMessage)
//{
// lblMessage.Text = "Detail Exist";
// logger.Error(exMessage);
//}
}
}
