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