private void btnlaythongtinchatluong_Click(object sender, EventArgs e)
{
Thread chay = new Thread(() =>
{
hamxoafile(@"C:\TempExcel");
#region // lay thông tin phát
ChromePerformanceLoggingPreferences perfLogPrefs = new ChromePerformanceLoggingPreferences();
perfLogPrefs.AddTracingCategories(new string[] { "devtools.timeline" });
ChromeOptions options = new ChromeOptions();
var downloadDirectory = @"C:\TempExcel";
options.AddUserProfilePreference("download.default_directory", downloadDirectory);
options.AddUserProfilePreference("download.prompt_for_download", false);
options.AddUserProfilePreference("disable-popup-blocking", "true");
options.AddArguments("--disable-notifications");
options.PerformanceLoggingPreferences = perfLogPrefs;
options.SetLoggingPreference(LogType.Driver, LogLevel.All);
options.SetLoggingPreference("performance", LogLevel.All);
options.AddAdditionalCapability(CapabilityType.EnableProfiling, true, true);
PropretiesCollection.driver = new ChromeDriver(options);
PropretiesCollection.driver.Navigate().GoToUrl("https://chatluong.vnpost.vn");
ChatLuong cl = new ChatLuong();
cl.XuLy(txttaikhoanchatluong.Text, txtpasschatluong.Text, txtngaychatluong.Text, txtngaychatluong.Text, 1);
//chạy xong tắt chome
PropretiesCollection.driver.Close();
#region //xử lý luôn file excel down về lưu vào csdl
string fileexcel = @"C:\TempExcel\" + "Chat Luong cong doan phat theo buu cuc phat.xlsx";
DuLieuExcel dExcel = new DuLieuExcel();
DataTable DuLieu = new DataTable();
dExcel.TenFile = fileexcel;
DuLieu = dExcel.Doc().Tables[0];
if (DuLieu.Rows.Count > 0)
{
}
hamxoafile(@"C:\TempExcel");
#endregion
#endregion
}
);
chay.Start();
}
private void btnimport_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.RestoreDirectory = true;
dlg.Filter = "Excel 2003|*.xls|Excel 2007|*.xlsx|All files (*.*)|*.*";
if (dlg.ShowDialog() == DialogResult.OK)
{
DuLieuExcel dExcel = new DuLieuExcel();
DataTable DuLieu = new DataTable();
DuLieu = Excel_To_DataTable(dlg.FileName, 0);
if (DuLieu.Rows.Count > 0)
{
foreach (DataRow r in DuLieu.Rows)
{
#region // truyền biến
string UID = r["UID"].ToString();
string USERNAME = r["USERNAME"].ToString();
string PASSWORD = r["PASSWORD"].ToString();
string SECRET = r["SECRET"].ToString();
string COOKIES = r["COOKIES"].ToString();
int DAY = 0;
try
{
DAY = int.Parse(r["DAY"].ToString());
}
catch { }
int MONTH = 0;
try
{
MONTH = int.Parse(r["MONTH"].ToString());
}
catch { }
int YEAR = 0;
try
{
YEAR = int.Parse(r["YEAR"].ToString());
}
catch { }
string FULLNAME = r["FULLNAME"].ToString();
string GENDER = r["GENDER"].ToString();
string AVATAR = r["AVATAR"].ToString();
string COVER = r["COVER"].ToString();
string HOME = r["HOME"].ToString();
string CITY = r["CITY"].ToString();
string BIO = r["BIO"].ToString();
string WORK = r["WORK"].ToString();
string UNIVERSITY = r["UNIVERSITY"].ToString();
string SCHOOL = r["SCHOOL"].ToString();
string FRIENDS = r["FRIENDS"].ToString();
string ISP = r["ISP"].ToString();
string TIME_REGISTER = r["TIME_REGISTER"].ToString();
string GMAIL_USERNAME = r["GMAIL_USERNAME"].ToString();
string GMAIL_PASSWORD = r["GMAIL_PASSWORD"].ToString();
string GMAIL_RECOVERY = r["GMAIL_RECOVERY"].ToString();
string GMAIL_TIME_REGISTER = r["GMAIL_TIME_REGISTER"].ToString();
int IDPhone = -1;
#endregion
daSqllite kt = new daSqllite();
DataSet ttkt = new DataSet();
ttkt = kt.KiemTraMail(USERNAME);
if (ttkt.Tables[0].Rows.Count > 0)
{
}
else
{
#region // thêm vào csdl
daSqllite them = new daSqllite();
them.Insert(UID, USERNAME, PASSWORD, SECRET, COOKIES, DAY,
MONTH, YEAR, FULLNAME, GENDER, AVATAR, COVER,
HOME, CITY, BIO, WORK, UNIVERSITY, SCHOOL, FRIENDS,
ISP, TIME_REGISTER, GMAIL_USERNAME,
GMAIL_PASSWORD, GMAIL_RECOVERY, GMAIL_TIME_REGISTER, IDPhone);
#endregion
}
}
#region // sau khi xong load lại dữ liệu
hienthi();
#endregion
}
}
}
