public List GetListById(int listId)
{
using (var db = new PingPingEntities())
{
return(db.List.Find(listId));
}
}
public User GetUserByUserName(string uname)
{
using (var db = new PingPingEntities())
{
return(db.User.Where(o => o.UserName.Equals(uname)).FirstOrDefault());
}
}
public User GetUserById(int uid)
{
using (var db = new PingPingEntities())
{
return(db.User.Find(uid));
}
}
public List <List> GetAllList()
{
using (var db = new PingPingEntities())
{
return(db.List.Where(o => o.Statue == 1).ToList());
}
}
public bool Update(User_List ul)
{
using (var db = new PingPingEntities())
{
var ulNew = db.User_List.Where(o => o.UserID == ul.UserID && o.ListID == ul.ListID).FirstOrDefault();
ulNew.Type = ul.Type;
return(db.SaveChanges() == 1 ? true : false);
}
}
public bool Delete(int uid)
{
using (var db = new PingPingEntities())
{
var u = db.User.Find(uid);
u.Status = 0;
return(db.SaveChanges() == 1 ? true : false);
}
}
public bool Add(List list)
{
using (var db = new PingPingEntities())
{
list.Statue = 1;
db.List.Add(list);
return(db.SaveChanges() == 1 ? true : false);
}
}
public List <List> GetListByDateAndEndAdress(double end_x, double end_y, DateTime date)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where o.Departure_Date == date.Date && (double)o.EndPoint_x == end_x && (double)o.EndPoint_y == end_y
select o;
return(list.ToList());
}
}
public List <List> GetTodayList()
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where o.Departure_Date == DateTime.Today
select o;
return(list.ToList());
}
}
public List <List> GetListByAdress(double start_x, double strart_y)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where (double)o.StartPoint_x == start_x && (double)o.StartPoint_y == strart_y
select o;
return(list.ToList());
}
}
public bool Add(User_List ul)
{
using (var db = new PingPingEntities())
{
ul.Time = DateTime.Now;
ul.Status = 1;
db.User_List.Add(ul);
return(db.SaveChanges() == 1 ? true : false);
}
}
public List <User> GetUserAll()
{
using (var db = new PingPingEntities())
{
var userList = from o in db.User
where o.Status == 1
select o;
return(userList.ToList());
}
}
public List <User_List> GetUserListByUserId(int uid)
{
using (var db = new PingPingEntities())
{
var ul = from o in db.User_List
where o.UserID == uid
select o;
return(ul.ToList());
}
}
public int GetUserIdByListId(int lid)
{
using (var db = new PingPingEntities())
{
var ul = from o in db.User_List
where o.ListID == lid && o.Status == 1
select o;
return(ul.FirstOrDefault().UserID);
}
}
public bool Add(User user)
{
using (var db = new PingPingEntities())
{
user.RegisterTime = DateTime.Now;
user.Status = 1;
db.User.Add(user);
return(db.SaveChanges() == 1 ? true : false);
}
}
public List <List> GetListByDate(DateTime date)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where o.Departure_Date == date.Date
select o;
return(list.ToList());
}
}
public List <List> GetListByAdress(double start_x, double strart_y, double end_x, double end_y, int scope)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where Math.Abs((double)o.StartPoint_x - start_x) < scope / 10000.0 && Math.Abs((double)o.StartPoint_y - strart_y) < scope / 10000.0 && (double)o.EndPoint_x == end_x && (double)o.EndPoint_y == end_y
select o;
return(list.ToList());
}
}
public List <List> GetListById(int[] listId)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where listId.Contains(o.ListID)
select o;
return(list.ToList());
}
}
public List <User_List> GetUserListAndListByUserId(int uid, int type)
{
using (var db = new PingPingEntities())
{
var ul = from o in db.User_List.Include("List")
where o.UserID == uid && o.Type == type && o.Status == 1
select o;
return(ul.Count() == 0 ? null : ul.ToList());
}
}
public User_List GetUserListById(int uid, int lid)
{
using (var db = new PingPingEntities())
{
var ul = from o in db.User_List
where o.UserID == uid && o.ListID == lid
select o;
return(ul.Count() == 0 ? null : ul.First());
}
}
public bool Update(User user)
{
using (var db = new PingPingEntities())
{
var u = db.User.Find(user.UserID);
u.Password = user.Password;
u.Sex = user.Sex;
u.Tel = user.Tel;
return(db.SaveChanges() == 1 ? true : false);
}
}
public User GetUser(string userName, string password)
{
using (var db = new PingPingEntities())
{
var u = from o in db.User
where o.UserName == userName && o.Password == password && o.Status == 1
select o;
return(u.Count() == 0 ? null : u.First());
//return db.User.Where(o => o.UserName == userName && o.Password == password && o.Status == 1).FirstOrDefault();
}
}
public bool Delete(int uid, int lid)
{
using (var db = new PingPingEntities())
{
var u = db.User_List.Where(o => o.UserID == uid && o.ListID == lid).FirstOrDefault();
if (u != null)
{
u.Status = 0;
}
return(db.SaveChanges() == 1 ? true : false);
}
}
public List <List> GetListByAdress(double start_x, double strart_y, double end_x, double end_y, DateTime date, TimeSpan time)
{
using (var db = new PingPingEntities())
{
var list = from o in db.List
where (double)o.StartPoint_x == start_x && (double)o.StartPoint_y == strart_y &&
(double)o.EndPoint_x == end_x && (double)o.EndPoint_y == end_y &&
o.Departure_Date == date && o.Departure_Time == time
select o;
return(list.ToList());
}
}
public bool Update(List list)
{
using (var db = new PingPingEntities())
{
var o = db.List.Find(list.ListID);
o.StartAdress = list.StartAdress;
o.StartPoint_x = list.StartPoint_x;
o.StartPoint_y = list.StartPoint_y;
o.EndAdress = list.EndAdress;
o.EndPoint_x = list.EndPoint_x;
o.EndPoint_y = list.EndPoint_y;
o.Departure_Date = list.Departure_Date;
o.Departure_Time = list.Departure_Time;
o.Sex = list.Sex;
o.Contacts = list.Contacts;
o.detail = list.detail;
return(db.SaveChanges() == 1 ? true : false);
}
}
