public StarsDTO GetGasStationStarts(GasStationsParametersID gasStationsParametersID, out ReturnValues returnValues)
{
StarsDTO starsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(gasStationsParametersID.ID);
var countTotal = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID)
.Count();
var countPositive = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID && row.Assessment1 == true)
.Count();
var countNegative = _unitOfWork.AssessmentRepository.QueryableObject()
.Where(row => row.GasStaionID == ID && row.Assessment1 == false)
.Count();
starsDTO = new StarsDTO
{
GasStaionID = ID.ToString(),
Total = countTotal.ToString(),
Positive = countPositive.ToString(),
Negative = countNegative.ToString()
};
return(starsDTO);
}
public IHttpActionResult GetGasStationsByID([FromUri] GasStationsParametersID gasStationsParametersID)
{
if (gasStationsParametersID != null && ModelState.IsValid)
{
GasStationsDTO gasStationsDTO = _gasstationsservice.GetGasStationsByID(gasStationsParametersID, out ReturnValues returnValues);
if (!returnValues.Error)
{
return(Ok(new ResponseSuccess
{
Success = true,
Status = Convert.ToInt32(returnValues.Code),
Message = returnValues.Message,
Data = new
{
gasStation = gasStationsDTO
}
}));
}
return(Ok(new ResponseError
{
Success = false,
Status = Convert.ToInt32(returnValues.Code),
Message = returnValues.Message
}));
}
return(BadRequest(ModelState));
}
public IHttpActionResult GetStars([FromUri] GasStationsParametersID gasStationsParametersID)
{
StarsDTO starsDTO = _gasstationsservice.GetGasStationStarts(gasStationsParametersID, out ReturnValues returnValues);
if (!returnValues.Error)
{
return(Ok(new ResponseSuccess
{
Success = true,
Status = Convert.ToInt32(returnValues.Code),
Message = returnValues.Message,
Data = new
{
stars = starsDTO
}
}));
}
return(Ok(new ResponseError
{
Success = false,
Status = Convert.ToInt32(returnValues.Code),
Message = returnValues.Message
}));
}
public GasStationsDTO GetGasStationsByID(GasStationsParametersID gasStationsParametersID, out ReturnValues returnValues)
{
GasStation gasStation;
GasStationsDTO gasStationsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(gasStationsParametersID.ID);
try
{
gasStation = _unitOfWork.GasStationRepository.Get(row => row.ID == ID);
if (gasStation == null)
{
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(gasStationsDTO);
}
gasStationsDTO = new GasStationsDTO
{
ID = gasStation.ID.ToString(),
Status = gasStation.Status.ToString(),
Name = gasStation.Name,
Phone = gasStation.Phone,
GasolinaComum = gasStation.GasolinaComum.ToString(),
GasolinaAditivada = gasStation.GasolinaAditivada.ToString(),
Disel = gasStation.Disel.ToString(),
Gas = gasStation.Gas.ToString(),
PriceGasolinaComum = gasStation.PriceGasolinaComum.ToString(),
PriceGasolinaAditivada = gasStation.PriceGasolinaAditivada.ToString(),
PriceDisel = gasStation.PriceDisel.ToString(),
PriceGas = gasStation.PriceGas.ToString(),
Latitude = gasStation.Latitude,
Longitude = gasStation.Longitude,
CEP = gasStation.CEP,
Address = gasStation.Address,
Number = gasStation.Number,
DistrictID = gasStation.DistrictID,
CityID = gasStation.CityID,
StateID = gasStation.StateID,
CreatedOn = gasStation.CreatedOn.ToString(),
UpdatedOn = gasStation.UpdatedOn.ToString()
};
gasStationsDTO.lastUpdatePrice = GetlastUpdatePrice(gasStationsDTO.ID);
gasStationsDTO.NamelastUpdatePrice = GetNamelastUpdatePrice(gasStationsDTO.ID);
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(gasStationsDTO);
}
//public RegistrationsDTO UpdateRegistrationsbyID(RegistrationsParametersUpdate usersParametersUpdate, out ReturnValues returnValues)
//{
// Registration registration;
// RegistrationsDTO registrationsDTO = null;
// returnValues = new ReturnValues();
// int ID = Convert.ToInt32(usersParametersUpdate.ID);
// try
// {
// registration = _unitOfWork.RegistrationRepository.Get(row => row.ID == ID);
// if (registration == null)
// {
// returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
// return registrationsDTO;
// }
// registration.Name = usersParametersUpdate.Name;
// registration.Email = usersParametersUpdate.Email;
// registration.CPFCNPJ = usersParametersUpdate.CPFCNPJ;
// registration.Phone = usersParametersUpdate.Phone;
// registration.Password = Utils.Encrypt(usersParametersUpdate.Password);
// registration.CEP = usersParametersUpdate.CEP;
// registration.Address = usersParametersUpdate.Address;
// registration.Number = usersParametersUpdate.Number;
// registration.DistrictID = usersParametersUpdate.DistrictID;
// registration.CityID = usersParametersUpdate.CityID;
// registration.StateID = usersParametersUpdate.StateID;
// registration.UpdatedOn = DateTime.Now;
// _unitOfWork.RegistrationRepository.Update(registration);
// _unitOfWork.PersistChanges();
// registrationsDTO = new RegistrationsDTO
// {
// ID = registration.ID.ToString(),
// Status = registration.Status.ToString(),
// Name = registration.Name,
// Email = registration.Email,
// CPFCNPJ = registration.CPFCNPJ,
// Phone = registration.Phone,
// Username = registration.Username,
// Password = registration.Password,
// CEP = registration.CEP,
// Address = registration.Address,
// Number = registration.Number,
// DistrictID = registration.DistrictID,
// CityID = registration.CityID,
// StateID = registration.StateID,
// Type = registration.Type,
// CreatedOn = registration.CreatedOn.ToString(),
// UpdatedOn = registration.UpdatedOn.ToString()
// };
// returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
// }
// catch (Exception ex)
// {
// returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
// }
// return registrationsDTO;
//}
public GasStationsDTO DeleteGasStationsByID(GasStationsParametersID gasStationsParametersID, out ReturnValues returnValues)
{
#region Parameters
GasStation gasStation;
GasStationsDTO gasStationsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(gasStationsParametersID.ID);
#endregion
try
{
gasStation = _unitOfWork.GasStationRepository.Get(row => row.ID == ID);
if (gasStation == null)
{
returnValues.SetReturnValues(true, ErrorCodes.NotFound, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(gasStationsDTO);
}
_unitOfWork.GasStationRepository.Delete(gasStation);
_unitOfWork.PersistChanges();
gasStationsDTO = new GasStationsDTO
{
ID = gasStation.ID.ToString(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(gasStationsDTO);
}
