public static bool delete_Thacmac(thacmac tm) { bool success = false; SqlCommand cmd = new SqlCommand("sp_delete_Thacmac", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cauhoi", tm.cauhoi); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("delete_Thacmac"); try { cmd.Transaction = trans; cmd.ExecuteNonQuery(); trans.Commit(); success = true; } catch (Exception) { success = false; trans.Rollback(); } finally { if (cnn.State != ConnectionState.Closed) { cnn.Close(); } } return(success); }
public static bool add_Thacmac(thacmac tm) { bool success = false; SqlCommand cmd = new SqlCommand("sp_add_Thacmac", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cauhoi", tm.cauhoi); cmd.Parameters.AddWithValue("@cautraloi", tm.cautraloi); cmd.Parameters.AddWithValue("@ngaydang", tm.ngaydang); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("add_Thacmac"); try { cmd.Transaction = trans; cmd.ExecuteNonQuery(); trans.Commit(); success = true; } catch (Exception) { success = false; trans.Rollback(); } finally { if (cnn.State != ConnectionState.Closed) { cnn.Close(); } } return success; }
//----------------------------------------- THẮC MẮC ---------------------------------------------------------------------- protected void btn_dangnoidungthacmac_Click(object sender, EventArgs e) { thacmac tm = new thacmac(); tm.cauhoi = txt_cauhoi.Value; tm.cautraloi = txt_cautraloi.Text; tm.ngaydang = DateTime.Now; bool success = thacmac_Action.add_Thacmac(tm); if(success == true) { Response.Write("<script>alert('Đăng thắc mắc thành công')</script>"); } else { Response.Write("<script>alert('Đăng thắc mắc không thành công')</script>"); } }
protected void grv_thacmac_RowDeleting(object sender, GridViewDeleteEventArgs e) { string cauhoi = grv_thacmac.DataKeys[e.RowIndex].Value.ToString(); thacmac tm = new thacmac(); tm.cauhoi = cauhoi; bool success = thacmac_Action.delete_Thacmac(tm); if (success == true) { Response.Write("<script>alert('Xóa thắc mắc thành công')</script>"); grv_thacmac.DataBind(); } else { Response.Write("<script>alert('Không thể xóa thắc mắc')</script>"); } }
//----------------------------------------- THẮC MẮC ---------------------------------------------------------------------- protected void btn_dangnoidungthacmac_Click(object sender, EventArgs e) { thacmac tm = new thacmac(); tm.cauhoi = txt_cauhoi.Value; tm.cautraloi = txt_cautraloi.Text; tm.ngaydang = DateTime.Now; bool success = thacmac_Action.add_Thacmac(tm); if (success == true) { Response.Write("<script>alert('Đăng thắc mắc thành công')</script>"); } else { Response.Write("<script>alert('Đăng thắc mắc không thành công')</script>"); } }