public IHttpActionResult Put(int ID, [FromBody] UserModel.UpdateModel upmodel) { if (!ModelState.IsValid || upmodel == null) { return(Content(HttpStatusCode.BadRequest, "Invald Update data.")); } else { try { UserModel model = new UserModel(); WebApplication2201802_dbEntities1 dbEntity = new WebApplication2201802_dbEntities1(); USERTABLE user = dbEntity.USERTABLE.Find(ID); user.UpdateAt = DateTime.Parse(DateTime.UtcNow.AddHours(8).ToString()); user.Arrived = "Yes"; model.Update(ID, user, upmodel); Debug.WriteLine("update success"); return(Ok()); } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, "Update fail.")); } } }
public IHttpActionResult Put(Int32 ID) { if (!ModelState.IsValid) { return(Content(HttpStatusCode.BadRequest, "Invald Clear data.")); } else { try { UserModel model = new UserModel(); WebApplication2201802_dbEntities1 dbEntity = new WebApplication2201802_dbEntities1(); USERTABLE user = dbEntity.USERTABLE.Find(ID); Debug.WriteLine("-------------" + user.UserName); user.UpdateAt = DateTime.Parse(DateTime.UtcNow.AddHours(8).ToString()); user.Arrived = "No"; user.TagID = Int64.Parse("0"); model.Clear(ID, user); Debug.WriteLine("Clear success"); return(Ok()); } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, "Clear fail.")); } } }
public void Create(CreateModel dataModel) { using (WebApplication2201802_dbEntities1 dbEntity = new WebApplication2201802_dbEntities1()) { USERTABLE newUser = new USERTABLE(); newUser.UserId = dataModel.Id; newUser.UserName = dataModel.Name; newUser.AGE = dataModel.Age; newUser.Arrived = dataModel.Arrived; newUser.CreateAt = DateTime.Parse(DateTime.UtcNow.AddHours(8).ToString()); newUser.UpdateAt = DateTime.Parse(DateTime.UtcNow.AddHours(8).ToString()); //newOrder.Deleted = false; dbEntity.USERTABLE.Add(newUser); dbEntity.SaveChanges(); } }
public List <DetailModel> GetAll() { using (WebApplication2201802_dbEntities1 dbEntity = new WebApplication2201802_dbEntities1()) { var L2Enty = from c in dbEntity.USERTABLE orderby c.UserId descending select c; return(L2Enty.Select(s => new DetailModel() { Id = (int)s.UserId, Name = s.UserName, Age = s.AGE, Arrived = s.Arrived, CreateTime = s.CreateAt, UpdateTime = s.UpdateAt, TagId = (long)s.TagID }).Take(50).ToList <DetailModel>()); } }
public void Update(int id, USERTABLE newUser, UpdateModel upmodel) { using (WebApplication2201802_dbEntities1 dbEntity = new WebApplication2201802_dbEntities1()) { USERTABLE origin_User = dbEntity.USERTABLE.Find(id); Debug.WriteLine(origin_User.UserId + " " + origin_User.UserName + " " + origin_User.UpdateAt); //dbEntity.USERTABLE.AddOrUpdate(User); /*update_User.UpdatedAt = DateTime.Parse(DateTime.UtcNow.AddHours(8).ToString()); * * if (update_User.Enroll == 0) * { * update_User.Enroll = 1; * }*/ Debug.WriteLine("TagId : " + upmodel.TagId); Debug.WriteLine(newUser.UserId + " " + newUser.UserName + " " + newUser.UpdateAt); //dbEntity.Entry(newUser).CurrentValues.SetValues(origin_User); try { origin_User.UserId = newUser.UserId; origin_User.UserName = newUser.UserName; origin_User.AGE = newUser.AGE; origin_User.Arrived = newUser.Arrived; origin_User.CreateAt = newUser.CreateAt; origin_User.UpdateAt = newUser.UpdateAt; origin_User.TagID = upmodel.TagId; //Debug.WriteLine(dbEntity.Entry(update_User).CurrentValues); Debug.WriteLine(origin_User.UserId + " " + origin_User.UserName + " " + origin_User.UpdateAt + " " + origin_User.TagID); //dbEntity.USERTABLE.Attach(origin_User); //dbEntity.Entry(origin_User).State = EntityState.Modified; //dbEntity.SaveChangesAsync(); dbEntity.SaveChanges(); //Debug.WriteLine(origin_User.UserID + " " + origin_User.UserName + " " + origin_User.Enroll + " " + origin_User.UpdatedAt); } catch (Exception e) { Debug.WriteLine(e); } } }