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