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