/// <summary> /// Example method for getting 1 or more events to test /// </summary> /// <returns></returns> public DataSet GetTestEvents() { SqlCommand cmd = new SqlCommand("Stored_Procedure_Name"); cmd.CommandType = CommandType.StoredProcedure; using (Common.SQL sql = new Common.SQL()) { DataSet ds = sql.GetSqlDataSet("Database_Name", cmd); return(ds); } }
/// <summary> /// Example method for retrieving specific data /// </summary> /// <param name="Parameter1"></param> /// <returns></returns> public DataSet GetCustomerData(int Parameter1) { SqlCommand cmd = new SqlCommand("Stored_Procedure_Name"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Parameter1", Parameter1); using (Common.SQL sql = new Common.SQL()) { DataSet ds = sql.GetSqlDataSet("Database_Name", cmd); return(ds); } }
//TODO: Write wrapper methods for any stored procedure calls public void UpdateEvent(int Parameter1, String Parameter2) { SqlCommand cmd = new SqlCommand("Stored_Procedure_Name"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Parameter1", Parameter1); cmd.Parameters.AddWithValue("@Parameter2", Parameter2); using (Common.SQL sql = new Common.SQL()) { sql.ExecuteSqlProcedure("Database_Name", cmd); } }