C# (CSharp) ProfissionalDAL Examples

Example #1

 public void SalvaDados(Profissional ObjProfissional)
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         ObjProfissionalDAL.InsertUpdateProfissional(ObjProfissional);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

Example #2

 //CARREGA TODOS OS REGISTROS PARA EDIÇÃO
 public object CarregaProfissional(int idProfissional)
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         return(ObjProfissionalDAL.SelectProfissionalByID(idProfissional));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

Example #3

File: ProfissionalBO.cs Project: danygolden/gianfratti

 public void SalvaDados(Profissional ObjProfissional)
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         ObjProfissionalDAL.InsertUpdateProfissional(ObjProfissional);
     }
     catch(Exception ex)
     {
         throw ex;
     }
 }

Example #4

File: ProfissionalBO.cs Project: danygolden/gianfratti

 //CARREGA TODOS OS REGISTROS PARA EDIÇÃO
 public object CarregaProfissional(int idProfissional)
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         return ObjProfissionalDAL.SelectProfissionalByID(idProfissional);
     }
     catch(Exception ex)
     {
         throw ex;
     }
 }

Example #5

 private void GridView()
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         GridView1.DataSource = ObjProfissionalDAL.SelectAll(TxtNome.Text, TxtCPF.Text, TxtRG.Text);
         GridView1.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex);
         Response.End();
     }
 }

Example #6

File: ProfissionalPrincipal.aspx.cs Project: danygolden/gianfratti

 private void GridView()
 {
     try
     {
         ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
         GridView1.DataSource = ObjProfissionalDAL.SelectAll(TxtNome.Text,TxtCPF.Text,TxtRG.Text);
         GridView1.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex);
         Response.End();
     }
 }

Example #7

 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Deletar")
         {
             ProfissionalDAL Obj = new ProfissionalDAL();
             Obj.DeleteProfissional(Convert.ToInt32(e.CommandArgument));
             GridView();
         }
     }
     catch (Exception ex)
     {
         Page.ClientScript.RegisterClientScriptBlock(GetType(), "Mensage", "alert('Este profissional não pode ser apagado pois esta vinculado a alguma empresa')", true);
         Console.Write(ex);
     }
 }

Example #8

File: ProfissionalPrincipal.aspx.cs Project: danygolden/gianfratti

 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Deletar")
         {
             ProfissionalDAL Obj = new ProfissionalDAL();
             Obj.DeleteProfissional(Convert.ToInt32(e.CommandArgument));
             GridView();
         }
     }
     catch (Exception ex)
     {
         Page.ClientScript.RegisterClientScriptBlock(GetType(), "Mensage", "alert('Este profissional não pode ser apagado pois esta vinculado a alguma empresa')", true);
         Console.Write(ex);
     }
 }

Example #9

    /// <summary>
    /// Usuado para gerar um DropDownList
    /// </summary>
    /// <returns></returns>
    public DataTable DropDownList()
    {
        ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();

        return(ObjProfissionalDAL.DropDownList());
    }

Example #10

File: ProfissionalBO.cs Project: danygolden/gianfratti

 /// <summary>
 /// Usuado para gerar um DropDownList
 /// </summary>
 /// <returns></returns>
 public DataTable DropDownList()
 {
     ProfissionalDAL ObjProfissionalDAL = new ProfissionalDAL();
     return ObjProfissionalDAL.DropDownList();
 }