internal static CABFeeSchedule FetchCABFeeScheduleReportByMasterID(CABFeeSchedule CABFeeSchedule, SafeDataReader dr)
{
CABFeeSchedule.ID = dr.GetInt32("ID");
CABFeeSchedule.ClientCode = dr.GetString("ClientCode");
CABFeeSchedule.SourceID = dr.GetString("SourceID");
CABFeeSchedule.FeeCode = dr.GetString("FeeCode");
CABFeeSchedule.FromDate = dr.GetDateTime("FromDate").ToString("dd/MMM/yyyy");
CABFeeSchedule.ToDate = dr.GetDateTime("ToDate").ToString("dd/MMM/yyyy");
CABFeeSchedule.Amount = dr.GetDecimal("Amount");
CABFeeSchedule.IsArrear = dr.GetBoolean("IsArrear");
CABFeeSchedule.CreatedDate = dr.GetString("CreatedDate");
CABFeeSchedule.IsClubFee = dr.GetBoolean("IsClubFee");
CABFeeSchedule.IsClubFeeBillGenerated = dr.GetBoolean("IsClubFeeBillGenerated");
CABFeeSchedule.ClubFeeBillID = dr.GetInt32("ClubFeeBillID");
CABFeeSchedule.CABMasterID = dr.GetInt32("CABMasterID");
return CABFeeSchedule;
}
/// <summary>
/// Description : To get CABFeeSchedule Report By CABMasterID.
/// Created By : Shiva
/// Created Date : 9 Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
internal static BillingInfo GetCABFeeScheduleReportByMasterID(int CABMasterID)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
var CABFeeScheduleData = new BillingInfo();
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@CABMasterID", CABMasterID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetCABFeeScheduleReportByMasterID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var CabMaster = new CABFeeSchedule();
CABFeeSchedule.FetchCABFeeScheduleReportByMasterID(CabMaster, safe);
CABFeeScheduleData.CABFeeScheduleList.Add(CabMaster);
}
return CABFeeScheduleData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return CABFeeScheduleData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
