internal IList <FuelStation> GetZipCode(ZipCodeRequest filter)
{
Command = new SqlCommand
{
Connection = (SqlConnection)Connection,
CommandType = CommandType.StoredProcedure,
CommandText = "Operation.GetZipCode"
};
var param = new SqlParameter
{
ParameterName = "@ZipCode",
DbType = DbType.String,
Value = filter.ZipCode
};
Command.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@SupplierID",
DbType = DbType.Int32,
Value = filter.SupplierId
};
Command.Parameters.Add(param);
Populate((SqlDataReader)Command.ExecuteReader());
return(_listResult);
}
public MainResponse GetAllZipCodes(ZipCodeRequest request)
{
var zipCodes = _zipCodeRepository2.GetAll(x => x.City == request.cityname && x.StateAbbrv == request.statecode).OrderBy(x => x.ZipCode);
var zipCodeResponse = _mapper.Map <List <GetZipCodes> >(zipCodes);
ZipCodeResponse response = new ZipCodeResponse();
response.ZipCode = zipCodeResponse;
_mainResponse.ZipCodeResponse = response;
_mainResponse.Success = true;
return(_mainResponse);
}
public IList <FuelStation> GetZipCode(ZipCodeRequest filter)
{
_listResult = null;
try
{
Connection.Open();
_listResult = _fuelStationDa.GetZipCode(filter);
}
finally
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
}
return(_listResult);
}
public IActionResult GetZipCodes(ZipCodeRequest request)
{
_mainResponse = _globalCodeService.GetAllZipCodes(request);
_jsonString = Mapper.Convert <ZipCodeResponse>(_mainResponse);
return(new OkObjectResult(_jsonString));
}
public Response GetZipCode(ZipCodeRequest request)
{
try
{
_listResult = _repository.GetZipCode(request);
var numberItems = _listResult.Count;
if (numberItems == 0)
{
_response = new Response
{
IsSuccess = true,
//Obsolete = _listResult,
NumberItems = numberItems,
StatusResponse = new StatusResponse
{
Status = 404,
Message = Default.LblHttpStatusCode404,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
return(_response);
}
_response = new Response
{
IsSuccess = true,
NumberItems = numberItems,
//Obsolete = request.SortedBy.HasValue ? Sorting.Sort(_listResult, request.SortedBy.Value) : _listResult,
StatusResponse = new StatusResponse
{
Status = 200,
Message = Default.LblHttpStatusCode200,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
}
catch (Exception exception)
{
var exceptionLog = new ExceptionLog
{
ApplicationName = $"{ConfigurationManager.AppSettings["SolutionName"]} - {ConfigurationManager.AppSettings["UserFuelServices"]}",
Message = exception.Message
};
var exceptionRepository = new ExceptionLogRepository("MetadataConnection");
var exceptionId = exceptionRepository.Add(exceptionLog);
_response = new Response
{
IsSuccess = false,
//Obsolete = null,
StatusResponse = new StatusResponse
{
Status = 500,
Message = Default.LblHttpStatusCode500,
Timestamp = DateTimeOperations.FormatTimeStamp()
}
};
}
return(_response);
}
public Response Get(ZipCodeRequest request)
{
return(_fuelStationBr.GetZipCode(request));
}
