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