public JsonResult AddSave(T_MainInfo model)
{
DateTime now = DateTime.Now;
DateTime minTime = model.DepartureTime.AddMinutes(-15);
DateTime maxTime = model.DepartureTime.AddMinutes(15);
if (model.DepartureTime < now)
{
return(Json(new { state = "Fail", msg = "请发布时间大于现在的行程" }));
}
T_MainInfo exisModel = db.T_MainInfo.FirstOrDefault(a => a.Driver == model.Driver && a.DepartureTime > minTime && a.DepartureTime < maxTime);
if (exisModel == null)
{
model.FreeSeat = model.SeatNumber;
model.PostTime = DateTime.Now;
db.T_MainInfo.Add(model);
try
{
db.SaveChanges();
return(Json(new { state = "Success", msg = "保存成功" }));
}
catch (Exception e)
{
return(Json(new { state = "Fail", msg = e.Message }));
}
}
else
{
return(Json(new { state = "Fail", msg = "您在该时间点附近已建立行程 ，请合理建立行程安排" }));
}
}
public JsonResult CancelSave(int ID)
{
string name = Server.UrlDecode(Request.Cookies["name"].Value);
//string name = "黄幸&夕影";
T_MainInfo maininfo = db.T_MainInfo.Find(ID);
if (name == maininfo.Driver)
{
maininfo.IsCancel = 1;
}
else
{
return(Json(new { state = "Fail", msg = "不允许取消他人发布的行程" }));
}
db.Entry <T_MainInfo>(maininfo).State = System.Data.Entity.EntityState.Modified;
try
{
db.SaveChanges();
return(Json(new { state = "Success", msg = "保存成功,请记得与相关小伙伴联系，通知您已取消本次行程哦" }));
}
catch (Exception e)
{
return(Json(new { state = "Fail", msg = e.Message }));
}
}
//
public JsonResult JoinSave(int ID)
{
string Passenger = Server.UrlDecode(Request.Cookies["name"].Value);
string Tel = Server.UrlDecode(Request.Cookies["mobile"].Value);
T_MainDetail existMainDetail = db.T_MainDetail.FirstOrDefault(a => a.PID == ID && a.Passenger == Passenger);
if (existMainDetail != null)
{
return(Json(new { state = "Fail", msg = "您已加入该行程，请勿重复哦" }));
}
T_MainInfo maininfo = db.T_MainInfo.Find(ID);
if (maininfo.FreeSeat == 0)
{
return(Json(new { state = "Fail", msg = "小伙伴已经满了哦，请选择其他行程加入" }));
}
maininfo.FreeSeat = maininfo.FreeSeat - 1;
if (maininfo.Passengers == null)
{
maininfo.Passengers = Passenger;
}
else
{
maininfo.Passengers = maininfo.Passengers + "," + Passenger;
}
db.Entry <T_MainInfo>(maininfo).State = System.Data.Entity.EntityState.Modified;
T_MainDetail mainDetail = new T_MainDetail()
{
Passenger = Passenger,
PostTime = DateTime.Now,
PID = ID,
Tel = Tel
};
db.T_MainDetail.Add(mainDetail);
try
{
db.SaveChanges();
return(Json(new { state = "Success", msg = "保存成功,记得及时与车主取得联系哦" }));
}
catch (Exception e)
{
return(Json(new { state = "Fail", msg = e.Message }));
}
}
//
public JsonResult CancelJoinSave(int ID)
{
string name = Server.UrlDecode(Request.Cookies["name"].Value);
//string name = "黄幸&夕影";
T_MainInfo maininfo = db.T_MainInfo.Find(ID);
maininfo.FreeSeat = maininfo.FreeSeat + 1;
maininfo.Passengers = maininfo.Passengers.Replace(name, "").Replace(",,", ",");
T_MainDetail deleteMainDetail = db.T_MainDetail.FirstOrDefault(a => a.Passenger == name && a.PID == ID);
db.T_MainDetail.Remove(deleteMainDetail);
db.Entry <T_MainInfo>(maininfo).State = System.Data.Entity.EntityState.Modified;
try
{
db.SaveChanges();
return(Json(new { state = "Success", msg = "保存成功,请记得与相关小伙伴联系，通知您已取消本次行程哦" }));
}
catch (Exception e)
{
return(Json(new { state = "Fail", msg = e.Message }));
}
}