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