/// <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);
}
