/// <summary>
/// Description : To get All Billing details by Company AND Fee.
/// Created By : Shiva
/// Created Date : 7 Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
internal static List<CABMaster> GetAllCABInvoiceErrors(string ClientId, string SourceID, int startpage, int rowsperpage, string FromDate, string ToDate)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
var CABInvoiceErrorsData = new List<CABMaster>();
try
{
SqlParameter[] sqlParams = new SqlParameter[6];
sqlParams[0] = new SqlParameter("@startPage", startpage);
sqlParams[1] = new SqlParameter("@resultPerPage", rowsperpage);
sqlParams[2] = new SqlParameter("@ClientId", ClientId);
sqlParams[3] = new SqlParameter("@SourceID", SourceID);
sqlParams[4] = new SqlParameter("@FromDate", HelperClasses.ConvertDateFormat(FromDate));
sqlParams[5] = new SqlParameter("@ToDate", HelperClasses.ConvertDateFormat(ToDate));
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SPGetCABInvoiceErrorList]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var CabMaster = new CABMaster();
CABMaster.FetchCABInvoiceErrors(CabMaster, safe);
CabMaster.InvoiceErrorsCount = Convert.ToInt32(reader["InvoiceErrorsCount"]);
CABInvoiceErrorsData.Add(CabMaster);
}
return CABInvoiceErrorsData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return CABInvoiceErrorsData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
internal static CABMaster FetchCABMasterReport(CABMaster CABMaster, SafeDataReader dr)
{
CABMaster.ID = dr.GetInt32("ID");
CABMaster.BillToClientCode = dr.GetInt32("BillToClientCode");
CABMaster.BillToSourceID = dr.GetString("BillToSourceID");
CABMaster.BillToName = dr.GetString("BillToName");
CABMaster.BillToAccpacCode = dr.GetString("BillToAccpacCode");
CABMaster.BillForClientCode = dr.GetInt32("BillForClientCode");
CABMaster.BillForSourceID = dr.GetString("BillForSourceID");
CABMaster.BillForName = dr.GetString("BillForName");
CABMaster.BillForAccpacCode = dr.GetString("BillForAccpacCode");
CABMaster.IsBillToThirdParty = dr.GetInt32("IsBillToThirdParty");
CABMaster.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
CABMaster.ISAdhoc = dr.GetBoolean("ISAdhoc");
CABMaster.Amount = dr.GetDecimal("Amount");
CABMaster.InvoiceNumber = dr.GetString("InvoiceNumber");
CABMaster.BillType = dr.GetString("BillType");
if (string.IsNullOrEmpty(CABMaster.InvoiceNumber))
CABMaster.IsInvoice = false;
else CABMaster.IsInvoice = true;
CABMaster.HSReceivedStatus = dr.GetInt32("HSReceivedStatus");
CABMaster.Description = dr.GetString("Description");
CABMaster.Explaination = dr.GetString("Explaination");
return CABMaster;
}
/// <summary>
/// Description : To get All Billing details by Company AND Fee.
/// Created By : Shiva
/// Created Date : 7 Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
internal static BillingInfo GetAllBillingDetailsByCompanyAndFee(string CompanyID, string CompanySource, string FeeCode, string BillFromDate, string BillToDate, int StartPage, int ResultPerPage, int BillType)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
var CABMasterData = new BillingInfo();
try
{
SqlParameter[] sqlParams = new SqlParameter[8];
sqlParams[0] = new SqlParameter("@ClientCode", CompanyID);
sqlParams[1] = new SqlParameter("@Source", CompanySource);
sqlParams[2] = new SqlParameter("@FeeCode", FeeCode);
sqlParams[3] = new SqlParameter("@BillFromDate", HelperClasses.ConvertDateFormat(BillFromDate));
sqlParams[4] = new SqlParameter("@BillToDate", HelperClasses.ConvertDateFormat(BillToDate));
sqlParams[5] = new SqlParameter("@BillType", BillType);
sqlParams[6] = new SqlParameter("@StartPage", StartPage);
sqlParams[7] = new SqlParameter("@ResultPerPage", ResultPerPage);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetCABMasterReport", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var CabMaster = new CABMaster();
CABMaster.FetchCABMasterReport(CabMaster, safe);
CABMasterData.CABMasterList.Add(CabMaster);
CABMasterData.BillingCount = Convert.ToInt32(reader["BillingCount"]);
}
return CABMasterData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return CABMasterData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
internal static CABMaster FetchCABInvoiceErrors(CABMaster CABMaster, SafeDataReader dr)
{
CABMaster.ID = dr.GetInt32("ID");
CABMaster.BillForName = dr.GetString("BillForName");
CABMaster.BillForAccpacCode = dr.GetString("BillForAccpacCode");
CABMaster.BillToName = dr.GetString("BillToName");
CABMaster.BillToAccpacCode = dr.GetString("BillToAccpacCode");
CABMaster.BillType = dr.GetString("BillType");
CABMaster.Description = dr.GetString("Description");
CABMaster.Explaination = dr.GetString("Explaination");
CABMaster.CreatedDate = dr.GetString("CreatedDate");
CABMaster.HSSentDate = dr.GetString("HSSentDate");
CABMaster.HSReceivedDate = dr.GetString("HSReceivedDate");
return CABMaster;
}
