public async Task <bool> InsertUserWork(UserWorks userWorks)
{
await getContext().AddAsync(userWorks);
await getContext().SaveChangesAsync();
return(true);
}
public void EndTime(int id)
{
var userWork = UserWorks.GetByID(id);
userWork.EndTime = DateTime.Now;
UserWorks.Update(userWork);
}
public int StartTime(string username, string title)
{
UserWork userWork = new UserWork();
userWork.Username = username;
userWork.Title = title;
userWork.StartTime = DateTime.Now;
UserWorks.Insert(userWork);
return(userWork.ID);
}
public static long UpdateUserWorks(UserWorks dr)
{
using (ContestEntities db = new ContestEntities())
{
UserWorks file = db.UserWorks.SingleOrDefault(p => p.UserWorksID == dr.UserWorksID);
file.Flag = dr.Flag;
file.Relationship = dr.Relationship;
file.UserID = dr.UserID;
file.WorksID = dr.WorksID;
db.SaveChanges();
return(1);
}
}
public static long InsertUserWorks(UserWorks dr)
{
using (ContestEntities db = new ContestEntities())
{
UserWorks file = new UserWorks();
file.Flag = dr.Flag;
file.Relationship = dr.Relationship;
file.UserID = dr.UserID;
file.WorksID = dr.WorksID;
db.UserWorks.Add(file);
db.SaveChanges();
return(file.UserWorksID);
}
}
public JsonResult Delete(int id)
{
var jsonSuccessResult = new JsonSuccessResult();
try
{
UserWorks.Delete(id);
jsonSuccessResult.Success = true;
}
catch (Exception ex)
{
jsonSuccessResult.Errors = new string[] { ex.Message };
jsonSuccessResult.Success = false;
}
return(new JsonResult()
{
Data = jsonSuccessResult
});
}
public JsonResult Get(int pageIndex, int pageSize, string pageOrder, string username)
{
if (pageOrder.Trim() == "ID")
{
pageOrder = "LastUpdate desc";
}
var list = UserWorks.Get(pageIndex,
pageSize,
pageOrder,
username);
int total = UserWorks.Count(username);
int totalPage = (int)Math.Ceiling((decimal)total / pageSize);
if (pageSize > total)
{
pageSize = total;
}
if (list.Count < pageSize)
{
pageSize = list.Count;
}
JsonResult result = new JsonResult()
{
Data = new
{
TotalPages = totalPage,
PageIndex = pageIndex,
PageSize = pageSize,
Rows = list
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
return(result);
}
public List <UserWork> GetLatestByUsername(string username)
{
return(UserWorks.GetByUsername(username));
}
