public UserInfo GetUserInfo(int userId)
{
OmeiTravelEntities db = new OmeiTravelEntities();
UserInfo dt = (from d in db.UserInfoSet
where d.userId == userId
select d).FirstOrDefault();
return dt;
}
public bool CheckUniqueEmail(string email)
{
OmeiTravelEntities db = new OmeiTravelEntities();
UserInfo ui = (from d in db.UserInfoSet
where d.email == email
select d).FirstOrDefault();
return ui == null;
}
public ActionResult List(TourTypeEnum id)
{
byte tt = Convert.ToByte(id);
OmeiTravelEntities db = new OmeiTravelEntities();
var tours = from t in db.TourSet
where t.status==1 && ( tt==0 || t.TourType == tt)
select t;
return View(tours.OrderBy(t=>t.TourDay).ThenBy(t=>t.tourOrder).ToList());
}
public ActionResult TourDestinations(int id)
{
OmeiTravelEntities db = new OmeiTravelEntities();
var td = from d in db.v_tourDestinationSet
where d.tourId == id
orderby d.visitDate, d.visitOrder
select d;
return View(td.ToList());
}
public ActionResult List(TourTypeEnum id)
{
byte tt = Convert.ToByte(id);
DateTime startDate = DateTime.Now;
OmeiTravelEntities db = new OmeiTravelEntities();
var schedules = (from s in db.V_scheduleSet
where (tt==0 || s.TourType==tt) && s.startDate>=startDate
select s).Take(30);
return View(schedules.ToList());
}
public ActionResult Detail(int id)
{
OmeiTravelEntities db = new OmeiTravelEntities();
Tour dt = (from d in db.TourSet
where d.TourID == id
select d).FirstOrDefault();
var td = from d in db.v_tourDestinationSet
where d.tourId == id
orderby d.visitDate, d.visitOrder
select d;
ViewData["TourDestinations"] = td.ToList();
return View(dt);
}
public ActionResult Detail(int id)
{
OmeiTravelEntities db = new OmeiTravelEntities();
Destination dt = (from d in db.DestinationSet
where d.DestinationID == id
select d).FirstOrDefault();
var relate = from td in db.TourDestinationSet
join d in db.TourSet on td.tourId equals d.TourID
where td.destinationId == id
select new { d.TourID, d.TourName };
ViewData["relate"] = relate;
return View(dt);
}
public bool AddUser(UserInfo userInfo)
{
ErrorCode = -1;
if (!CheckUniqueEmail(userInfo.email))
{
ErrorMessage = "Email already exist.";
return false;
}
userInfo.userId = 0;
userInfo.userType = 0;
userInfo.addDate = userInfo.updateDate = DateTime.Now;
OmeiTravelEntities db = new OmeiTravelEntities();
db.AddToUserInfoSet(userInfo);
db.SaveChanges();
ErrorCode = 0;
return true;
}
public ActionResult Index()
{
OmeiTravelEntities db = new OmeiTravelEntities();
return View(db.FlightSet.Select(f=>f.status>0).ToList());
}
public ActionResult Index()
{
OmeiTravelEntities db = new OmeiTravelEntities();
return View(db.DestinationSet.OrderBy(d=>d.DestinationName).ToList());
}
/// <summary>
/// UserLogin
/// </summary>
/// <param name="email"></param>
/// <param name="password"></param>
/// <returns>userID, 0 for null email or password, -1 for email not exist, -2 for password incorrect.</returns>
public int UserLogin(string email, string password)
{
if (email == null || password == null || email == string.Empty || password == string.Empty)
return 0;
OmeiTravelEntities db = new OmeiTravelEntities();
UserInfo ui = (from d in db.UserInfoSet
where d.email == email
select d).FirstOrDefault();
if (ui != null && ui.userId > 0)
{
if (ui.pin == password)
return ui.userId;
else
return -2;
}
else
return -1;
}
