private void Run()
{
DataTable dtfinal = new DataTable();
dtfinal = new DataTable();
dtfinal.Columns.Add("ID", typeof(string));
dtfinal.Columns.Add("Domain", typeof(string));
dtfinal.Columns.Add("Detail", typeof(string));
WSS.DownloadImageByHand.DBTableAdapters.CompanyTableAdapter companyAdapter = new DBTableAdapters.CompanyTableAdapter();
companyAdapter.Connection.ConnectionString = connectionString;
WSS.DownloadImageByHand.DB.CompanyDataTable companyTable = new DB.CompanyDataTable();
var fileStream = new FileStream(txtFolder.Text, FileMode.Open, FileAccess.Read);
int i = 0;
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8))
{
string line;
while ((line = streamReader.ReadLine()) != null)
{
this.Invoke(new Action(() =>
{
richTextBox1.AppendText(i + ". " + line + System.Environment.NewLine);
}));
i++;
companyTable.Clear();
long idcompany = QT.Entities.Common.GetIDCompany(line);
companyAdapter.FillBy_ID(companyTable, idcompany);
if (companyTable.Rows.Count == 0)
{
DataRow dr = dtfinal.NewRow();
dr["ID"] = idcompany;
dr["Domain"] = line;
dr["Detail"] = "Not in Database";
dtfinal.Rows.Add(dr);
}
else
{
int totalvalid = QT.Entities.Common.Obj2Int(companyTable.Rows[0]["TotalValid"].ToString());
if (totalvalid == 0)
{
DataRow dr = dtfinal.NewRow();
dr["ID"] = idcompany;
dr["Domain"] = line;
dr["Detail"] = "Total Valid = 0";
dtfinal.Rows.Add(dr);
}
}
}
this.Invoke(new Action(() =>
{
gridControl1.DataSource = dtfinal;
}));
}
}
private void Run()
{
DBTableAdapters.CompanyTableAdapter companyTableAdapter = new CompanyTableAdapter();
companyTableAdapter.Connection.ConnectionString = _connectionString;
DBTableAdapters.Company_AddressTableAdapter addressTableAdapter = new Company_AddressTableAdapter();
addressTableAdapter.Connection.ConnectionString = _connectionString;
DB.CompanyDataTable companyDataTable = new DB.CompanyDataTable();
DataTable addressDataTable = new DataTable();
DataTable dtCompany = new DataTable();
dtCompany.Columns.Add("ID", typeof(string));
dtCompany.Columns.Add("Domain", typeof(string));
dtCompany.Columns.Add("Address", typeof(string));
dtCompany.Columns.Add("ThanhPho", typeof(string));
dtCompany.Columns.Add("Phone", typeof(string));
var listDomain = memoEdit1.Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
int i = 0;
foreach (var item in listDomain)
{
i++;
this.Invoke(new Action(() =>
{
rbError.AppendText(String.Format("{0}. {1}", i, item) + System.Environment.NewLine);
}));
companyDataTable.Clear();
addressDataTable.Clear();
long idCompany = Common.GetIDCompany(item); try
{
companyTableAdapter.FillBy_ID(companyDataTable, idCompany);
}
catch (Exception exception)
{
this.Invoke(new Action(() =>
{
rbError.AppendText(String.Format("{0}. {1} Fill By ID error: {2}", i, item, exception) + System.Environment.NewLine);
}));
}
if (companyDataTable.Rows.Count > 0)
{
DataRow dataRow = dtCompany.NewRow();
dataRow["ID"] = idCompany;
dataRow["Domain"] = item;
dataRow["Address"] = companyDataTable.Rows[0]["Address"];
dataRow["Phone"] = companyDataTable.Rows[0]["Phone"];
//try
//{
// string querry = @"SELECT Distinct ThanhPho FROM Company_Address WHERE CompanyID =" + idCompany;
// SqlDb sqldb = new SqlDb(_connectionString);
// try
// {
// addressDataTable = sqldb.GetTblData(querry, CommandType.Text, null);
// }
// catch (Exception)
// {
// }
// string thanhpho = "";
// for (int j = 0; j < addressDataTable.Rows.Count; j++)
// {
// if (addressDataTable.Rows[j]["ThanhPho"] != DBNull.Value)
// {
// thanhpho += addressDataTable.Rows[j]["ThanhPho"].ToString()+" , ";
// }
// }
// dataRow["ThanhPho"] = thanhpho;
//}
//catch (Exception exception)
//{
// this.Invoke(new Action(() =>
// {
// rbError.AppendText(String.Format("{0}. {1} Get address error: {2}", i, item, exception));
// }));
//}
dtCompany.Rows.Add(dataRow);
}
else
{
this.Invoke(new Action(() =>
{
rbError.AppendText(String.Format("{0}. {1} Khong ton tai trong SQL", i, item) + System.Environment.NewLine);
}));
}
}
this.Invoke(new Action(() =>
{
gridControl1.DataSource = dtCompany;
}));
}
