public List<FeedBack> GetAllFeedBack() { List<FeedBack> list = new List<FeedBack>(); using (SqlCommand cmd = GetCommand("getAllFeedBack", CommandType.StoredProcedure)) { FeedBack feedBack = new FeedBack(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(feedBack.FeedBackIDatareader(dr)); } } } feedBack = null; } return list; }
public List<FeedBack> GetFeedBackByID(string id) { List<FeedBack> list = new List<FeedBack>(); using (SqlCommand cmd = GetCommand("getFeedBackByID", CommandType.StoredProcedure)) { AddParameter(cmd, "@ID", Convert.ToInt32(id)); FeedBack feedBack = new FeedBack(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(feedBack.FeedBackIDatareader(dr)); } } } feedBack = null; } return list; }
public List<FeedBack> SearchFeedBackByName(string name) { List<FeedBack> list = new List<FeedBack>(); using (SqlCommand cmd = GetCommand("SearchFeedBackByName", CommandType.StoredProcedure)) { AddParameter(cmd, "@FullName", name); FeedBack feedBack = new FeedBack(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(feedBack.FeedBackIDatareader(dr)); } } } feedBack = null; } return list; }