private void LoadData() { FeedBack feedBack = new FeedBack(); feedBack = FeedBackBLL.GetFeedBackByID(Request.QueryString["FeedBackID"].ToString())[0]; lblFullName.Text = feedBack.FullName; lblEmail.Text = feedBack.Email; ltrContent.Text = feedBack.Content; }
public FeedBack FeedBackIDatareader(IDataReader dr) { FeedBack obj = new FeedBack(); obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString(); obj.FullName = (dr["FullName"] is DBNull) ? string.Empty : dr["FullName"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString(); return obj; }
public bool InsertFeedBack(FeedBack feedBack) { using (SqlCommand cmd = GetCommand("insertFeedBack", CommandType.StoredProcedure)) { AddParameter(cmd, "@FullName", feedBack.FullName); AddParameter(cmd, "@Email", feedBack.Email); AddParameter(cmd, "@Content", feedBack.Content); int result = ExeNonQuery(cmd); return result > 0; } }
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; }
protected void btnSend_Click(object sender, EventArgs e) { if (Page.IsValid) { FeedBack feedBack = new FeedBack(); feedBack.FullName = txtFullName.Text; feedBack.Email = txtEmail.Text; feedBack.Content = txtContent.Text; bool result = FeedBackBLL.InsertFeedBack(feedBack); if (result) { lblReport.Text = "Send feedback Successful!"; Response.AddHeader("REFRESH", "2;URL=Support.aspx"); } else { lblReport.Text = "Can't send feed back"; } } }
public static bool UpdateFeedBack(FeedBack feedBack) { return db.UpdateFeedBack(feedBack); }
public static bool InsertFeedBack(FeedBack feedBack) { return db.InsertFeedBack(feedBack); }
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; }