public void TestAddAndDelete() { DateTime thoiGianDi = DateTime.Now; ChuyenDi t1 = new ChuyenDi("BL-BH-003", "BL-BH", thoiGianDi, 240, 40); Assert.AreEqual(true, manager.add(t1)); Assert.AreEqual(false, manager.add(t1)); Assert.AreEqual(true, manager.delete("BL-BH-003")); }
private void LearnMoreButton_Click(object sender, RoutedEventArgs e) { Button sd = sender as Button; ChuyenDi cdi = (ChuyenDi)sd.DataContext; string maChuyenDi = cdi.MaChuyenDi; if (LearnMoreHandler != null) { LearnMoreHandler(Type, maChuyenDi); } }
public static string toText(this ChuyenDi item) { if (item == null) { return(""); } if (item.xevanchuyen != null) { return(string.Format("{0}({1})", item.Ma, item.xevanchuyen.BienSo)); } return(item.Ma); }
public void TestUpdate() { DateTime thoiGianDi = DateTime.Now; ChuyenDi t1 = new ChuyenDi("BL-BH-003", "BL-BH", thoiGianDi, 240, 40); manager.add(t1); ChuyenDi t2 = new ChuyenDi("BL-BH-003", "BL-BH", thoiGianDi, 240, 50); Assert.AreEqual(true, manager.update(t2)); Assert.AreEqual(true, manager.update(t1)); Assert.AreEqual(true, manager.delete("BL-BH-003")); }
public static string ChuyenDitoText(this ChuyenDi item, bool IsMa) { if (item == null) { return(""); } if (IsMa) { return(string.Format("{0}({1})", item.Ma, item.NgayDiThuc.ToString("HH:mm"))); } else { return(item.NgayDiThuc.ToString("HH:mm")); } }
private DatVe _DatCho(ChuyenDi chuyendi, int SoDoGheId, string SessionId) { //trang thai khong hop le if (chuyendi.trangthai == ENTrangThaiXeXuatBen.KET_THUC || chuyendi.trangthai == ENTrangThaiXeXuatBen.HUY) { return(null); } //kiem tra xem co ai dat chua var checkdatve = chuyendi.DatVes.Where(c => c.SoDoGheId == SoDoGheId && c.TrangThaiId != (int)ENTrangThaiDatVe.HUY).FirstOrDefault(); if (checkdatve != null) { //neu co roi thi kiem tra thoi gian dat trc do neu chua qua 2 phut thi out if (checkdatve.NgayTao.AddSeconds(_settings.THOI_GIAN_GHE_DAT_CHO) > DateTime.Now) { //trong truong hop dat ve, nhung paste thong tin thi bo qua cho dat nay, neu da dat roi return(null); } else { //kiem tra trang thai ghe if (checkdatve.trangthai == ENTrangThaiDatVe.MOI) { //huy ghe nay di _limousinebanveService.DeleteDatVe(checkdatve); } else { return(null); } } } //tao thong tin dat ve var datve = new DatVe(); datve.NhaXeId = chuyendi.NhaXeId; datve.ChuyenDiId = chuyendi.Id; datve.SoDoGheId = SoDoGheId; datve.NguoiTaoId = _settings.NhanVienId; datve.NgayDi = chuyendi.NgayDi; datve.LichTrinhId = chuyendi.LichTrinhId; datve.HanhTrinhId = chuyendi.HanhTrinhId; datve.trangthai = ENTrangThaiDatVe.MOI; datve.SessionID = SessionId; _limousinebanveService.InsertDatVe(datve); return(_limousinebanveService.GetDatVeById(datve.Id)); }
private void loadUI() { String db = "QLChuyenDi"; String con = $"Server=localhost; Database= master; Trusted_Connection=True;"; bool isHasDatabase = DatabaseHelper.isDatabaseExists(con, db); if (!isHasDatabase) { return; } ChuyenDiDAOImpl chuyenDiDAOImpl = new ChuyenDiDAOImpl(); if (chuyenDiDAOImpl.GetAllChuyenDi().Count() > 0) { Random random = new Random(); int index = random.Next(chuyenDiDAOImpl.GetAllChuyenDi().Count()); ChuyenDi trip = chuyenDiDAOImpl.GetAllChuyenDi()[index]; txtTripTittle.Text = trip.TenChuyenDi; txtTripDescription.Text = trip.MoTa; HinhAnhChuyenDiDAOlmpl hinhAnhChuyenDiDAOlmpl = new HinhAnhChuyenDiDAOlmpl(); HinhAnhChuyenDi tripImage = hinhAnhChuyenDiDAOlmpl.getTripImageByTripCode(trip.MaChuyenDi); if (tripImage == null || tripImage.HinhAnh == null || tripImage.HinhAnh == "") { Uri uri = new Uri("../Assets/Images/default_trip_image.jpg", UriKind.RelativeOrAbsolute); imgTrip.Source = new BitmapImage(uri); } else { Uri uri = new Uri(tripImage.HinhAnh, UriKind.RelativeOrAbsolute); try { imgTrip.Source = new BitmapImage(uri); } catch (Exception) { } } } else { //do nothing. use default screen in xml } }
string isAuthentication(int NhaXeId, int CustomerId, string apiToken, int XeXuatBenId) { string _isauthen = isAuthentication(NhaXeId, CustomerId, apiToken); if (!String.IsNullOrEmpty(_isauthen)) { return(_isauthen); } xexuatben = _limousinebanveService.GetChuyenDiById(XeXuatBenId); if (xexuatben == null) { return("Không tồn tại thông tin xe xuất bến"); } if (xexuatben.NhaXeId != NhaXeId) { return("Xe xuất bến không thuộc nhà xe"); } return(String.Empty); }
private void filterByTrip() { cdList.Clear(); foreach (var trip in cdDao.GetAllChuyenDi()) { cdList.Add(trip); } String filterQuery = keywordTextBox.Text; if (!filterQuery.Equals("")) { String unSignLowerTripName = ConvertToUnSign(filterQuery.ToLower()); for (int i = 0; i < cdList.Count(); i++) { ChuyenDi trip = cdList[i]; if (!ConvertToUnSign(trip.TenChuyenDi.ToLower()).Contains(unSignLowerTripName)) { i--; tripVM.TripList.Remove(trip); } } } }
public static ChuyenDiModel toModel(this ChuyenDi e, ILocalizationService localizationService) { var m = new ChuyenDiModel(); m.Id = e.Id; m.Ma = e.Ma; m.LaiXeId = e.LaiXeId; m.TenLaiXeRutGon = ""; if (e.laixe != null) { m.TenLaiXe = e.laixe.ThongTin(); m.TenLaiXeRutGon = e.laixe.HoVaTen; } else { m.TenLaiXe = ""; } //chi lay ten if (!string.IsNullOrEmpty(m.TenLaiXeRutGon)) { string[] arrten = m.TenLaiXeRutGon.Split(' '); m.TenLaiXeRutGon = arrten[arrten.Length - 1].Trim(); } else { m.TenLaiXeRutGon = "---"; } m.NgayDi = e.NgayDi; m.NgayDiThuc = e.NgayDiThuc; m.LichTrinhId = e.LichTrinhId; m.TenLichTrinh = e.lichtrinh.toText(false); m.HanhTrinhId = e.HanhTrinhId; m.TenHanhTrinh = e.hanhtrinh.MaHanhTrinh; if (e.DatVeHopLes() != null) { m.TienChuaThanhToan = e.DatVeHopLes().Where(c => !c.isThanhToan).Sum(c => c.GiaTien); } m.XeVanChuyenId = e.XeVanChuyenId; if (e.xevanchuyen != null) { m.BienSoXe = e.xevanchuyen.BienSo; } else { m.BienSoXe = "---------"; } if (m.BienSoXe.Length >= 4) { m.BienSoXe3So = m.BienSoXe.Substring(m.BienSoXe.Length - 4); } else { m.BienSoXe3So = m.BienSoXe; } m.NgayTao = e.NgayTao; m.NguoiTaoId = e.NguoiTaoId; m.TenNguoiTao = e.nguoitao.HoVaTen; m.trangthai = e.trangthai; m.TrangThaiText = e.trangthai.ToCVEnumText(localizationService); m.GhiChu = e.GhiChu; m.SoKhach = e.DatVeHopLes().Count(); m.SoGhe = e.lichtrinh.loaixe.sodoghe.SoLuongGhe; m.TenLoaiXe = e.lichtrinh.loaixe.TenLoaiXe; m.GiaVe = e.lichtrinh.GiaVeToanTuyen; m.isEdit = true; if (e.trangthai == ENTrangThaiXeXuatBen.KET_THUC) { m.isEdit = false; } return(m); }
public JsonResult Search(ChuyenDi chuyenDi) { if (!ModelState.IsValid) { ModelState.AddModelError("", "Model binding failed"); return(new JsonResult(new object())); } string diemDungA = null; bool isToDN = false; if (chuyenDi.DiemDen.Contains("Đà Nẵng")) { isToDN = true; diemDungA = chuyenDi.DiemDi; } else if (chuyenDi.DiemDi.Contains("Đà Nẵng")) { diemDungA = chuyenDi.DiemDen; } else { return(new JsonResult(new { })); } //dsDiemDungA var dsDiemDungA = from stop in context.DiemDung where stop.TenTinhTp == diemDungA select stop; //dsXeKhachA var dsXK_DDA = from xk_dd in context.XeKhach_DiemDung from dd in dsDiemDungA where xk_dd.MaDiemDung == dd.MaDiemDung select xk_dd; //filter List <ChuyenDiViewModel> res = new List <ChuyenDiViewModel>(); foreach (XeKhach_DiemDung xkdd in dsXK_DDA) { xkdd.XeKhach = context.XeKhach.Find(xkdd.MaXeKhach); xkdd.XeKhach.NhaXe = context.NhaXe.Find(xkdd.XeKhach.MaNhaXe); xkdd.XeKhach.TaiXe = context.TaiXe.Find(xkdd.XeKhach.MaTaiXe); xkdd.DiemDung = context.DiemDung.Find(xkdd.MaDiemDung); if (xkdd.XeKhach.NhaXe.GiaoDichCuoi.AddDays(180) < DateTime.Today) { continue; } if (chuyenDi.TenNhaXe != null && chuyenDi.TenNhaXe != xkdd.XeKhach.NhaXe.TenNhaXe) { continue; } if (chuyenDi.SoGhe != null && chuyenDi.SoGhe != xkdd.XeKhach.SoGhe) { continue; } if (chuyenDi.ThoiGianDiChuyenMax != null) { if (isToDN && chuyenDi.ThoiGianDiChuyenMax < xkdd.TGDCtoiDN) { continue; } else if (!isToDN && chuyenDi.ThoiGianDiChuyenMax < xkdd.TGDCkhoiDN) { continue; } } if (chuyenDi.GiaVeMax != null && chuyenDi.GiaVeMax < xkdd.XeKhach.GiaVe) { continue; } string noiXuatPhat = null, noiDen = null; TimeSpan tg; DateTime khoiHanh; //giả sử đi từ A -> đà nẵng if (isToDN) { noiDen = chuyenDi.DiemDen; noiXuatPhat = xkdd.DiemDung.ToString(); tg = xkdd.TGDCtoiDN; } else { noiDen = xkdd.DiemDung.ToString(); noiXuatPhat = chuyenDi.DiemDi; tg = xkdd.TGDCkhoiDN; } khoiHanh = chuyenDi.NgayKhoiHanh.Add(tg); res.Add(new ChuyenDiViewModel(xkdd.XeKhach, noiXuatPhat, noiDen, khoiHanh, tg)); } //return return(new JsonResult(res.ToArray())); }
public ActionResult ChotKhach(int NhaXeId, int XeXuatBenId, string Email, string Password, int slpm, int sltt, string Latitude, string Longitude, string VitriChot, string apiToken) { var loginresult = _customerRegistrationService.ValidateCustomer(Email, Password); if (loginresult != CustomerLoginResults.Successful) { return(ErrorOccured("Tài khoản hoặc mật khẩu không đúng !")); } var tkchot = _customerService.GetCustomerByEmail(Email); //luu nhat ky _customerActivityService.InsertActivity("PublicStore.Login", "Tài khoản nhà xe đăng nhập để chốt khách", tkchot); //lay thong tin van phong var nhanvienchot = _nhanvienService.GetByCustomerId(tkchot.Id); if (nhanvienchot == null) { return(ErrorOccured("Thông tin người chốt không hợp lệ")); } if (!nhanvienchot.DiemDonId.HasValue) { return(ErrorOccured("Thông tin người chốt không hợp lệ")); } xexuatben = _limousinebanveService.GetChuyenDiById(XeXuatBenId); if (xexuatben == null) { return(ErrorOccured("Không tồn tại thông tin xe xuất bến")); } if (xexuatben.NhaXeId != NhaXeId) { return(ErrorOccured("Xe xuất bến không thuộc nhà xe")); } //thuc hien thong tin chot khach //kiem tra co thong tin chot trc chua var lschotkhach = _nhaxeService.GetChotKhachs(NhaXeId, HistoryXeXuatBenId: XeXuatBenId); var itemck = new ChotKhach(); if (lschotkhach.Count > 0) { itemck = lschotkhach.FirstOrDefault(); } itemck.SoLuongThucTe = sltt; itemck.SoLuongPhanMem = slpm; itemck.NguoiChotId = nhanvienchot.Id; itemck.DiemDonId = nhanvienchot.DiemDonId.Value; itemck.NgayChot = DateTime.Now; itemck.NhaXeId = NhaXeId; itemck.HistoryXeXuatBenId = xexuatben.Id; itemck.Latitude = Convert.ToDecimal(Latitude) / 1000000000m; itemck.Longitude = Convert.ToDecimal(Longitude) / 1000000000m; itemck.ViTriChot = VitriChot; if (itemck.Id > 0) { _nhaxeService.UpdateChotKhach(itemck); } else { _nhaxeService.InsertChotKhach(itemck); } itemck = _nhaxeService.GetChotKhachById(itemck.Id); string ghichu = string.Format("Chốt khách tại {0} : SL khách thực tế/phần mềm: {1}/{2}; người chốt: {3}", itemck.diemchot.TenDiemDon, sltt, slpm, nhanvienchot.HoVaTen); var item = CreateHistoryXeXuatBenLog(xexuatben.trangthai, ghichu, XeXuatBenId, nhanvienchot.Id); var nhatkyinfo = new { Id = item.Id, NgayTao = item.NgayTao.toStringDateTime(), GhiChu = item.GhiChu }; return(Successful(nhatkyinfo)); }
public JsonResult XeKhach(ChuyenDi chuyenDi) { if (!ModelState.IsValid) { ModelState.AddModelError("", "Model binding failed"); return(new JsonResult(new { })); } var xeKhachList = context.XeKhach.AsEnumerable <XeKhach>(); bool val = false; var res = xeKhachList.Where(xk => { //required foreach (var rec in xk.DiemDungList) { if (chuyenDi.MaDiemDung.Contains(rec.MaDiemDung)) { val |= true; break; } val |= false; } //required val |= xk.GioKhoiHanh == chuyenDi.GioKhoiHanh; //nullable if (chuyenDi.TenNhaXe != null) { val |= xk.NhaXe.TenNhaXe == chuyenDi.TenNhaXe; } if (chuyenDi.LoaiXe != null) { val |= xk.LoaiXe == chuyenDi.LoaiXe; } if (chuyenDi.ThoiGianDiChuyenMin != null && chuyenDi.ThoiGianDiChuyenMax != null) { if (xk.ThoiGianDiChuyen >= chuyenDi.ThoiGianDiChuyenMin && xk.ThoiGianDiChuyen <= chuyenDi.ThoiGianDiChuyenMax) { val |= true; } else { val |= false; } } if (chuyenDi.GiaVeMin != null && chuyenDi.GiaVeMax != null) { if (xk.GiaVe >= chuyenDi.GiaVeMin && xk.GiaVe <= chuyenDi.GiaVeMax) { val |= true; } else { val |= false; } } //returning return(val); }); //convert to view model List <ChuyenDiViewModel> models = new List <ChuyenDiViewModel>(); foreach (XeKhach xk in res) { var diemDungList = context.DiemDung.AsEnumerable <DiemDung>(); var fullDiemDung = from ctDiemDung in diemDungList from diemDung in xk.DiemDungList where diemDung.MaDiemDung == ctDiemDung.MaDiemDung select ctDiemDung; List <string> tenDiemDungList = new List <string>(); foreach (DiemDung diemDung in fullDiemDung) { tenDiemDungList.Add(diemDung.ToString()); } models.Add(new ChuyenDiViewModel(xk, tenDiemDungList.ToArray(), chuyenDi.NgayKhoiHanh)); } //return return(new JsonResult(models.ToArray())); }
private void OnSubmit(object sender, RoutedEventArgs e) { String tripName = txtTripName.Text; String curStateString = cbTrangThai.Text; String location = txtLocation.Text; String description = txtDescription.Text; if (tripName == "") { MessageBox.Show("Bạn chưa nhập tên chuyến đi"); } else if (location == "") { MessageBox.Show("Bạn chưa nhập địa điểm chuyến đi"); } int curState = 1; if (curStateString.Equals("Đang đi")) { curState = 0; } ChuyenDi newTrip = new ChuyenDi(maChuyenDi, tripName, curState, location, description, anhbiaChuyenDi); chuyenDiDAOImpl.addChuyenDi(newTrip); if (extraExpense.Count() > 0) { foreach (MucChi mucChi in extraExpense) { mucChiDAOlmpl.addMucChi(mucChi); } } if (milestones.Count() > 0) { foreach (CacMocLoTrinh milistone in milestones) { cacMocLoTrinhDAOlmpl.addCacMocLoTrinh(milistone); } } if (members.Count() > 0) { foreach (ThanhVien member in members) { thanhVienDAOlmpl.addThanhVien(member); } foreach (CHUYENDI_THANHVIEN trip_member in trip_memberList) { chuyenDiThanhVienDAOImpl.addChuyenDiThanhVien(trip_member); } } if (fileList.Count() > 0) { //foreach(HinhAnhChuyenDi image in images) //{ // hinhAnhChuyenDiDAOlmpl.addHinhAnhChuyenDi(image); //} var currentFolder = AppDomain.CurrentDomain.BaseDirectory; foreach (string file in fileList) { var info = new FileInfo(file); var newName = $"{Guid.NewGuid()}{info.Extension}"; File.Copy(file, $"{currentFolder}Assets\\Images\\{newName}"); HinhAnhChuyenDi newImage = new HinhAnhChuyenDi() { HinhAnh = newName, MaChuyenDi = this.maChuyenDi }; hinhAnhChuyenDiDAOlmpl.addHinhAnhChuyenDi(newImage); } } //ChuyenDi newTrip = new ChuyenDi(maChuyenDi, tripName, curState, location, description, anhbia); //chuyenDiDAOImpl.addChuyenDi(newTrip); if (anhbiaChuyenDi != "") { var currentFolder = AppDomain.CurrentDomain.BaseDirectory; string file = AvatarName; File.Copy(file, $"{currentFolder}Assets\\Images\\{newNameAvt}"); } MessageBox.Show("Đã hoàn thành"); }
private void filterByMember() { cdList.Clear(); foreach (var trip in cdDao.GetAllChuyenDi()) { cdList.Add(trip); } String filterQuery = keywordTextBox.Text; if (!filterQuery.Equals("")) { String unSignLowerMemberName = ConvertToUnSign(filterQuery.ToLower()); ChuyenDiThanhVienDAOImpl tripMemberDAO = new ChuyenDiThanhVienDAOImpl(); List <CHUYENDI_THANHVIEN> trip_members = tripMemberDAO.GetCHUYENDI_THANHVIENList(); ThanhVienDAOlmpl memberDAO = new ThanhVienDAOlmpl(); List <ThanhVien> members = memberDAO.GetAllThanhVien(); for (int i = 0; i < members.Count(); i++) { ThanhVien member = members[i]; String unSignLowerMemberNameItem = ConvertToUnSign(member.TenThanhVien.ToLower()); if (!unSignLowerMemberNameItem.Contains(unSignLowerMemberName)) { members.Remove(member); i--; } } for (int i = 0; i < trip_members.Count(); i++) { CHUYENDI_THANHVIEN trip_member = trip_members[i]; for (int j = 0; j < members.Count(); j++) { if (trip_member.MaThanhVien.Equals(members[j].MaThanhVien)) { break; } if (j == members.Count() - 1) { trip_members.Remove(trip_member); i--; } } } for (int i = 0; i < cdList.Count(); i++) { ChuyenDi trip = cdList[i]; for (int j = 0; j < trip_members.Count(); j++) { if (trip.MaChuyenDi.Equals(trip_members[j].MaChuyenDi)) { break; } if (j == trip_members.Count() - 1) { i--; tripVM.TripList.Remove(trip); } } } } }