public TableParameter <OrderListEntity> GetOrderListForClient(TableParameter <OrderListEntity> tableParameter,
int PageIndex, int UserAccessId, int CompanyNo,
string UserId,
string SearchValue = "",
string OrderID = "",
string AttorneyID = "",
string RecordsOf = "",
string Caption = "",
string Cause = "",
string Claim = "",
string ClaimMatterNo = "",
bool HideArchived = true)
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
string searchValue = SearchValue == null ? string.Empty : SearchValue.Trim();
var response = new ApiResponse <OrderListEntity>();
try
{
SqlParameter[] param = { new SqlParameter("Keyword", (object)searchValue ?? (object)DBNull.Value),
new SqlParameter("PageIndex", (object)tableParameter.PageIndex ?? (object)DBNull.Value),
new SqlParameter("PageSize", (object)tableParameter != null ? tableParameter.iDisplayLength : 10),
new SqlParameter("SortBy", (object)sortColumn ?? (object)DBNull.Value),
new SqlParameter("OrderID", (object)OrderID ?? (object)DBNull.Value),
new SqlParameter("AttorneyID", (object)AttorneyID ?? (object)DBNull.Value),
new SqlParameter("RecordsOf", (object)RecordsOf ?? (object)DBNull.Value),
new SqlParameter("Caption", (object)Caption ?? (object)DBNull.Value),
new SqlParameter("Cause", (object)Cause ?? (object)DBNull.Value),
new SqlParameter("Claim", (object)Claim ?? (object)DBNull.Value),
new SqlParameter("ClaimMatterNo", (object)ClaimMatterNo ?? (object)DBNull.Value),
new SqlParameter("HideArchived", (object)HideArchived ?? (object)DBNull.Value),
new SqlParameter("UserId", (object)UserId ?? (object)DBNull.Value),
new SqlParameter("UserAccessId", (object)UserAccessId ?? (object)DBNull.Value),
new SqlParameter("CompanyNo", (object)CompanyNo ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <OrderListEntity>("GetOrderListForClient", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <OrderListEntity>
{
aaData = (List <OrderListEntity>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <OrderListEntity>());
}
public Task <IReadOnlyCollection <TResult> > InsertMultipleAsync <TResult, TRow>(CancellationToken cancellationToken, string sql, IEnumerable <TRow> rows, object param = null)
where TRow : class, new()
{
var tableParameter = new TableParameter <TRow>("@rows", rows, param ?? new {});
return(QueryAsync <TResult>(cancellationToken, sql, tableParameter));
}
public async Task <IActionResult> GetDepartments(TableParameter param)
{
var depts = await _coreRep.GetDepartments(param.search, param.page, param.pageSize, param.orderBy, param.orderDirection, param.filter);
var count = await _coreRep.GetDepartmentCount(param.filter);
return(Ok(new ResponseModel(new
{
depts = depts.Select(u => new DepartmentModel(u)),
total = count
})));
}
public override Task <IReadOnlyCollection <TResult> > InsertMultipleAsync <TResult, TRow>(
Label label,
CancellationToken cancellationToken,
string sql,
IEnumerable <TRow> rows)
{
Log.Verbose(
"Using optimised table type to insert with SQL: {0}",
sql);
var tableParameter = new TableParameter <TRow>("@rows", rows, new {});
return(QueryAsync <TResult>(label, cancellationToken, sql, tableParameter));
}
public async Task <IActionResult> Employees(TableParameter param)
{
var list = await _coreRep.ListEmployees(param.search, param.page, param.pageSize, param.orderBy, param.orderDirection, param.filter);
var count = await _coreRep.GetEmployeeCount(param.filter);
return(Ok(new
ResponseModel(new
{
emps = list.Select(u => new EmployeeModel(u)),
total = count
})));
}
public List <CustomerEntity> GetCustomerList(string sortColumn, TableParameter <CustomerEntity> filter, string customerName, string email, int?customer_group_id, int?status, int?approved, string ip, DateTime?date_added, int?storeId)
{
try
{
var paramOrderBy = new SqlParameter {
ParameterName = "OrderBy", DbType = DbType.String, Value = sortColumn
};
var paramPageSize = new SqlParameter {
ParameterName = "PageSize", DbType = DbType.Int32, Value = filter != null ? filter.iDisplayLength : 10
};
var paramPageIndex = new SqlParameter {
ParameterName = "PageIndex", DbType = DbType.Int32, Value = filter != null ? filter.PageIndex : 1
};
var paramCustomerName = new SqlParameter {
ParameterName = "customerName", DbType = DbType.String, Value = customerName ?? DBNull.Value.ToString()
};
var paramEmail = new SqlParameter {
ParameterName = "email", DbType = DbType.String, Value = email ?? (object)DBNull.Value
};
var paramCustomer_group_id = new SqlParameter {
ParameterName = "customer_group_id", DbType = DbType.Int32, Value = customer_group_id ?? (object)DBNull.Value
};
var paramApproved = new SqlParameter {
ParameterName = "approved", DbType = DbType.Int32, Value = approved ?? (object)DBNull.Value
};
var paramIp = new SqlParameter {
ParameterName = "ip", DbType = DbType.String, Value = ip ?? (object)DBNull.Value
};
var paramDate_added = new SqlParameter {
ParameterName = "date_added", DbType = DbType.DateTime, Value = date_added ?? (object)DBNull.Value
};
var paramstatus = new SqlParameter {
ParameterName = "status", DbType = DbType.Int32, Value = status ?? (object)DBNull.Value
};
var paramStoreId = new SqlParameter {
ParameterName = "storeId", DbType = DbType.Int32, Value = storeId ?? (object)DBNull.Value
};
var CustomerList = CustomerEntityGenericRepository.ExecuteSQL <CustomerEntity>("EXEC GetCustomerList", paramOrderBy, paramPageSize, paramPageIndex, paramCustomerName, paramEmail, paramCustomer_group_id, paramApproved, paramIp, paramDate_added, paramstatus, paramStoreId).ToList <CustomerEntity>().ToList();
return(CustomerList);
}
catch (Exception ex)
{
throw;
}
}
public TableParameter <OrderEntity> GetOrderList(int StoreId, int LoggedInUserId, int PageIndex, int?orderId, int?order_status_id, string CustomerName, Nullable <DateTime> DateAdded, Nullable <DateTime> DateModified, TableParameter <OrderEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _orderService.GetOrderList(StoreId, LoggedInUserId, sortColumn, orderId, order_status_id, CustomerName, DateAdded, DateModified, tableParameter, "").ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <OrderEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception)
{
throw;
}
}
public TableParameter <ProductEntity> GetProductList(int StoreId, int LoggedInUserId, int PageIndex, string name, decimal?Price, int?status, string Model, int?Quantity, TableParameter <ProductEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _ProductServices.GetProductList(StoreId, LoggedInUserId, sortColumn, tableParameter, name, Price, status, Model, Quantity).ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <ProductEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception)
{
throw;
}
}
public List <OrderProductEntity> GetProductViewedList(int store_id, int LoggedInUserId, string sortColumn, TableParameter <OrderProductEntity> filter)
{
try
{
var ParameterStoreId = new SqlParameter
{
ParameterName = "StoreId",
DbType = DbType.Int32,
Value = store_id
};
var ParameterLoggedInUserId = new SqlParameter
{
ParameterName = "LoggedInUserId",
DbType = DbType.Int32,
Value = LoggedInUserId
};
var paramOrderBy = new SqlParameter {
ParameterName = "OrderBy", DbType = DbType.String, Value = sortColumn
};
var paramPageSize = new SqlParameter {
ParameterName = "PageSize", DbType = DbType.Int32, Value = filter != null ? filter.iDisplayLength : 10
};
var paramPageIndex = new SqlParameter {
ParameterName = "PageIndex", DbType = DbType.Int32, Value = filter != null ? filter.PageIndex : 1
};
var query = objGenericRepository.ExecuteSQL <OrderProductEntity>("GetProductViewedList", ParameterStoreId, ParameterLoggedInUserId, paramOrderBy, paramPageSize, paramPageIndex).ToList <OrderProductEntity>();
return(query);
}
catch (Exception ex)
{
throw ex;
}
}
public List <OrderProductEntity> GetProductPurchasedList(string sortColumn, int order_status_id, int store_id, int LoggedInUserId, TableParameter <OrderProductEntity> filter, DateTime?DateStart, DateTime?DateEnd)
{
try
{
var paramOrderBy = new SqlParameter {
ParameterName = "OrderBy", DbType = DbType.String, Value = sortColumn
};
var paramPageSize = new SqlParameter {
ParameterName = "PageSize", DbType = DbType.Int32, Value = filter != null ? filter.iDisplayLength : 10
};
var paramPageIndex = new SqlParameter {
ParameterName = "PageIndex", DbType = DbType.Int32, Value = filter != null ? filter.PageIndex : 1
};
var paramOrderStatusId = new SqlParameter {
ParameterName = "order_status_id", DbType = DbType.Int32, Value = order_status_id
};
var paramStoreId = new SqlParameter {
ParameterName = "store_id", DbType = DbType.Int32, Value = store_id
};
//var ParameterLoggedInUserId = new SqlParameter
//{
// ParameterName = "LoggedInUserId",
// DbType = DbType.Int32,
// Value = LoggedInUserId
//};
var paramStartDate = new SqlParameter {
ParameterName = "DateStart", DbType = DbType.DateTime, Value = DateStart ?? (object)DBNull.Value
};
var paramEndDate = new SqlParameter {
ParameterName = "DateEnd", DbType = DbType.DateTime, Value = DateEnd ?? (object)DBNull.Value
};
var query = objGenericRepository.ExecuteSQL <OrderProductEntity>("GetProductPurchasedList", paramOrderBy, paramPageSize, paramPageIndex, paramOrderStatusId, paramStoreId, paramStartDate, paramEndDate).ToList <OrderProductEntity>();
return(query);
}
catch (Exception ex)
{
throw ex;
}
}
public TableParameter <LocationList> GetLocationList(TableParameter <LocationEntity> tableParameter, int PageIndex, string SearchValue = "", string LocID = "",
string Name = "",
string PhoneNo = "",
string Department = "",
string Address = "",
string City = "",
string State = "", string ReplacedBy = "")
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
sortColumn = sortColumn.Replace("Name", "Name1");
string searchValue = SearchValue == null ? string.Empty : SearchValue.Trim();
var response = new ApiResponse <LocationList>();
try
{
SqlParameter[] param =
{
new SqlParameter {
ParameterName = "Keyword",
DbType = DbType.String,
Value = searchValue
}, new SqlParameter
{
ParameterName = "PageIndex",
DbType = DbType.Int32,
Value = tableParameter.PageIndex
}, new SqlParameter
{
ParameterName = "PageSize",
DbType = DbType.Int32,
Value = (object)tableParameter != null ? tableParameter.iDisplayLength : 10
},
new SqlParameter
{
ParameterName = "SortBy",
DbType = DbType.String,
Value = sortColumn
},
new SqlParameter {
ParameterName = "LocID", DbType = DbType.String, Value = (object)LocID ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "Name", DbType = DbType.String, Value = (object)Name ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "PhoneNo", DbType = DbType.String, Value = (object)PhoneNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "Department", DbType = DbType.String, Value = (object)Department ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "Address", DbType = DbType.String, Value = (object)Address ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "City", DbType = DbType.String, Value = (object)City ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "State", DbType = DbType.String, Value = (object)State ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ReplacedBy", DbType = DbType.String, Value = (object)ReplacedBy ?? (object)DBNull.Value
}
};
var result = _repository.ExecuteSQL <LocationList>("GetLocationList", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <LocationList>
{
aaData = (List <LocationList>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <LocationList>());
//var response = new ApiResponse<LocationEntity>();
//try
//{
// SqlParameter[] param = { new SqlParameter("LocationId", (object)LocationId ?? (object)DBNull.Value) };
// var result = _repository.ExecuteSQL<LocationEntity>("GetLocationList", param).ToList();
// if (result == null)
// {
// result = new List<LocationEntity>();
// }
// response.Success = true;
// response.Data = result;
//}
//catch (Exception ex)
//{
// response.Message.Add(ex.Message);
//}
//return response;
}
public TableParameter <ReportEntity> GetTransactionReportList(int PageIndex, Nullable <DateTime> DateStart, Nullable <DateTime> DateEnd, int StoreId, int LoggedInUserId, TableParameter <ReportEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _reportServices.GetTransactionReportList(sortColumn, DateStart, DateEnd, StoreId, LoggedInUserId, tableParameter, "").ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <ReportEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception)
{
throw;
}
}
public TableParameter <OrderProductEntity> GetProductViewedList(int store_id, int LoggedInUserId, int PageIndex, TableParameter <OrderProductEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _productPurchasedReportService.GetProductViewedList(store_id, LoggedInUserId, sortColumn, tableParameter).ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <OrderProductEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception)
{
throw;
}
}
public IEnumerable <ReportEntity> GetTransactionReportList(string sortColumn, DateTime?DateStart, DateTime?DateEnd, int store_id, int LoggedInUserId, TableParameter <ReportEntity> filter, string PageFrom = "")
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("OrderBy", sortColumn != null ? sortColumn:(object)DBNull.Value)
, new SqlParameter("PageSize", filter != null ? filter.iDisplayLength : 10)
, new SqlParameter("PageIndex", filter != null ? filter.PageIndex : 1)
, new SqlParameter("DateStart", DateStart != null ? DateStart:(object)DBNull.Value)
, new SqlParameter("DateEnd", DateEnd != null ? DateEnd:(object)DBNull.Value)
, new SqlParameter("store_id", store_id != null ? store_id:(object)DBNull.Value)
//,new SqlParameter("LoggedInUserId", LoggedInUserId!=null ? LoggedInUserId:(object)DBNull.Value)
};
var query = ReportEntityGenericRepository.ExecuteSQL <ReportEntity>("GetTransectionReportList", param).AsQueryable();
return(query);
}
catch (Exception)
{
throw;
}
//return result;
}
public IEnumerable <ReportEntity> GetCustomerBalanceReportList(string sortColumn, string storeids, DateTime?Date, TableParameter <ReportEntity> filter)
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("OrderBy", sortColumn != null ? sortColumn:(object)DBNull.Value)
, new SqlParameter("PageSize", filter != null ? filter.iDisplayLength : 10)
, new SqlParameter("PageIndex", filter != null ? filter.PageIndex : 1)
, new SqlParameter("storeids", !string.IsNullOrWhiteSpace(storeids) ? storeids:(object)DBNull.Value)
, new SqlParameter("Date", Date != null ? Date:(object)DBNull.Value)
};
var query = ReportEntityGenericRepository.ExecuteSQL <ReportEntity>("GetCustomerBalanceReportList", param).AsQueryable();
return(query);
}
catch (Exception)
{
throw;
}
//return result;
}
public async Task <IActionResult> GetReceivers(TableParameter param)
{
var model = (await _imessage.GetReceivers(param.search, param.page, param.pageSize, param.orderBy, param.orderDirection, param.filter, DateTime.Now)).Select(u => new MessageReceiverModel(u));
return(Ok(new ResponseModel(model)));
}
public TableParameter <SearchListEntity> GetOrderListForAdmin(TableParameter <SearchListEntity> tableParameter
, int PageIndex
, int CompanyNo
, string SearchValue = ""
, string OrderNo = ""
, string PartNo = ""
, string PatientName = ""
, string LocationName = ""
, string LocationState = ""
, string PlaintiffAtty1 = ""
, string PlaintiffAtty2 = ""
, string PlaintiffAtty3 = ""
, string PlaintiffAtty4 = ""
, string PlaintiffAtty5 = ""
, string OrderAtty = ""
, string OrderFirm = ""
, string RecordTypeId = ""
, string AccountRep = ""
, string Processor = ""
, string AssignedTo = ""
, string InternalStatus = ""
, string Rush = ""
, bool CallbackOnly = false
, DateTime?DueDateFrom = null
, DateTime?DueDateTo = null
, DateTime?ActionDateFrom = null
, DateTime?ActionDateTo = null
, DateTime?CallbackDateFrom = null
, DateTime?CallbackDateTo = null
, string CompNo = null
, string AreaCode = null
, string FaxNo = null
, bool ShowPartDetailWithOrder = true
)
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
string searchValue = SearchValue == null ? string.Empty : SearchValue.Trim();
var response = new ApiResponse <SearchListEntity>();
try
{
SqlParameter[] param =
{
new SqlParameter {
ParameterName = "PageIndex", Value = tableParameter.PageIndex
}
, new SqlParameter{
ParameterName = "PageSize", Value = (object)tableParameter != null ? tableParameter.iDisplayLength : 10
}
, new SqlParameter{
ParameterName = "CompanyNo", Value = CompanyNo
}
, new SqlParameter{
ParameterName = "SortBy", Value = sortColumn
}
, new SqlParameter{
ParameterName = "Keyword", DbType = DbType.String, Value = searchValue
},
new SqlParameter {
ParameterName = "OrderNo", Value = (object)OrderNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "PartNo", Value = (object)PartNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "PatientName", Value = (object)PatientName ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "LocationName", Value = (object)LocationName ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "LocationState", Value = (object)LocationState ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "PlaintiffAtty1", Value = (object)PlaintiffAtty1 ?? ""
},
new SqlParameter {
ParameterName = "PlaintiffAtty2", Value = (object)PlaintiffAtty2 ?? ""
},
new SqlParameter {
ParameterName = "PlaintiffAtty3", Value = (object)PlaintiffAtty3 ?? ""
},
new SqlParameter {
ParameterName = "PlaintiffAtty4", Value = (object)PlaintiffAtty4 ?? ""
},
new SqlParameter {
ParameterName = "PlaintiffAtty5", Value = (object)PlaintiffAtty5 ?? ""
},
new SqlParameter {
ParameterName = "OrderAtty", Value = (object)OrderAtty ?? ""
},
new SqlParameter {
ParameterName = "OrderFirm", Value = (object)OrderFirm ?? ""
},
new SqlParameter {
ParameterName = "RecordTypeId", Value = (object)RecordTypeId ?? ""
},
new SqlParameter {
ParameterName = "AccountRep", Value = (object)AccountRep ?? ""
},
new SqlParameter {
ParameterName = "Processor", Value = (object)Processor ?? ""
},
new SqlParameter {
ParameterName = "AssignedTo", Value = (object)AssignedTo ?? ""
},
new SqlParameter {
ParameterName = "InternalStatus", Value = (object)InternalStatus ?? ""
},
new SqlParameter {
ParameterName = "Rush", Value = (object)Rush ?? ""
},
new SqlParameter {
ParameterName = "CallbackOnly", Value = (object)CallbackOnly ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "DueDateFrom", Value = (object)DueDateFrom ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "DueDateTo", Value = (object)DueDateTo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ActionDateFrom", Value = (object)ActionDateFrom ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ActionDateTo", Value = (object)ActionDateTo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "CallbackDateFrom", Value = (object)CallbackDateFrom ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "CallbackDateTo", Value = (object)CallbackDateTo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "CompNo", Value = (object)CompNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "AreaCode", Value = (object)AreaCode ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "FaxNo", Value = (object)FaxNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ShowPartDetailWithOrder", Value = (object)ShowPartDetailWithOrder ?? (object)DBNull.Value
},
};
var result = _repository.ExecuteSQL <SearchListEntity>("GetOrderListForAdmin", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <SearchListEntity>
{
aaData = (List <SearchListEntity>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <SearchListEntity>());
}
public List <ProductEntity> GetProductList(int StoreId, int LoggedInUserId, string sortColumn, TableParameter <ProductEntity> filter, string name, decimal?Price, int?status, string Model, int?Quantity)
{
try
{
var ParameterStoreId = new SqlParameter
{
ParameterName = "StoreId",
DbType = DbType.Int32,
Value = StoreId
};
var ParameterLoggedInUserId = new SqlParameter
{
ParameterName = "LoggedInUserId",
DbType = DbType.Int32,
Value = LoggedInUserId
};
var paramOrderBy = new SqlParameter {
ParameterName = "OrderBy", DbType = DbType.String, Value = sortColumn
};
var paramPageSize = new SqlParameter {
ParameterName = "PageSize", DbType = DbType.Int32, Value = filter != null ? filter.iDisplayLength : 10
};
var paramPageIndex = new SqlParameter {
ParameterName = "PageIndex", DbType = DbType.Int32, Value = filter != null ? filter.PageIndex : 1
};
//var paramPageFrom = new SqlParameter { ParameterName = "PageFrom", DbType = DbType.String, Value = PageFrom };
var paramName = new SqlParameter {
ParameterName = "name", DbType = DbType.String, Value = name ?? DBNull.Value.ToString()
};
var paramPrice = new SqlParameter {
ParameterName = "price", DbType = DbType.Decimal, Value = Price ?? (object)DBNull.Value
};
var paramStatus = new SqlParameter {
ParameterName = "status", DbType = DbType.Int32, Value = status ?? (object)DBNull.Value
};
var paramModel = new SqlParameter {
ParameterName = "Model", DbType = DbType.String, Value = Model ?? DBNull.Value.ToString()
};
var paramQuantity = new SqlParameter {
ParameterName = "Quantity", DbType = DbType.Int32, Value = Quantity ?? (object)DBNull.Value
};
var query = objGenericRepository.ExecuteSQL <ProductEntity>("GetProductList", ParameterStoreId, ParameterLoggedInUserId, paramOrderBy, paramPageSize, paramPageIndex, paramName, paramPrice, paramStatus, paramModel, paramQuantity).ToList <ProductEntity>();
return(query);
}
catch (Exception)
{
throw;
}
}
public TableParameter <IIFCheckListEntity> IIFGenerateCheckList(TableParameter <IIFCheckListEntity> tableParameter, int PageIndex, string FromDate = "",
string ToDate = "", bool ToBePrint = false, int CompanyNo = 1)
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
string searchValue = string.Empty;
var response = new ApiResponse <IIFCheckListEntity>();
try
{
SqlParameter[] param =
{
new SqlParameter {
ParameterName = "Keyword",
DbType = DbType.String,
Value = searchValue
}, new SqlParameter
{
ParameterName = "PageIndex",
DbType = DbType.Int32,
Value = tableParameter.PageIndex
}, new SqlParameter
{
ParameterName = "PageSize",
DbType = DbType.Int32,
Value = (object)tableParameter != null ? tableParameter.iDisplayLength : 10
},
new SqlParameter
{
ParameterName = "SortBy",
DbType = DbType.String,
Value = sortColumn
},
new SqlParameter {
ParameterName = "FromDate", DbType = DbType.Date, Value = (object)Convert.ToDateTime(FromDate) ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ToDate", DbType = DbType.Date, Value = (object)Convert.ToDateTime(ToDate) ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "ToBePrint", DbType = DbType.Boolean, Value = (object)ToBePrint ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "CompanyNo", DbType = DbType.Int32, Value = (object)CompanyNo ?? (object)DBNull.Value
}
};
var result = _repository.ExecuteSQL <IIFCheckListEntity>("IIFGenerateCheckList", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <IIFCheckListEntity>
{
aaData = (List <IIFCheckListEntity>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <IIFCheckListEntity>());
}
public TableParameter <CustomerEntity> GetCustomerList(int PageIndex, string customerName, string email, int?customer_group_id, int?status, int?approved, string ip, DateTime?date_added, int storeId, TableParameter <CustomerEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _CustomerService.GetCustomerList(sortColumn, tableParameter, customerName, email, customer_group_id, status, approved, ip, date_added, storeId).ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <CustomerEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception e)
{
Console.Write(e);
throw;
}
}
public TableParameter <InvoiceListEntity> GetVoidAndAllInVoices(TableParameter <InvoiceListEntity> tableParameter, int PageIndex, int?InvoiceNo, int?OrderNo, int UserId, string BilledAttorney, string SoldAttorney, bool?VoidInvoices,
bool?AllInvoices, string FirmID, string FirmName)
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var response = new ApiResponse <InvoiceListEntity>();
try
{
SqlParameter[] param =
{
new SqlParameter {
ParameterName = "FirmID ", DbType = DbType.String, Value = (object)FirmID ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "FirmName", DbType = DbType.String, Value = (object)FirmName ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "VoidInvoices", DbType = DbType.Boolean, Value = (object)VoidInvoices ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "AllInvoices", DbType = DbType.Boolean, Value = (object)AllInvoices ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "InvoiceNo", DbType = DbType.Int32, Value = (object)InvoiceNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "UserId", DbType = DbType.Int32, Value = (object)UserId ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "OrderNo", DbType = DbType.Int32, Value = (object)OrderNo ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "PageSize", DbType = DbType.Int32, Value = (object)tableParameter != null ? tableParameter.iDisplayLength : 10
},
new SqlParameter {
ParameterName = "SortBy", DbType = DbType.String, Value = sortColumn
},
new SqlParameter {
ParameterName = "PageIndex", DbType = DbType.Int32, Value = (object)PageIndex ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "BilledAttorney", DbType = DbType.String, Value = (object)BilledAttorney ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "SoldAttorney", DbType = DbType.String, Value = (object)SoldAttorney ?? (object)DBNull.Value
}
};
var result = _repository.ExecuteSQL <InvoiceListEntity>("GetVoidAndAllInvoices", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <InvoiceListEntity>
{
aaData = (List <InvoiceListEntity>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <InvoiceListEntity>());
}
public void SetValue(IDbDataParameter parameter, object value)
{
TableParameter.Set(parameter, value as DataTable, null);
}
public IEnumerable <OrderEntity> GetOrderList(int StoreId, int LoggedInUserId, string sortColumn, int?orderId, int?order_status_id, string CustomerName, Nullable <DateTime> DateAdded, Nullable <DateTime> DateModified, TableParameter <OrderEntity> filter, string PageFrom = "")
{
try
{
SqlParameter[] sqlParameter = new SqlParameter[] {
new SqlParameter("StoreId", StoreId)
, new SqlParameter("LoggedInUserId", LoggedInUserId)
, new SqlParameter("OrderBy", sortColumn)
, new SqlParameter("PageSize", filter != null ? filter.iDisplayLength : 10)
, new SqlParameter("PageIndex", filter != null ? filter.PageIndex : 1)
, new SqlParameter("PageFrom", PageFrom)
, new SqlParameter("orderId ", orderId != null?orderId:0)
, new SqlParameter("order_status_id ", order_status_id != null?order_status_id:0)
, new SqlParameter("customer ", CustomerName != null?CustomerName:(object)DBNull.Value)
//,new SqlParameter("total ",total!=null?total:0)
, new SqlParameter("dateAdded ", DateAdded != null?DateAdded:(object)DBNull.Value)
, new SqlParameter("dateModifies ", DateModified != null?DateModified:(object)DBNull.Value)
};
var query = objGenericRepository.ExecuteSQL <OrderEntity>("GetOrderList_Admin", sqlParameter).AsQueryable();
return(query);
}
catch (Exception)
{
throw;
}
//return result;
}
public TableParameter <FirmList> SearchFirmList(TableParameter <FirmEntity> tableParameter, int PageIndex, string CompanyNo, string SearchValue = "", string FirmID = "",
string FirmName = "",
string Address = "",
string City = "",
string State = "",
string ParentFirm = "")
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
string searchValue = SearchValue == null ? string.Empty : SearchValue.Trim();
var response = new ApiResponse <FirmList>();
try
{
SqlParameter[] param =
{
new SqlParameter {
ParameterName = "Keyword",
DbType = DbType.String,
Value = searchValue
}, new SqlParameter
{
ParameterName = "PageIndex",
DbType = DbType.Int32,
Value = tableParameter.PageIndex
}, new SqlParameter
{
ParameterName = "PageSize",
DbType = DbType.Int32,
Value = (object)tableParameter != null ? tableParameter.iDisplayLength : 10
},
new SqlParameter
{
ParameterName = "SortBy",
DbType = DbType.String,
Value = sortColumn
},
new SqlParameter {
ParameterName = "FirmID", DbType = DbType.String, Value = (object)FirmID ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "FirmName", DbType = DbType.String, Value = (object)FirmName ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "Address", DbType = DbType.String, Value = (object)Address ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "City", DbType = DbType.String, Value = (object)City ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "State", DbType = DbType.String, Value = (object)State ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "AssociatedFirm", DbType = DbType.String, Value = (object)ParentFirm ?? (object)DBNull.Value
},
new SqlParameter {
ParameterName = "CompanyNo", DbType = DbType.String, Value = (object)CompanyNo ?? (object)DBNull.Value
}
};
var result = _repository.ExecuteSQL <FirmList>("GetFirmList", param).ToList();
response.Success = true;
response.Data = result;
int totalRecords = 0;
if (response != null && response.Data.Count > 0)
{
totalRecords = response.Data[0].TotalRecords;
}
return(new TableParameter <FirmList>
{
aaData = (List <FirmList>)response.Data,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(new TableParameter <FirmList>());
}
public TableParameter <ReportEntity> GetCustomerBalanceReportList(int PageIndex, string StoreIDs, Nullable <DateTime> Date, TableParameter <ReportEntity> tableParameter)
{
try
{
tableParameter.PageIndex = PageIndex;
string sortColumn = tableParameter.SortColumn.Desc ? tableParameter.SortColumn.Column + " desc" : tableParameter.SortColumn.Column + " asc";
var result = _reportServices.GetCustomerBalanceReportList(sortColumn, StoreIDs, Date, tableParameter).ToList();
int totalRecords = 0;
if (result != null && result.Count > 0)
{
totalRecords = result.FirstOrDefault().TotalRecords;
}
return(new TableParameter <ReportEntity>
{
aaData = result.ToList(),
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
});
}
catch (Exception)
{
throw;
}
}
