public async Task <IActionResult> Edit(Guid id, [Bind("TravelsID,TravelsTitle,travelsTime,Like,Collection,Share")] Travels travels) { if (id != travels.TravelsID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(travels); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TravelsExists(travels.TravelsID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(travels)); }
public async Task <Travels> FindByIdAsync(params object[] values) { Travels entity = new Travels(); try { SqlConnection con = Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = $"SELECT * FROM {TABLE} WHERE ID_Travels = {values[0]};"; var dr = await cmd.ExecuteReaderAsync(); while (dr.Read()) { entity = GetEntityFromDataReader(dr); } dr.Close(); cmd.Dispose(); Close(con); return(entity); } catch (Exception ex) { throw ex; } }
public List <TravelVm> GetMyTravels(int page, int count, int userid) { var list = new List <TravelVm>(); var ds = dal.GetMyTravels(page, count, userid); if (ds == null || ds.Tables[0] == null || ds.Tables[0].Rows.Count <= 0) { return(list); } foreach (DataRow dataRow in ds.Tables[0].Rows) { var partId = Int32.Parse(dataRow["id"].ToString()); var travelId = 0; if (dataRow["TravelId"] != DBNull.Value && !string.IsNullOrEmpty(dataRow["TravelId"].ToString())) { travelId = Int32.Parse(dataRow["TravelId"].ToString()); } var partType = Int32.Parse(dataRow["PartType"].ToString()); var description = dataRow["Description"].ToString(); var partUrl = dataRow["PartUrl"] != DBNull.Value?dataRow["PartUrl"].ToString():""; var longitude = dataRow["Longitude"] != DBNull.Value ? Decimal.Parse(dataRow["Longitude"].ToString()) : 0; var latitude = dataRow["Latitude"] != DBNull.Value ? Decimal.Parse(dataRow["Latitude"].ToString()) : 0; var height = dataRow["Height"] != DBNull.Value ? Decimal.Parse(dataRow["Height"].ToString()) : 0; var area = dataRow["Area"] != DBNull.Value ? dataRow["Area"].ToString() : ""; var createtime = DateTime.Parse(dataRow["CreateTime"].ToString()); var travel = new Travels(); if (travelId > 0) { travel = GetModelByCache(travelId); } var vm = new TravelVm() { TravelName = travel != null ? travel.TravelName : "", CoverImage = travel != null ? travel.CoverImage : "", Id = partId, TravelId = travelId, PartType = partType, PartUrl = partUrl, Description = description, Longitude = longitude, Latitude = latitude, Height = height, Area = area, CreateTime = createtime, }; list.Add(vm); } return(list); }
public TravelController() { display = new Display(); travels = new Travels(display.Distance, display.Time); Console.WriteLine(travels.Distance); Console.WriteLine(travels.Time); display.MinCost = travels.CalculateMinCost(); display.Output(); }
protected virtual void ExecuteQueryCommand() { #region 状态 var tripStatus = new int?[0]; if (SelectedTravelStatus.HasValue) { switch (SelectedTravelStatus.Value) { case EnumPassengerTripStatus.NoCreate: tripStatus = new int?[] { 0, 3, 4 }; break; case EnumPassengerTripStatus.HasCreate: tripStatus = new int?[] { 1 }; break; case EnumPassengerTripStatus.HasVoid: tripStatus = new int?[] { 2, 5 }; break; } } #endregion //if (int.Parse(startTicketNumber) > int.Parse(endTicketNumber) && !string.IsNullOrEmpty(startTicketNumber) && !string.IsNullOrEmpty(endTicketNumber)) //{ UIManager.ShowMessage("票号段选择开始票号大于结束票号"); return; } if (StartCreateTime > EndCreateTime || StartGrantTime > EndGrantTime || StartVoidTime > EndVoidTime) { UIManager.ShowMessage("选择日期时开始日期大于结束日期"); return; } IsBusy = true; Travels.Clear(); Action action = () => CommunicateManager.Invoke <ITravelPaperService>(service => { var data = service.FindTravelPaper(null, null, UseOffice, StartTripNumber, EndTripNumber, StartTicketNumber, EndTicketNumber, StartCreateTime, EndCreateTime, StartVoidTime, EndVoidTime, StartGrantTime, EndGrantTime, null, null, null, null, CurrentPageIndex, PageSize, true, tripStatus, OrderId); if (data.List == null) { return; } TotalCount = data.TotalCount; foreach (var item in data.List) { DispatcherHelper.UIDispatcher.Invoke(new Action <TravelPaperDto>(Travels.Add), item); } }, UIManager.ShowErr); Task.Factory.StartNew(action).ContinueWith(task => { Action setBusyAction = () => { IsBusy = false; }; DispatcherHelper.UIDispatcher.Invoke(setBusyAction); }); }
public async Task <IActionResult> Create([Bind("TravelsID,TravelsTitle,travelsTime,Like,Collection,Share")] Travels travels) { if (ModelState.IsValid) { travels.TravelsID = Guid.NewGuid(); _context.Add(travels); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(travels)); }
public long AddTravel(string title, string context, long?tops, long Uid) { Travels lines = new Travels(); lines.title = title; lines.content = context; lines.tops = tops; lines.Uid = Uid; using (Dbcontext ctx = new Dbcontext()) { ctx.Travels.Add(lines); ctx.SaveChanges(); } return(lines.Id); }
public async Task Delete(int id) { try { Travels entity = await TravelsRepository.FindByIdAsync(id); TravelsRepository.Remove(entity); } catch (DeleteWithRelationshipException ex) { throw new Exception("The record you are trying to delete is related to another"); } catch (Exception ex) { throw new Exception("Have ocurred an error to delete"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Travels DataRowToModel(DataRow row) { Travels model = new Travels(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["TravelName"] != null) { model.TravelName = row["TravelName"].ToString(); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } if (row["CoverImage"] != null) { model.CoverImage = row["CoverImage"].ToString(); } if (row["IsDelete"] != null && row["IsDelete"].ToString() != "") { if ((row["IsDelete"].ToString() == "1") || (row["IsDelete"].ToString().ToLower() == "true")) { model.IsDelete = true; } else { model.IsDelete = false; } } } return(model); }
public void Remove(Travels entity) { try { var con = Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = $"DELETE FROM {TABLE} WHERE ID_Travels = {entity.ID_Travels};"; cmd.ExecuteNonQuery(); Close(con); } catch (SqlException ex) when(ex.Number == 1451) { throw new DeleteWithRelationshipException($"{TAG}: {ex.Message}"); } catch (Exception ex) { throw ex; } }
public static int NewTravelIndex(Travels travle) { var docs = new List <SolrInputDocument>(); var doc = new SolrInputDocument(); doc.Add("id", new SolrInputField("id", "travels_" + travle.Id)); //索引中Id不能重复 doc.Add("userid", new SolrInputField("userid", travle.UserId)); doc.Add("TravelName", new SolrInputField("TravelName", travle.TravelName)); doc.Add("CreateTime", new SolrInputField("CreateTime", travle.CreateTime)); doc.Add("UpdateTime", new SolrInputField("UpdateTime", travle.UpdateTime)); doc.Add("CoverImage", new SolrInputField("CoverImage", travle.CoverImage)); docs.Add(doc); var result = updateOperations.Update(CoreName, "/update", new UpdateOptions() { OptimizeOptions = optimizeOptions, Docs = docs }); var header = binaryResponseHeaderParser.Parse(result); return(header.Status); //返回状态码。0表示成功 }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Travels model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Travels set "); strSql.Append("UserId=@UserId,"); strSql.Append("TravelName=@TravelName,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("CoverImage=@CoverImage,"); strSql.Append("IsDelete=@IsDelete"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@TravelName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CoverImage", SqlDbType.VarChar, 100), new SqlParameter("@IsDelete", SqlDbType.Bit, 1), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.TravelName; parameters[2].Value = model.CreateTime; parameters[3].Value = model.UpdateTime; parameters[4].Value = model.CoverImage; parameters[5].Value = model.IsDelete; parameters[6].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public HomePage() { _travels = new ObservableCollection <Travel>(); this.InitializeComponent(); LoaderProgressRing.IsActive = true; Task.Run(() => { return(TravelService.GetAllTravelsAsync()); }).ContinueWith(x => { foreach (var travel in x.Result.Take(MaxElements)) { Travels.Add(travel); } LoaderProgressRing.IsActive = false; }, TaskScheduler.FromCurrentSynchronizationContext()); }
public async Task Save(Travels entity) { try { if (entity.ID_Travels == 0) { await TravelsRepository.Add(entity); } else { await TravelsRepository.UpdateAsync(entity); } } catch (UniqueKeyException ex) { throw new Exception("Cannot insert or update a value duplicate" + ex); } catch (Exception ex) { throw new Exception("Cannot add a register" + ex); } }
public async Task Add(Travels entity) { try { var con = await OpenAsync(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = $"INSERT INTO {TABLE} (NU_TravelCode, NU_NumberOfPlace, TX_Destination, TX_Origin, NU_Price) " + $"VALUES ({entity.NU_TravelCode},{entity.NU_NumberOfPlace}, '{entity.TX_Destination}', '{entity.TX_Origin}', {entity.NU_Price.ToString().Replace(',', '.')});"; await cmd.ExecuteNonQueryAsync(); Close(con); } catch (SqlException ex) when(ex.Number == 2627) { throw new UniqueKeyException($"{TAG}: {ex.Message}"); } catch (Exception ex) { throw ex; } }
public string Create(string userId, string travelName) { if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(travelName)) { return(HttpRequestResult.StateNotNull); } int useridInt; if (Int32.TryParse(userId, out useridInt) && useridInt > 0) { var model = new Travels { TravelName = travelName, UserId = useridInt, IsDelete = false, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; var flag = _travelsBll.Add(model); return(flag > 0 ? HttpRequestResult.StateOk : HttpRequestResult.StateError); } return(HttpRequestResult.StateError); }
private TravelsDTO ToDTO(Travels r) { TravelsDTO dto = new TravelsDTO(); dto.content = r.content; dto.Id = r.Id; dto.title = r.title; dto.shenhe = r.shenhe; dto.tops = r.tops; dto.shenhe = r.shenhe; using (Dbcontext ctx = new Dbcontext()) { BaseService <User> bs = new BaseService <User>(ctx); var user = bs.GetById(r.Uid); if (user != null) { dto.UNickName = user.NickName; } } dto.CreateDateTime = r.CreateDateTime; dto.Id = r.Id; return(dto); }
/// <summary> /// 得到一个对象实体 /// </summary> public Travels GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserId,TravelName,CreateTime,UpdateTime,CoverImage,IsDelete from Travels "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; Travels model = new Travels(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public async Task <Travels> UpdateAsync(Travels entity, params object[] Id) { try { var con = await OpenAsync(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = $"UPDATE {TABLE} SET NU_TravelCode = {entity.NU_TravelCode}, NU_NumberOfPlace = {entity.NU_NumberOfPlace}, " + $"TX_Destination = '{entity.TX_Destination}', TX_Origin = '{entity.TX_Origin}', NU_Price = {entity.NU_Price.ToString().Replace(',', '.')} " + $"WHERE ID_Travels = { entity.ID_Travels }"; await cmd.ExecuteNonQueryAsync(); Close(con); return(entity); } catch (SqlException ex) when(ex.Number == 2627) { throw new UniqueKeyException($"{TAG}: {ex.Message}"); } catch (Exception ex) { throw ex; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Travels model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Travels("); strSql.Append("UserId,TravelName,CreateTime,UpdateTime,CoverImage,IsDelete)"); strSql.Append(" values ("); strSql.Append("@UserId,@TravelName,@CreateTime,@UpdateTime,@CoverImage,@IsDelete)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@TravelName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CoverImage", SqlDbType.VarChar, 100), new SqlParameter("@IsDelete", SqlDbType.Bit, 1) }; parameters[0].Value = model.UserId; parameters[1].Value = model.TravelName; parameters[2].Value = model.CreateTime; parameters[3].Value = model.UpdateTime; parameters[4].Value = model.CoverImage; parameters[5].Value = model.IsDelete; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Travels model) { return(dal.Update(model)); }
public ActionResult Create(Trip trip) { if (ModelState.IsValid) { if (trip.Start > trip.Finish) { ModelState.AddModelError("", "Дата початку має бути раніше за дату кінця"); return View(); } if (Math.Abs(trip.Start.Year - DateTime.Now.Year) >100) { ModelState.AddModelError("", "Неправильно введена дата початку"); return View(); } if (Math.Abs(trip.Finish.Year - DateTime.Now.Year) > 100) { ModelState.AddModelError("", "Неправильно введена дата кінця"); return View(); } using (var db = new RazomContext()) { HttpCookie cookie = Request.Cookies[FormsAuthentication.FormsCookieName]; FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(cookie.Value); Users user = db.Users.Where(u => u.Login == ticket.Name).SingleOrDefault(); Travels t = new Travels { DateStart = trip.Start, DateFinish = trip.Finish, Name = trip.Name }; db.Travels.Add(t); db.SaveChanges(); db.History.Add(new History { UserID = user.UserID, TravelID = t.TravelID }); db.SaveChanges(); return RedirectToAction("Show", "Trip", new { id = t.TravelID }); } } return View(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Travels model) { return(dal.Add(model)); }
public void Test_Default_CTR() { Travels Japan = new Travels(); }