/// <summary>
/// Description : Get the ClientFeeSetting and ClientFeeMapping Information by ClientCode
/// Created By : Shiva
/// Created Date : 2nd July 2014
/// Modified By : Shiva
/// Modified Date: 4 July 2014
/// </summary>
public static BillingInfo GetFeeSettingAndMappingsByClientCode(int ClientCode, string SourceID)
{
var GetFeeSettingAndMappingInfo = new BillingInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@ClientCode", ClientCode);
sqlParams[1] = new SqlParameter("@SourceID", SourceID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetFeeSettingAndMappingsByClientCode", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var feeSetting = new FeeSetting();
feeSetting.FetchClientFeeSettingInfo(feeSetting, safe);
GetFeeSettingAndMappingInfo.ClientFeeSettingList.Add(feeSetting);
}
reader.NextResult();
while (reader.Read())
{
var feeMapping = new FeeMapping();
feeMapping.FetchClientFeeMappingInfo(feeMapping, safe);
GetFeeSettingAndMappingInfo.ClientFeeMappingList.Add(feeMapping);
}
return GetFeeSettingAndMappingInfo;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return GetFeeSettingAndMappingInfo;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
public FeeMapping FetchClientFeeMappingInfo(FeeMapping getClientFeeMappingInfo, SafeDataReader dr)
{
getClientFeeMappingInfo.CFMID = dr.GetInt32("ID");
getClientFeeMappingInfo.BillingFrequency = dr.GetString("BillingFrequency");
getClientFeeMappingInfo.BillingMonth = dr.GetString("BillingMonth");
getClientFeeMappingInfo.IsBillArrears = dr.GetBoolean("IsBillArrears");
getClientFeeMappingInfo.Status = dr.GetString("Status");
getClientFeeMappingInfo.FeeCode = dr.GetString("FeeCode");
getClientFeeMappingInfo.SecurityDeposit = dr.GetDecimal("SecurityDeposit");
getClientFeeMappingInfo.SecurityDepositInvoiceNo = dr.GetString("SecurityDepositInvoiceNo");
getClientFeeMappingInfo.FeeDueToNominee = dr.GetString("FeeDueToNominee");
return getClientFeeMappingInfo;
}
