private void UnPublicShopButton_Click(object sender, EventArgs e)
{
Wait.Show("Ngừng public cửa hàng" + shopNameTextEdit.Text);
#region Cập nhật Toàn bộ sản phẩm Valid = 0
try
{
long idcompanywss = Common.Obj2Int64(companyIdWSSSpinEdit.Text);
DBWebPartnerTableAdapters.ProductTableAdapter productAdapter = new DBWebPartnerTableAdapters.ProductTableAdapter();
productAdapter.Connection.ConnectionString = Server.ConnectionString;
productAdapter.UpdateValidProductByCompanyId(false, idcompanywss);
}
catch (Exception ex)
{
MessageBox.Show("Cập nhật Valid = 0 lỗi!" + ex.Message);
return;
}
#endregion
#region Cập nhật IsPublic = 0 trong Company_Haravan
try
{
long idcompanyharavan = Common.Obj2Int64(companyIdHaravanSpinEdit.Text);
DBWebPartnerTableAdapters.Company_HaravanTableAdapter haravanAdapter = new DBWebPartnerTableAdapters.Company_HaravanTableAdapter();
haravanAdapter.Connection.ConnectionString = Server.ConnectionString;
haravanAdapter.UpdateIsPublic(false, idcompanyharavan);
}
catch (Exception ex)
{
MessageBox.Show("Cập nhật IsPublic = 0 lỗi!" + ex.Message);
}
#endregion
Wait.Close();
}
private void DownloadImageThieuButton_Click(object sender, EventArgs e)
{
Wait.Show("Đang download ảnh");
long idcompany = Common.Obj2Int64(companyIdWSSSpinEdit.Text);
string _domain = domainChinhXacTextEdit.Text;
DBWebPartnerTableAdapters.ProductTableAdapter productAdapter = new DBWebPartnerTableAdapters.ProductTableAdapter();
productAdapter.Connection.ConnectionString = Server.ConnectionString;
DBWebPartner.ProductDataTable productTable = new DBWebPartner.ProductDataTable();
productAdapter.FillBy_CompanyAndImagePathNullAndValid1(productTable, idcompany);
if (productTable.Rows.Count == 0)
{
MessageBox.Show("Shop không có sản phẩm! Vui lòng kiểm tra lại!");
}
else
{
int count = productTable.Rows.Count;
int countproduct = 0;
int countproductimagesuccess = 0;
for (int i = 0; i < count; i++)
{
Wait.Show(string.Format("Download ảnh {0}/{1}", i.ToString(), count.ToString()));
long idProduct = long.Parse(productTable.Rows[i]["ID"].ToString());
string imageurls = productTable.Rows[i]["ImageUrls"].ToString();
string nameproduct = productTable.Rows[i]["Name"].ToString();
if (!string.IsNullOrEmpty(imageurls))
{
countproduct++;
string imagepath = string.Empty;
imagepath = Common.UploadImageProductStore(nameproduct, _domain, imageurls);
if (imagepath != "")
{
countproductimagesuccess++;
productTableAdapter.UpdateImagePath(imagepath, idProduct);
}
else
{
richTextBoxMessage.Text += idProduct.ToString() + "Upload fails\r\n";
}
}
else
{
richTextBoxMessage.Text += idProduct.ToString() + "Url null or Empty\r\n";
}
}
labelControlMessageImage.Text = string.Format("Upload ảnh {0} sản phẩm. Thành công {1}/{2}", count, countproductimagesuccess, countproduct);
}
Wait.Close();
}
private void LoadProductDatabaseButton_Click(object sender, EventArgs e)
{
Wait.Show("Load all product in database!");
try
{
DBWebPartnerTableAdapters.ProductTableAdapter productAdapter = new DBWebPartnerTableAdapters.ProductTableAdapter();
productAdapter.Connection.ConnectionString = Server.ConnectionString;
long idwss = Common.Obj2Int64(companyIdWSSSpinEdit.Text);
productAdapter.FillBy_CompanyId(dBWebPartner.Product, idwss);
}
catch (Exception)
{
//MessageBox.Show("Lỗi!");
}
Wait.Close();
}
