/// <summary> /// Gets the reward points summary. /// </summary> /// <param name="accountNumber">The account number.</param> /// <returns></returns> /// <remarks></remarks> public CH_CR_TERMDTO GetRewardPointsSummary(string accountNumber) { CH_CR_TERMDTO objRewardPointsSummary = new CH_CR_TERMDTO(); objRewardPointsSummary = AccountDALC.GetRewardPointsSummary(accountNumber); return(objRewardPointsSummary); }
/// <summary> /// Gets the summary. /// </summary> /// <param name="accountNumber">The account number.</param> /// <returns></returns> /// <remarks></remarks> public CH_CR_TERMDTO GetSummary(string accountNumber) { CH_CR_TERMDTO objLastBillSummary = new CH_CR_TERMDTO(); objLastBillSummary = AccountDALC.GetSummary(accountNumber); return(objLastBillSummary); }
/// <summary> /// Binds the grid card statement. /// </summary> /// <param name="accountNumber">The account number.</param> /// <remarks></remarks> private void BindGridCardStatement(string accountNumber) { lblStmntmonthrange.Text = ""; try { int monthRange = GetMonthRangeToShowStatement(Constants.CardHolderStatementMonthly); if (monthRange > 0) { lblStmntmonthrange.Text = Constants.StatementMonths + monthRange + " months"; } int pRecordCount = 0; int SkipCount = (this.Pager1.CurrentIndex - 1) * this.Pager1.PageSize; lstCardStatement = new CardManager().GetCardStatement(SkipCount, this.Pager1.PageSize, ref pRecordCount, accountNumber, monthRange); lstViewCardStatement.DataSource = lstCardStatement; this.RecordCount = pRecordCount; this.Pager1.Visible = this.RecordCount > this.Pager1.PageSize; //if (pRecordCount > 0) // btnPayNow.Visible = true; //else // btnPayNow.Visible = false; lstViewCardStatement.DataBind(); double closingBalance = 0; // CH_CR_TERMDTO lastRecordInGrid = lstCardStatement[lstCardStatement.Count - 1]; CH_CR_TERMDTO lastRecordInGrid = lstCardStatement[0]; if (lastRecordInGrid != null) { closingBalance = lastRecordInGrid.Billed_Closing_Bal; } if (Session[totalUnbilledAmount] != null) { Session[totalUnbilledAmount] = null; } Session[sessionAmountDue] = closingBalance; } catch (Exception ex) { DisplayMessage("Some error has generated.Please contact administrator.", false); } }
/// <summary> /// Gets the last bill summary. /// </summary> /// <param name="accountNumber">The account number.</param> /// <returns></returns> public static CH_CR_TERMDTO GetRewardPointsSummary(string accountNumber) { CH_CR_TERMDTO objTermDTO = new CH_CR_TERMDTO(); try { using (OracleConnection conn = new OracleConnection(common.GetConnectionstring())) { conn.Open(); string sql = "SELECT * from BOBVW_REWARDPOINT_SUMMARY where cr_account_nbr=:cr_account_nbr"; OracleCommand cmd = new OracleCommand(sql, conn); OracleParameter p1 = new OracleParameter("cr_account_nbr", OracleDbType.Varchar2, 30); p1.Value = accountNumber; cmd.Parameters.Add(p1); OracleDataReader dr = cmd.ExecuteReader(); if (dr == null) { return(null); } while (dr.Read()) { objTermDTO.PTS_CLOSING = dr[col_Pts_Closing] == null ? 0 : Convert.ToDouble(dr[col_Pts_Closing]); objTermDTO.PTS_OPENING = dr[col_Pts_Opening] == null ? 0 : Convert.ToDouble(dr[col_Pts_Opening]); objTermDTO.Earned_For_The_Month = dr[col_Earned_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Earned_For_The_Month]); objTermDTO.Redeemed_For_The_Month = dr[col_Redeemed_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Redeemed_For_The_Month]); objTermDTO.Points_Expiring = dr[col_Redeemed_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Redeemed_For_The_Month]); //Query } } } catch (Exception ex) { string str = ex.Message; common.logger.Debug(errorGenerated + " Summary : " + ex.Message.ToString()); return(null); } return(objTermDTO); }
/// <summary> /// Gets the last bill summary. /// </summary> /// <param name="accountNumber">The account number.</param> /// <returns></returns> public static CH_CR_TERMDTO GetSummary(string accountNumber) { CH_CR_TERMDTO objTermDTO = new CH_CR_TERMDTO(); try { using (OracleConnection conn = new OracleConnection(common.GetConnectionstring())) { conn.Open(); //string sql = "SELECT * from BOBVW_BILLSUMMARY where STAT_DATE =(select max(C.STAT_DATE) from cr_term C where C.cr_account_nbr=:cr_account_nbr) and cr_account_nbr=:cr_account_nbr"; string sql = "SELECT * from BOBVW_BILLSUMMARY where cr_account_nbr=:cr_account_nbr"; OracleCommand cmd = new OracleCommand(sql, conn); OracleParameter p1 = new OracleParameter("cr_account_nbr", OracleDbType.Varchar2, 30); p1.Value = accountNumber; cmd.Parameters.Add(p1); OracleDataReader dr = cmd.ExecuteReader(); if (dr == null) { return(null); } while (dr.Read()) { if (dr[BILLED_OPENING_BAL] != null & Convert.ToString(dr[BILLED_OPENING_BAL]) != "") { objTermDTO.BILLED_OPENING_BAL = Convert.ToDouble(dr[BILLED_OPENING_BAL]); } else { objTermDTO.BILLED_OPENING_BAL = 0; } if (dr[col_Total_Amount_Due] != null & Convert.ToString(dr[col_Total_Amount_Due]) != "") { objTermDTO.Total_Amount_Due = Convert.ToDouble(dr[col_Total_Amount_Due]); } else { objTermDTO.Total_Amount_Due = 0; } if (dr[TOTAL_CREDITS] != null & Convert.ToString(dr[TOTAL_CREDITS]) != "") { objTermDTO.TOTAL_CREDITS = Convert.ToDouble(dr[TOTAL_CREDITS]); } else { objTermDTO.BILLED_OPENING_BAL = 0; } if (dr[TOTAL_DEBITS] != null & Convert.ToString(dr[TOTAL_DEBITS]) != "") { objTermDTO.TOTAL_DEBITS = Convert.ToDouble(dr[TOTAL_DEBITS]); } else { objTermDTO.BILLED_OPENING_BAL = 0; } // objTermDTO.Total_Outstanding = dr[col_Total_Outstanding] == null ? 0 : Convert.ToDouble(dr[col_Total_Outstanding]); objTermDTO.Minimum_Amount_Due = dr[col_Billed_Min_Due] == null ? 0 : Convert.ToDouble(dr[col_Billed_Min_Due]); objTermDTO.Payment_Due_Date = Convert.ToDateTime(dr[col_Payment_Due_Date]); objTermDTO.Stat_Date = Convert.ToDateTime(dr[STAT_DATE]); if (dr[col_Amount_Received] != null & Convert.ToString(dr[col_Amount_Received]) != "") { objTermDTO.Amount_Received = Convert.ToDouble(dr[col_Amount_Received]); } else { objTermDTO.Amount_Received = 0; } if (objTermDTO.Paymnet_Received_Date != null && Convert.ToString(objTermDTO.Paymnet_Received_Date) != "" && Convert.ToString(objTermDTO.Paymnet_Received_Date) != "01-Jan-01 12:00:00 AM") { objTermDTO.Paymnet_Received_Date = Convert.ToDateTime(dr[col_Payment_Received_Date]); } else { objTermDTO.Paymnet_Received_Date = DateTime.MinValue; } //objTermDTO.Closing_Balance = dr[col_Closing_Balance] == null ? 0 : Convert.ToDouble(dr[col_Closing_Balance]); //objTermDTO.Opening_Balance = dr[col_Opening_Balance] == null ? 0 : Convert.ToDouble(dr[col_Opening_Balance]); //objTermDTO.Earned_For_The_Month = dr[col_Earned_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Earned_For_The_Month]); //objTermDTO.Redeemed_For_The_Month = dr[col_Redeemed_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Redeemed_For_The_Month]); //objTermDTO.Points_Expiring = dr[col_Redeemed_For_The_Month] == null ? 0 : Convert.ToDouble(dr[col_Redeemed_For_The_Month]); //Query } } } catch (Exception ex) { string str = ex.Message; common.logger.Debug(errorGenerated + " Summary : " + ex.Message.ToString()); return(null); } return(objTermDTO); }