public static DataTable getByID_Yeucau(yeucau yc) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("sp_getByID_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("getByID_Yeucau"); try { cmd.Transaction = trans; dt.Load(cmd.ExecuteReader()); trans.Commit(); } catch (Exception) { trans.Rollback(); } finally { if (cnn.State != ConnectionState.Closed) { cnn.Close(); } } return(dt); }
protected void btn_guiyeucau_Click(object sender, EventArgs e) { //if(txt_hoten.Value != "" || txt_sdt.Value != "" || txt_email.Value != "" || txt_diachi.Value != "" || txt_content.Text != "") //{ //} //else //{ // Response.Write("<script>alert('Một trong các thông tin người dùng vẫn chưa được nhập')</script>"); //} yeucau yc = new yeucau(); yc.mayeucau = "YC-" + DateTime.Now.ToString("yyyyMMddhhmmss"); yc.hoten = txt_hoten.Value; yc.email = txt_email.Value; yc.sdt = txt_sdt.Value; yc.diachithicong = txt_diachi.Value; yc.noidung = txt_content.Text; yc.ngaygui = DateTime.Now; bool success = yeucau_Action.add_Yeucau(yc); if (success) { Response.Write("<script>alert('Cám ơn quí khách đã tin tưởng Persky. Chúng tôi sẽ liên hệ trong thời gian sớm nhất')</script>"); } else { Response.Write("<script>alert('Không thể gửi yêu cầu')</script>"); } }
public static bool delete_Yeucau(yeucau yc) { bool success = false; SqlCommand cmd = new SqlCommand("sp_delete_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("delete_Yeucau"); 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_Yeucau(yeucau yc) { bool success = false; SqlCommand cmd = new SqlCommand("sp_add_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cmd.Parameters.AddWithValue("@hoten", yc.hoten); cmd.Parameters.AddWithValue("@email", yc.email); cmd.Parameters.AddWithValue("@diachithicong", yc.diachithicong); cmd.Parameters.AddWithValue("@sodienthoai", yc.sdt); cmd.Parameters.AddWithValue("@noidung", yc.noidung); cmd.Parameters.AddWithValue("@ngaygui", yc.ngaygui); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("add_Yeucau"); 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; }
protected void Page_Load(object sender, EventArgs e) { string mayeucau = ""; if (Session["dangnhap"].ToString() == "refuse") { Response.Redirect("~/default.aspx"); } try { mayeucau = Request.QueryString["requestID"].ToString(); if (mayeucau == "") { Response.Redirect("~/default.aspx"); } } catch (Exception) { Response.Redirect("~/default.aspx"); } yeucau yc = new yeucau(); yc.mayeucau = mayeucau; dtl_chitietyeucau.DataSource = yeucau_Action.getByID_Yeucau(yc); dtl_chitietyeucau.DataBind(); }
protected void grv_daduyet_RowDeleting(object sender, GridViewDeleteEventArgs e) { string mayeucau = grv_daduyet.DataKeys[e.RowIndex].Value.ToString(); yeucau yc = new yeucau(); yc.mayeucau = mayeucau; try { bool success = yeucau_Action.delete_Yeucau(yc); grv_chuaduyet.DataSource = yeucau_Action.getAll_Yeucau("CHƯA DUYỆT"); grv_chuaduyet.DataBind(); grv_choxuli.DataSource = yeucau_Action.getAll_Yeucau("CHỜ XỬ LÍ"); grv_choxuli.DataBind(); grv_daduyet.DataSource = yeucau_Action.getAll_Yeucau("ĐÃ DUYỆT"); grv_daduyet.DataBind(); } catch (Exception) { Response.Write("<script>alert('Xóa yêu cầu thất bại')</script>"); } }
public static bool add_Yeucau(yeucau yc) { bool success = false; SqlCommand cmd = new SqlCommand("sp_add_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cmd.Parameters.AddWithValue("@hoten", yc.hoten); cmd.Parameters.AddWithValue("@email", yc.email); cmd.Parameters.AddWithValue("@diachithicong", yc.diachithicong); cmd.Parameters.AddWithValue("@sodienthoai", yc.sdt); cmd.Parameters.AddWithValue("@noidung", yc.noidung); cmd.Parameters.AddWithValue("@ngaygui", yc.ngaygui); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("add_Yeucau"); 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); }
protected void grv_chuaduyet_RowEditing(object sender, GridViewEditEventArgs e) { string mayeucau = grv_chuaduyet.DataKeys[e.NewEditIndex].Value.ToString(); yeucau yc = new yeucau(); yc.mayeucau = mayeucau; yc.tinhtrang = "CHỜ XỬ LÍ"; try { bool success = yeucau_Action.updateStatus_Yeucau(yc); grv_chuaduyet.DataSource = yeucau_Action.getAll_Yeucau("CHƯA DUYỆT"); grv_chuaduyet.DataBind(); grv_choxuli.DataSource = yeucau_Action.getAll_Yeucau("CHỜ XỬ LÍ"); grv_choxuli.DataBind(); grv_daduyet.DataSource = yeucau_Action.getAll_Yeucau("ĐÃ DUYỆT"); grv_daduyet.DataBind(); } catch (Exception) { Response.Write("<script>alert('Cập nhật thất bại')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { string mayeucau = ""; if(Session["dangnhap"].ToString() == "refuse") { Response.Redirect("~/default.aspx"); } try { mayeucau = Request.QueryString["requestID"].ToString(); if(mayeucau == "") { Response.Redirect("~/default.aspx"); } } catch (Exception) { Response.Redirect("~/default.aspx"); } yeucau yc = new yeucau(); yc.mayeucau = mayeucau; dtl_chitietyeucau.DataSource = yeucau_Action.getByID_Yeucau(yc); dtl_chitietyeucau.DataBind(); }
public static bool updateStatus_Yeucau(yeucau yc) { bool success = false; SqlCommand cmd = new SqlCommand("sp_changeStatus_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cmd.Parameters.AddWithValue("@tinhtrangmoi", yc.tinhtrang); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("changeStatus_Yeucau"); 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 DataTable getByID_Yeucau(yeucau yc) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("sp_getByID_Yeucau", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mayeucau", yc.mayeucau); cnn.Open(); SqlTransaction trans = cnn.BeginTransaction("getByID_Yeucau"); try { cmd.Transaction = trans; dt.Load(cmd.ExecuteReader()); trans.Commit(); } catch (Exception) { trans.Rollback(); } finally { if (cnn.State != ConnectionState.Closed) { cnn.Close(); } } return dt; }