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);
}
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 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;
}
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>");
}
}
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>");
}
}
