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))); }