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); }