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