public IActionResult AddCity(AddCityRequestModel addCity) { try { bool status = false; string message; AddCityResponseModel cityResponse = _cityBusiness.AddCity(addCity); if (cityResponse != null) { if (cityResponse.ErrorResponse.ErrorStatus) { message = cityResponse.ErrorResponse.Message; return(Ok(new { status, message })); } else { status = true; message = "City Has Been Successfully Added to State."; CityAddResponseModel data = cityResponse.CityAdd; return(Ok(new { status, message, data })); } } message = "Unable to Add City."; return(Ok(new { status, message })); } catch (Exception e) { return(BadRequest(new { e.Message })); } }
/// <summary> /// It add City to the state in db /// </summary> /// <param name="addCity">City Name and state Id</param> /// <returns>Add City Response Model</returns> public AddCityResponseModel AddCity(AddCityRequestModel addCity) { try { if (addCity == null) { return(null); } else { return(_cityRepository.AddCity(addCity)); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// It Add City to the State /// </summary> /// <param name="addCity">City Name and State Id</param> /// <returns>Add City Response Model</returns> public AddCityResponseModel AddCity(AddCityRequestModel addCity) { try { SqlDataReader reader; int statusCode, CityPresent; string errorMsg = ""; bool errorFlag = false; AddCityResponseModel cityResponse = null; using (SqlConnection connection = new SqlConnection(sqlConnection)) { SqlCommand sqlCommand = new SqlCommand("spCity", connection) { CommandType = System.Data.CommandType.StoredProcedure }; sqlCommand.Parameters.AddWithValue("@CityId", -1); sqlCommand.Parameters.AddWithValue("@Name", addCity.Name); sqlCommand.Parameters.AddWithValue("@StateId", addCity.StateId); sqlCommand.Parameters.AddWithValue("@ActionType", "Add"); SqlParameter CityPresentParameter = sqlCommand.Parameters.Add("@CityPresentCount", System.Data.SqlDbType.Int); CityPresentParameter.Direction = System.Data.ParameterDirection.ReturnValue; SqlParameter cmdExecuteSuccess = sqlCommand.Parameters.Add("@return_value", System.Data.SqlDbType.Int); cmdExecuteSuccess.Direction = System.Data.ParameterDirection.ReturnValue; connection.Open(); reader = sqlCommand.ExecuteReader(); CityPresent = Convert.ToInt32(sqlCommand.Parameters["@CityPresentCount"].Value); statusCode = Convert.ToInt32(sqlCommand.Parameters["@return_Value"].Value); if (CityPresent == -1) { errorFlag = true; errorMsg = "This State is Not Present"; } else if (CityPresent == -2) { errorFlag = true; errorMsg = "A State Cannot have Same City Name"; } if (errorFlag) { cityResponse = new AddCityResponseModel { ErrorResponse = new ErrorResponseModel { ErrorStatus = errorFlag, Message = errorMsg } }; return(cityResponse); } if (statusCode == 0) { if (reader.HasRows) { cityResponse = new AddCityResponseModel(); while (reader.Read()) { cityResponse.CityAdd = new CityAddResponseModel { CityId = Convert.ToInt32(reader[0]), Name = reader[1].ToString(), StateId = Convert.ToInt32(reader[2]), CreatedAt = Convert.ToDateTime(reader[3]), ModifiedAt = Convert.ToDateTime(reader[4]) }; cityResponse.ErrorResponse = new ErrorResponseModel() { ErrorStatus = false }; } } } } return(cityResponse); } catch (Exception e) { throw new Exception(e.Message); } }