public bool Update(Stadium model) { try { using (var context = new YueDongEntities()) { var result = context.Stadia.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.UpdateTime = model.UpdateTime; result.Address = model.Address; result.Name = model.Name; result.OpenEndTime = model.OpenEndTime; result.OpenStartTime = model.OpenStartTime; result.Phone = model.Phone; result.Price = model.Price; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Insert(FreeTime model) { try { using (var context = new YueDongEntities()) { context.FreeTimes.Add(model); return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Insert(CommonPicture model) { try { using (var context = new YueDongEntities()) { context.CommonPictures.Add(model); return context.SaveChanges() > 0; } } catch (Exception e) { } return false; }
public List <Message> GetListByBatch(string batch) { try { using (var context = new YueDongEntities()) { var result = context.Messages.Where(a => a.Status > 0 && a.MessageBatch == batch); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <Message>()); }
public Message GetSingleById(Guid Id) { try { using (var context = new YueDongEntities()) { var result = context.Messages.Where(a => a.Status > 0 && a.Id == Id); if (result.Any()) { return(result.FirstOrDefault()); } } } catch (Exception e) { } return(null); }
public CommonPicture GetSingleByUserId(Guid Id) { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.Where(a => a.Status > 0 && a.UserId.Value == Id); if (result.Any()) { return(result.FirstOrDefault()); } } } catch (Exception e) { } return(null); }
public List <FreeTime> GetListByUserId(Guid UserId) { try { using (var context = new YueDongEntities()) { var result = context.FreeTimes.Where(a => a.Status > 0 && a.UserId == UserId); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <FreeTime>()); }
public CommonUser GetSingleByName(string name) { try { using (var context = new YueDongEntities()) { var result = context.CommonUsers.Where(a => a.Status > 0 && a.UserName == name); if (result.Any()) { return(result.FirstOrDefault()); } } } catch (Exception e) { } return(null); }
public List <CommonPicture> GetList() { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.Where(a => a.Status > 0); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <CommonPicture>()); }
public List <SportRecord> GetListByUserId(Guid Id) { try { using (var context = new YueDongEntities()) { var result = context.SportRecords.Where(a => a.Status > 0 && a.UserId.Value == Id); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <SportRecord>()); }
public List <Message> GetListByUserId(Guid UserId) { try { using (var context = new YueDongEntities()) { var result = context.Messages.Where(a => a.Status > 0).Where(a => a.FromWho.Value == UserId || a.ToWho.Value == UserId); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <Message>()); }
public CommonPicture GetSingleByUserId(Guid Id) { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.Where(a => a.Status > 0 && a.UserId.Value == Id); if (result.Any()) { return result.FirstOrDefault(); } } } catch (Exception e) { } return null; }
public List<CommonPicture> GetList() { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.Where(a => a.Status > 0); if (result.Any()) { return result.ToList(); } } } catch (Exception e) { } return new List<CommonPicture>(); }
public bool DeleteByUserIdAndWeekTime(FreeTime time) { try { using (var context = new YueDongEntities()) { var result = context.FreeTimes.Where(a => a.Status > 0 && a.UserId == time.UserId && time.Week == a.Week.Value && a.StartTime.Value.ToString("HH:mm") == time.StartTime.Value.ToString("HH:mm") && a.EndTime.Value.ToString("HH:mm") == time.EndTime.Value.ToString("HH:mm")); if (result.Any()) { result.FirstOrDefault().Status = 0; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public List <Stadium> GetListByKeyWord(string keyword) { try { using (var context = new YueDongEntities()) { var result = context.Stadia.Where(a => a.Status > 0).Where(a => a.Name.Contains(keyword) || a.Address.Contains(keyword) ); if (result.Any()) { return(result.ToList()); } } } catch (Exception e) { } return(new List <Stadium>()); }
public bool Update(SportRecord model) { try { using (var context = new YueDongEntities()) { var result = context.SportRecords.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.UpdateTime = model.UpdateTime; result.SportLastTime = model.SportLastTime; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Update(CommonPicture model) { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.CreateTime = model.CreateTime; result.FileData = model.FileData; result.UserId = model.UserId; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Update(FreeTime model) { try { using (var context = new YueDongEntities()) { var result = context.FreeTimes.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.StartTime = model.StartTime; result.EndTime = model.EndTime; result.Week = model.Week; result.UpdateTime = model.UpdateTime; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Update(CommonUser model) { try { using (var context = new YueDongEntities()) { var result = context.CommonUsers.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.Password = model.Password; result.Age = model.Age; result.Gender = model.Gender; result.Hobby = model.Hobby; result.NickName = model.NickName; result.UpdateTime = model.UpdateTime; } return(context.SaveChanges() > 0); } } catch (Exception e) { } return(false); }
public bool Update(CommonPicture model) { try { using (var context = new YueDongEntities()) { var result = context.CommonPictures.FirstOrDefault(a => a.Id == model.Id); if (result != null) { result.CreateTime = model.CreateTime; result.FileData = model.FileData; result.UserId = model.UserId; } return context.SaveChanges() > 0; } } catch (Exception e) { } return false; }