public void rmDelete(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_rm '" + bllcreate.RMID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
        }
    }
    public void managerDelete(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_manager '" + bllcreate.MANAGERID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
        }
    }
    public void gmInsert(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Insert_gm '" + bllcreate.GM + "' ,'"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }
        catch (Exception e)
        {
        }
    }
    public void gmDelete(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_gm '" + bllcreate.GMID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
            //Use label to print an error >> lbl.text = e.Message;
        }
    }
    public void managerInsert(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Insert_manager '" + bllcreate.GM + "' ,'"
                  + bllcreate.MANAGER + "' ,'"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }
        catch (Exception e)
        {
            throw e;
        }
    }
    public void rmUpdate(bll_CreateAuthority bllcreate)
    {
        try
        {
            cmd = "EXEC Update_rm '"
                  + bllcreate.MANAGERID + "','"
                  + bllcreate.GM + "' ,'"
                  + bllcreate.MANAGER + "' ,'"
                  + bllcreate.RM + "' ,'"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }
        catch (Exception e)
        {
        }
    }