public async Task <IEnumerable <RetrievalTracker> > GetRetrievalTracker(string customerCode,
DateTime fromDate, DateTime toDate, bool includeSubAccount)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = RetreivalTrackerStoredProcedure.StoredProcedureParameters[0].ToString(),
Value = customerCode.AsDbValue()
},
new SqlParameter {
ParameterName = RetreivalTrackerStoredProcedure.StoredProcedureParameters[1].ToString(),
Value = includeSubAccount.AsDbValue()
},
new SqlParameter {
ParameterName = RetreivalTrackerStoredProcedure.StoredProcedureParameters[2].ToString(),
Value = fromDate.DateToInt().AsDbValue()
},
new SqlParameter {
ParameterName = RetreivalTrackerStoredProcedure.StoredProcedureParameters[3].ToString(),
Value = toDate.DateToInt().AsDbValue()
}
};
return(await _tcContext.Set <RetrievalTracker>().FromSqlRaw(RetreivalTrackerStoredProcedure.Sql, parms.ToArray()).ToListAsync());
}
public async Task <IEnumerable <LongOutstanding> > GetLongOutStanding(string customerCode, DateTime asAtDate, bool includeSubAccount)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = LongOutStandingStoredProcedure.StoredProcedureParameters[0].ToString(),
Value = customerCode.AsDbValue()
},
new SqlParameter {
ParameterName = LongOutStandingStoredProcedure.StoredProcedureParameters[1].ToString(),
Value = includeSubAccount.AsDbValue()
},
new SqlParameter {
ParameterName = LongOutStandingStoredProcedure.StoredProcedureParameters[2].ToString(),
Value = asAtDate.DateToInt().AsDbValue()
}
};
return(await _tcContext.Set <LongOutstanding>().FromSqlRaw(LongOutStandingStoredProcedure.Sql, parms.ToArray()).ToListAsync());
}
private List <SqlParameter> SendResponse(int customerId, string woType,
DateTime asAtDate, string reportType, bool includeSubAccount, out SqlParameter outParam)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[0].ToString(),
Value = customerId.AsDbValue()
},
new SqlParameter {
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[1].ToString(),
Value = woType.AsDbValue()
},
new SqlParameter {
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[2].ToString(),
Value = asAtDate.AsDbValue()
},
new SqlParameter {
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[3].ToString(),
Value = includeSubAccount.AsDbValue()
},
new SqlParameter {
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[4].ToString(),
Value = reportType.AsDbValue()
},
};
outParam = new SqlParameter
{
ParameterName = InventoryByCustomerStoredProcedure.StoredProcedureParameters[5].ToString(),
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output
};
parms.Add(outParam);
return(parms);
}
public async Task <IEnumerable <ViewTobeDisposedCartonList> > GetToBeDisposedCartonList(string customerCode, bool includeSubAccount)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = ToBeDisposedCartonListStoredProcedure.StoredProcedureParameters[0].ToString(), Value = customerCode.AsDbValue()
},
new SqlParameter {
ParameterName = ToBeDisposedCartonListStoredProcedure.StoredProcedureParameters[1].ToString(), Value = includeSubAccount.AsDbValue()
}
};
return(await _tcContext.Set <ViewTobeDisposedCartonList>().FromSqlRaw(ToBeDisposedCartonListStoredProcedure.Sql, parms.ToArray()).ToListAsync());
}
public async Task <PagedResponse <OperationOverviewByUserLocaion> > GetOperationOverviewByUserLocationAsync(int date, string user, string locationCode,
bool isRcLocation, bool isVehicle, string searchText, int pageIndex, int pageSize)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[0].ToString(), Value = date.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[1].ToString(), Value = user.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[2].ToString(), Value = locationCode.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[3].ToString(), Value = isRcLocation.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[4].ToString(), Value = isVehicle.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[5].ToString(), Value = searchText.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[6].ToString(), Value = pageIndex.AsDbValue()
},
new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[7].ToString(), Value = pageSize.AsDbValue()
},
};
var outParam = new SqlParameter {
ParameterName = InquiryOperationOverviewByUserLocationStoredProcedure.StoredProcedureParameters[8].ToString(), SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
};
parms.Add(outParam);
var operationOverviewByUserLocation = await _tcContext.Set <OperationOverviewByUserLocaion>().FromSqlRaw(InquiryOperationOverviewByUserLocationStoredProcedure.Sql, parms.ToArray()).ToListAsync();
var totalRows = (int)outParam.Value;
#region paging
var postResponse = _mapper.Map <List <OperationOverviewByUserLocaion> >(operationOverviewByUserLocation);
var paginationResponse = new PagedResponse <OperationOverviewByUserLocaion>
{
Data = postResponse,
pageNumber = pageIndex,
pageSize = pageSize,
totalCount = totalRows,
totalPages = (int)Math.Ceiling(totalRows / (double)pageSize),
};
#endregion
return(paginationResponse);
}