/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvRecurrenceDeposite_RowEditing(object sender, GridViewEditEventArgs e) { objRecurrenceDeposite = new clsRecurrenceDeposite(); dtRecurrenceDeposite = new DataTable(); int iRecurrenceDepositeId; try { iRecurrenceDepositeId = Convert.ToInt32(((Label)gvRecurrenceDeposite.Rows[e.NewEditIndex].FindControl("lblRecurrenceDepositeId")).Text); if (iRecurrenceDepositeId > 0) { objRecurrenceDeposite.RecurrenceDepositeId = iRecurrenceDepositeId; dtRecurrenceDeposite = objRecurrenceDeposite.GetRecurrenceDepositeDetailsByRecurrenceDepositeId(); if (dtRecurrenceDeposite.Rows.Count > 0) { //Fill Recurrence Deposite Information hdnRecurrenceDepositeId.Value = dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeId"].ToString(); hdnCustomerId.Value = dtRecurrenceDeposite.Rows[0]["CustomerId"].ToString(); txtRDCustomerNo.Text = dtRecurrenceDeposite.Rows[0]["CustomerCode"].ToString(); txtRecurrenceDepositeDate.Text = dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeDate"].ToString(); ddlCustomerType.SelectedIndex = ddlCustomerType.Items.IndexOf(ddlCustomerType.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["CustomerTypeId"].ToString())); ddlRDCustomernamePrefix.SelectedIndex = ddlRDCustomernamePrefix.Items.IndexOf(ddlRDCustomernamePrefix.Items.FindByText(dtRecurrenceDeposite.Rows[0]["CustomerNamePrifix"].ToString())); txtRDCusotmerFirstname.Text = dtRecurrenceDeposite.Rows[0]["CustomerFirstName"].ToString(); txtRDCustomerMiddlename.Text = dtRecurrenceDeposite.Rows[0]["CustomerMiddleName"].ToString(); txtRDCustomerLastname.Text = dtRecurrenceDeposite.Rows[0]["CustomerLastName"].ToString(); txtRecurrenceDepositeAmount.Text = string.Format("{0:0.##}", dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeAmount"]); //Bind Recurrence Deposite Types as per customer Type BindRecurrenceDepositeTypes(); ddlRecurrenceDepositeType.SelectedIndex = ddlRecurrenceDepositeType.Items.IndexOf(ddlRecurrenceDepositeType.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeTypeId"].ToString())); //Then Bind Recurrence Deposite Periods and Interest Rate. BindRecurrenceDepositePeriods(); ddlRecurrenceDepositePeriodYears.SelectedIndex = ddlRecurrenceDepositePeriodYears.Items.IndexOf(ddlRecurrenceDepositePeriodYears.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["RecurrenceDepositePeriods"].ToString())); txtRDInterestRate.Text = dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeInterestRate"].ToString(); txtRecurrenceDepositeAmount.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeAmount"])); txtRDMaturityDate.Text = dtRecurrenceDeposite.Rows[0]["MaturityDate"].ToString(); txtRDMaturityAmt.Text = string.Format("{0:0.##}", dtRecurrenceDeposite.Rows[0]["MaturityAmount"]); //Fill Nominee Information hdnNomineeId.Value = dtRecurrenceDeposite.Rows[0]["NomineeId"].ToString(); ddlRDNomineePrefix.SelectedIndex = ddlRDNomineePrefix.Items.IndexOf(ddlRDNomineePrefix.Items.FindByText(dtRecurrenceDeposite.Rows[0]["NomineeNamePrefix"].ToString())); txtRDNomineeFirstname.Text = dtRecurrenceDeposite.Rows[0]["NomineeFirstName"].ToString(); txtRDNomineeMiddlename.Text = dtRecurrenceDeposite.Rows[0]["NomineeMiddleName"].ToString(); txtRDNomineeLastname.Text = dtRecurrenceDeposite.Rows[0]["NomineeLastName"].ToString(); txtRDNomineeAddress.Text = dtRecurrenceDeposite.Rows[0]["NomineeAddress"].ToString(); ddlRDNomineeVillage.SelectedIndex = ddlRDNomineeVillage.Items.IndexOf(ddlRDNomineeVillage.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["NomineeVillageId"].ToString())); ; ddlRDNomineeTaluka.SelectedIndex = ddlRDNomineeTaluka.Items.IndexOf(ddlRDNomineeTaluka.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["NomineeTahsilId"].ToString())); ; ddlRDNomineeDistrict.SelectedIndex = ddlRDNomineeDistrict.Items.IndexOf(ddlRDNomineeDistrict.Items.FindByValue(dtRecurrenceDeposite.Rows[0]["NomineeDistrictId"].ToString())); ; txtRDNomineePinCode.Text = dtRecurrenceDeposite.Rows[0]["NomineePinCode"].ToString(); txtRDNomineePhonenumber.Text = dtRecurrenceDeposite.Rows[0]["NomineePhoneNumber"].ToString(); EnableDisableRecurrenceDepositeControls(false); } ShowHideRecurrenceDepositeGrid(false); } } catch { } finally { objRecurrenceDeposite = null; dtRecurrenceDeposite = null; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveRecurrenceDepoisite_Click(object sender, EventArgs e) { objRecurrenceDeposite = new clsRecurrenceDeposite(); objNominee = new clsNominees(); try { if (Page.IsValid) { if (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()))) { objRecurrenceDeposite.RecurrenceDepositeId = !string.IsNullOrEmpty(hdnRecurrenceDepositeId.Value) ? Convert.ToInt32(hdnRecurrenceDepositeId.Value.ToString()) : 0; objRecurrenceDeposite.CustomerId = !string.IsNullOrEmpty(hdnCustomerId.Value) ? Convert.ToInt32(hdnCustomerId.Value.ToString()) : 0; objRecurrenceDeposite.RecurrenceDepositeTypeId = !string.IsNullOrEmpty(ddlRecurrenceDepositePeriodYears.SelectedValue) ? Convert.ToInt32(ddlRecurrenceDepositePeriodYears.SelectedValue.ToString()) : 0; objRecurrenceDeposite.RecurrenceDepositeDate = !string.IsNullOrEmpty(txtRecurrenceDepositeDate.Text) ? txtRecurrenceDepositeDate.Text : string.Empty; objRecurrenceDeposite.RecurrenceDepositeAmount = !string.IsNullOrEmpty(txtRecurrenceDepositeAmount.Text) ? Convert.ToDecimal(txtRecurrenceDepositeAmount.Text) : 0; objRecurrenceDeposite.MaturityDate = !string.IsNullOrEmpty(txtRDMaturityDate.Text) ? txtRDMaturityDate.Text : string.Empty; objRecurrenceDeposite.MaturityAmount = !string.IsNullOrEmpty(txtRDMaturityAmt.Text) ? Convert.ToDecimal(txtRDMaturityAmt.Text) : 0; objRecurrenceDeposite.IsClosed = false; objRecurrenceDeposite.ClosedDate = string.Empty; objRecurrenceDeposite.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); objRecurrenceDeposite.CreatedDate = Convert.ToDateTime(txtRecurrenceDepositeDate.Text); objRecurrenceDeposite.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); objRecurrenceDeposite.UpdatedDate = Convert.ToDateTime(txtRecurrenceDepositeDate.Text); objRecurrenceDeposite.IsActive = true; if (objRecurrenceDeposite.Insert()) { //Customer Nominee Details objNominee.NomineeId = !string.IsNullOrEmpty(hdnNomineeId.Value) ? Convert.ToInt32(hdnNomineeId.Value.ToString()) : 0; objNominee.NomineeReferenceId = objRecurrenceDeposite.RecurrenceDepositeId > 0 ? objRecurrenceDeposite.RecurrenceDepositeId : 0; objNominee.NomineeTypeId = Convert.ToInt32(clsEnum.NomineeType.RecurrenceDeposite.GetHashCode().ToString()); objNominee.NamePrefix = !string.IsNullOrEmpty(ddlRDNomineePrefix.SelectedValue) ? ddlRDNomineePrefix.SelectedValue.ToString() : string.Empty; objNominee.FirstName = !string.IsNullOrEmpty(txtRDNomineeFirstname.Text) ? txtRDNomineeFirstname.Text.ToString() : string.Empty; objNominee.MiddleName = !string.IsNullOrEmpty(txtRDNomineeMiddlename.Text) ? txtRDNomineeMiddlename.Text.ToString() : string.Empty; objNominee.LastName = !string.IsNullOrEmpty(txtRDNomineeLastname.Text) ? txtRDNomineeLastname.Text.ToString() : string.Empty; objNominee.Address = !string.IsNullOrEmpty(txtRDNomineeAddress.Text) ? txtRDNomineeAddress.Text.ToString() : string.Empty; objNominee.VillageId = !string.IsNullOrEmpty(ddlRDNomineeVillage.Text) ? ddlRDNomineeVillage.Text.ToString() : string.Empty; objNominee.TahsilId = !string.IsNullOrEmpty(ddlRDNomineeTaluka.SelectedValue) ? Convert.ToInt32(ddlRDNomineeTaluka.SelectedValue.ToString()) : 0; objNominee.DistrictId = !string.IsNullOrEmpty(ddlRDNomineeDistrict.SelectedValue) ? Convert.ToInt32(ddlRDNomineeDistrict.SelectedValue.ToString()) : 0; objNominee.PinCode = !string.IsNullOrEmpty(txtRDNomineePinCode.Text) ? txtRDNomineePinCode.Text.ToString() : string.Empty; objNominee.PhoneNumber = !string.IsNullOrEmpty(txtRDNomineePhonenumber.Text) ? txtRDNomineePhonenumber.Text.ToString() : string.Empty; objNominee.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); objNominee.CreatedDate = Convert.ToDateTime(txtRecurrenceDepositeDate.Text); objNominee.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); objNominee.UpdatedDate = Convert.ToDateTime(txtRecurrenceDepositeDate.Text); objNominee.IsActive = true; objNominee.Insert(); lblRecurrenceDepositeMessage.CssClass = "SuccessfulMessage"; lblRecurrenceDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully"); } else { lblRecurrenceDepositeMessage.CssClass = "FailureMessage"; lblRecurrenceDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire"); } } } ClearRDControls(); EnableDisableRecurrenceDepositeControls(true); BindRecurrenceDepositesGrid(); ShowHideRecurrenceDepositeGrid(true); } catch { } finally { objRecurrenceDeposite = null; objNominee = null; } }
/// <summary> /// Added By : Himanshu Pandya /// Date : 08-03-2013 /// Desc : Close Recurrence Deposite /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCloseRecurrenceDeposite_Click(object sender, EventArgs e) { clsRecurrenceDeposite objRecurrenceDeposite = new clsRecurrenceDeposite(); try { if ((!string.IsNullOrEmpty(hdnRecurrenceDepositeId.Value)) && (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())))) { objRecurrenceDeposite.RecurrenceDepositeId = Convert.ToInt32(hdnRecurrenceDepositeId.Value.ToString()); objRecurrenceDeposite.IsClosed = true; objRecurrenceDeposite.ClosedDate = String.Format("{0:dd/MM/yyyy}", DateTime.Now); objRecurrenceDeposite.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ; objRecurrenceDeposite.UpdatedDate = Convert.ToDateTime(txtRecurrenceDepositeDate.Text); objRecurrenceDeposite.IsActive = false; if (objRecurrenceDeposite.CloseRecurrenceDepositeByRecurrenceDepositeId()) { lblRecurrenceDepositeMessage.CssClass = "SuccessfulMessage"; lblRecurrenceDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully"); } else { lblRecurrenceDepositeMessage.CssClass = "FailureMessage"; lblRecurrenceDepositeMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire"); } ClearRDControls(); BindRecurrenceDepositesGrid(); EnableDisableRecurrenceDepositeControls(true); ShowHideRecurrenceDepositeGrid(true); } } catch { } }
/// <summary> /// Added By : Himanshu Pandya /// Date : 31-12-2012 /// Desc : Bind Recurrence Deposite Details /// </summary> public void BindRecurrenceDepositesGrid() { objRecurrenceDeposite = new clsRecurrenceDeposite(); dtRecurrenceDeposite = new DataTable(); try { if (!string.IsNullOrEmpty(txtSearchRD.Text) && !string.IsNullOrEmpty(ddlRDSearch.SelectedValue)) { string strsearch = ddlRDSearch.SelectedValue.ToString(); switch (strsearch) { case "CusotmerName": objRecurrenceDeposite.CustomerFirstName = txtSearchRD.Text.ToString(); break; } } else { objRecurrenceDeposite.CustomerFirstName = string.Empty; } dtRecurrenceDeposite = objRecurrenceDeposite.SearcheAllRecurrenceDepositeWSearchFilters(); if (dtRecurrenceDeposite.Rows.Count > 0) { gvRecurrenceDeposite.DataSource = dtRecurrenceDeposite; } else { gvRecurrenceDeposite.DataSource = null; } gvRecurrenceDeposite.PageSize = Convert.ToInt32(ddlRDPager.SelectedValue.ToString()); gvRecurrenceDeposite.DataBind(); } catch { } finally { objRecurrenceDeposite = null; dtRecurrenceDeposite = null; } }
/// <summary> /// Added By : Himanshu Pandya /// Date : 04-03-2013 /// Desc : Bind Recurrence Deposite Periods. /// </summary> /// <param name="RecurrenceDepositeTypeId"></param> public void BindRecurrenceDepositePeriods() { objRecurrenceDeposite = new clsRecurrenceDeposite(); List<clsRecurrenceDepositeTypes> lstRDTypes = null; try { if (!string.IsNullOrEmpty(ddlRecurrenceDepositeType.SelectedValue.ToString())) { ddlRecurrenceDepositePeriodYears.Items.Clear(); lstRDTypes = clsRecurrenceDepositeTypes.GetRecurrenceDepositePeriodsByRecurrenceDepositeTypeId(Convert.ToInt32(ddlRecurrenceDepositeType.SelectedValue.ToString())); if (lstRDTypes.Count > 0) { ddlRecurrenceDepositePeriodYears.DataSource = lstRDTypes; ddlRecurrenceDepositePeriodYears.DataValueField = "RecurrenceDepositeTypeId"; ddlRecurrenceDepositePeriodYears.DataTextField = "RecurrenceDepositeTypeName"; ddlRecurrenceDepositePeriodYears.DataBind(); } ddlRecurrenceDepositePeriodYears.Items.Insert(0, new ListItem("fuoMk", "")); } } catch { } finally { objRecurrenceDeposite = null; lstRDTypes = null; } }
/// <summary> /// Added By : Himanshu Pandya /// Date : 04-03-2013 /// </summary> public void BindRecurrenceDepositeMaturityDetails() { objRecurrenceDeposite = new clsRecurrenceDeposite(); DataTable dtRecurrenceDeposite = new DataTable(); try { if (!string.IsNullOrEmpty(ddlRecurrenceDepositePeriodYears.SelectedValue.ToString())) { objRecurrenceDeposite.RecurrenceDepositeTypeId = Convert.ToInt32(ddlRecurrenceDepositePeriodYears.SelectedValue); objRecurrenceDeposite.RecurrenceDepositeAmount = !string.IsNullOrEmpty(txtRecurrenceDepositeAmount.Text) ? Convert.ToDecimal(txtRecurrenceDepositeAmount.Text) : 0; objRecurrenceDeposite.RecurrenceDepositeDate = !string.IsNullOrEmpty(txtRecurrenceDepositeDate.Text) ? txtRecurrenceDepositeDate.Text : string.Empty; dtRecurrenceDeposite = objRecurrenceDeposite.GetRecurrenceDepositeMaturityDetailsByRecurrenceDepositeTypeId(); if (dtRecurrenceDeposite.Rows.Count > 0) { txtRDInterestRate.Text = dtRecurrenceDeposite.Rows[0]["RecurrenceDepositeDate"].ToString(); txtRDMaturityDate.Text = dtRecurrenceDeposite.Rows[0]["MaturityDate"].ToString(); txtRDMaturityAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtRecurrenceDeposite.Rows[0]["MaturityAmount"])); } } } catch { } finally { objRecurrenceDeposite = null; dtRecurrenceDeposite = null; } }