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