public void sendSMS()
{
XuLyChuoi.LoaiBoDau boDau = new XuLyChuoi.LoaiBoDau();
XuLyChuoi.checkKyTu checkKyTu = new XuLyChuoi.checkKyTu();
logical.APIeSMS eSMS = new logical.APIeSMS();
string chuoiTin = frmbirth.tb_LoiNhan.Text;
string chuoira = "";
int sotinDaGui = 0;
foreach (DataGridViewRow r in frmbirth.dgv_List.Rows)
{
string sqlquery = "SELECT [IDThanhVien] as ID,[HoThanhVien] + ' ' + [TenThanhVien] as HoTen,[NgaySinh], [MSSV],Khoa,Lop,NgaySinh,SDT FROM [ThanhVien] where DAY(NgaySinh) = DAY(getdate()) and MONTH(NgaySinh) = month(GETDATE()) and IDThanhVien =" + r.Cells[0].Value.ToString();;
DataTable dt = sql.listLoad(sqlquery);
chuoiTin = checkKyTu.DetectChar(chuoiTin, dt.Rows[0]["IDThanhVien"].ToString());
chuoira = boDau.ConvertToUnsign(chuoiTin);
if (eSMS.SendSMS(dt.Rows[0]["SDT"].ToString(), chuoira))
{
string sqlqueryLuu = "insert into ChucSinhNhat(IDNguoiNhan,NoiDungChuc,ThoiGianGui,NguoiGui) values(" + r.Cells[0].Value.ToString() + ",N'" + chuoiTin + "',getdate()," + caseData.DataTam.DuLieu.ID + ")";
if (sql.themTinNhan(sqlqueryLuu) > 0)
{
sotinDaGui++;
}
}
}
MessageBox.Show("Đã gửi: " + sotinDaGui + " tin nhắn chúc sinh nhật");
}
public void createaccount()
{
string sqlquery = "select ThanhVien.IDThanhVien,HoThanhVien,TenThanhVien,MSSV,TenChucVu as ChucVu,NgaySinh from ThanhVien,ChucVu,TaiKhoan where RoiCLB is null and ThanhVien.IDThanhVien != TaiKhoan.IDThanhVien and ThanhVien.IDChucVu = ChucVu.IDChucVu and ThanhVien.IDThanhVien = 394";
DataTable dt = dalcreateaccount.getDataBase(sqlquery);
XuLyChuoi.LoaiBoDau boDau = new XuLyChuoi.LoaiBoDau();
SECURITY.BamChuoi bc = new SECURITY.BamChuoi();
SECURITY.RandomClass rd = new SECURITY.RandomClass();
string userName = (dt.Rows[0]["TenThanhVien"].ToString() +
layKyTuCuaHo(dt.Rows[0]["HoThanhVien"].ToString()) +
dt.Rows[0]["MSSV"].ToString().Substring(dt.Rows[0]["MSSV"].ToString().Length - 4, 4));
userName = boDau.ConvertToUnsign(userName).ToLower();
MessageBox.Show(userName);
userName = bc.maHoaKyTu(userName);
string randomstr = rd.RandomText(10);
string pass = dt.Rows[0]["MSSV"].ToString();
MessageBox.Show(pass);
pass = bc.maHoaKyTu(pass + randomstr);
sqlquery = "insert into TaiKhoan(IDThanhVien,UserName,PassWD,RandomString,DangNhap,KhoaTaiKhoan) values(394,N'" + userName + "',N'" + pass + "',N'" + randomstr
+ "',0,0)";
dalcreateaccount.createaccount(sqlquery);
}
public void sendThongBao()
{
if (checkData())
{
string noiDung = "Xin chào bạn: <HoTen>, MSSV: <MSSV>. BCN CLB Tinh nguyen Sinh vien Duy Tan THÔNG BÁO: " + frmThongBao.tb_TieuDe.Text
+ " Nội dung: " + frmThongBao.tb_NoiDung.Text;
XuLyChuoi.LoaiBoDau lbd = new XuLyChuoi.LoaiBoDau();
XuLyChuoi.checkKyTu chkKT = new XuLyChuoi.checkKyTu();
logical.APIeSMS eSMS = new logical.APIeSMS();
string sqlquery = "SELECT [IDThanhVien] as ID,[HoThanhVien] + ' ' + [TenThanhVien] as HoTen,[NgaySinh],SDT FROM [ThanhVien]";
DataTable dt = daltt.getTable(sqlquery);
for (int i = 0; i < dt.Rows.Count; i++)
{
noiDung = chkKT.DetectChar(noiDung, dt.Rows[i]["IDThanhVien"].ToString());
string bodau = lbd.ConvertToUnsign(noiDung);
eSMS.SendSMS(dt.Rows[i]["SDT"].ToString(), bodau);
}
}
}
public void sendSMS()
{
if (checkData())
{
string noiDung = "Xin chào bạn: <HoTen>, MSSV: <MSSV>. BCN CLB Tinh nguyen Sinh vien Duy Tan THÔNG BÁO: " + frmaddMeeting.tb_TieuDe.Text
+ " Nội dung: " + frmaddMeeting.tb_NoiDung.Text + " Thời gian: " + frmaddMeeting.dtp_NgayHop.Text
+ " - " + frmaddMeeting.dtp_GioHop.Text + ". Địa điểm: " + frmaddMeeting.tb_DiaChiCuThe.Text + " - " + frmaddMeeting.cbb_TenXa.Text
+ " - " + frmaddMeeting.cbb_TenHuyen.Text + " - " + frmaddMeeting.cbb_TenTinh.Text;
XuLyChuoi.LoaiBoDau lbd = new XuLyChuoi.LoaiBoDau();
XuLyChuoi.checkKyTu chkKT = new XuLyChuoi.checkKyTu();
logical.APIeSMS eSMS = new logical.APIeSMS();
string sqlquery = "SELECT [IDThanhVien] as ID,[HoThanhVien] + ' ' + [TenThanhVien] as HoTen,[NgaySinh], [MSSV],Khoa,Lop,NgaySinh,SDT FROM [ThanhVien]";
DataTable dt = daladdmeeting.getTable(sqlquery);
for (int i = 0; i < dt.Rows.Count; i++)
{
noiDung = chkKT.DetectChar(noiDung, dt.Rows[i]["IDThanhVien"].ToString());
string bodau = lbd.ConvertToUnsign(noiDung);
eSMS.SendSMS(dt.Rows[i]["SDT"].ToString(), bodau);
}
}
}
