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