/// <summary>
/// Added By : Himanshu Pandya
/// Date : 06-01-2012
/// Desc : Bind FixDeposite Maturity Details.
/// </summary>
public void BindFixDepositeMaturityDetails()
{
objFixDeposite = new clsFixDeposite();
DataTable dtFixDeposite = new DataTable();
try
{
if (!string.IsNullOrEmpty(ddlFDPeriodYears.SelectedValue.ToString()))
{
objFixDeposite.FixDepositeTypeId = Convert.ToInt32(ddlFDPeriodYears.SelectedValue);
objFixDeposite.FixDepositeAmount = !string.IsNullOrEmpty(txtFixDepositeAmount.Text) ? Convert.ToDecimal(txtFixDepositeAmount.Text) : 0;
objFixDeposite.FixDepositeDate = !string.IsNullOrEmpty(txtFixDepositeDate.Text) ? txtFixDepositeDate.Text : string.Empty;
dtFixDeposite = objFixDeposite.GetFixDepositeMaturityDetailsByFixDepositeTypeId();
if (dtFixDeposite.Rows.Count > 0)
{
txtFDInterestRate.Text = dtFixDeposite.Rows[0]["FixDepositeDate"].ToString();
txtFDMaturityDate.Text = dtFixDeposite.Rows[0]["MaturityDate"].ToString();
txtFDMaturityAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtFixDeposite.Rows[0]["MaturityAmount"]));
}
}
}
catch
{ }
finally
{
objFixDeposite = null;
dtFixDeposite = null;
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Fix Deposite GridRow Editing.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvFixDeposite_RowEditing(object sender, GridViewEditEventArgs e)
{
objFixDeposite = new clsFixDeposite();
DataTable dtFixDeposite = new DataTable();
int iFixDepositeId;
try
{
iFixDepositeId = Convert.ToInt32(((Label)gvFixDeposite.Rows[e.NewEditIndex].FindControl("lblFixDepositeId")).Text);
if (iFixDepositeId > 0)
{
objFixDeposite.FixDepositeId = iFixDepositeId;
dtFixDeposite = objFixDeposite.GetFixDepositeDetailsByFixDepositeId();
if (dtFixDeposite.Rows.Count > 0)
{
//Fill Fix Deposite Information
hdnFixDepositeId.Value = dtFixDeposite.Rows[0]["FixDepositeId"].ToString();
hdnCustomerId.Value = dtFixDeposite.Rows[0]["CustomerId"].ToString();
txtFDCustomerNo.Text = dtFixDeposite.Rows[0]["CustomerCode"].ToString();
txtFixDepositeDate.Text = dtFixDeposite.Rows[0]["FixDepositeDate"].ToString();
ddlCustomerType.SelectedIndex = ddlCustomerType.Items.IndexOf(ddlCustomerType.Items.FindByValue(dtFixDeposite.Rows[0]["CustomerTypeId"].ToString()));
ddlFDCustomernamePrefix.SelectedIndex = ddlFDCustomernamePrefix.Items.IndexOf(ddlFDCustomernamePrefix.Items.FindByText(dtFixDeposite.Rows[0]["CustomerNamePrifix"].ToString()));
txtFDCusotmerFirstname.Text = dtFixDeposite.Rows[0]["CustomerFirstName"].ToString();
txtFDCustomerMiddlename.Text = dtFixDeposite.Rows[0]["CustomerMiddleName"].ToString();
txtFDCustomerLastname.Text = dtFixDeposite.Rows[0]["CustomerLastName"].ToString();
//Bind FD Types as per customer Type
BindFixDepositeTypes();
ddlFixDepositeType.SelectedIndex = ddlFixDepositeType.Items.IndexOf(ddlFixDepositeType.Items.FindByValue(dtFixDeposite.Rows[0]["FixDepositeTypeId"].ToString()));
//Then Bind Fix Deposite Periods and Interest Rate.
BindFixDepositePeriods();
ddlFDPeriodYears.SelectedIndex = ddlFDPeriodYears.Items.IndexOf(ddlFDPeriodYears.Items.FindByValue(dtFixDeposite.Rows[0]["FixDepositePeriods"].ToString()));
txtFDInterestRate.Text = dtFixDeposite.Rows[0]["FixDepositeInterestRate"].ToString();
txtFixDepositeAmount.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtFixDeposite.Rows[0]["FixDepositeAmount"]));
txtFDMaturityDate.Text = dtFixDeposite.Rows[0]["MaturityDate"].ToString();
txtFDMaturityAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtFixDeposite.Rows[0]["MaturityAmount"]));
//Fill Nominee Information
hdnNomineeId.Value = dtFixDeposite.Rows[0]["NomineeId"].ToString();
ddlFDNomineePrefix.SelectedIndex = ddlFDNomineePrefix.Items.IndexOf(ddlFDNomineePrefix.Items.FindByText(dtFixDeposite.Rows[0]["NomineeNamePrefix"].ToString()));
txtFDNomineeFirstname.Text = dtFixDeposite.Rows[0]["NomineeFirstName"].ToString();
txtFDNomineeMiddlename.Text = dtFixDeposite.Rows[0]["NomineeMiddleName"].ToString();
txtFDNomineeLastname.Text = dtFixDeposite.Rows[0]["NomineeLastName"].ToString();
txtFDNomineeAddress.Text = dtFixDeposite.Rows[0]["NomineeAddress"].ToString();
ddlFDNomineeVillage.SelectedIndex = ddlFDNomineeVillage.Items.IndexOf(ddlFDNomineeVillage.Items.FindByValue(dtFixDeposite.Rows[0]["NomineeVillageId"].ToString())); ;
ddlFDNomineeTaluka.SelectedIndex = ddlFDNomineeTaluka.Items.IndexOf(ddlFDNomineeTaluka.Items.FindByValue(dtFixDeposite.Rows[0]["NomineeTahsilId"].ToString())); ;
ddlFDNomineeDistrict.SelectedIndex = ddlFDNomineeDistrict.Items.IndexOf(ddlFDNomineeDistrict.Items.FindByValue(dtFixDeposite.Rows[0]["NomineeDistrictId"].ToString())); ;
txtFDNomineePinCode.Text = dtFixDeposite.Rows[0]["NomineePinCode"].ToString();
txtFDNomineePhonenumber.Text = dtFixDeposite.Rows[0]["NomineePhoneNumber"].ToString();
EnableDisableFixDepositeControls(false);
}
ShowHideFixDepositeGrid(false);
}
}
catch
{
}
finally
{
objFixDeposite = null;
dtFixDeposite = null;
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Save New Fix Deposite Details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveFixDepoisite_Click(object sender, EventArgs e)
{
objFixDeposite = new clsFixDeposite();
objNominee = new clsNominees();
try
{
if (Page.IsValid)
{
if (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())))
{
objFixDeposite.FixDepositeId = !string.IsNullOrEmpty(hdnFixDepositeId.Value) ? Convert.ToInt32(hdnFixDepositeId.Value.ToString()) : 0;
objFixDeposite.CustomerId = !string.IsNullOrEmpty(hdnCustomerId.Value) ? Convert.ToInt32(hdnCustomerId.Value.ToString()) : 0;
objFixDeposite.FixDepositeDate = !string.IsNullOrEmpty(txtFixDepositeDate.Text) ? txtFixDepositeDate.Text : string.Empty;
objFixDeposite.FixDepositeTypeId = !string.IsNullOrEmpty(ddlFDPeriodYears.SelectedValue) ? Convert.ToInt32(ddlFDPeriodYears.SelectedValue.ToString()) : 0;
objFixDeposite.FixDepositeAmount = !string.IsNullOrEmpty(txtFixDepositeAmount.Text) ? Convert.ToDecimal(txtFixDepositeAmount.Text) : 0;
objFixDeposite.MaturityDate = !string.IsNullOrEmpty(txtFDMaturityDate.Text) ? txtFDMaturityDate.Text : string.Empty;
objFixDeposite.MaturityAmount = !string.IsNullOrEmpty(txtFDMaturityAmt.Text) ? Convert.ToDecimal(txtFDMaturityAmt.Text) : 0;
objFixDeposite.IsClosed = false;
objFixDeposite.ClosedDate = string.Empty;
objFixDeposite.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
objFixDeposite.CreatedDate = Convert.ToDateTime(txtFixDepositeDate.Text);
objFixDeposite.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
objFixDeposite.UpdatedDate = Convert.ToDateTime(txtFixDepositeDate.Text);
objFixDeposite.IsActive = true;
if (objFixDeposite.Insert())
{
//Customer Nominee Details
objNominee.NomineeId = !string.IsNullOrEmpty(hdnNomineeId.Value) ? Convert.ToInt32(hdnNomineeId.Value.ToString()) : 0;
objNominee.NomineeReferenceId = objFixDeposite.FixDepositeId > 0 ? objFixDeposite.FixDepositeId : 0;
objNominee.NomineeTypeId = Convert.ToInt32(clsEnum.NomineeType.FixDeposite.GetHashCode().ToString());
objNominee.NamePrefix = !string.IsNullOrEmpty(ddlFDNomineePrefix.SelectedValue) ? ddlFDNomineePrefix.SelectedValue.ToString() : string.Empty;
objNominee.FirstName = !string.IsNullOrEmpty(txtFDNomineeFirstname.Text) ? txtFDNomineeFirstname.Text.ToString() : string.Empty;
objNominee.MiddleName = !string.IsNullOrEmpty(txtFDNomineeMiddlename.Text) ? txtFDNomineeMiddlename.Text.ToString() : string.Empty;
objNominee.LastName = !string.IsNullOrEmpty(txtFDNomineeLastname.Text) ? txtFDNomineeLastname.Text.ToString() : string.Empty;
objNominee.Address = !string.IsNullOrEmpty(txtFDNomineeAddress.Text) ? txtFDNomineeAddress.Text.ToString() : string.Empty;
objNominee.VillageId = !string.IsNullOrEmpty(ddlFDNomineeVillage.Text) ? ddlFDNomineeVillage.Text.ToString() : string.Empty;
objNominee.TahsilId = !string.IsNullOrEmpty(ddlFDNomineeTaluka.SelectedValue) ? Convert.ToInt32(ddlFDNomineeTaluka.SelectedValue.ToString()) : 0;
objNominee.DistrictId = !string.IsNullOrEmpty(ddlFDNomineeDistrict.SelectedValue) ? Convert.ToInt32(ddlFDNomineeDistrict.SelectedValue.ToString()) : 0;
objNominee.PinCode = !string.IsNullOrEmpty(txtFDNomineePinCode.Text) ? txtFDNomineePinCode.Text.ToString() : string.Empty;
objNominee.PhoneNumber = !string.IsNullOrEmpty(txtFDNomineePhonenumber.Text) ? txtFDNomineePhonenumber.Text.ToString() : string.Empty;
objNominee.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
objNominee.CreatedDate = Convert.ToDateTime(txtFixDepositeDate.Text);
objNominee.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
objNominee.UpdatedDate = Convert.ToDateTime(txtFixDepositeDate.Text);
objNominee.IsActive = true;
objNominee.Insert();
lblFixDepositeMessage.CssClass = "SuccessfulMessage";
lblFixDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully");
}
else
{
lblFixDepositeMessage.CssClass = "FailureMessage";
lblFixDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire");
}
}
}
ClearFDControls();
BindFixDepositesGrid();
ShowHideFixDepositeGrid(true);
}
catch
{
}
finally
{
objFixDeposite = null;
objNominee = null;
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 12-01-2013
/// Desc : Close Fix Deposite
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCloseFixDeposite_Click(object sender, EventArgs e)
{
clsFixDeposite objFixDeposite = new clsFixDeposite();
try
{
if ((!string.IsNullOrEmpty(hdnFixDepositeId.Value)) && (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()))))
{
objFixDeposite.FixDepositeId = Convert.ToInt32(hdnFixDepositeId.Value.ToString());
objFixDeposite.IsClosed = true;
objFixDeposite.ClosedDate = String.Format("{0:dd/MM/yyyy}", DateTime.Now);
objFixDeposite.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ;
objFixDeposite.UpdatedDate = Convert.ToDateTime(txtFixDepositeDate.Text);
objFixDeposite.IsActive = false;
if (objFixDeposite.CloseFixDepositeByFixDepositeId())
{
lblFixDepositeMessage.CssClass = "SuccessfulMessage";
lblFixDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully");
}
else
{
lblFixDepositeMessage.CssClass = "FailureMessage";
lblFixDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire");
}
ClearFDControls();
BindFixDepositesGrid();
EnableDisableFixDepositeControls(true);
ShowHideFixDepositeGrid(true);
}
}
catch
{ }
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Bind Fix Deposite Details
/// </summary>
public void BindFixDepositesGrid()
{
objFixDeposite = new clsFixDeposite();
DataTable dtFixDeposite = new DataTable();
try
{
if (!string.IsNullOrEmpty(txtSearchFD.Text) && !string.IsNullOrEmpty(ddlFDSearch.SelectedValue))
{
string strsearch = ddlFDSearch.SelectedValue.ToString();
switch (strsearch)
{
case "CusotmerName":
objFixDeposite.CustomerFirstName = txtSearchFD.Text.ToString();
break;
}
}
else
{
objFixDeposite.CustomerFirstName = string.Empty;
}
dtFixDeposite = objFixDeposite.SearcheAllFixDepositeWSearchFilters();
if (dtFixDeposite.Rows.Count > 0)
{
gvFixDeposite.DataSource = dtFixDeposite;
}
else
{
gvFixDeposite.DataSource = null;
}
gvFixDeposite.PageSize = Convert.ToInt32(ddlFDPager.SelectedValue.ToString());
gvFixDeposite.DataBind();
}
catch
{
}
finally
{
objFixDeposite = null;
dtFixDeposite = null;
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 06-01-2013
/// Desc : Bind Fix Deposite Periods.
/// </summary>
/// <param name="FixDepositeTypeId"></param>
public void BindFixDepositePeriods()
{
objFixDeposite = new clsFixDeposite();
DataTable dtFixDeposite = new DataTable();
try
{
if (!string.IsNullOrEmpty(ddlFixDepositeType.SelectedValue.ToString()))
{
ddlFDPeriodYears.Items.Clear();
objFixDeposite.FixDepositeTypeId = Convert.ToInt32(ddlFixDepositeType.SelectedValue.ToString());
dtFixDeposite = objFixDeposite.GetFixDepositePeriodsByFixDepositeTypeId();
{
ddlFDPeriodYears.DataSource = dtFixDeposite;
ddlFDPeriodYears.DataValueField = "FixDepositeTypeId";
ddlFDPeriodYears.DataTextField = "FixDepositeTypeDesc";
ddlFDPeriodYears.DataBind();
}
ddlFDPeriodYears.Items.Insert(0, new ListItem("fuoMk", ""));
}
}
catch
{
}
finally
{
objFixDeposite = null;
dtFixDeposite = null;
}
}
