protected void ddlAddLoanType_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddlAddLoanPartner;
DropDownList ddlAddLoanType;
DropDownList ddlSchemeName;
ddlAddLoanPartner = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddLoanPartner") as DropDownList;
ddlAddLoanType = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddLoanType") as DropDownList;
int Loantype = 0;
int LoanPartner = 0;
if (ddlAddLoanType.SelectedItem.Value.ToString() != "Select Loan Type")
{
Loantype = Convert.ToInt32(ddlAddLoanType.SelectedItem.Value.ToString());
}
if (ddlAddLoanPartner.SelectedItem.Value.ToString() != "Select Loan Partner")
{
LoanPartner = Convert.ToInt32(ddlAddLoanPartner.SelectedItem.Value.ToString());
}
AdviserLoanCommsnStrucWithLoanPartnerBo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerBo();
DataSet ds = AdviserLoanCommsnStrucWithLoanPartner.GetAdviserLoanSchemeNameForLnPtnrLnType(Loantype, LoanPartner, adviserVo.advisorId);
ddlSchemeName = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddSchemeName") as DropDownList;
ddlSchemeName.DataSource = ds;
ddlSchemeName.DataTextField = "LoanSchemeName";
ddlSchemeName.DataValueField = "LoanSchemeId";
ddlSchemeName.DataBind();
ddlSchemeName.Items.Insert(0, "Select Scheme");
}
protected void gvRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int advLnPrtnrId = 0;
AdviserLoanCommsnStrucWithLoanPartnerBo adviserLoanCommsnStrucWithLoanPartnerbo = new AdviserLoanCommsnStrucWithLoanPartnerBo();
advLnPrtnrId = Convert.ToInt32(gvLnCommsnStrucLnPtr.DataKeys[e.RowIndex].Value);
bool result = adviserLoanCommsnStrucWithLoanPartnerbo.DeleteAdvisorLoanPartnerCommission(advLnPrtnrId);
if (result)
{
Bindgrid();
}
}
private void Bindgrid()
{
DataSet ds;
AdviserLoanCommsnStrucWithLoanPartnerBo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerBo();
ds = AdviserLoanCommsnStrucWithLoanPartner.GetAdvisorLoanPartnerCommissionForAdviser(adviserVo.advisorId);
if (ds.Tables[0].Rows.Count == 0)
{
dsCount = 0;
DataTable dt = new DataTable();
DataRow dr = null;
dt = GetGridviewTable();
dr = dt.NewRow();
dt.Rows.Add(dr);
gvLnCommsnStrucLnPtr.DataSource = dt;
gvLnCommsnStrucLnPtr.DataBind();
gvLnCommsnStrucLnPtr.Rows[0].Visible = false;
}
else
{
dsCount = ds.Tables[0].Rows.Count;
lblNoOfRows.Text = dsCount.ToString();
gvLnCommsnStrucLnPtr.DataSource = ds;
foreach (DataRow dr in ds.Tables[0].Rows)
{
AdviserLoanCommsnStrucWithLoanPartnerVo adviserLoanCommsnStrucWithLoanPartnerVo = new AdviserLoanCommsnStrucWithLoanPartnerVo();
adviserLoanCommsnStrucWithLoanPartnerVo.LoanPartnerCode = int.Parse(dr["LoanPartnerCode"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.LoanTypeCode = int.Parse(dr["LoanTypeCode"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.LoanSchemeId = int.Parse(dr["LoanSchemeId"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.CommissionFee = float.Parse(dr["CommissionFee"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.SlabUpperLimit = float.Parse(dr["SlabUpperLimit"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.SlabLowerLimit = float.Parse(dr["SlabLowerLimit"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.StartDate = DateTime.Parse(dr["StartDate"].ToString());
adviserLoanCommsnStrucWithLoanPartnerVo.EndDate = DateTime.Parse(dr["EndDate"].ToString());
AdviserLoanCommsnStrucWithLoanPartnerVoList.Add(adviserLoanCommsnStrucWithLoanPartnerVo);
}
gvLnCommsnStrucLnPtr.DataBind();
}
if (ds.Tables[0].Rows.Count == 0)
{
lblNoOfRows.Text = "0";
}
}
protected void ddlLoanType_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = (DropDownList)sender;
GridViewRow gvr = (GridViewRow)ddl.Parent.Parent;
DropDownList ddlLoanPartner;
DropDownList ddlLoanType;
DropDownList ddlSchemeName;
ddlLoanPartner = gvr.FindControl("ddlLoanPartner") as DropDownList;
ddlLoanType = gvr.FindControl("ddlLoanType") as DropDownList;
int Loantype = Convert.ToInt32(ddlLoanType.SelectedItem.Value.ToString());
int LoanPartner = Convert.ToInt32(ddlLoanPartner.SelectedItem.Value.ToString());
AdviserLoanCommsnStrucWithLoanPartnerBo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerBo();
DataSet ds = AdviserLoanCommsnStrucWithLoanPartner.GetAdviserLoanSchemeNameForLnPtnrLnType(Loantype, LoanPartner, adviserVo.advisorId);
ddlSchemeName = gvr.FindControl("ddlSchemeName") as DropDownList;
ddlSchemeName.DataSource = ds;
ddlSchemeName.DataBind();
ddlSchemeName.Items.Insert(0, "Select Scheme");
}
protected void gvLnCommsnStrucLnPtr_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlAddLoanPartner;
DropDownList ddlAddLoanType;
DropDownList ddlSchemeName;
ddlAddLoanPartner = e.Row.FindControl("ddlAddLoanPartner") as DropDownList;
if (ddlAddLoanPartner != null)
{
ddlAddLoanPartner.DataSource = XMLBo.GetLoanPartner(path);
ddlAddLoanPartner.DataTextField = "XLP_LoanPartner";
ddlAddLoanPartner.DataValueField = "XLP_LoanPartnerCode";
ddlAddLoanPartner.DataBind();
ddlAddLoanPartner.Items.Insert(0, "Select Loan Partner");
}
ddlAddLoanType = e.Row.FindControl("ddlAddLoanType") as DropDownList;
if (ddlAddLoanType != null)
{
ddlAddLoanType.DataSource = XMLBo.GetLoanType(path);
ddlAddLoanType.DataTextField = "XLT_LoanType";
ddlAddLoanType.DataValueField = "XLT_LoanTypeCode";
ddlAddLoanType.DataBind();
ddlAddLoanType.Items.Insert(0, "Select Loan Type");
}
ddlSchemeName = e.Row.FindControl("ddlAddSchemeName") as DropDownList;
ddlSchemeName.Items.Insert(0, "Select Scheme");
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (dsCount != 0)
{
DropDownList ddlLoanPartner;
DropDownList ddlLoanType;
DropDownList ddlSchemeName;
AdviserLoanCommsnStrucWithLoanPartnerVo adviserLoanCommsnStrucWithLoanPartnervo = new AdviserLoanCommsnStrucWithLoanPartnerVo();
adviserLoanCommsnStrucWithLoanPartnervo = AdviserLoanCommsnStrucWithLoanPartnerVoList[gvLnCommsnStrucLnPtr.Rows.Count];
ddlLoanPartner = e.Row.FindControl("ddlLoanPartner") as DropDownList;
if (ddlLoanPartner != null)
{
ddlLoanPartner.DataSource = XMLBo.GetLoanPartner(path);
ddlLoanPartner.DataTextField = "XLP_LoanPartner";
ddlLoanPartner.DataValueField = "XLP_LoanPartnerCode";
ddlLoanPartner.DataBind();
ddlLoanPartner.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanPartnerCode.ToString();
}
ddlLoanType = e.Row.FindControl("ddlLoanType") as DropDownList;
if (ddlLoanType != null)
{
ddlLoanType.DataSource = XMLBo.GetLoanType(path);
ddlLoanType.DataTextField = "XLT_LoanType";
ddlLoanType.DataValueField = "XLT_LoanTypeCode";
ddlLoanType.DataBind();
ddlLoanType.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanTypeCode.ToString();
}
AdviserLoanCommsnStrucWithLoanPartnerBo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerBo();
DataSet ds1 = AdviserLoanCommsnStrucWithLoanPartner.GetAdviserLoanSchemeNameForLnPtnrLnType(int.Parse(ddlLoanType.SelectedValue), int.Parse(ddlLoanPartner.SelectedValue), adviserVo.advisorId);
ddlSchemeName = e.Row.FindControl("ddlSchemeName") as DropDownList;
if (ddlSchemeName != null)
{
ddlSchemeName.DataSource = ds1;
ddlSchemeName.DataTextField = "LoanSchemeName";
ddlSchemeName.DataValueField = "LoanSchemeId";
ddlSchemeName.DataBind();
ddlSchemeName.SelectedValue = adviserLoanCommsnStrucWithLoanPartnervo.LoanSchemeId.ToString();
}
}
}
}
private bool InsertNew()
{
bool result = false;
TextBox txtAddCommissionFee = gvLnCommsnStrucLnPtr.FooterRow.FindControl("txtAddCommissionFee") as TextBox;
TextBox txtAddSlabLowerLimit = gvLnCommsnStrucLnPtr.FooterRow.FindControl("txtAddSlabLowerLimit") as TextBox;
TextBox txtAddSlabUpperLimit = gvLnCommsnStrucLnPtr.FooterRow.FindControl("txtAddSlabUpperLimit") as TextBox;
TextBox txtAddStartDate = gvLnCommsnStrucLnPtr.FooterRow.FindControl("txtAddStartDate") as TextBox;
TextBox txtAddEndDate = gvLnCommsnStrucLnPtr.FooterRow.FindControl("txtAddEndDate") as TextBox;
DropDownList ddlAddLoanPartner = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddLoanPartner") as DropDownList;
DropDownList ddlAddLoanType = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddLoanType") as DropDownList;
DropDownList ddlAddSchemeName = gvLnCommsnStrucLnPtr.FooterRow.FindControl("ddlAddSchemeName") as DropDownList;
AdviserLoanCommsnStrucWithLoanPartnerVo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerVo();
AdviserLoanCommsnStrucWithLoanPartnerBo adviserLoanCommsnStrucWithLoanPartnerbo = new AdviserLoanCommsnStrucWithLoanPartnerBo();
if (ddlAddLoanPartner.SelectedItem.Value != "Select Loan Partner" && ddlAddLoanType.SelectedItem.Value != "Select Loan Type" &&
ddlAddSchemeName.SelectedItem.Value != "Select Scheme" && txtAddCommissionFee.Text.Trim() != "" &&
txtAddSlabLowerLimit.Text.Trim() != "" && txtAddSlabUpperLimit.Text.Trim() != "" &&
txtAddEndDate.Text.Trim() != "" && txtAddStartDate.Text.Trim() != "")
{
try
{
AdviserLoanCommsnStrucWithLoanPartner.AdviserId = adviserVo.advisorId;
AdviserLoanCommsnStrucWithLoanPartner.LoanPartnerCode = int.Parse(ddlAddLoanPartner.SelectedItem.Value.ToString());
AdviserLoanCommsnStrucWithLoanPartner.LoanTypeCode = int.Parse(ddlAddLoanType.SelectedItem.Value.ToString());
AdviserLoanCommsnStrucWithLoanPartner.LoanSchemeId = int.Parse(ddlAddSchemeName.SelectedItem.Value.ToString());
AdviserLoanCommsnStrucWithLoanPartner.CommissionFee = float.Parse(txtAddCommissionFee.Text);
AdviserLoanCommsnStrucWithLoanPartner.SlabUpperLimit = float.Parse(txtAddSlabUpperLimit.Text);
AdviserLoanCommsnStrucWithLoanPartner.SlabLowerLimit = float.Parse(txtAddSlabLowerLimit.Text);
AdviserLoanCommsnStrucWithLoanPartner.StartDate = DateTime.Parse(txtAddStartDate.Text);
AdviserLoanCommsnStrucWithLoanPartner.EndDate = DateTime.Parse(txtAddEndDate.Text);
AdviserLoanCommsnStrucWithLoanPartner.CreatedBy = userVo.UserId;
AdviserLoanCommsnStrucWithLoanPartner.CreatedOn = DateTime.Now;
AdviserLoanCommsnStrucWithLoanPartner.ModifiedBy = userVo.UserId;
AdviserLoanCommsnStrucWithLoanPartner.ModifiedOn = DateTime.Now;
result = adviserLoanCommsnStrucWithLoanPartnerbo.InsertAdviserLoanSchemeNameForLnPtnrLnType(AdviserLoanCommsnStrucWithLoanPartner);
trValueInserted.Visible = true;
result = true;
}
catch (Exception ex)
{
trInsertError.Visible = true;
gvLnCommsnStrucLnPtr.FooterRow.BackColor = System.Drawing.Color.Red;
result = false;
}
}
else if (ddlAddLoanPartner.SelectedItem.Value == "Select Loan Partner" && ddlAddLoanType.SelectedItem.Value == "Select Loan Type" &&
ddlAddSchemeName.SelectedItem.Value == "Select Scheme" && txtAddCommissionFee.Text.Trim() == "" &&
txtAddSlabLowerLimit.Text.Trim() == "" && txtAddSlabUpperLimit.Text.Trim() == "" &&
txtAddEndDate.Text.Trim() == "" && txtAddStartDate.Text.Trim() == "")
{
if (dsCount == 0)
{
result = false;
trInsertError.Visible = true;
}
}
else
{
if (gvLnCommsnStrucLnPtr.Rows.Count == 0)
{
if (ddlAddLoanPartner.SelectedItem.Value == "Select Loan Partner" && ddlAddLoanType.SelectedItem.Value == "Select Loan Type" &&
ddlAddSchemeName.SelectedItem.Value == "Select Scheme" && txtAddCommissionFee.Text.Trim() == "" &&
txtAddSlabLowerLimit.Text.Trim() == "" && txtAddSlabUpperLimit.Text.Trim() == "" &&
txtAddEndDate.Text.Trim() == "" && txtAddStartDate.Text.Trim() == "")
{
trInsertError.Visible = true;
}
gvLnCommsnStrucLnPtr.FooterRow.BackColor = System.Drawing.Color.Red;
result = false;
}
trValuesUpdated.Visible = false;
trInsertError.Visible = true;
gvLnCommsnStrucLnPtr.FooterRow.BackColor = System.Drawing.Color.Red;
gvLnCommsnStrucLnPtr.CssClass = "selected";
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
dsCount = int.Parse(lblNoOfRows.Text);
}
if (trInsertError.Visible == true)
{
trInsertError.Visible = false;
}
if (trUpdateError.Visible == true)
{
trUpdateError.Visible = false;
}
if (trValueInserted.Visible == true)
{
trValueInserted.Visible = false;
}
if (trValuesUpdated.Visible == true)
{
trValuesUpdated.Visible = false;
}
bool UpdateResult = true;
AdviserLoanCommsnStrucWithLoanPartnerVo AdviserLoanCommsnStrucWithLoanPartner = new AdviserLoanCommsnStrucWithLoanPartnerVo();
AdviserLoanCommsnStrucWithLoanPartnerBo adviserLoanCommsnStrucWithLoanPartnerbo = new AdviserLoanCommsnStrucWithLoanPartnerBo();
if (dsCount > 0)
{
foreach (GridViewRow gvRow in gvLnCommsnStrucLnPtr.Rows)
{
TextBox txtCommissionFee = gvRow.FindControl("txtCommissionFee") as TextBox;
TextBox txtSlabLowerLimit = gvRow.FindControl("txtSlabLowerLimit") as TextBox;
TextBox txtSlabUpperLimit = gvRow.FindControl("txtSlabUpperLimit") as TextBox;
TextBox txtStartDate = gvRow.FindControl("txtStartDate") as TextBox;
TextBox txtEndDate = gvRow.FindControl("txtEndDate") as TextBox;
DropDownList ddlLoanPartner = gvRow.FindControl("ddlLoanPartner") as DropDownList;
DropDownList ddlLoanType = gvRow.FindControl("ddlLoanType") as DropDownList;
DropDownList ddlSchemeName = gvRow.FindControl("ddlSchemeName") as DropDownList;
try
{
AdviserLoanCommsnStrucWithLoanPartner.AdviserId = adviserVo.advisorId;
AdviserLoanCommsnStrucWithLoanPartner.Id = int.Parse(gvLnCommsnStrucLnPtr.DataKeys[gvRow.RowIndex].Value.ToString());
AdviserLoanCommsnStrucWithLoanPartner.LoanPartnerCode = int.Parse(ddlLoanPartner.SelectedItem.Value.ToString());
AdviserLoanCommsnStrucWithLoanPartner.LoanTypeCode = int.Parse(ddlLoanType.SelectedItem.Value.ToString());
if (ddlSchemeName.SelectedItem.Value != "Select Scheme")
{
AdviserLoanCommsnStrucWithLoanPartner.LoanSchemeId = int.Parse(ddlSchemeName.SelectedItem.Value.ToString());
}
AdviserLoanCommsnStrucWithLoanPartner.CommissionFee = float.Parse(txtCommissionFee.Text);
AdviserLoanCommsnStrucWithLoanPartner.SlabUpperLimit = float.Parse(txtSlabUpperLimit.Text);
AdviserLoanCommsnStrucWithLoanPartner.SlabLowerLimit = float.Parse(txtSlabLowerLimit.Text);
AdviserLoanCommsnStrucWithLoanPartner.StartDate = DateTime.Parse(txtStartDate.Text);
AdviserLoanCommsnStrucWithLoanPartner.EndDate = DateTime.Parse(txtEndDate.Text);
AdviserLoanCommsnStrucWithLoanPartner.ModifiedBy = userVo.UserId;
AdviserLoanCommsnStrucWithLoanPartner.ModifiedOn = DateTime.Now;
if (ddlSchemeName.SelectedItem.Value != "Select Scheme" && txtCommissionFee.Text.Trim() != "" &&
txtSlabLowerLimit.Text.Trim() != "" && txtSlabUpperLimit.Text.Trim() != "" &&
txtEndDate.Text.Trim() != "" && txtStartDate.Text.Trim() != "")
{
bool result = adviserLoanCommsnStrucWithLoanPartnerbo.UpdateAdviserLoanSchemeNameForLnPtnrLnType(AdviserLoanCommsnStrucWithLoanPartner);
}
else
{
trUpdateError.Visible = true;
gvRow.BackColor = System.Drawing.Color.Red;
gvRow.CssClass = "selected";
UpdateResult = false;
}
}
catch (Exception ex)
{
trUpdateError.Visible = true;
gvRow.BackColor = System.Drawing.Color.Red;
gvRow.CssClass = "selected";
UpdateResult = false;
}
}
}
bool insertresult = false;
if (UpdateResult == true)
{
if (dsCount != 0)
{
trValuesUpdated.Visible = true;
}
insertresult = InsertNew();
Bindgrid();
}
if (insertresult == true && UpdateResult == true)
{
Bindgrid();
trValueInserted.Visible = true;
}
}
