public IHttpActionResult PostState(StateBindingModel stateBM)
{
if (ModelState.IsValid)
{
try
{
var state = Mapper.Map <StateBindingModel, State>(stateBM);
_stateService.Save(state);
state = _stateService.GetById(state.Id);
stateBM = Mapper.Map <State, StateBindingModel>(state);
return(Ok(stateBM));
}
catch (Exception ex)
{
var result = ex.Message;
}
}
else
{
return(BadRequest(ModelState));
}
return(Ok(StatusCode(HttpStatusCode.BadRequest)));
}
public async Task <IHttpActionResult> GetStates()
{
var processingResult = new ServiceProcessingResult <List <StateBindingModel> > {
IsSuccessful = true
};
try {
var sqlQuery = "SELECT * FROM states order by name";
MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@InvNumber", "1") };
var sqlQueryService = new SQLQuery();
var stateResult = await sqlQueryService.ExecuteReaderAsync(CommandType.Text, sqlQuery, parameters);
if (!stateResult.IsSuccessful)
{
processingResult.IsSuccessful = false;
processingResult.Error = new ProcessingError("Error getting states", "Error getting ", true, false);
return(Ok(processingResult));
}
if (stateResult.Data.Rows.Count > 0)
{
List <StateBindingModel> States = new List <StateBindingModel>();
foreach (DataRow row in stateResult.Data.Rows)
{
StateBindingModel state = new StateBindingModel();
state.Abrv = row["abrv"].ToString();
state.Name = row["name"].ToString();
States.Add(state);
}
processingResult.Data = States;
processingResult.IsSuccessful = true;
}
else
{
processingResult.IsSuccessful = false;
processingResult.Error = new ProcessingError("Failed to retrieve states", "Failed to retrieve states", true, false);
}
} catch (Exception ex) {
ex.ToExceptionless().Submit();
processingResult.IsSuccessful = false;
processingResult.Error = new ProcessingError("Failed to retrieve states", "Failed to retrieve states", true, false);
}
return(Ok(processingResult));
}
public IHttpActionResult DeleteState(Guid id)
{
try
{
var stateBM = new StateBindingModel()
{
Id = id
};
var state = Mapper.Map <StateBindingModel, State>(stateBM);
_stateService.Delete(state.Id);
return(Ok());
}
catch (Exception ex)
{
var result = ex.Message;
}
return(Ok(StatusCode(HttpStatusCode.BadRequest)));
}
