public QueryResponse <Sirus> GetAll()
{
QueryResponse <Sirus> response = new QueryResponse <Sirus>();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\entra21\Documents\dbSirus.mdf;Integrated Security=True;Connect Timeout=30";
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM CLIENTES WHERE ATIVO = 1";
command.Connection = connection;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <Sirus> _ListSirus = new List <Sirus>();
while (reader.Read())
{
Sirus c = new Sirus();
c.ID = (int)reader["ID"];
c.Nome = (string)reader["NOME"];
c.Awakener = (byte)reader["AWAKENER"];
c.DataCadastro = (DateTime)reader["DATACADASTRO"];
c.Completado = (bool)reader["COMPLETADO"];
c.Ativo = (bool)reader["ATIVO"];
_ListSirus.Add(c);
}
response.Success = true;
response.Message = "Dados selecionados com sucesso";
response.Data = _ListSirus;
return(response);
}
catch (Exception e)
{
response.Success = false;
response.Message = "Erro no Banco de dados, contato o administrador.";
response.StackTrace = e.StackTrace;
response.ExceptionError = e.Message;
return(response);
}
finally
{
connection.Close();
}
}
public Response Delete(Sirus sirus)
{
Response response = new Response();
//classe responsavel por realizar conexao fisica com banco de dados
SqlConnection connection = new SqlConnection();
connection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\entra21\Documents\dbSirus.mdf;Integrated Security=True;Connect Timeout=30";
//classe responsavel por realizar um querry no DB
SqlCommand command = new SqlCommand();
command.CommandText = "UPDATE Sirus SET ATIVO = @ATIVO, WHERE ID = @ID";
command.Parameters.AddWithValue("@ATIVO", false);
command.Parameters.AddWithValue("@ID", sirus.ID);
try
{
connection.Open();
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected != 1)
{
response.Success = false;
response.Message = "Registro nao encontrado";
return(response);
}
response.Success = true;
response.Message = "Deletado com sucesso";
}
catch (Exception e)
{
response.Success = false;
response.Message = "Erro no Banco de dados, contato o administrador.";
//estas duas propriedades sao para LOG
response.StackTrace = e.StackTrace;
response.ExceptionError = e.Message;
}
finally
{
//finaly sempre executa.
connection.Close();
}
return(response);
}
public Response Update(Sirus sirus)
{
Response response = new Response();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\entra21\Documents\dbSirus.mdf;Integrated Security=True;Connect Timeout=30";
SqlCommand command = new SqlCommand();
command.CommandText = "UPDATE Sirus SET NOME = @NOME, ATIVO = @ATIVO, AWAKENER = @AWAKENER, COMPLETADO = @COMPLETADO, WHERE ID = @ID";
command.Parameters.AddWithValue("@NOME", sirus.Nome);
command.Parameters.AddWithValue("@AWAKENER", sirus.Awakener);
command.Parameters.AddWithValue("@COMPLETADO", sirus.Completado);
command.Parameters.AddWithValue("@ID", sirus.ID);
try
{
connection.Open();
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected != 1)
{
response.Success = false;
response.Message = "Registro nao encontrado";
return(response);
}
response.Success = true;
response.Message = "Atualizado com sucesso.";
}
catch (Exception e)
{
response.Success = false;
response.Message = "Erro no Banco de dados, contato o administrador.";
response.StackTrace = e.StackTrace;
response.ExceptionError = e.Message;
}
finally
{
//finaly sempre executa.
connection.Close();
}
return(response);
}
public Response Insert(Sirus sirus)
{
Response response = new Response();
//classe responsavel por realizar conexao fisica com banco de dados
SqlConnection connection = new SqlConnection();
connection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\entra21\Documents\dbSirus.mdf;Integrated Security=True;Connect Timeout=30";
//classe responsavel por realizar um querry no DB
SqlCommand command = new SqlCommand();
command.CommandText = "INSERT INTO SIRUS(NOME,AWAKENER,COMPLETADO,ATIVO) VALUES (@NOME,@AWAKENER,@COMPLETADO,@ATIVO)";
command.Parameters.AddWithValue("@NOME", sirus.Nome);
command.Parameters.AddWithValue("@AWAKENER", sirus.Awakener);
command.Parameters.AddWithValue("@COMPLETADO", sirus.Completado);
command.Parameters.AddWithValue("@ATIVO", true);
try
{
connection.Open();
command.ExecuteNonQuery();
response.Success = true;
response.Message = "Cadastrado com sucess.";
}
catch (Exception e)
{
response.Success = false;
response.Message = "Erro no Banco de dados, contato o administrador.";
//estas duas propriedades sao para LOG
response.StackTrace = e.StackTrace;
response.ExceptionError = e.Message;
}
finally
{
//finaly sempre executa.
connection.Close();
}
return(response);
}
