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