// GET: /Tuyen/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tuyenkhachhang tuyenkhachhang = db.Tuyenkhachhangs.Find(id); Tuyentheonhanvien tuyenTheoNhanVien = db.Tuyentheonhanviens.FirstOrDefault(p => p.TuyenKHID == id); if (tuyenTheoNhanVien != null) { ViewBag.selectedNhanVien = tuyenTheoNhanVien.NhanVienID; ViewBag._nhanVien = db.Nhanviens.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); } //nếu ko có thì load tất cả ra else { ViewBag._nhanVien = db.Nhanviens.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); } if (tuyenkhachhang == null) { return(HttpNotFound()); } return(View(tuyenkhachhang)); }
// GET: /Tuyen/Details/5 public ActionResult Details(int?id) { Tuyenkhachhang tuyenkhachhang = db.Tuyenkhachhangs.Find(id); int loggedInUserDepartment = getPhongBanNguoiDung(); if (tuyenkhachhang == null || id == null) { return(HttpNotFound()); } var tuyenTheoNhanVien = (from i in db.Tuyentheonhanviens join r in db.Nhanviens on i.NhanVienID equals r.NhanvienID where i.TuyenKHID == id && r.PhongbanID == loggedInUserDepartment select new { NhanVienID = i.NhanVienID, }).FirstOrDefault(); if (tuyenTheoNhanVien != null) { ViewBag.nhanVien = db.Nhanviens.Where(p => p.NhanvienID == tuyenTheoNhanVien.NhanVienID).First(); } //nếu ko có thì load ds nhân viên có trong hệ thống ra else { ViewBag.nhanVien = null; } return(View(tuyenkhachhang)); }
// // GET: /ThuNgan/ //hien thi ra danh sach khach hang ma hoa don có trang thai in =1(đã in) public ActionResult DanhSachKhachHangDaInXongHoaDon() { var hoadon = db.Hoadonnuocs.Where(p => p.Trangthaiin == true); List <Tuyenkhachhang> lstTuyen = new List <Tuyenkhachhang>(); foreach (var hdnuoc in db.Hoadonnuocs.OrderBy(p => p.HoadonnuocID).ToList()) { Tuyenkhachhang t = hdnuoc.Khachhang.Tuyenkhachhang; if (hdnuoc.Trangthaiin == true && lstTuyen.FindIndex(x => x.TuyenKHID == t.TuyenKHID) == -1) { lstTuyen.Add(t); } } if (Request.QueryString["id"] == null) { ViewBag.hoadon = hoadon.ToList(); } else { List <Hoadonnuoc> lstHoadon = new List <Hoadonnuoc>(); foreach (var hdnuoc in db.Hoadonnuocs.OrderBy(p => p.HoadonnuocID).ToList()) { if (hdnuoc.Khachhang.Tuyenkhachhang.TuyenKHID == int.Parse(Request.QueryString["id"])) { lstHoadon.Add(hdnuoc); } } ViewBag.hoadon = lstHoadon; } ViewBag.tuyen = lstTuyen; return(View()); }
public String getTTTuyen(int TuyenKHID) { Tuyenkhachhang tuyen = _db.Tuyenkhachhangs.Find(TuyenKHID); if (tuyen != null) { return(tuyen.Matuyen + " - " + tuyen.Ten); } return(""); }
public string getMaTuyenById(int TuyenKHID) { Tuyenkhachhang tuyen = _db.Tuyenkhachhangs.Find(TuyenKHID); if (tuyen != null) { return(tuyen.Matuyen); } return(""); }
public String translateTuyenIDToMaTuyen(String tuyenIdsInput) { String maTuyens = ""; String[] maTuyensAsArray = tuyenIdsInput.Split(','); foreach (var item in maTuyensAsArray) { int tuyenId = Convert.ToInt32(item); Tuyenkhachhang tuyen = _db.Tuyenkhachhangs.Find(tuyenId); if (tuyen != null) { maTuyens += tuyen.Matuyen + ","; } } return(maTuyens.Trim(',')); }
public ActionResult PrintFromTo(FormCollection form, int?quan, int TuyenID, int month, int year) { setPrintCircumstance((int)PrintModeEnum.PRINT_FROM_RECEIPT_TO_RECEIPT); int count = db.Lichsuhoadons.Count(p => p.TuyenKHID == TuyenID && p.ThangHoaDon == month && p.NamHoaDon == year); Tuyenkhachhang tuyenKH = db.Tuyenkhachhangs.Find(TuyenID); int fromSoHoaDon = String.IsNullOrEmpty(form["from"]) ? 1 : Convert.ToInt16(form["from"]); int toSoHoaDon = String.IsNullOrEmpty(form["to"]) ? count : Convert.ToInt16(form["to"]); updateFromReceiptToReceipt(quan, TuyenID.ToString(), month, year, fromSoHoaDon, toSoHoaDon); List <LichSuHoaDon> danhSachHoaDons = GetDanhSachHoaDons(TuyenID, month, year); if (toSoHoaDon >= danhSachHoaDons.Count) { toSoHoaDon = danhSachHoaDons.Count(); } String formPrintMachine = form["printMachine"]; Stream str = null; if (formPrintMachine == "LQ2190") { Factory.ReportLP2190 report = new Factory.ReportLP2190(); str = report.generateReportPrintFromTo(fromSoHoaDon, toSoHoaDon, TuyenID, month, year, tuyenKH); } else if (formPrintMachine == "LX2170") { Factory.ReportLX2170 report = new Factory.ReportLX2170(); str = report.generateReportPrintFromTo(fromSoHoaDon, toSoHoaDon, TuyenID, month, year, tuyenKH); } else { Factory.ReportTallyGenicom report = new Factory.ReportTallyGenicom(); str = report.generateReportPrintFromTo(fromSoHoaDon, toSoHoaDon, TuyenID, month, year, tuyenKH); } return(File(str, "application/pdf")); }
public ActionResult Create([Bind(Include = "Matuyen,TuyenKHID,ToID,CumdancuID,Ten,Diachi,IsDelete")] Tuyenkhachhang tuyenkhachhang) { tuyenkhachhang.IsDelete = false; if (ModelState.IsValid) { //kiểm tra trong tuyến trước Tuyenkhachhang existingTuyen = db.Tuyenkhachhangs.FirstOrDefault(p => p.Matuyen == tuyenkhachhang.Matuyen && p.IsDelete == false); if (existingTuyen == null) { db.Tuyenkhachhangs.Add(tuyenkhachhang); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.hasTuyen = true; } } ViewData["nhanVien"] = db.Nhanviens.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); ViewBag.CumdancuID = new SelectList(db.Cumdancus.Where(p => p.IsDelete == false), "CumdancuID", "Ten"); ViewBag.ToID = new SelectList(db.Toes, "ToID", "Ten", tuyenkhachhang.ToID); return(View(tuyenkhachhang)); }
public ActionResult Edit([Bind(Include = "Matuyen,TuyenKHID,ToID,CumdancuID,Ten,Diachi,IsDelete")] Tuyenkhachhang tuyenkhachhang) { HoaDonHaDongEntities _db = new HoaDonHaDongEntities(); Tuyenkhachhang tuyen = _db.Tuyenkhachhangs.Find(tuyenkhachhang.TuyenKHID); if (ModelState.IsValid) { Tuyenkhachhang existingTuyen = db.Tuyenkhachhangs.AsNoTracking().FirstOrDefault(p => p.Matuyen == tuyenkhachhang.Matuyen && p.IsDelete == false); if (existingTuyen == null || tuyen.Matuyen == tuyenkhachhang.Matuyen) { db.Tuyenkhachhangs.AsNoTracking(); db.Tuyenkhachhangs.Attach(tuyenkhachhang); db.Entry(tuyenkhachhang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.hasTuyen = "Mã tuyến đã tồn tại trong cơ sở dữ liệu"; } } return(View(tuyenkhachhang)); }
public Stream generateReportPrintFromTo(int fromSoHoaDon, int toSoHoaDon, int TuyenID, int month, int year, Tuyenkhachhang tuyenKH) { List <dynamic> ls = new List <dynamic>(); for (int i = fromSoHoaDon; i <= toSoHoaDon; i++) { ControllerBase <HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon> cb = new ControllerBase <HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon>(); HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon source = cb.Query("InHoaDonFromTo", new SqlParameter("@d1", month), new SqlParameter("@d2", year), new SqlParameter("@d3", TuyenID), new SqlParameter("@matuyen", tuyenKH.Matuyen), new SqlParameter("@num", i) ).FirstOrDefault(); ls.Add(source); //cập nhật trạng thái in cho hóa đơn được in từ số thứ tự (số hóa đơn) từ xx->yy int hoaDonID = source.HoaDonID; //cập nhật trạng thái in vào tất cả các hóa đơn printCtl.CapNhatTrangThaiIn(hoaDonID); } report.SetDataSource(ls); try { Stream str = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); str.Seek(0, SeekOrigin.Begin); return(str); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public Stream generateReportPrintFromToPreview(int fromSoHoaDon, int toSoHoaDon, int TuyenID, int month, int year, Tuyenkhachhang tuyenKH) { List <dynamic> ls = new List <dynamic>(); for (int i = fromSoHoaDon; i <= toSoHoaDon; i++) { ControllerBase <HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon> cb = new ControllerBase <HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon>(); HoaDonNuocHaDong.Models.InHoaDon.LichSuHoaDon hoaDon = cb.Query("InHoaDonFromTo", new SqlParameter("@d1", month), new SqlParameter("@d2", year), new SqlParameter("@d3", TuyenID), new SqlParameter("@matuyen", tuyenKH.Matuyen), new SqlParameter("@num", i) ).FirstOrDefault(); ls.Add(hoaDon); } report.SetDataSource(ls); try { Stream str = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); str.Seek(0, SeekOrigin.Begin); return(str); } catch (Exception ex) { throw new Exception(ex.ToString()); } }