/// <summary>
/// Description : To get CABFeeScheduleDetails Report By CABFeeScheduleID.
/// Created By : Shiva
/// Created Date : 9 Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
internal static BillingInfo GetCABFeeScheduleDetailsReportByCABFeeScheduleID(int CABFeeScheduleID)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
var CABFeeScheduleDetailsData = new BillingInfo();
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@CABFeeScheduleID", CABFeeScheduleID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetCABFeeScheduleDetailsReportByCABFeeScheduleID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var GetCABFeeScheduleDetails = new CABFeeScheduleDetails();
CABFeeScheduleDetails.FetchCABFeeScheduleDetailsReportByCABFeeScheduleID(GetCABFeeScheduleDetails, safe);
CABFeeScheduleDetailsData.CABFeeScheduleDetailsList.Add(GetCABFeeScheduleDetails);
}
return CABFeeScheduleDetailsData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return CABFeeScheduleDetailsData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
internal static CABFeeScheduleDetails FetchCABFeeScheduleDetailsReportByCABFeeScheduleID(CABFeeScheduleDetails CABFeeScheduleDetails, SafeDataReader dr)
{
CABFeeScheduleDetails.ID = dr.GetInt32("ID");
CABFeeScheduleDetails.ClientCode = dr.GetString("ClientCode");
CABFeeScheduleDetails.SourceID = dr.GetString("SourceID");
CABFeeScheduleDetails.FeeCode = dr.GetString("FeeCode");
CABFeeScheduleDetails.BilledFrom = dr.GetDateTime("BilledFrom").ToString("dd/MMM/yyyy"); ;
CABFeeScheduleDetails.BilledTo = dr.GetDateTime("BilledTo").ToString("dd/MMM/yyyy"); ;
CABFeeScheduleDetails.Amount = dr.GetDecimal("Amount");
CABFeeScheduleDetails.Prorate = dr.GetDecimal("Prorate");
CABFeeScheduleDetails.BillableAmount = dr.GetDecimal("BillableAmount");
CABFeeScheduleDetails.IsArrear = dr.GetBoolean("IsArrear");
CABFeeScheduleDetails.CreatedDate = dr.GetString("CreatedDate");
CABFeeScheduleDetails.CABFeeScheduleID = dr.GetInt32("CABFeeScheduleID");
return CABFeeScheduleDetails;
}
