public IActionResult UpdateState(int StateId, UpdateStateRequestModel stateRequest)
{
try
{
bool status = false;
string message;
UpdateStateResponseModel updateState = _stateBusiness.UpdateState(StateId, stateRequest);
if (updateState != null)
{
if (updateState.ErrorResponse.ErrorStatus)
{
message = updateState.ErrorResponse.Message;
return(Ok(new { status, message }));
}
status = true;
message = "State Name has Been Updated";
StateUpdateResponseModel data = updateState.StateUpdate;
return(Ok(new { status, message, data }));
}
message = "Unable to Update the state";
return(Ok(new { status, message }));
}
catch (Exception e)
{
return(BadRequest(new { e.Message }));
}
}
/// <summary>
/// It Update the State Name
/// </summary>
/// <param name="StateId">StateId</param>
/// <param name="stateRequest">State Name</param>
/// <returns>Update State Response Model</returns>
public UpdateStateResponseModel UpdateState(int StateId, UpdateStateRequestModel stateRequest)
{
try
{
if (StateId <= 0 || stateRequest == null)
{
return(null);
}
else
{
return(_stateRepository.UpdateState(StateId, stateRequest));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// It Update the State Name.
/// </summary>
/// <param name="StateId">State Id</param>
/// <param name="stateRequest">State Name</param>
/// <returns>Update State Response Model</returns>
public UpdateStateResponseModel UpdateState(int StateId, UpdateStateRequestModel stateRequest)
{
try
{
SqlDataReader reader;
int statusCode, StateUpdatedPresent;
UpdateStateResponseModel updateState = null;
using (SqlConnection connection = new SqlConnection(sqlConnection))
{
SqlCommand sqlCommand = new SqlCommand("spState", connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
sqlCommand.Parameters.AddWithValue("@StateId", StateId);
sqlCommand.Parameters.AddWithValue("@Name", stateRequest.Name);
sqlCommand.Parameters.AddWithValue("@ActionType", "Update");
SqlParameter StatePresentParameter = sqlCommand.Parameters.Add("@StateNamePresentCount", System.Data.SqlDbType.Int);
StatePresentParameter.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();
StateUpdatedPresent = Convert.ToInt32(sqlCommand.Parameters["@StateNamePresentCount"].Value);
statusCode = Convert.ToInt32(sqlCommand.Parameters["@return_Value"].Value);
if (StateUpdatedPresent > 0)
{
updateState = new UpdateStateResponseModel
{
ErrorResponse = new ErrorResponseModel
{
ErrorStatus = true,
Message = "This Name Is already Present"
}
};
return(updateState);
}
if (statusCode == 0)
{
while (reader.Read())
{
updateState = new UpdateStateResponseModel
{
StateUpdate = new StateUpdateResponseModel()
{
StateId = Convert.ToInt32(reader[0]),
Name = reader[1].ToString(),
CreatedAt = Convert.ToDateTime(reader[2]),
ModifiedAt = Convert.ToDateTime(reader[3])
},
ErrorResponse = new ErrorResponseModel()
{
ErrorStatus = false
}
};
}
}
}
return(updateState);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
