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);
}
}
