public List <Model.status> Select()
{
List <Model.status> ListaStatus = new List <Model.status>();
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Select * from status;";
SqlCommand cmd = new SqlCommand(sql, conexao);
conexao.Open();
try
{
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Model.status status = new Model.status();
status.idStatus = Convert.ToInt32(reader[0].ToString());
status.desc_status = reader["desc_status"].ToString();
ListaStatus.Add(status);
}
}
catch
{
Console.WriteLine("Deu erro na execução de status ...");
}
finally
{
conexao.Close();
}
return(ListaStatus);
}
public void Delete(Model.status status)
{
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Delete from status where idStatus=@idStatus;";
SqlCommand cmd = new SqlCommand(sql, conexao);
cmd.Parameters.AddWithValue("@idStatus", status.idStatus);
conexao.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
Console.WriteLine("Erro na remoção de status ...");
}
finally
{
conexao.Close();
}
}
public void Insert(Model.status status)
{
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Insert into status values (@desc_status)";
SqlCommand cmd = new SqlCommand(sql, conexao);
cmd.Parameters.AddWithValue("@desc_status", status.desc_status);
conexao.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
Console.WriteLine("Deu erro na inserção de status ...");
}
finally
{
conexao.Close();
}
}
public void Update(Model.status status)
{
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Update status set desc_status=@desc_status";
sql += " where idStatus=@idStatus;";
SqlCommand cmd = new SqlCommand(sql, conexao);
cmd.Parameters.AddWithValue("@idStatus", status.idStatus);
cmd.Parameters.AddWithValue("@desc_status", status.desc_status);
conexao.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
Console.WriteLine("Deu erro na atualização de status ...");
}
finally
{
conexao.Close();
}
}
public void Delete(Model.status status)
{
DAL.status dalStatus = new DAL.status();
dalStatus.Delete(status);
}
public void Update(Model.status status)
{
DAL.status dalStatus = new DAL.status();
dalStatus.Update(status);
}
public void Insert(Model.status status)
{
DAL.status dalStatus = new DAL.status();
dalStatus.Insert(status);
}
