public ActionResult Edit([Bind(Include = "ID_BenhNhan,HoTen,GioiTinh,NamSinh,DiaChi,Deleted")] HoSoBenhNhan hoSoBenhNhan) { if (ModelState.IsValid) { db.Entry(hoSoBenhNhan).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } List <SelectListItem> Gender = new List <SelectListItem>() { new SelectListItem { Value = "true", Text = "Nam" }, new SelectListItem { Value = "false", Text = "Nữ" } }; ViewBag.GioiTinh = new SelectList(Gender, "Value", "Text"); return(View(hoSoBenhNhan)); }
public ActionResult Edit([Bind(Include = "ID_User,Username,Password,Roles")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "ID_CachDung,TenCachDung,Deleted")] CachDung cachDung) { if (ModelState.IsValid) { db.Entry(cachDung).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cachDung)); }
public ActionResult Edit([Bind(Include = "ID,TypeName")] UserType userType) { if (ModelState.IsValid) { db.Entry(userType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userType)); }
public ActionResult Edit([Bind(Include = "ID_BenhNhan,HoTen,GioiTinh,NamSinh,DiaChi,NgayKham")] HoSoBenhNhan hoSoBenhNhan) { if (ModelState.IsValid) { db.Entry(hoSoBenhNhan).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("DanhSachKhamBenh", "HoSoBenhNhan")); } return(View(hoSoBenhNhan)); }
public ActionResult Edit([Bind(Include = "ID_DonVi,TenDonVi,Deleted")] DonVi donVi) { if (ModelState.IsValid) { db.Entry(donVi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(donVi)); }
public ActionResult Edit([Bind(Include = "ID_ThamSo,GiaTri,GhiChu")] ThamSo thamSo) { if (ModelState.IsValid) { db.Entry(thamSo).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(thamSo)); }
public ActionResult Edit([Bind(Include = "ID_Benh,TenBenh")] Benh benh) { if (ModelState.IsValid) { db.Entry(benh).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(benh)); }
public ActionResult Edit([Bind(Include = "ID_Thuoc,ID_DonVi,TenThuoc,SoLuong,DonGia")] Thuoc thuoc) { if (ModelState.IsValid) { db.Entry(thuoc).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_DonVi = new SelectList(db.DonVis, "ID_DonVi", "TenDonVi", thuoc.ID_DonVi); return(View(thuoc)); }
public ActionResult Edit([Bind(Include = "ID_HoaDon,ID_PhieuKham,TienKham,TienThuoc,DoanhThu,GhiChu")] HoaDon hoaDon) { if (ModelState.IsValid) { db.Entry(hoaDon).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_PhieuKham = new SelectList(db.PhieuKhamBenhs, "ID_PhieuKham", "TrieuChung", hoaDon.ID_PhieuKham); return(View(hoaDon)); }
public ActionResult Edit([Bind(Include = "IDPhieuTN,ID_BenhNhan,NgayTiepNhan,Deleted")] PhieuTiepNhan phieuTiepNhan) { if (ModelState.IsValid) { db.Entry(phieuTiepNhan).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_BenhNhan = new SelectList(db.HoSoBenhNhans.Where(x => x.Deleted == false), "ID_BenhNhan", "HoTen", phieuTiepNhan.ID_BenhNhan); return(View(phieuTiepNhan)); }
public ActionResult Edit([Bind(Include = "UserName,Password,UserTypeID")] UserDetail userDetail) { if (ModelState.IsValid) { userDetail.Password = Encryptor.MD5Hash(userDetail.Password); db.Entry(userDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserTypeID = new SelectList(db.UserTypes, "ID", "TypeName", userDetail.UserTypeID); return(View(userDetail)); }
public ActionResult Edit([Bind(Include = "ID_PhieuKham,ID_BenhNhan,ID_Benh,TrieuChung")] PhieuKhamBenh phieuKhamBenh) { if (ModelState.IsValid) { db.Entry(phieuKhamBenh).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_Benh = new SelectList(db.Benhs, "ID_Benh", "TenBenh", phieuKhamBenh.ID_Benh); ViewBag.ID_BenhNhan = new SelectList(db.HoSoBenhNhans, "ID_BenhNhan", "HoTen", phieuKhamBenh.ID_BenhNhan); return(View(phieuKhamBenh)); }
public ActionResult Edit([Bind(Include = "ID_PhieuKham,ID_Thuoc,ID_CachDung,SoLuongThuocLay")] CT_PhieuKhamBenh cT_PhieuKhamBenh) { if (ModelState.IsValid) { db.Entry(cT_PhieuKhamBenh).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_CachDung = new SelectList(db.CachDungs, "ID_CachDung", "TenCachDung", cT_PhieuKhamBenh.ID_CachDung); ViewBag.ID_PhieuKham = new SelectList(db.PhieuKhamBenhs, "ID_PhieuKham", "TrieuChung", cT_PhieuKhamBenh.ID_PhieuKham); ViewBag.ID_Thuoc = new SelectList(db.Thuocs, "ID_Thuoc", "TenThuoc", cT_PhieuKhamBenh.ID_Thuoc); return(View(cT_PhieuKhamBenh)); }
public ActionResult Save(int?IDPhieu, int idPhieuTN, DateTime date, int IDBenh, string TrieuChung, CT_PhieuKhamBenh[] chitietphieukham) { string result = "Error! Thêm chi tiết không thể hoàn tất!"; if (IDPhieu == null && idPhieuTN != 0 && date != null && chitietphieukham != null && IDBenh != 0) { PhieuKhamBenh phieuKham = new PhieuKhamBenh(); int tienThuoc = 0; phieuKham.IDPhieuTN = idPhieuTN; phieuKham.ID_Benh = IDBenh; phieuKham.NgayKham = date; phieuKham.TrieuChung = TrieuChung; db.PhieuKhamBenhs.Add(phieuKham); db.SaveChanges(); int idPhieuKham = phieuKham.ID_PhieuKham; HoaDon hoaDon = new HoaDon(); hoaDon.ID_PhieuKham = idPhieuKham; int tienKham = Convert.ToInt32(db.ThamSoes.Where(x => x.GhiChu.Contains("Tien kham")).SingleOrDefault().GiaTri);; hoaDon.TienKham = tienKham; foreach (var ct in chitietphieukham) { CT_PhieuKhamBenh C = new CT_PhieuKhamBenh(); C.ID_PhieuKham = idPhieuKham; C.ID_Thuoc = ct.ID_Thuoc; C.DonGiaBan = ct.DonGiaBan; C.SoLuongThuocLay = ct.SoLuongThuocLay; C.ThanhTien = ct.ThanhTien; db.CT_PhieuKhamBenh.Add(C); tienThuoc += ct.ThanhTien; } hoaDon.TienThuoc = tienThuoc; hoaDon.TongTien = tienKham + tienThuoc; db.HoaDons.Add(hoaDon); db.SaveChanges(); Session["ID_PhieuKham"] = idPhieuKham; result = "Thành công! Thêm chi tiết hoàn tất!"; } else { try { int tienThuoc = 0; //Trường hợp đã remove 1 hay nhiều ChiTietKhamBenh nào đó ... CT_PhieuKhamBenh[] C = db.CT_PhieuKhamBenh.Where(x => x.ID_PhieuKham == IDPhieu && x.Deleted == false).ToList().ToArray(); List <int> listC = Helper.GhiIDThuocThanhMang(C); List <int> listChiTiet = Helper.GhiIDThuocThanhMang(chitietphieukham); //Tìm phần tử có trong C mà ko có trong chitietphieusua var excepts = listC.Except(listChiTiet).ToArray(); if (excepts.Count() != 0) { foreach (var e in excepts) { CT_PhieuKhamBenh chiTietPhieuKham = db.CT_PhieuKhamBenh.Find(IDPhieu, e); chiTietPhieuKham.Deleted = true; //Update lại thành Số lượng tồn Helper.UpdateAfterDeleteChiTietPhieu(chiTietPhieuKham); //Flag db.Entry(chiTietPhieuKham).State = EntityState.Modified; } db.SaveChanges(); } foreach (CT_PhieuKhamBenh chiTiet in chitietphieukham) { int idThuoc = chiTiet.ID_Thuoc; //Nếu đã có ChiTietPhieu này thi chỉ thực hiện edit if (db.CT_PhieuKhamBenh.Any(x => x.ID_PhieuKham == IDPhieu && x.ID_Thuoc == idThuoc)) { CT_PhieuKhamBenh ct = db.CT_PhieuKhamBenh.Find(IDPhieu, idThuoc); if (ct.Deleted == false) //Chi Edit vs ChiTiet chua xoa { ct.DonGiaBan = chiTiet.DonGiaBan; ct.SoLuongThuocLay = chiTiet.SoLuongThuocLay; ct.ThanhTien = chiTiet.ThanhTien; db.Entry(ct).State = EntityState.Modified; } else //Neu xoa roi (Deleted = true) thi xoa hẳn giá trị đó, va them lai => To fire trigger, update Soluongton, ... { //Xóa db.CT_PhieuKhamBenh.Remove(ct); db.SaveChanges(); //Gán & Add lại ct.DonGiaBan = chiTiet.DonGiaBan; ct.SoLuongThuocLay = chiTiet.SoLuongThuocLay; ct.ThanhTien = chiTiet.ThanhTien; ct.Deleted = false; db.CT_PhieuKhamBenh.Add(ct); db.SaveChanges(); } } else //Nếu không có thì thêm mới { CT_PhieuKhamBenh ChiTiet = new CT_PhieuKhamBenh(); ChiTiet.ID_PhieuKham = (int)IDPhieu; ChiTiet.ID_Thuoc = chiTiet.ID_Thuoc; ChiTiet.DonGiaBan = chiTiet.DonGiaBan; ChiTiet.SoLuongThuocLay = chiTiet.SoLuongThuocLay; ChiTiet.ThanhTien = chiTiet.ThanhTien; db.CT_PhieuKhamBenh.Add(ChiTiet); } db.SaveChanges(); } HoaDon phieuThuTien = db.HoaDons.Where(x => x.ID_PhieuKham == IDPhieu).SingleOrDefault(); var chiTietKham = db.CT_PhieuKhamBenh.Where(x => x.ID_PhieuKham == IDPhieu && x.Deleted == false); foreach (var ele in chiTietKham) { tienThuoc += ele.ThanhTien; } phieuThuTien.TienThuoc = tienThuoc; phieuThuTien.TongTien = tienThuoc + phieuThuTien.TienKham; db.SaveChanges(); Session["ID_PhieuKham"] = IDPhieu; result = "Sửa thành công!!"; } catch (Exception ex) { ViewBag.Errors = ex.Message; throw ex; } } return(Json(result, JsonRequestBehavior.AllowGet)); }