private void tb_Gui_Click(object sender, EventArgs e) { attach = null; try { FileInfo file = new FileInfo(tb_DinhKem.Text); attach = new Attachment(tb_DinhKem.Text); } catch { } //DataTable data = KhachHangBUS.Instance.HienThi(); if (hdflat == 0) { foreach (DataRow item in data.Rows) { tb_NguoiNhan.Text = item["Gmail"].ToString(); int MaKH = int.Parse(item["MaKH"].ToString()); GuiMail(tb_TenDangNhap.Text, tb_NguoiNhan.Text, tb_ChuDe.Text, tb_NoiDung.Text, attach); TinNhan tn = TinNhanBUS.Instance.DocThongTin(MaTN); tn.NoiDung = tb_NoiDung.Text; tn.ChuDe = tb_ChuDe.Text; TinNhanBUS.Instance.Sua(tn); TinNhan_KhachHang tnkh = new TinNhan_KhachHang(MaTN, MaKH); TinNhan_KhachHangBUS.Instance.Them(tnkh); } } else { GuiMail(tb_TenDangNhap.Text, tb_NguoiNhan.Text, tb_ChuDe.Text, tb_NoiDung.Text, attach); hdflat = 0; } MessageBox.Show("Đã gửi xong."); this.Hide(); }
public bool Them(TinNhan_KhachHang tnkh) { string query = "Insert INTO TinNhan_KhachHang(MaTN, MaKH) VALUES ( @MaTN , @MaKH ) "; object[] para = new object[] { tnkh.MaTN, tnkh.MaKH }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }
public bool Them(TinNhan_KhachHang tnkh) { return(TinNhan_KhachHangDAC.Instance.Them(tnkh)); }