Ejemplo n.º 1
0
        public static CityEntity Select(CityEntity cityEntity)
        {
            //cityEntity.LogMessages.MsgType = MessageType.INFO;
            //cityEntity.LogMessages.Content = _nameSpaceClass + "Select";
            //LoggerHelper.LogWriter(cityEntity.LogMessages);

            try
            {
                return CityDA.Select(cityEntity);
            }
            catch (Exception ex)
            {
                //cityEntity.LogMessages.MsgType = MessageType.ERROR;
                //cityEntity.LogMessages.Content = _nameSpaceClass + "Select  Error: " + ex.Message;
                //LoggerHelper.LogWriter(cityEntity.LogMessages);
                throw ex;
            }
        }
Ejemplo n.º 2
0
        public ActionResult AutoGetCityList(string query)
        {
            CityEntity _cityEntity = new CityEntity();
            _cityEntity.CityDBEntity = new List<CityDBEntity>();
            CityDBEntity cityDBEntity = new CityDBEntity();
            cityDBEntity.Name_CN = query;
            //cityDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
            //cityDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
            //cityDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
            //cityDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();

            _cityEntity.CityDBEntity.Add(cityDBEntity);
            DataSet dsResult = CityInfoBP.CommonSelect(_cityEntity).QueryResult;

            query = query.Replace(" ", "");
            if (query.Length > 1)
            {
                int op = query.LastIndexOf(",");
                query = query.Substring(op + 1);
            }

            ArrayList alCity = new ArrayList();

            for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++ )
            {
                alCity.Add(dsResult.Tables[0].Rows[i][0].ToString().Trim());
            }

            //var list = JsonConvert.SerializeObject(dsResult.Tables[0], new DataTableConverter());
            //var users = (from u in dsResult.Tables[0].Rows
            //             where u.EmailAddress.Contains(query)
            //             orderby u.EmailAddress // optional
            //             select u.EmailAddress).Distinct().ToArray();

            return Json(alCity, JsonRequestBehavior.AllowGet);
        }
Ejemplo n.º 3
0
        public string AjxGetCityList(string citynm, string startdt, string enddt, string online)
        {
            //ViewBag
            CityEntity _cityEntity = new CityEntity();
            _cityEntity.CityDBEntity = new List<CityDBEntity>();
            CityDBEntity cityDBEntity = new CityDBEntity();

            //cityDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
            //cityDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
            //cityDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
            //cityDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();

            _cityEntity.CityDBEntity.Add(cityDBEntity);
            System.Data.DataSet dsResult = CityInfoBP.Select(_cityEntity).QueryResult;

            using(var sw = new StringWriter())
            {
                ViewData.Model = dsResult;
                var viewResult = ViewEngines.Engines.FindPartialView(ControllerContext, "../Partial/_cityListInfo");
                var viewContent = new ViewContext(ControllerContext, viewResult.View, ViewData, TempData, sw);
                viewResult.View.Render(viewContent, sw);
                return sw.GetStringBuilder().ToString();
            }
        }
Ejemplo n.º 4
0
        //
        // GET: /City/
        public ActionResult Index()
        {
            ViewBag.Message = "Your City page.";
            //_cityEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
            //_cityEntity.LogMessages.Userid = UserSession.Current.UserAccount;
            //_cityEntity.LogMessages.Username = UserSession.Current.UserDspName;
            //_cityEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
            CityEntity _cityEntity = new CityEntity();
            _cityEntity.CityDBEntity = new List<CityDBEntity>();
            CityDBEntity cityDBEntity = new CityDBEntity();

            //cityDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
            //cityDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
            //cityDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
            //cityDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();

            _cityEntity.CityDBEntity.Add(cityDBEntity);
            ViewBag.CityList = CityInfoBP.Select(_cityEntity).QueryResult;

            return View();
        }
Ejemplo n.º 5
0
        public string GetCityList(string citynm, string startdt, string enddt, string online)
        {
            //ViewBag
            //System.Threading.Thread.Sleep(5000);
            CityEntity _cityEntity = new CityEntity();
            _cityEntity.CityDBEntity = new List<CityDBEntity>();
            CityDBEntity cityDBEntity = new CityDBEntity();

            //cityDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
            //cityDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
            //cityDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
            //cityDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();

            _cityEntity.CityDBEntity.Add(cityDBEntity);
            System.Data.DataSet dsResult = CityInfoBP.Select(_cityEntity).QueryResult;
            var list = JsonConvert.SerializeObject(dsResult.Tables[0], new DataTableConverter());
            return list;
        }