Exemple #1
0
 public DataTable notifyComments(CommentsFlagBO commentsflagBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query = "notifyComments";
         dap   = new SqlDataAdapter(query, con);
         dap.SelectCommand.CommandType = CommandType.StoredProcedure;
         DataSet ds = new DataSet();
         dap.Fill(ds, "notifyComments");
         dap.Dispose();
         return(ds.Tables["notifyComments"]);
     }
     catch
     {
         throw;
     }
     finally
     {
         if (con.State == ConnectionState.Open)
         {
             con.Close();
         }
     }
 }
 public DataTable notifyComments(CommentsFlagBO commentsflagBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query = "notifyComments";
         dap = new SqlDataAdapter(query, con);
         dap.SelectCommand.CommandType = CommandType.StoredProcedure;
         DataSet ds = new DataSet();
         dap.Fill(ds, "notifyComments");
         dap.Dispose();
         return ds.Tables["notifyComments"];
     }
     catch
     {
         throw;
     }
     finally
     {
         if (con.State == ConnectionState.Open)
             con.Close();
     }
 }
 public DataTable notifyComment(CommentsFlagBO commentsflagBO)
 {
     try
     {
         return(commentsflagDAL.notifyComments(commentsflagBO));
     }
     catch
     {
         throw;
     }
     finally
     {
     }
 }
    public DataTable notifyComment(CommentsFlagBO commentsflagBO)
    {
        try
        {
            return commentsflagDAL.notifyComments(commentsflagBO);
        }
        catch
        {
            throw;

        }
        finally
        {

        }
    }