Ejemplo n.º 1
0
        public bool ThemTinNhanQC(TinNhanQC pTinNhanQC)
        {
            string query = "INSERT INTO dbo.TINNHAN_QUANGCAO " +
                           "(NOIDUNG, NGUOIGUI, NGAYGUI, NGUOINHAN) " +
                           "VALUES (@noidung,  @nguoigui, @ngaygui, @nguoinhan) ";
            SqlConnection conn = DBUtils.GetDBConnection();

            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.Add("@noidung", SqlDbType.Text).Value  = pTinNhanQC.NoiDung;
                cmd.Parameters.Add("@nguoigui", SqlDbType.Int).Value  = pTinNhanQC.NguoiGui;
                cmd.Parameters.Add("@ngaygui", SqlDbType.Date).Value  = pTinNhanQC.NgayGui;
                cmd.Parameters.Add("@nguoinhan", SqlDbType.Int).Value = pTinNhanQC.NguoiNhan;
                cmd.ExecuteNonQuery();
                conn.Close();

                return(true);
            }
            catch
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        private void btnGuiTin_Click(object sender, EventArgs e)
        {
            DateTime  curDate   = DateTime.Today;
            TinNhanQC tinnhanqc = new TinNhanQC(txtNoiDungTN.Text, Int32.Parse(txtMANV.Text), curDate.Date, Id);

            if (bus_nhantinqc.ThemTinNhanQC(tinnhanqc))
            {
                HienThiTinNhan();
            }
            else
            {
                MessageBox.Show("Đã xảy ra lỗi!");
            }
        }
Ejemplo n.º 3
0
 public bool ThemTinNhanQC(TinNhanQC pTinNhanQC)
 {
     return(dal_quanlyquangcao.ThemTinNhanQC(pTinNhanQC));
 }