public void Incluir(modeloCompra obj)
{
try
{
//command
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.Conexao;
cmd.CommandText = "insert into compra(com_cod, com_data, com_nfiscal, com_total, com_nparcelas, com_status) values (@comcod, @comdata, @comnfiscal, @comtotal, @comnparcelas, @comstatus); select @@IDENTITY;";
cmd.Parameters.AddWithValue("@comdata", obj.com_data);
cmd.Parameters.AddWithValue("@comnfiscal", obj.com_nfiscal);
cmd.Parameters.AddWithValue("@comtotal", obj.com_total);
cmd.Parameters.AddWithValue("@comnparcelas", obj.com_nparcelas);
cmd.Parameters.AddWithValue("@comstatus", obj.com_status);
cn.Conectar();
obj.com_cod = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (SqlException ex)
{
throw new Exception("SQL ERROR: " + ex.Message);
}
catch (Exception ex)
{
throw new Exception("ERROR: " + ex.Message);
}
finally
{
cn.Desconectar();
}
}
public void Alterar(modeloCompra obj)
{
try
{
//command
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.Conexao;
cmd.CommandText = "UPDATE compra SET com_data, com_nfiscal, com_total, com_nparcelas, com_status = @comdata, @comnfiscal, @comtotal, @comnparcelas, @comstatus, WHERE com_cod = @comcod";
cmd.Parameters.AddWithValue("@comcod", obj.com_cod);
cmd.Parameters.AddWithValue("@comdata", obj.com_data);
cmd.Parameters.AddWithValue("@comnfiscal", obj.com_nfiscal);
cmd.Parameters.AddWithValue("@comtotal", obj.com_total);
cmd.Parameters.AddWithValue("@comnparcelas", obj.com_nparcelas);
cmd.Parameters.AddWithValue("@comstatus", obj.com_status);
cn.Conectar();
obj.com_cod = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (SqlException ex)
{
throw new Exception("Servidor SQL Erro: " + ex.Message);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cn.Desconectar();
}
}
public modeloCompra carregaModelo(int codigo)
{
modeloCompra modelo = new modeloCompra();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.Conexao;
cmd.CommandText = "select * from compra where com_cod =" + codigo.ToString();
cn.Conectar();
SqlDataReader registro = cmd.ExecuteReader();
if (registro.HasRows)
{
registro.Read();
modelo.com_cod = Convert.ToInt32(registro["com_cod"]);
modelo.com_data = Convert.ToString(registro["com_data"]);
modelo.com_nfiscal = Convert.ToInt32(registro["com_nfiscal"]);
modelo.com_nparcelas = Convert.ToInt32(registro["com_nparcelas"]);
modelo.com_status = Convert.ToInt32(registro["com_status"]);
modelo.com_total = Convert.ToInt32(registro["com_total"]);
}
return(modelo);
}
