public void Create(SalesMan salesMan) { string script = @"INSERT INTO salesman VALUES(@IDSALESMAN, @NAME, @CPF, @TELEPHONE, @ADDRESS)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@IDSALESMAN", salesMan.IdSalesMan); command.Parameters.AddWithValue("@NAME", salesMan.Name); command.Parameters.AddWithValue("@CPF", salesMan.Cpf); command.Parameters.AddWithValue("@TELEPHONE", salesMan.Telephone); command.Parameters.AddWithValue("@ADDRESS", salesMan.Address); con.getCon().Open(); command.ExecuteNonQuery(); } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } }
public string Create(Sale sale) { string idSale = ""; string script = @"INSERT INTO sale(total,idClient,idSaleman,date,rate) VALUES (@TOTAL, @IDCLIENT, @IDSALESMAN, @DATA, @RATE)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@TOTAL", sale.Total); command.Parameters.AddWithValue("@IDCLIENT", sale.IdClient); command.Parameters.AddWithValue("@IDSALESMAN", sale.IdSalesMan); command.Parameters.AddWithValue("@DATA", sale.Data); command.Parameters.AddWithValue("@RATE", sale.Rate); con.getCon().Open(); reader = command.ExecuteReader(); if (reader.Read()) { idSale = reader["idSale"].ToString(); } } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } return(idSale); }
public void Create1(Client client) { string script = @"INSERT INTO client(name, address, telephone, cpf) VALUES (@NAME, @ADDRESS, @TELEPHONE, @CPF)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@NAME", client.Name); command.Parameters.AddWithValue("@ADDRESS", client.Address); command.Parameters.AddWithValue("@TELEPHONE", client.Telephone); command.Parameters.AddWithValue("@CPF", client.Cpf); con.getCon().Open(); command.ExecuteNonQuery(); } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } }
public void Create(ModePay modePay) { string script = @"INSERT INTO modePay (name,otherDetails) VALUES (@NAME, @OTHERDETAILS)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@NAME", modePay.Name); command.Parameters.AddWithValue("@OTHERDETAILS", modePay.OtherDetails); con.getCon().Open(); command.ExecuteNonQuery(); } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } }
public void CreateSql(Cliente objCliente) { string Create = $"INSERT INTO cliente(nome, endereco, telefone, cpf ) VALUES ({objCliente.Nome}, {objCliente.Endereco}, {objCliente.Telefone}, {objCliente.CPF})"; try { Comando = new SqlCommand(Create, objConexaoDB.GetConnection()); objConexaoDB.GetConnection().Open(); Comando.ExecuteNonQuery(); } catch (Exception e) { objCliente.Estado = 1; } finally { objConexaoDB.CloseDB(); } }
public void Create(Product product) { string script = @"INSERT INTO product VALUES(@IDPRODUCT, @NAME, @UNITPRICE, @IDCATEGORY)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@IDPRODUCT", product.IdProduct); command.Parameters.AddWithValue("@NAME", product.Name); command.Parameters.AddWithValue("@UNITPRICE", product.UnitPrice); command.Parameters.AddWithValue("@IDCATEGORY", product.IdCategory); con.getCon().Open(); command.ExecuteNonQuery(); } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } }
public void Create(Category category) { string script = @"INSERT INTO category VALUES(@IDCATEGORY, @NAME, @DESCRIPTION)"; try { command = new SqlCommand(script, con.getCon()); command.Parameters.AddWithValue("@IDCATEGORY", category.IdCategory); command.Parameters.AddWithValue("@NAME", category.Name); command.Parameters.AddWithValue("@DESCRIPTION", category.Description); con.getCon().Open(); command.ExecuteNonQuery(); } catch (Exception erro) { Message.MessageError(erro.Message); } finally { con.getCon().Close(); con.CloseDB(); } }