// PUT: api/Users/5 public HttpResponseMessage Put([FromBody] DailyPresence value) { if (ModelState.IsValid) { return((LogicDailyPresence.UpdateDailyPresence(value)) ? new HttpResponseMessage(HttpStatusCode.OK) : new HttpResponseMessage(HttpStatusCode.BadRequest) { Content = new ObjectContent <String>("Can not update in DB", new JsonMediaTypeFormatter()) }); } ; List <string> ErrorList = new List <string>(); //if the code reached this part - the user is not valid foreach (var item in ModelState.Values) { foreach (var err in item.Errors) { ErrorList.Add(err.ErrorMessage); } } return(new HttpResponseMessage(HttpStatusCode.BadRequest) { Content = new ObjectContent <List <string> >(ErrorList, new JsonMediaTypeFormatter()) }); }
public static bool UpdateDailyPresence(DailyPresence daliyPresence) { //check if first time or only update end time string formatForMySqlEndDatePresence = daliyPresence.EndDatePresence.ToString("yyyy-MM-dd HH:mm:ss"); string query = $"SELECT distinct d2.idDaliyPresence FROM truth_time_ct.daily_presence as d2 where d2.idUserProject ={ daliyPresence.IdUserProjectFK} and d2.startDatePresence = d2.endDatePresence;";