public async Task <IActionResult> Create(HoatDongCreateViewModel model) { ViewBag.ListNgonNgu = ListNgonNgu; ViewBag.ListHoatDong = ListHoatDong; if (!ModelState.IsValid) { return(View(model)); } var dbItem = new HoatDong(); dbItem.FkNgonNgu = model.NgonNguId; dbItem.FkLoaiHoatDong = model.TenLoaiId; dbItem.TieuDe = model.TieuDe; dbItem.GioiThieu = model.GioiThieu; dbItem.NoiDung = model.NoiDung; dbItem.HinhAnhMinhHoa = model.HinhAnh; dbItem.Author = model.TacGia; dbItem.NgayTao = DateTime.Now; dbItem.FkNguoiTao = "admin"; dbItem.NgaySua = DateTime.Now; dbItem.FkNguoiSua = "admin"; InitParam.Db.HoatDong.Add(dbItem); await InitParam.Db.SaveChangesAsync(); return(RedirectToAction(nameof(Edit), new { id = dbItem.Id })); }
public string Edit(HoatDong position) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "shd") { HoatDong p = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == position.IdHoatDong); //p.HinhAnh = position.HinhAnh; p.TenHoatDong = position.TenHoatDong; p.MoTaChinh = position.MoTaChinh; p.Diadiem = position.Diadiem; p.ThoiGianBD = position.ThoiGianBD; p.ThoiGianKT = position.ThoiGianKT; p.GioiHanNguoiThamGia = position.GioiHanNguoiThamGia; p.IdDonViToChuc = position.IdDonViToChuc; p.NoiDungChinhSua = position.NoiDungChinhSua; p.ThoiGiand = DateTime.Now; try { UpdateModel(p); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền cập nhật"); }
public string Delete(HoatDong position) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null) { HoatDong p = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == position.IdHoatDong); p.TrangThai = "dh"; p.XoaTam = true; try { UpdateModel(p); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền xóa"); }
public string Delete(ThongBao position) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null) { HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == position.IdHoatDong); hd.SLDaDangKi = hd.SLDaDangKi - 1; DangKiThamGiaHD p = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == position.IdDangKiHD); p.XoaTam = true; try { UpdateModel(hd); db.SubmitChanges(); UpdateModel(p); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền xóa"); }
public ActionResult XoaDangKy(int MaHoatDong) { //kiem tra sestion Phieu dang ky hoat dong ton tai hay chua if (Session["PhieuDangKyHoatDong"] == null) { return(RedirectToAction("DangKyChuongTrinh")); } //kiem tra hoat dong co ton tai trong csdl hay khong HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.MaHoatDong == MaHoatDong); if (hd == null) { Response.StatusCode = 404; return(null); } //lay list hoat dong tu sestion List <PhieuDangKyHoatDong> listPhieuDangKyHoatDong = LayPhieuDangKyHoatDong(); //kiem tra hoat dong co nam trong phieu dang ky hay khong PhieuDangKyHoatDong hdCheck = listPhieuDangKyHoatDong.SingleOrDefault(n => n.MaHoatDong == MaHoatDong); if (hdCheck == null) { return(RedirectToAction("DangKyChuongTrinh")); } //xoa hoat dong da dang ky listPhieuDangKyHoatDong.Remove(hdCheck); return(RedirectToAction("XemChuongTrinh")); }
public HttpResponseMessage KhoaMo(HttpRequestMessage request, int id) { HoatDong hoatDongSinger = null; try { _hoatDongService.KhoaMo(id); _hoatDongService.SaveChange(); hoatDongSinger = _hoatDongService.GetById(id); if (hoatDongSinger != null) { if (hoatDongSinger.TinhTrang != null && (bool)hoatDongSinger.TinhTrang) { Message = "Mở hoat dong thành công"; } else { Message = "Khóa hoat dong thành công"; } } else { throw new DbEntityValidationException("Khóa mở hoat dong không thành công"); } } catch (DbEntityValidationException ex) { LogException(ex); } return(GetResponseMessage(IsSuccess, Message, 1, hoatDongSinger)); }
public string Add(DangKiThamGiaHD position, HoatDong hd, int id = 0) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null) { hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id); hd.SLDaDangKi = hd.SLDaDangKi + 1; try { UpdateModel(hd); db.SubmitChanges(); position.IdHoatDong = id; position.XoaTam = false; position.TrangThai = false; db.DangKiThamGiaHDs.InsertOnSubmit(position); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền thêm"); }
//them phieu dang ky (load lai trang) public ActionResult ThemPhieuDangKy(int MaHoatDong, string strURL) { // kiem tra hoat dong co trong csdl hay khong HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.MaHoatDong == MaHoatDong); if (hd == null) { //trang duong dan khong hop le Response.StatusCode = 404; return(null); } //tao list phieu dang ky List <PhieuDangKyHoatDong> listPhieuDangKyHoatDong = LayPhieuDangKyHoatDong(); //neu hoat dong da ton tai trong phieu dang ky PhieuDangKyHoatDong hdCheck = listPhieuDangKyHoatDong.SingleOrDefault(n => n.MaHoatDong == MaHoatDong); if (hdCheck != null) { hdCheck.NgayDangKy = DateTime.Now; return(Redirect(strURL)); } PhieuDangKyHoatDong ItemPhieuDangKy = new PhieuDangKyHoatDong(MaHoatDong); listPhieuDangKyHoatDong.Add(ItemPhieuDangKy); return(Redirect(strURL)); }
public ActionResult ChinhSua(int id) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return(RedirectToAction("Index", "Login")); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "shd") { HoatDong sv = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id); ViewBag.IdDonViToChuc = new SelectList(db.DonViToChucs.ToList().OrderBy(n => n.IdDonViToChuc), "IdDonViToChuc", "TenDonVi", sv.IdDonViToChuc); if (sv == null) { Response.StatusCode = 404; return(null); } return(View(sv)); } } return(RedirectToAction("Index", "TrangChuQt")); } }
public ActionResult DeleteConfirmed(int id) { HoatDong hoatDong = db.HoatDongs.Find(id); db.HoatDongs.Remove(hoatDong); db.SaveChanges(); return(RedirectToAction("getlist")); }
public HoatDongDtoForTable(HoatDong hd) { Id = hd.Id; TenHoatDong = hd.TenHoatDong; NgayBatDau = hd.NgayBatDau; NgayKetThuc = hd.NgayKetThuc; DaKetThuc = hd.DaKetThuc; SoLuotThamGia = hd.SoLuotThamGia; }
public ActionResult Edit([Bind(Include = "HD_IDHoatDong,HD_ChuDe,HD_NoiDung,HD_NgayHoatDong,HD_NgayKetThuc")] HoatDong hoatDong) { if (ModelState.IsValid) { db.Entry(hoatDong).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("getlist")); } return(View(hoatDong)); }
public ActionResult Edit([Bind(Include = "mahd,madv,tenhd,thoigiantc,ghichu")] HoatDong hoatDong) { if (ModelState.IsValid) { db.Entry(hoatDong).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hoatDong)); }
public ActionResult Create([Bind(Include = "mahd,madv,tenhd,thoigiantc,ghichu")] HoatDong hoatDong) { if (ModelState.IsValid) { db.HoatDongs.Add(hoatDong); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hoatDong)); }
public HoatDongDtoForSearch(HoatDong hd) { Id = hd.Id; TenHoatDong = hd.TenHoatDong; NgayBatDau = hd.NgayBatDau; NgayKetThuc = hd.NgayKetThuc; DaKetThuc = hd.DaKetThuc; DiaDiem = hd.DiaDiem; BiHuy = hd.BiHuy; AnhBia = hd.AnhBia; }
public ActionResult Create([Bind(Include = "HD_IDHoatDong,HD_ChuDe,HD_NoiDung,HD_NgayHoatDong,HD_NgayKetThuc")] HoatDong hoatDong) { if (ModelState.IsValid) { db.HoatDongs.Add(hoatDong); db.SaveChanges(); return(RedirectToAction("getlist")); } return(View(hoatDong)); }
// Cập nhật gửi/trả xe public void CapNhatGuiTraXe(string maSo, HoatDong hoatDong) { Connect(); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); string sql = "UPDATE [DBBaiDoXe].[dbo].[TBUsers] SET DangGui= '" + (hoatDong == HoatDong.Vao ? "1" : "0") + "' WHERE MaSo=N'" + maSo + "';"; command = new SqlCommand(sql, sqlConnection); adapter.InsertCommand = new SqlCommand(sql, sqlConnection); adapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); sqlConnection.Close(); }
// GET: HoatDong/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HoatDong hoatDong = db.HoatDongs.Find(id); if (hoatDong == null) { return(HttpNotFound()); } return(View(hoatDong)); }
public string Add(HoatDong position) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "thd") { try { if (position.ThoiGianBD < DateTime.Now || position.ThoiGianKT < DateTime.Now) { return("Ngày tháng không hợp lệ"); } position.ThoiGianT = DateTime.Now; position.SLDaDangKi = 0; position.TrangThai = "cd"; position.IdInfo = nd.IdInfo; position.XoaTam = false; db.HoatDongs.InsertOnSubmit(position); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } else if (nd != null && a.Quyen.MoTa == "thd" && nd.ChucVu.MoTa == "K") { try { position.ThoiGianT = DateTime.Now; position.SLDaDangKi = 0; position.TrangThai = "dd"; position.IdInfo = nd.IdInfo; position.XoaTam = false; db.HoatDongs.InsertOnSubmit(position); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền thêm"); }
public ActionResult ChinhSua(HoatDong sv, HttpPostedFileBase fileUpload) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return(RedirectToAction("Index", "Login")); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; if (fileUpload == null && nd != null) { HoatDong d = db.HoatDongs.SingleOrDefault(n => (n.IdHoatDong == sv.IdHoatDong) && (n.IdInfo == nd.IdInfo)); d.TenHoatDong = sv.TenHoatDong; d.MoTaChinh = sv.MoTaChinh; d.ThoiGianBD = sv.ThoiGianBD; d.ThoiGianKT = sv.ThoiGianKT; d.GioiHanNguoiThamGia = sv.GioiHanNguoiThamGia; d.Diadiem = sv.Diadiem; UpdateModel(d); db.SubmitChanges(); return(RedirectToAction("Index", "HDChoChinhSuaBCS")); } else if (fileUpload != null && nd != null) { HoatDong d = db.HoatDongs.SingleOrDefault(n => (n.IdHoatDong == sv.IdHoatDong) && (n.IdInfo == nd.IdInfo)); var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/images"), fileName); ViewBag.chucvu = nd.ChucVu.MoTa; if (System.IO.File.Exists(path)) { ViewBag.ThongBao = "Hình ảnh đã tồn tại"; } else { fileUpload.SaveAs(path); } d.HinhAnh = fileName; UpdateModel(d); db.SubmitChanges(); return(RedirectToAction("Index", "HDChoChinhSuaBCS")); } return(RedirectToAction("Index", "TrangChu")); } }
public ActionResult Index(HoatDong ds, HttpPostedFileBase fileUpload) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return(RedirectToAction("Index", "Login")); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "thd") { string message = ""; var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/images/"), fileName); if (System.IO.File.Exists(path)) { ViewBag.ThongBao = "Hình ảnh đã tồn tại"; } else { fileUpload.SaveAs(path); } if (ds.ThoiGianBD < DateTime.Now || ds.ThoiGianKT < DateTime.Now || ds.ThoiGianBD > ds.ThoiGianKT) { ViewBag.message = "Ngày tháng không hợp lệ"; return(View()); } ds.HinhAnh = fileName; ds.XoaTam = false; ds.TrangThai = "cd"; ds.IdInfo = nd.IdInfo; ds.SLDaDangKi = 0; ds.ThoiGianT = DateTime.Now; ds.IdDonViToChuc = 3; db.HoatDongs.InsertOnSubmit(ds); db.SubmitChanges(); } } return(RedirectToAction("Index", "HDDaTaoBCS")); } }
public string Add(HoatDong hd) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return("Bạn phải đăng nhập"); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null) { //int id = Convert.ToInt32(Request.Form["idlop"]); hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == hd.IdHoatDong); hd.SLDaDangKi = hd.SLDaDangKi + 1; DangKiThamGiaHD dk = new DangKiThamGiaHD(); try { UpdateModel(hd); db.SubmitChanges(); dk.IdHoatDong = hd.IdHoatDong; dk.IdInfo = nd.IdInfo; dk.TrangThai = false; dk.XoaTam = false; db.DangKiThamGiaHDs.InsertOnSubmit(dk); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } } return("Lỗi đăng ký"); }
public string Delete(NguoiDung position, HoatDong hd, DangKiThamGiaHD dk) { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList(); foreach (var a in re) { if (nd != null && a.Quyen.MoTa == "xsvthd") { NguoiDung p = db.NguoiDungs.SingleOrDefault(n => n.IdInfo == position.IdInfo); p.XoaTam = true; try { List <DangKiThamGiaHD> lstdk = db.DangKiThamGiaHDs.OrderBy(n => n.IdDangKiHD).Where(n => n.IdInfo == position.IdInfo).ToList(); foreach (var a1 in lstdk) { List <HoatDong> lsthd = db.HoatDongs.OrderBy(n => n.IdHoatDong).Where(n => n.IdHoatDong == a1.IdHoatDong).ToList(); foreach (var a2 in lsthd) { a2.SLDaDangKi = a2.SLDaDangKi - 1; UpdateModel(a2); db.SubmitChanges(); } a1.XoaTam = true; UpdateModel(a1); db.SubmitChanges(); } UpdateModel(p); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } return("ok"); } } return("Bạn không có quyền xóa"); }
public HttpResponseMessage UploadImage(HttpRequestMessage request) { HoatDong modelHoatDong = null; try { var httpRequest = HttpContext.Current.Request; //Upload Image var postedFile = httpRequest.Files["ImageShow"]; var id = httpRequest["Id"]; var hoatDong = _hoatDongService.GetById(int.Parse(id)); //Create custom filename if (postedFile != null) { var imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()) .Replace(" ", "-"); imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); hoatDong.ImageShow = imageName; _hoatDongService.Update(hoatDong); _hoatDongService.SaveChange(); modelHoatDong = _hoatDongService.GetById(hoatDong.IdHoatDong); } if (modelHoatDong != null) { Message = "Upload ảnh thành công thành công"; } else { throw new DbEntityValidationException("Upload ảnh không thành công"); } } catch (DbEntityValidationException ex) { LogException(ex); } return(GetResponseMessage(IsSuccess, Message, 1, modelHoatDong)); }
public HttpResponseMessage GetById(HttpRequestMessage request, int id) { HoatDong hoatDongSinger = null; try { hoatDongSinger = _hoatDongService.GetById(id); if (hoatDongSinger != null) { Message = "Thông tin hoat dong với id: " + id; } else { throw new DbEntityValidationException(string.Format("Không tìm kiếm được hoat dong với id {0}", id)); } } catch (DbEntityValidationException ex) { LogException(ex); } return(GetResponseMessage(IsSuccess, Message, 1, hoatDongSinger)); }
public ActionResult ChinhSua(int id) { if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "") { return(RedirectToAction("Index", "Login")); } else { NguoiDung nd = (NguoiDung)Session["Taikhoan"]; if (nd != null) { HoatDong sv = db.HoatDongs.SingleOrDefault(n => (n.IdHoatDong == id) && (n.IdInfo == nd.IdInfo)); if (sv == null) { Response.StatusCode = 404; return(null); } return(View(sv)); } return(RedirectToAction("Index", "TrangChu")); } }
public HttpResponseMessage Delete(HttpRequestMessage request, int id) { HoatDong hoatDongSinger = null; try { hoatDongSinger = _hoatDongService.Delete(id); _hoatDongService.SaveChange(); if (hoatDongSinger != null) { Message = "Xóa hoat dong thành công"; } else { throw new DbEntityValidationException("Xóa hoat dong không thành công"); } } catch (DbEntityValidationException ex) { LogException(ex); } return(GetResponseMessage(IsSuccess, Message, 1, hoatDongSinger)); }
public void CapNhatHoatDong(string maSo, HoatDong hoatDong, bool thanhCong, string thoiGian, string noiDung, string maTheNap, string soTienNap) { int iHoatDong = -1; // -1: Mặc định/Lỗi. Không làm gì | 0: Nạp thẻ | 1: Vào | 2: Ra switch (hoatDong) { case HoatDong.NapThe: iHoatDong = 0; break; case HoatDong.Vao: iHoatDong = 1; break; case HoatDong.Ra: iHoatDong = 2; break; default: break; } Insert(TableName.Activities, Table.Activities, new[] { maSo, iHoatDong.ToString(), thanhCong ? "1" : "0", thoiGian, noiDung, maTheNap, soTienNap }); }
public async Task <IActionResult> Create([Bind("Id,TieuDe,GioiThieu,HinhAnhMinhHoa,FkNgonNgu,FkLoaiHoatDong,NoiDung,Stt,LuotXem,FkNguoiTao,NgayTao,Author,FkNguoiSua,NgaySua")] HoatDong hoatDong) { if (ModelState.IsValid) { #region Get list master var listNgonNgu = await GetListNgonNguAsync(); ViewBag.ListNgonNgu = listNgonNgu; #endregion var listLoaiHoatDong = await GetListLoaiHoatDongAsync(); ViewBag.ListLoaiHoatDong = listLoaiHoatDong; InitParam.Db.Add(hoatDong); await InitParam.Db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FkLoaiHoatDong"] = new SelectList(InitParam.Db.LoaiHoatDong, "Id", "Id", hoatDong.FkLoaiHoatDong); ViewData["FkNgonNgu"] = new SelectList(InitParam.Db.NgonNgu, "Id", "Id", hoatDong.FkNgonNgu); ViewData["FkNguoiSua"] = new SelectList(InitParam.Db.User, "UserName", "UserName", hoatDong.FkNguoiSua); ViewData["FkNguoiTao"] = new SelectList(InitParam.Db.User, "UserName", "UserName", hoatDong.FkNguoiTao); return(View(hoatDong)); }
// Cập nhật số dư khả dụng public void CapNhatSoDuKhaDung(HoatDong hoatDong, string maSo, string strSoTien) { int soDuKhaDung = KiemTraSoDuKhaDung(maSo); //Đặt con trỏ chuột vào tên hàm (chữ "KiemTraSoDuKhaDung"), nhấn F12 để xem chi tiết. int soTien = Convert.ToInt32(strSoTien); //Số tiền: Đơn giá (Hoạt động = Vào hoặc Ra) || Mệnh giá thẻ nạp (Hoạt động = Nạp thẻ). int soNgayGui = TinhToanSoNgayGui(maSo); switch (hoatDong) { case HoatDong.NapThe: soDuKhaDung += soTien; //Nạp thẻ thì đương nhiên cộng tiền. break; case HoatDong.Vao: soDuKhaDung -= soTien; //Cứ VÀO là mất tiền. break; case HoatDong.Ra: if (soNgayGui > 1) //Kiểm tra nếu số ngày gửi không >1 thì sẽ không trừ tiền nữa, vì đã trừ lúc VÀO rồi. { soDuKhaDung -= soTien * (soNgayGui - 1); //Trừ số tiền lúc VÀO đã thanh toán. } break; default: break; } Connect(); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); string sql = "UPDATE [DBBaiDoXe].[dbo].[TBUsers] SET SoDuKhaDung= '" + soDuKhaDung + "' WHERE MaSo=N'" + maSo + "';"; command = new SqlCommand(sql, sqlConnection); adapter.InsertCommand = new SqlCommand(sql, sqlConnection); adapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); sqlConnection.Close(); }
public void Add(HoatDong hoatdong) { db.HoatDongs.InsertOnSubmit(hoatdong); db.SubmitChanges(); }
public void Delete(HoatDong hoatdong) { db.HoatDongs.DeleteOnSubmit(hoatdong); db.SubmitChanges(); }