// 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;";
