public IList <CitysDTO> GetCitys(CityParametersGetAll cityParametersGetAll, out ReturnValues returnValues)
{
IList <CitysDTO> citysDTO = null;
returnValues = new ReturnValues();
var StateID = String.IsNullOrEmpty(cityParametersGetAll.StateID) ? "" : cityParametersGetAll.StateID;
try
{
var query = _unitOfWork.CityRepository.QueryableObject();
if (!String.IsNullOrEmpty(StateID))
{
citysDTO = query
.Where(row => row.StateID == StateID)
.Select(row => new CitysDTO()
{
ID = row.Id,
Name = row.Name,
}).ToList();
}
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(citysDTO as IList <CitysDTO>);
}
public IList <DistrictsDTO> GetDistricts(DistrictParametersGetAll districtParametersGetAll, out ReturnValues returnValues)
{
IList <DistrictsDTO> districtsDTO = null;
returnValues = new ReturnValues();
var CityID = String.IsNullOrEmpty(districtParametersGetAll.CityID) ? "" : districtParametersGetAll.CityID;
try
{
var query = _unitOfWork.DistrictRepository.QueryableObject();
if (!String.IsNullOrEmpty(CityID))
{
districtsDTO = query
.Where(row => row.CityID == CityID)
.Select(row => new DistrictsDTO()
{
ID = row.Id,
Name = row.Name,
}).ToList();
}
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(districtsDTO as IList <DistrictsDTO>);
}
public IList <StatesDTO> GetStates(StateParametersGetAll stateParametersGetAll, out ReturnValues returnValues)
{
IList <StatesDTO> statesDTO = null;
returnValues = new ReturnValues();
try
{
var query = _unitOfWork.StateRepository.QueryableObject();
statesDTO = query.Select(row => new StatesDTO()
{
ID = row.Id,
Name = row.Name
}).ToList();
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(statesDTO as IList <StatesDTO>);
}
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 GetRegistrationsByPassword(RegistrationsParametersPassword registrationsParametersPassword, out ReturnValues returnValues)
{
Registration registration;
RegistrationsDTO registrationsDTO = null;
returnValues = new ReturnValues();
try
{
registrationsParametersPassword.Password = Utils.Encrypt(registrationsParametersPassword.Password);
registration = _unitOfWork.RegistrationRepository.Get(row => row.Username == registrationsParametersPassword.UserName);
if (registration == null)
{
returnValues.SetReturnValues(true, ErrorCodes.InvalidUserPassword, Utils.GetEnumDescription(ErrorCodes.InvalidUserPassword));
return(registrationsDTO);
}
if (registration.Password != registrationsParametersPassword.Password)
{
returnValues.SetReturnValues(true, ErrorCodes.InvalidUserPassword, Utils.GetEnumDescription(ErrorCodes.InvalidUserPassword));
return(registrationsDTO);
}
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 IList <CommentsDTO> GetComments(CommentsGetParameters commentsGetParameters, out ReturnValues returnValues)
{
IList <CommentsDTO> commentsDTO = null;
returnValues = new ReturnValues();
int gasstaion;
try
{
var query = _unitOfWork.CommentRepository.QueryableObject();
if (!String.IsNullOrEmpty(commentsGetParameters.GasStationID))
{
gasstaion = Convert.ToInt32(commentsGetParameters.GasStationID);
query = query.Where(row => row.GasStaionID == gasstaion);
}
query = query.OrderByDescending(row => row.CreatedOn);
commentsDTO = query.Select(row => new CommentsDTO()
{
ID = row.ID.ToString(),
GasStaionID = row.GasStaionID.ToString(),
RegistrationID = row.RegistrationID.ToString(),
Comment = row.Comment1,
CreatedOn = row.CreatedOn.ToString(),
}).ToList();
foreach (var comment in commentsDTO)
{
comment.RegistrationID = GetNameComment(comment.RegistrationID);
}
;
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(commentsDTO as IList <CommentsDTO>);
}
public CommentsDTO CreateComments(CommentsParametersCreate commentsParametersCreate, out ReturnValues returnValues)
{
#region Parameters
Comment comments;
CommentsDTO commentsDTO = null;
returnValues = new ReturnValues();
#endregion
try
{
comments = new Comment()
{
GasStaionID = Convert.ToInt32(commentsParametersCreate.GasStationID),
RegistrationID = Convert.ToInt32(commentsParametersCreate.RegistrationID),
Comment1 = commentsParametersCreate.Comment,
CreatedOn = DateTime.Now
};
_unitOfWork.CommentRepository.Insert(comments);
_unitOfWork.PersistChanges();
commentsDTO = new CommentsDTO
{
ID = comments.ID.ToString(),
GasStaionID = comments.GasStaionID.ToString(),
RegistrationID = comments.RegistrationID.ToString(),
Comment = comments.Comment1,
CreatedOn = comments.CreatedOn.ToString(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message + " inner --> " + ex.InnerException);
}
return(commentsDTO);
}
public IList <RegistrationsDTO> GetRegistrations(RegistrationsParametersGetAll registrationsParametersGetAll, out ReturnValues returnValues)
{
IList <RegistrationsDTO> registrationsDTO = null;
returnValues = new ReturnValues();
try
{
var query = _unitOfWork.RegistrationRepository.QueryableObject();
registrationsDTO = query.Select(row => new RegistrationsDTO()
{
ID = row.ID.ToString(),
Status = row.Status.ToString(),
Name = row.Name,
Email = row.Email,
CPFCNPJ = row.CPFCNPJ,
Phone = row.Phone,
Username = row.Username,
Password = row.Password,
CEP = row.CEP,
Address = row.Address,
Number = row.Number,
DistrictID = row.DistrictID,
CityID = row.CityID,
StateID = row.StateID,
Type = row.Type,
CreatedOn = row.CreatedOn.ToString(),
UpdatedOn = row.UpdatedOn.ToString()
}).ToList();
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(registrationsDTO as IList <RegistrationsDTO>);
}
public CommentsDTO DeleteCommentsByID(CommentsParametersDelete commentsParametersDelete, out ReturnValues returnValues)
{
#region Parameters
Comment comments;
CommentsDTO commentsDTO = null;
returnValues = new ReturnValues();
int ID = Convert.ToInt32(commentsParametersDelete.ID);
int registration = Convert.ToInt32(commentsParametersDelete.RegistrationID);
int gasstation = Convert.ToInt32(commentsParametersDelete.GasStationID);
#endregion
try
{
comments = _unitOfWork.CommentRepository.Get(row => row.ID == ID && row.GasStaionID == gasstation && row.RegistrationID == registration);
if (comments == null)
{
returnValues.SetReturnValues(true, ErrorCodes.NotFound, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(commentsDTO);
}
_unitOfWork.CommentRepository.Delete(comments);
_unitOfWork.PersistChanges();
commentsDTO = new CommentsDTO
{
ID = comments.ID.ToString(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(commentsDTO);
}
//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);
}
public UpdatePricesGasStationDTO UpdatePriceGasStations(UpdatePriicesParameters updatePriicesParameters, out ReturnValues returnValues)
{
GasStation gasstation;
UpdatePricesGasStation updatepricesgasstation;
UpdatePricesGasStationDTO updatePricesGasStationDTO = null;
returnValues = new ReturnValues();
int GasstationID = Convert.ToInt32(updatePriicesParameters.GasstationID);
try
{
gasstation = _unitOfWork.GasStationRepository.Get(row => row.ID == GasstationID);
if (gasstation == null)
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(updatePricesGasStationDTO);
}
;
if (updatePriicesParameters.GasolinaComum > 0)
{
if (gasstation.PriceGasolinaComum > 0)
{
if (updatePriicesParameters.GasolinaComum <= gasstation.PriceGasolinaComum + 1 && updatePriicesParameters.GasolinaComum >= gasstation.PriceGasolinaComum - 1)
{
gasstation.PriceGasolinaComum = updatePriicesParameters.GasolinaComum;
}
else
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(updatePricesGasStationDTO);
}
}
else
{
gasstation.PriceGasolinaComum = updatePriicesParameters.GasolinaComum;
}
}
;
if (updatePriicesParameters.GasolinaAditivada > 0)
{
if (gasstation.PriceGasolinaAditivada > 0)
{
if (updatePriicesParameters.GasolinaAditivada <= gasstation.PriceGasolinaAditivada + 1 && updatePriicesParameters.GasolinaAditivada >= gasstation.PriceGasolinaAditivada - 1)
{
gasstation.PriceGasolinaAditivada = updatePriicesParameters.GasolinaAditivada;
}
else
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(updatePricesGasStationDTO);
}
}
else
{
gasstation.PriceGasolinaAditivada = updatePriicesParameters.GasolinaAditivada;
}
}
;
if (updatePriicesParameters.Gas > 0)
{
if (gasstation.PriceGas > 0)
{
if (updatePriicesParameters.Gas <= gasstation.PriceGas + 1 && updatePriicesParameters.Gas >= gasstation.PriceGas - 1)
{
gasstation.PriceGas = updatePriicesParameters.Gas;
}
else
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(updatePricesGasStationDTO);
}
}
else
{
gasstation.PriceGas = updatePriicesParameters.Gas;
}
}
;
if (updatePriicesParameters.Disel > 0)
{
if (gasstation.PriceDisel > 0)
{
if (updatePriicesParameters.Disel <= gasstation.PriceDisel + 1 && updatePriicesParameters.Disel >= gasstation.PriceDisel - 1)
{
gasstation.PriceDisel = updatePriicesParameters.Disel;
}
else
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(updatePricesGasStationDTO);
}
}
else
{
gasstation.PriceDisel = updatePriicesParameters.Disel;
}
}
;
_unitOfWork.GasStationRepository.Update(gasstation);
_unitOfWork.PersistChanges();
updatepricesgasstation = new UpdatePricesGasStation()
{
GasStationID = updatePriicesParameters.GasstationID,
RegistrationID = updatePriicesParameters.RegistrationID,
PriceGasolinaComum = updatePriicesParameters.GasolinaComum > 0 ? updatePriicesParameters.GasolinaComum : 0,
PriceGasolinaAditivada = updatePriicesParameters.GasolinaAditivada > 0 ? updatePriicesParameters.GasolinaAditivada : 0,
PriceGas = updatePriicesParameters.Gas > 0 ? updatePriicesParameters.Gas : 0,
PriceDisel = updatePriicesParameters.Disel > 0 ? updatePriicesParameters.Disel : 0,
CreatedOn = DateTime.Now,
};
_unitOfWork.UpdatePricesGasStationRepository.Insert(updatepricesgasstation);
_unitOfWork.PersistChanges();
updatePricesGasStationDTO = new UpdatePricesGasStationDTO
{
ID = updatepricesgasstation.ID.ToString(),
GasStationID = updatepricesgasstation.GasStationID,
RegistrationID = updatepricesgasstation.RegistrationID,
PriceGasolinaComum = updatepricesgasstation.PriceGasolinaComum.ToString(),
PriceGasolinaAditivada = updatepricesgasstation.PriceGasolinaAditivada.ToString(),
PriceDisel = updatepricesgasstation.PriceDisel.ToString(),
PriceGas = updatepricesgasstation.PriceGas.ToString(),
CreatedOn = updatepricesgasstation.CreatedOn.ToString()
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(updatePricesGasStationDTO);
}
public AssessmentsDTO CreateAssessments(AssessmentsParametersCreate assessmentsParametersCreate, out ReturnValues returnValues)
{
#region Parameters
Assessment assessment;
AssessmentsDTO assessmentsDTO = null;
returnValues = new ReturnValues();
bool edit = EditAssessment(assessmentsParametersCreate.GasStationID, assessmentsParametersCreate.RegistrationID);
#endregion
if (!edit)
{
try
{
assessment = new Assessment()
{
GasStaionID = Convert.ToInt32(assessmentsParametersCreate.GasStationID),
RegistrationID = Convert.ToInt32(assessmentsParametersCreate.RegistrationID),
Assessment1 = Convert.ToBoolean(assessmentsParametersCreate.Assessment),
CreatedOn = DateTime.Now
};
_unitOfWork.AssessmentRepository.Insert(assessment);
_unitOfWork.PersistChanges();
assessmentsDTO = new AssessmentsDTO
{
ID = assessment.ID.ToString(),
GasStaionID = assessment.GasStaionID.ToString(),
RegistrationID = assessment.RegistrationID.ToString(),
Assessment = assessment.Assessment1.ToString(),
CreatedOn = assessment.CreatedOn.ToString(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message + " inner --> " + ex.InnerException);
}
}
else
{
try
{
int gasstation = Convert.ToInt32(assessmentsParametersCreate.GasStationID);
int registration = Convert.ToInt32(assessmentsParametersCreate.RegistrationID);
assessment = _unitOfWork.AssessmentRepository.Get(row => row.GasStaionID == gasstation && row.RegistrationID == registration);
if (assessment == null)
{
returnValues.SetReturnValues(true, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.NotFound));
return(assessmentsDTO);
}
assessment.Assessment1 = Convert.ToBoolean(assessmentsParametersCreate.Assessment);
_unitOfWork.AssessmentRepository.Update(assessment);
_unitOfWork.PersistChanges();
assessmentsDTO = new AssessmentsDTO
{
ID = assessment.ID.ToString(),
GasStaionID = assessment.GasStaionID.ToString(),
RegistrationID = assessment.RegistrationID.ToString(),
Assessment = assessment.Assessment1.ToString(),
CreatedOn = assessment.CreatedOn.ToString(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
}
return(assessmentsDTO);
}
public IList <GasStationsDTO> GetGasStations(GasStationsParametersGetAll gasStationsParametersGetAll, out ReturnValues returnValues)
{
IList <GasStationsDTO> gasStationsDTO = null;
returnValues = new ReturnValues();
try
{
var query = _unitOfWork.GasStationRepository.QueryableObject()
.Where(row => row.Status == true);
if (!String.IsNullOrEmpty(gasStationsParametersGetAll.Name))
{
query = query.Where(row => row.Name.Contains(gasStationsParametersGetAll.Name));
}
if (!String.IsNullOrEmpty(gasStationsParametersGetAll.TypeGas))
{
switch (gasStationsParametersGetAll.TypeGas)
{
case "Gasolina Comum":
query = query.Where(row => row.GasolinaComum == true);
break;
case "Gasolina Aditivada":
query = query.Where(row => row.GasolinaAditivada == true);
break;
case "Disel":
query = query.Where(row => row.Disel == true);
break;
case "Gás":
query = query.Where(row => row.Gas == true);
break;
}
}
if (!String.IsNullOrEmpty(gasStationsParametersGetAll.DistrictID))
{
query = query.Where(row => row.DistrictID == gasStationsParametersGetAll.DistrictID);
}
gasStationsDTO = query.Select(row => new GasStationsDTO()
{
ID = row.ID.ToString(),
Status = row.Status.ToString(),
Name = row.Name,
Phone = row.Phone,
GasolinaComum = row.GasolinaComum.ToString(),
GasolinaAditivada = row.GasolinaAditivada.ToString(),
Disel = row.Disel.ToString(),
Gas = row.Gas.ToString(),
PriceGasolinaComum = row.PriceGasolinaComum.ToString(),
PriceGasolinaAditivada = row.PriceGasolinaAditivada.ToString(),
PriceDisel = row.PriceDisel.ToString(),
PriceGas = row.PriceGas.ToString(),
Latitude = row.Latitude,
Longitude = row.Longitude,
CEP = row.CEP,
Address = row.Address,
Number = row.Number,
DistrictID = row.DistrictID,
CityID = row.CityID,
StateID = row.StateID,
CreatedOn = row.CreatedOn.ToString(),
UpdatedOn = row.UpdatedOn.ToString(),
distance = "",
lastUpdatePrice = ""
}).ToList();
double lat = -30.076721;
double longui = -51.031796;
if (!String.IsNullOrEmpty(gasStationsParametersGetAll.latitude) && !String.IsNullOrEmpty(gasStationsParametersGetAll.longitude))
{
lat = Convert.ToDouble(gasStationsParametersGetAll.latitude);
longui = Convert.ToDouble(gasStationsParametersGetAll.longitude);
}
foreach (var gas in gasStationsDTO)
{
gas.distance = getDistance(Convert.ToDouble(gas.Latitude), Convert.ToDouble(gas.Longitude), lat, longui).ToString();
}
;
if (!String.IsNullOrEmpty(gasStationsParametersGetAll.Order))
{
switch (gasStationsParametersGetAll.Order)
{
case "More Relevant":
switch (gasStationsParametersGetAll.TypeGas)
{
case "Gasolina Comum":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaComum)).OrderBy(o => Convert.ToDouble(o.distance)).Take(30).ToList();
break;
case "Gasolina Aditivada":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaAditivada)).OrderBy(o => Convert.ToDouble(o.distance)).Take(30).ToList();
break;
case "Disel":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceDisel)).OrderBy(o => Convert.ToDouble(o.distance)).Take(30).ToList();
break;
case "Gás":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGas)).OrderBy(o => Convert.ToDouble(o.distance)).Take(30).ToList();
break;
default:
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaComum)).OrderBy(o => Convert.ToDouble(o.distance)).Take(30).ToList();
break;
}
break;
case "Highest Price":
switch (gasStationsParametersGetAll.TypeGas)
{
case "Gasolina Comum":
gasStationsDTO = gasStationsDTO.OrderByDescending(o => Convert.ToDecimal(o.PriceGasolinaComum)).Take(30).ToList();
break;
case "Gasolina Aditivada":
gasStationsDTO = gasStationsDTO.OrderByDescending(o => Convert.ToDecimal(o.PriceGasolinaAditivada)).Take(30).ToList();
break;
case "Disel":
gasStationsDTO = gasStationsDTO.OrderByDescending(o => Convert.ToDecimal(o.PriceDisel)).Take(30).ToList();
break;
case "Gás":
gasStationsDTO = gasStationsDTO.OrderByDescending(o => Convert.ToDecimal(o.PriceGas)).Take(30).ToList();
break;
default:
gasStationsDTO = gasStationsDTO.OrderByDescending(o => Convert.ToDecimal(o.PriceGasolinaComum)).Take(30).ToList();
break;
}
break;
case "Lower Price":
switch (gasStationsParametersGetAll.TypeGas)
{
case "Gasolina Comum":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaComum)).Take(30).ToList();
break;
case "Gasolina Aditivada":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaAditivada)).Take(30).ToList();
break;
case "Disel":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceDisel)).Take(30).ToList();
break;
case "Gás":
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGas)).Take(30).ToList();
break;
default:
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaComum)).Take(30).ToList();
break;
}
break;
}
}
else
{
gasStationsDTO = gasStationsDTO.OrderBy(o => Convert.ToDecimal(o.PriceGasolinaComum)).OrderBy(o => Convert.ToDouble(o.distance)).Take(20).ToList();
}
foreach (var gas in gasStationsDTO)
{
gas.lastUpdatePrice = GetlastUpdatePrice(gas.ID);
//gas.distance = getDistanceGoogle(lat.ToString() + "," + longui.ToString(), Convert.ToDouble(gas.Latitude).ToString()+ "," +Convert.ToDouble(gas.Longitude).ToString()).ToString();
}
;
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message);
}
return(gasStationsDTO as IList <GasStationsDTO>);
}
public GasStationsDTO CreateGasStations(GasStationsParametersCreate gasStationsParametersCreate, out ReturnValues returnValues)
{
#region Parameters
GasStation gasStation;
GasStationsDTO gasStationsDTO = null;
returnValues = new ReturnValues();
#endregion
try
{
gasStation = new GasStation()
{
Status = false,
Name = gasStationsParametersCreate.Name,
Phone = string.IsNullOrEmpty(gasStationsParametersCreate.Phone) ? null : gasStationsParametersCreate.Phone,
GasolinaComum = string.IsNullOrEmpty(gasStationsParametersCreate.GasolinaComum) ? false : Convert.ToBoolean(gasStationsParametersCreate.GasolinaComum),
GasolinaAditivada = string.IsNullOrEmpty(gasStationsParametersCreate.GasolinaAditivada) ? false : Convert.ToBoolean(gasStationsParametersCreate.GasolinaAditivada),
Disel = string.IsNullOrEmpty(gasStationsParametersCreate.Disel) ? false : Convert.ToBoolean(gasStationsParametersCreate.Disel),
Gas = string.IsNullOrEmpty(gasStationsParametersCreate.Gas) ? false : Convert.ToBoolean(gasStationsParametersCreate.Gas),
PriceGasolinaComum = string.IsNullOrEmpty(gasStationsParametersCreate.PriceGasolinaComum) ? 0 : Math.Round(Convert.ToDecimal(gasStationsParametersCreate.PriceGasolinaComum), 2),
PriceGasolinaAditivada = string.IsNullOrEmpty(gasStationsParametersCreate.PriceGasolinaAditivada) ? 0 : Math.Round(Convert.ToDecimal(gasStationsParametersCreate.PriceGasolinaAditivada), 2),
PriceDisel = string.IsNullOrEmpty(gasStationsParametersCreate.PriceDisel) ? 0 : Math.Round(Convert.ToDecimal(gasStationsParametersCreate.PriceDisel), 2),
PriceGas = string.IsNullOrEmpty(gasStationsParametersCreate.PriceGas) ? 0 : Math.Round(Convert.ToDecimal(gasStationsParametersCreate.PriceGas), 2),
Latitude = string.IsNullOrEmpty(gasStationsParametersCreate.Latitude) ? null : gasStationsParametersCreate.Latitude,
Longitude = string.IsNullOrEmpty(gasStationsParametersCreate.Longitude) ? null : gasStationsParametersCreate.Longitude,
CEP = string.IsNullOrEmpty(gasStationsParametersCreate.CEP) ? null : gasStationsParametersCreate.CEP,
Address = gasStationsParametersCreate.Address,
Number = gasStationsParametersCreate.Number,
DistrictID = gasStationsParametersCreate.DistrictID,
CityID = gasStationsParametersCreate.CityID,
StateID = gasStationsParametersCreate.StateID,
CreatedOn = DateTime.Now
};
_unitOfWork.GasStationRepository.Insert(gasStation);
_unitOfWork.PersistChanges();
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(),
};
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.Ok));
}
catch (Exception ex)
{
returnValues.SetReturnValues(true, ErrorCodes.InternalError, ex.Message + " inner --> " + ex.InnerException);
}
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 RegistrationsDTO CreateRegistrations(RegistrationsParametersCreate registrationsParametersCreate, out ReturnValues returnValues)
{
#region Parameters
Registration registration;
RegistrationsDTO registrationsDTO = null;
returnValues = new ReturnValues();
#endregion
if (!RegistrationExistEmail(registrationsParametersCreate.Email))
{
try
{
registration = new Registration()
{
Status = true,
Name = registrationsParametersCreate.Name,
Email = registrationsParametersCreate.Email,
CPFCNPJ = registrationsParametersCreate.CPFCNPJ,
Phone = registrationsParametersCreate.Phone,
Username = registrationsParametersCreate.Email,
Password = Utils.Encrypt(registrationsParametersCreate.Password),
CEP = registrationsParametersCreate.CEP,
Address = registrationsParametersCreate.Address,
Number = registrationsParametersCreate.Number,
DistrictID = registrationsParametersCreate.DistrictID,
CityID = registrationsParametersCreate.CityID,
StateID = registrationsParametersCreate.StateID,
Type = "CLI",
CreatedOn = DateTime.Now
};
_unitOfWork.RegistrationRepository.Insert(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 + " inner --> " + ex.InnerException);
}
}
else
{
returnValues.SetReturnValues(false, ErrorCodes.Ok, Utils.GetEnumDescription(ErrorCodes.UserExist));
}
return(registrationsDTO);
}