public MessageResponse Cadastrar(EspacosCafe esp) { string connectionString = Parametros.GetConnectionString(); SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand(); MessageResponse response = new MessageResponse(); command.CommandText = "insert into espacos (lotacao, horainicial, horafinal) values (@lotacao, @horainicial, @horafinal)"; command.Parameters.AddWithValue("@lotacao", esp.Lotacao); command.Parameters.AddWithValue("@horainicial", esp.HoraInicial); command.Parameters.AddWithValue("@horafinal", esp.HoraFinal); command.Connection = connection; try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception ex) { response.Success = false; response.Message = $"Ocorreu um erro ao realizar a requisição solicitada. Erro: {ex.Message}"; return(response); } finally { connection.Dispose(); } response.Success = true; response.Message = "Cadastrado com sucesso."; return(response); }
public MessageResponse Atualizar(EspacosCafe espaco) { MessageResponse response = new MessageResponse(); response = VerificarAtualizar(espaco); if (response.Success) { response = dal.Atualizar(espaco); response.Message = "Atualizado com sucesso!"; return(response); } return(response); }
public List <EspacosCafe> TrazerEspacosCafe() { string connectionString = Parametros.GetConnectionString(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = connectionString; SqlCommand command = new SqlCommand(); command.CommandText = @"select * from espacos"; command.Connection = connection; List <EspacosCafe> espacos = new List <EspacosCafe>(); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { long id = Convert.ToInt64(reader["ID"]); int lotacao = Convert.ToInt32(reader["LOTACAO"]); DateTime horaInicial = Convert.ToDateTime(reader["HORAINICIAL"]); DateTime horaFinal = Convert.ToDateTime(reader["HORAFINAL"]); EspacosCafe es = new EspacosCafe(id, lotacao, horaInicial, horaFinal); espacos.Add(es); } } catch { throw; } finally { connection.Dispose(); } return(espacos); }
private MessageResponse VerificarAtualizar(EspacosCafe espaco) { MessageResponse response = new MessageResponse(); List <string> erros = new List <string>(); StringBuilder errosEspaco = new StringBuilder(); if (erros.Count != 0) { for (int i = 0; i < erros.Count; i++) { errosEspaco.AppendLine(erros[i].ToString()); } response.Success = false; response.Message = errosEspaco.ToString(); return(response); } response.Success = true; return(response); }