public ServicesResponse <IEnumerable <InvoiceHeaderReponseModel> > GetAllDataByFilterV2(InvoiceHeaderRequestModel requestModel)
{
var methodName = MethodBase.GetCurrentMethod().GetMethodName();
try
{
var invoiceHeaders = connectionFactory.CreateConnection().GetAll <InvoiceHeaderEntity>().AsQueryable();
var customers = customerInfoManager.GetAllDataByFilter(null, requestModel.CustomerNo).ResultData;
var users = usersInfoManager.GetAllData().ResultData;
#region Filter Condition
var predicate = PredicateBuilderHelper.True <InvoiceHeaderEntity>();
if (!requestModel.InvoiceNo.IsNullOrLessOrEqToZero())
{
predicate = predicate.Or(q => q.InvoiceNo == requestModel.InvoiceNo);
}
if (!requestModel.CustomerNo.IsNullOrLessOrEqToZero())
{
var cus = customers.FirstOrDefault(q => q.CustomerNo == requestModel.CustomerNo);
if (cus != null)
{
predicate = predicate.Or(q => q.CustomerId == cus.Id);
}
}
if (requestModel.StartDate.HasValue && requestModel.EndDate.HasValue)
{
predicate = predicate.Or(q => q.CreatedDate >= requestModel.StartDate.Value && q.CreatedDate <= requestModel.EndDate.Value);
}
#endregion
var result = invoiceHeaders.Where(predicate).Select(q => new InvoiceHeaderReponseModel
{
Currency = q.Currency,
Address = customers.FirstOrDefault(p => p.Id == q.Id).CutomerCity,
CustomerNo = customers.FirstOrDefault(p => p.Id == q.Id).CustomerNo,
GrandTotal = q.GrandTotal,
InvoiceNo = q.InvoiceNo,
CreatedDate = q.CreatedDate,
CreatedBy = users.FirstOrDefault(p => p.Id == q.CreatedUser).UserNo
}).AsEnumerable();
return(GlobalHelper.CreateServicesResponse(result));
}
catch (FattalDbException ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.ExceptionMessageProp, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <InvoiceHeaderReponseModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (KnownException ex)
{
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <InvoiceHeaderReponseModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (Exception ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.Message, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <InvoiceHeaderReponseModel> >());
}
}
public ServicesResponse <IEnumerable <CustomerInfoModel> > GetAllDataByFilter(int?customerId = null, string customerNo = "")
{
var methodName = MethodBase.GetCurrentMethod().GetMethodName();
try
{
var data = cache.GetAllCachedData().AsQueryable();
var predicate = PredicateBuilderHelper.True <CustomerInfoModel>();
#region Filter Condition
if (!customerId.IsNullOrLessOrEqToZero())
{
predicate = predicate.Or(q => q.Id == customerId);
}
else if (!customerNo.IsNullOrEmpty())
{
predicate = predicate.Or(q => q.CustomerNo == customerNo);
}
#endregion
var result = data.Where(predicate).AsEnumerable();
return(GlobalHelper.CreateServicesResponse(result));
}
catch (FattalDbException ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.ExceptionMessageProp, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <CustomerInfoModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (KnownException ex)
{
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <CustomerInfoModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (Exception ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.Message, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <CustomerInfoModel> >());
}
}
public ServicesResponse <IEnumerable <UserInfoModel> > GetAllData()
{
var methodName = MethodBase.GetCurrentMethod().GetMethodName();
try
{
var data = cache.GetAllCachedData();
return(GlobalHelper.CreateServicesResponse(data));
}
catch (FattalDbException ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.ExceptionMessageProp, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <UserInfoModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (KnownException ex)
{
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <UserInfoModel> >(ex.ExceptionMessageProp, ex.ErrorTypeProp));
}
catch (Exception ex)
{
logger.AddErrorLog(LogTypeEnum.Error, methodName, null, ex.Message, ex);
return(GlobalHelper.CreateServicesErrorResponse <IEnumerable <UserInfoModel> >());
}
}