예제 #1
0
        public async Task <int> ThemMoiHocSinh(HocSinh hocSinh)
        {
            using (Data.Connection())
            {
                var    insertId = 0;
                string Query    = "INSERT INTO HocSinh VALUES (@Ten,@Tuoi,@ngaySinh,@maSoSinhVien,@lopId,@khoaId)";
                var    pa       = new DynamicParameters();
                pa.Add("@Ten", hocSinh.Ten);
                pa.Add("@Tuoi", hocSinh.Tuoi);
                pa.Add("@ngaySinh", hocSinh.ngaySinh);
                pa.Add("@maSoSinhVien", hocSinh.maSinhVien);
                pa.Add("@lopId", hocSinh.lopId);
                pa.Add("@khoaId", hocSinh.khoaId);
                CommandType c = CommandType.Text;
                insertId = await Data.Connection().ExecuteAsync(Query, pa, null, null, c);

                return(insertId);
            }
        }
예제 #2
0
        public async Task <int> SuaHocSinh(HocSinh hocSinh)
        {
            using (Data.Connection())
            {
                var    updateId = 0;
                string Query    = "UPDATE HocSinh SET Ten = @Ten, Tuoi = @Tuoi, ngaySinh = @ngaySinh, maSinhVien = @maSoSinhVien, lopId = @lopId, khoaId = @khoaId";
                var    pa       = new DynamicParameters();
                pa.Add("@Ten", hocSinh.Ten);
                pa.Add("@Tuoi", hocSinh.Tuoi);
                pa.Add("@ngaySinh", DateTime.Now);
                pa.Add("@maSoSinhVien", hocSinh.maSinhVien);
                pa.Add("@lopId", hocSinh.lopId);
                pa.Add("@khoaId", hocSinh.khoaId);
                CommandType c = CommandType.Text;
                updateId = await Data.Connection().ExecuteAsync(Query, pa, null, null, c);

                return(updateId);
            }
        }