private void UpdateImagePathCompany(long companyId)
{
if (companyId == 0)
{
this.Invoke(new Action(() =>
{
richTextBox1.AppendText("Complete!");
this.Text = "Complete!";
}));
return;
}
this.Invoke(new Action(() =>
{
richTextBox1.AppendText("CompanyID: " + companyId + ": Start get Product in SQL!\r\n");
}));
WSS.ReDownloadImage.DBTableAdapters.ProductTableAdapter productAdapter = new WSS.ReDownloadImage.DBTableAdapters.ProductTableAdapter();
productAdapter.Connection.ConnectionString = ServerConnection.ConnectionString;
WSS.ReDownloadImage.DB.ProductDataTable productTable = new WSS.ReDownloadImage.DB.ProductDataTable();
WSS.ReDownloadImage.DBTableAdapters.DownloadImageTempTableAdapter tempAdapter = new DBTableAdapters.DownloadImageTempTableAdapter();
tempAdapter.Connection.ConnectionString = ServerConnection.ConnectionString;
int demgetproduct = 0;
while (!istopgetdata)
{
try
{
productAdapter.FillBy_CompanyDownloaded(productTable, companyId);
break;
}
catch (Exception ex)
{
demgetproduct++;
if (demgetproduct == 1)
{
Log.Error(string.Format("CompanyID = {0} Get Product of Company in SQL Error 1", companyId), ex);
}
else if (demgetproduct == 5)
{
Log.Error(string.Format("CompanyID = {0} Get Product of Company in SQL Error {1}", companyId, 5), ex);
break;
}
Thread.Sleep(10000);
}
}
try
{
if (productTable.Rows.Count > 0)
{
this.Invoke(new Action(() =>
{
richTextBox1.AppendText("CompanyID: " + companyId + ": Get " + productTable.Rows.Count + " Product in SQL!\r\n");
}));
String path = ServerConnection.FolderImage;
int countsuccess = 0;
for (int i = 0; i < productTable.Rows.Count; i++)
{
long productId = Common.Obj2Int64(productTable.Rows[i]["ID"].ToString());
string url = productTable.Rows[i]["DetailUrl"].ToString();
if (string.IsNullOrEmpty(url))
{
continue;
}
Uri root = new Uri(url);
string domain = root.DnsSafeHost.Replace("www.", "");
string char1 = domain.Substring(0, 1);
String namepath = domain.Substring(0, 1) + "\\" + root.DnsSafeHost.Replace("www.", "").Replace('.', '_');
string direct = namepath + "\\";
string filename = Common.UnicodeToKoDauAndGach(productTable.Rows[i]["Name"].ToString());
string tempf = filename.Replace("-", "");
if (tempf.Length < 3)
{
continue;
}
string folder = tempf.Substring(0, 3);
if (folder == "bin")
{
folder = "bin1";
}
if (folder == "con")
{
folder = "con1";
}
direct += folder + "\\";
if (filename.Length > 100)
{
filename = filename.Substring(0, 99);
}
filename += "_" + productId;
String fullfile = path + direct + filename + ".jpg";
string imageurl = string.Empty;
imageurl = productTable.Rows[i]["ImageUrls"].ToString();
if (string.IsNullOrEmpty(imageurl))
{
Log.Error(string.Format("CompanyID = {0} ProductID = {1} ImageUrl is null or empty.", companyId, productId));
continue;
}
string pathsave = direct + filename.Replace('\\', '/') + ".jpg";
pathsave = "Store/" + pathsave.Replace('\\', '/');
int demupdate = 0;
while (!istopupdate)
{
try
{
//productAdapter.UpdateQuery(pathsave, 0, 0, productId);
tempAdapter.UpdateImagePathTemp(pathsave, productId);
countsuccess++;
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("{0}.Update Image Path {1}!\r\n", i + 1, productId));
}));
break;
}
catch (Exception)
{
demupdate++;
if (demupdate == 5)
{
break;
}
Thread.Sleep(10000);
}
}
}
Log.InfoFormat("CompanyID = {0} Download Image Success {1}/{2}", companyId, countsuccess, productTable.Rows.Count);
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0} Download Image Success {1}/{2}-----------------------------\n", companyId, countsuccess, productTable.Rows.Count));
}));
}
else
{
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0} 0 product!-----------------------------\r\n", companyId));
}));
}
}
catch (Exception ex)
{
Log.Error(string.Format("CompanyID = {0} ERROR~~~", companyId), ex);
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0} ERROR:\n{1}", companyId, ex));
}));
}
}
private void ReDownloadImageCompany(long companyId)
{
if (companyId == 0)
{
this.Invoke(new Action(() =>
{
richTextBox1.AppendText("Complete!");
this.Text = "Complete!";
}));
return;
}
this.Invoke(new Action(() =>
{
richTextBox1.AppendText("CompanyID: " + companyId + ": Start get Product in SQL!\r\n");
}));
WSS.ReDownloadImage.DBTableAdapters.ProductTableAdapter productAdapter = new WSS.ReDownloadImage.DBTableAdapters.ProductTableAdapter();
productAdapter.Connection.ConnectionString = ServerConnection.ConnectionString;
WSS.ReDownloadImage.DB.ProductDataTable productTable = new WSS.ReDownloadImage.DB.ProductDataTable();
DBTableAdapters.DownloadImageTempTableAdapter logAdapter = new DBTableAdapters.DownloadImageTempTableAdapter();
logAdapter.Connection.ConnectionString = ServerConnection.ConnectionString;
int demgetproduct = 0;
while (!istopgetdata)
{
try
{
productAdapter.FillBy_Company(productTable, companyId);
break;
}
catch (Exception ex)
{
demgetproduct++;
if (demgetproduct == 1)
{
Log.Error(string.Format("CompanyID = {0} Get Product of Company in SQL Error 1", companyId), ex);
}
else if (demgetproduct == 5)
{
Log.Error(string.Format("CompanyID = {0} Get Product of Company in SQL Error {1}", companyId, 5), ex);
break;
}
Thread.Sleep(60000);
}
}
try
{
if (productTable.Rows.Count > 0)
{
String path = ServerConnection.FolderImage;
int countsuccess = 0;
for (int i = 0; i < productTable.Rows.Count; i++)
{
long productId = Common.Obj2Int64(productTable.Rows[i]["ID"].ToString());
string url = productTable.Rows[i]["DetailUrl"].ToString();
if (string.IsNullOrEmpty(url))
{
continue;
}
Uri root = new Uri(url);
string domain = root.DnsSafeHost.Replace("www.", "");
string char1 = domain.Substring(0, 1);
String namepath = domain.Substring(0, 1) + "\\" + root.DnsSafeHost.Replace("www.", "").Replace('.', '_');
string ss = namepath + "\\";
string filename = Common.UnicodeToKoDauAndGach(productTable.Rows[i]["Name"].ToString());
string tempf = filename.Replace("-", "");
if (tempf.Length < 3)
{
continue;
}
string folder = tempf.Substring(0, 3);
if (folder == "bin")
{
folder = "bin1";
}
if (folder == "con")
{
folder = "con1";
}
ss += folder + "\\";
if (filename.Length > 100)
{
filename = filename.Substring(0, 99);
}
filename += "_" + productId;
String fullfile = path + ss + filename + ".jpg";
string imageurl = string.Empty;
imageurl = productTable.Rows[i]["ImageUrls"].ToString();
if (string.IsNullOrEmpty(imageurl))
{
Log.Error(string.Format("CompanyID = {0} ProductID = {1} ImageUrl is null or empty.", companyId, productId));
continue;
}
bool fileSaved = Common.SaveFileDownloadImage(imageurl, path + ss, filename + ".jpg", productId, companyId);
if (fileSaved)
{
#region Log download
int dem = 0;
while (!istoplog)
{
try
{
logAdapter.Insert(productId, companyId, true, DateTime.Now, "");
break;
}
catch (Exception ex)
{
Log.Error(string.Format("Write log product {0} / company {1} error", productId, companyId), ex);
if (dem == 5)
{
break;
}
else
{
dem++;
}
Thread.Sleep(10000);
}
}
#endregion
countsuccess++;
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("{0}.Download Image Product {1} success!\r\n", i + 1, productId));
}));
}
else
{
#region Log download
int dem = 0;
while (!istoplog)
{
try
{
logAdapter.Insert(productId, companyId, false, DateTime.Now, "");
break;
}
catch (Exception ex)
{
Log.Error(string.Format("Write log product {0} / company {1} error", productId, companyId), ex);
if (dem == 5)
{
break;
}
else
{
dem++;
}
Thread.Sleep(10000);
}
}
#endregion
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("{0}.Download Image Product {1} fails!\r\n", i + 1, productId));
}));
}
}
Log.InfoFormat("CompanyID = {0} Download Image Success {1}/{2}", companyId, countsuccess, productTable.Rows.Count);
WriteLogCompanyImage(companyId, countsuccess, productTable.Rows.Count);
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0}. Download Image Product success {1}/{2}", companyId, countsuccess, productTable.Rows.Count));
}));
}
else
{
Log.InfoFormat("CompanyID = {0} 0 product", companyId);
WriteLogCompanyImage(companyId, 0, 0);
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0} 0 product", companyId));
}));
}
}
catch (Exception ex)
{
Log.Error(string.Format("CompanyID = {0} ERROR~~~", companyId), ex);
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(string.Format("CompanyID = {0} ERROR:\n{1}", companyId, ex));
}));
}
}