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();
}
