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();
}
