private CsFuncao CsFuncao_Preencher() { try { CsFuncao csFuncao = new CsFuncao { Nome = TxtNome.Text, Descricao = TxtDescricao.Text }; return(csFuncao); } catch (Exception exception) { MessageBox.Show("Houve um erro durante a transferência de dados, detalhes:" + exception.Message); } return(null); }
public CsCollectionFuncao CsFuncaoParametroColecao_Returno(CommandType commandType, string oleDbCommand, string where, string name) { csFuncao = new CsFuncao(); csCollectionFuncao = new CsCollectionFuncao(); csCommand = new CsCommand(); csCommand.ParameterCollection_Clear(); if (!(String.IsNullOrEmpty(name))) { csCommand.ParameterCollection_Add("@Nome", name); } DataTable dataTable = csCommand.ExecuteCommandConsult(commandType, oleDbCommand); foreach (DataRow linha in dataTable.Rows) { csCollectionFuncao.Add(csFuncao.CsFuncaoDataGridView(linha)); } return(csCollectionFuncao); }
public void CsFuncaoParemetroColecao(CommandType commandType, string oleDbCommand, CsFuncao csFuncao) { csCommand = new CsCommand(); csCommand.ParameterCollection_Clear(); csCommand.ParameterCollection_Add("@Nome", csFuncao.Nome); csCommand.ParameterCollection_Add("@Descricao", csFuncao.Descricao); csCommand.ExecuteCommandNonQuery(commandType, oleDbCommand); }