public DataTable notifyIssues(IssueFlagBO issueflagBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query = "notifyIssues";
         dap = new SqlDataAdapter(query, con);
         dap.SelectCommand.Parameters.AddWithValue("@guid",issueflagBO.guid);
         dap.SelectCommand.CommandType = CommandType.StoredProcedure;
         DataSet ds = new DataSet();
         dap.Fill(ds, "notifyIssues");
         dap.Dispose();
         return ds.Tables["notifyIssues"];
     }
     catch
     {
         throw;
     }
     finally
     {
         if (con.State == ConnectionState.Open)
             con.Close();
     }
 }
예제 #2
0
 public DataTable notifyIssues(IssueFlagBO issueflagBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query = "notifyIssues";
         dap   = new SqlDataAdapter(query, con);
         dap.SelectCommand.Parameters.AddWithValue("@guid", issueflagBO.guid);
         dap.SelectCommand.CommandType = CommandType.StoredProcedure;
         DataSet ds = new DataSet();
         dap.Fill(ds, "notifyIssues");
         dap.Dispose();
         return(ds.Tables["notifyIssues"]);
     }
     catch
     {
         throw;
     }
     finally
     {
         if (con.State == ConnectionState.Open)
         {
             con.Close();
         }
     }
 }
예제 #3
0
 public DataTable notifyIssues(IssueFlagBO issueflagBO)
 {
     try
     {
         return(issueflagDAL.notifyIssues(issueflagBO));
     }
     catch
     {
         throw;
     }
     finally
     {
     }
 }
    public DataTable notifyIssues(IssueFlagBO issueflagBO)
    {
        try
        {
            return issueflagDAL.notifyIssues(issueflagBO);
        }
        catch
        {
            throw;

        }
        finally
        {

        }
    }