internal Boolean updateInstituicao(InstituicaoDTO dto) { var _stringDeConexao = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName]; using (SqlConnection conn = new SqlConnection(_stringDeConexao.ToString())) { try { conn.Open(); var _update = stringDeUpdate; SqlCommand _comman = new SqlCommand(_update, conn); _comman.Parameters.AddWithValue(idInstituicao, dto.IdInstituicao); _comman.Parameters.AddWithValue("@cnpj", dto.cnpj); _comman.Parameters.AddWithValue("@NomeInstituicao", dto.NomeInstituicao); _comman.Parameters.AddWithValue("@EnderecoInstituicao", dto.EnderecoInstituicao); _comman.Parameters.AddWithValue("@TelefoneInstituicao", dto.TelefoneInstituicao); _comman.Parameters.AddWithValue("@EmailInstituicao", dto.EmailInstituicao); _comman.Parameters.AddWithValue("@Senha", dto.Senha); _comman.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } } return(true); }
internal Boolean deleteInstituicao(InstituicaoDTO dto) { var _stringDeConexao = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName]; using (SqlConnection conn = new SqlConnection(_stringDeConexao.ToString())) { try { conn.Open(); var _delete = stringDeDelete; SqlCommand _comman = new SqlCommand(_delete, conn); _comman.Parameters.AddWithValue(idInstituicao, dto.IdInstituicao); _comman.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } } return(true); }
internal InstituicaoDTO verificaLoginInstuicao(InstituicaoDTO dto) { var _stringDeConexao = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ToString(); using (SqlConnection conn = new SqlConnection(_stringDeConexao)) { try { DataSet dtSet = new DataSet(); DataTable table = new DataTable(); InstituicaoDTO instituicao = new InstituicaoDTO(); conn.Open(); var sql = stringSelectLogin; SqlCommand command = new SqlCommand(sql, conn); command.Parameters.AddWithValue("@EmailInstituicao", dto.EmailInstituicao); command.Parameters.AddWithValue("@Senha", dto.Senha); command.CommandType = CommandType.Text; dtSet = new DataSet(); SqlDataAdapter dtAdapter = new SqlDataAdapter(command); dtAdapter.Fill(dtSet); table = dtSet.Tables[0]; if (0 < table.Rows.Count) { instituicao.IdInstituicao = Convert.ToInt64(table.Rows[0]["IdInstituicao"].ToString()); instituicao.cnpj = table.Rows[0]["cnpj"].ToString(); instituicao.NomeInstituicao = table.Rows[0]["NomeInstituicao"].ToString(); return(instituicao); } else { return(null); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { } } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Selecionar") { int _index = int.Parse((string)e.CommandArgument); string _chave = GridView1.DataKeys[_index]["IdInstituicao"].ToString(); InstituicaoDTO _dto = new InstituicaoDTO(); if (!String.IsNullOrEmpty(_chave)) { _dto.IdInstituicao = long.Parse(_chave); } idInstituicao = Convert.ToInt16(_dto.IdInstituicao); } }
/// <summary> /// Metodo que insere dados na tabela instituição /// </summary> /// <param name="dto">InstituicaoDTO</param> /// <returns>Boolean</returns> internal Boolean insertInstituicao(InstituicaoDTO dto) { var _stringDeConexao = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ToString(); using (SqlConnection conn = new SqlConnection(_stringDeConexao)) { try { //abre o BD conn.Open(); // prepara o comando para enviar ao BD var _insert = stringDeInsert; //utiliza o sqlcommand para enviar os dados ao BD SqlCommand _comand = new SqlCommand(_insert, conn); //seta o valor do parametro que o BD está esperando _comand.Parameters.AddWithValue("@cnpj", dto.cnpj); _comand.Parameters.AddWithValue("@NomeInstituicao", dto.NomeInstituicao); _comand.Parameters.AddWithValue("@EnderecoInstituicao", dto.EnderecoInstituicao); _comand.Parameters.AddWithValue("@TelefoneInstituicao", dto.TelefoneInstituicao); _comand.Parameters.AddWithValue("@EmailInstituicao", dto.EmailInstituicao); _comand.Parameters.AddWithValue("@Senha", dto.Senha); //executa a informação _comand.ExecuteNonQuery(); return(true); } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { } } }
public InstituicaoDTO verificaLoginInstuicao(InstituicaoDTO dto) { return(_instituicaoDAL.verificaLoginInstuicao(dto)); }
public Boolean deleteInstituicao(InstituicaoDTO dto) { return(_instituicaoDAL.deleteInstituicao(dto)); }
public Boolean updateInstituicao(InstituicaoDTO dto) { return(_instituicaoDAL.updateInstituicao(dto)); }
/// <summary> /// Método responsável pela regra de negócios da instituicao /// No momento de inserir valores /// </summary> /// <param name="dto">InstituicaoDTO</param> /// <returns>Boolean</returns> public Boolean insertInstituicao(InstituicaoDTO dto) { return(_instituicaoDAL.insertInstituicao(dto)); }
protected void grudUsuario_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Excluir") { int _index = int.Parse((string)e.CommandArgument); string _chave = grudUsuario.DataKeys[_index]["IdInstituicao"].ToString(); InstituicaoDTO _dto = new InstituicaoDTO(); if (!String.IsNullOrEmpty(_chave)) { _dto.IdInstituicao = long.Parse(_chave); } InstituicaoBLL _bll = new InstituicaoBLL(); if (_bll.deleteInstituicao(_dto)) { preencherGrid(); } } if (e.CommandName == "Atualizar") { int _index = int.Parse((string)e.CommandArgument); string _chave = grudUsuario.DataKeys[_index]["IdInstituicao"].ToString(); string _cnpj = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[1].Text); string _nome = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[2].Text); string _endereco = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[3].Text); string _telefone = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[4].Text); string _email = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[5].Text); string _senha = Server.HtmlDecode(grudUsuario.Rows[_index].Cells[6].Text); txtCnpj.Text = _cnpj; txtCnpj.Focus(); txtNome.Text = _nome; txtNome.Focus(); txtEndereco.Text = _endereco; txtEndereco.Focus(); txtTelefone.Text = _telefone; txtTelefone.Focus(); txtEmail.Text = _email; txtEmail.Focus(); txtSenha.Text = _senha; txtSenha.Focus(); InstituicaoDTO _dto = new InstituicaoDTO(); if (!String.IsNullOrEmpty(_chave)) { _dto.IdInstituicao = long.Parse(_chave); } //acessa a business passando a dto InstituicaoBLL _bll = new InstituicaoBLL(); if (_bll.updateInstituicao(_dto)) { //Response.Redirect("About.aspx"); preencherGrid(); } } }