private void SendMessage_DoWork(object sender, DoWorkEventArgs e) { try { int countSuccess = 0; List <TinNhanSMS> listSended = _listData.Where(a => a.Chon).ToList(); foreach (TinNhanSMS item in listSended) { TinNhanSMS itemTemp = item; if (Service_Common.FastTaxi.Try(client => client.SendSMS(GetFirstMobilePhone(itemTemp.SoDienThoai), txtNoiDung.Text))) { countSuccess++; ShowStatus(item.TenNhanVien, true); } else { ShowStatus(item.TenNhanVien, false); } Thread.Sleep(500); } new MessageBoxBA().Show("Tổng số tin nhắn gửi thành công: " + countSuccess + "/" + listSended.Count() + " tin nhắn.", "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Information); } catch (Exception ex) { LogError.WriteLogError("SendMessage_DoWork: ", ex); } }
private void btnImportByExcel_Click(object sender, EventArgs e) { try { OpenFileDialog dlgDialog = new OpenFileDialog(); dlgDialog.Filter = "All File |*.*;|File Excel |*.xlsx;|File Excel |*.xls;"; dlgDialog.FilterIndex = 1; dlgDialog.AddExtension = true; dlgDialog.RestoreDirectory = true; dlgDialog.InitialDirectory = Application.StartupPath + "\\Template"; if (dlgDialog.ShowDialog() == DialogResult.OK) { try { string sourcefile = dlgDialog.FileName; string excelquery = string.Format("Select * from [{0}$]", SHEETNAME); ExcelDataAccess.SourceFile = sourcefile; ExcelDataAccess.OpenConnectionExcel(); DataSet ds = ExcelDataAccess.GetDataSet(excelquery); TinNhanSMS temp; if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (row[0].ToString().Length > 3) { temp = new TinNhanSMS(); temp.SoDienThoai = row[0].ToString(); temp.TenNhanVien = row[1].ToString(); temp.ThongTinThem = row[2].ToString(); _listData.Add(temp); } } } ExcelDataAccess.CloseConnectionExcel(); gridMessage.DataSource = _listData; gridViewMessage.RefreshData(); } catch (Exception ex) { new MessageBoxBA().Show(ex.ToString()); } } } catch (Exception ex) { LogError.WriteLogError("btnImportByExcel_Click: ", ex); } }