protected void dtlPartnerSMS_DeleteCommand(object source, DataListCommandEventArgs e) { int id = (int)dtlPartnerSMS.DataKeys[e.Item.ItemIndex]; PartnerSMS objPartner = new PartnerSMS(); objPartner.delData(id); Response.Redirect(Request.RawUrl); }
protected void btnSeen_Click(object sender, EventArgs e) { PartnerSMS objSms = new PartnerSMS(); try { objSms.setSeenMsgByPartner(Session["ACCOUNT_CUSTOMER"].ToString()); } catch { return; } Response.Redirect(Request.RawUrl); }
public int setPrice(int Id, double Price, string accountChange = "", string CategoryId = "") { try { SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TVSConn"].ConnectionString); sqlCon.Open(); SqlCommand Cmd = sqlCon.CreateCommand(); string sqlQuery = ""; sqlQuery += " IF(@Price = (SELECT Price FROM tblProduct where Id = @Id )) " + " BEGIN " + " UPDATE tblProduct SET Price= 's' WHERE Id = -1 "+ // break error " END " + " ELSE " + " BEGIN " + " UPDATE tblProduct SET Price = @Price WHERE Id = @Id " + " END "; Cmd.CommandText = sqlQuery; Cmd.Parameters.Add("Id", SqlDbType.Int).Value = Id; Cmd.Parameters.Add("Price", SqlDbType.Float).Value = Price; Cmd.ExecuteNonQuery(); // Thực hiện thành công câu lệnh trên/ Cap nhat thong bao toi khach hang lien quan #region setNotice if (Id > 0) { sqlQuery = "SELECT DISTINCT PartnerId FROM tblCategoryPartner WHERE CategoryCode = (SELECT Code FROM tblCategory WHERE Id = (SELECT CatId FROM tblProduct WHERE Id = @Id))"; Cmd.CommandText = sqlQuery; SqlDataReader Rd = Cmd.ExecuteReader(); while (Rd.Read()) { this.setProductPartner(Id, Price, int.Parse(Rd["PartnerId"].ToString())); } Rd.Close(); } #endregion if (accountChange != "" && CategoryId != "") { #region setMsg // send notice for inbox PartnerSMS objCreateSMS = new PartnerSMS(); // lấy danh sách những khách hàng được phân quyền đã Partners objPartner = new Partners(); DataTable objTb = new DataTable(); objTb = objPartner.getPartnerByCat(int.Parse(CategoryId)); if (objTb.Rows.Count > 0) { for (int j = 0; j < objTb.Rows.Count; j++) { if (objPartner.getPartnerByAccout(objTb.Rows[j]["AccountName"].ToString()).Rows.Count > 0) { try { objCreateSMS.setData(" THAY ĐÔI GIÁ " , " " + getDataById(Id).Rows[0]["Name"].ToString() + " GIÁ THAY ĐỔI THÀNH " + Price + " VNĐ . ", int.Parse(objPartner.getPartnerByAccout(objTb.Rows[j]["AccountName"].ToString()).Rows[0]["Id"].ToString()), objTb.Rows[j]["AccountName"].ToString() , accountChange); } catch { } } } } #endregion } sqlCon.Close(); sqlCon.Dispose(); return(1); } catch { return(0); } }
protected void btnSave_Click(object sender, EventArgs e) { if (checkInputOption() < 0) { return; } if (upImage1.PostedFile.FileName != "") { if (!saveImage1()) { return; } } if (objProducts.setProduct(this.itemId, this.txtCode.Text, this.txtName.Text, this.txtSpecification.Text, float.Parse(this.txtPrice.Text), float.Parse(this.txtDiscount.Text), this.chkState.Checked, this.txtImage.Text, this.txtContent.Text, this.ddlNational.SelectedIndex, float.Parse(txtGuarantee.Text), int.Parse(this.ddlCategory.SelectedValue.ToString()), this.txtCapacity.Text ) > 0) { // send notice for inbox PartnerSMS objCreateSMS = new PartnerSMS(); // lấy danh sách những khách hàng được phân quyền đã Partners objPartner = new Partners(); DataTable objTb = new DataTable(); objTb = objPartner.getPartnerByCat(int.Parse(this.ddlCategory.SelectedValue.ToString())); if (objTb.Rows.Count > 0) { for (int j = 0; j < objTb.Rows.Count; j++) { if (objPartner.getPartnerByAccout(objTb.Rows[j]["AccountName"].ToString()).Rows.Count > 0) { try { objCreateSMS.setData(" SẢN PHẨM MỚI " , " " + this.txtName.Text + " có giá " + this.txtPrice.Text + " VNĐ . " + this.txtSpecification.Text, int.Parse(objPartner.getPartnerByAccout(objTb.Rows[j]["AccountName"].ToString()).Rows[0]["Id"].ToString()), objTb.Rows[j]["AccountName"].ToString() , Session["ACCOUNT"].ToString()); } catch { return; } } } } // objCreateSMS.setData("Thay đổi sản phẩm : "," "+ this.txtName.Text + " có giá " + this.txtPrice.Text + " " + this.txtSpecification.Text,,,); // Page.ClientScript.RegisterStartupScript(GetType(), "msg", "confirm('Sản phẩm đã cập nhật thành công')", true); Response.Redirect("AddProduct.aspx"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "msg", "confirm('Thao tác thất bại , Vui lòng thực hiện lại ')", true); lblMsg.Text = "Thao tác không thành công"; return; } }