public HttpResponseMessage Post([FromBody] Task value) { if (ModelState.IsValid) { if (LogicTask.CheckIfExists(value)) { return(Request.CreateResponse(HttpStatusCode.Found, "Worker already exists in this project.")); } return((LogicTask.AddTask(value)) ? Request.CreateResponse(HttpStatusCode.Created) : Request.CreateResponse(HttpStatusCode.BadRequest, "Can not add to DB.")); } ; 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(Request.CreateResponse(HttpStatusCode.BadRequest, ErrorList)); }
public async Task <LogicTask> Get(int id) { await using var con = new SqlConnection(_connectionString); await using var com = new SqlCommand(Select_Query, con); var idParameter = new SqlParameter("@Id", SqlDbType.Int, sizeof(int)).Value = id as object; com.Parameters.Add(idParameter); var reader = await com.ExecuteReaderAsync(); var logicTask = new LogicTask(); DefaultMapper(reader, logicTask); return(logicTask); }
public async Task <List <LogicTask> > GetList() { await using var con = new SqlConnection(_connectionString); await using var com = new SqlCommand(GetList_Query, con); SqlDataReader reader = await com.ExecuteReaderAsync(); var logicTasks = new List <LogicTask>(); while (reader.Read()) { var logicTask = new LogicTask(); DefaultMapper(reader, logicTask); logicTasks.Add(logicTask); } return(logicTasks); }
/// <summary> /// Adds a timer that when elapsed will add the given task to tasks for logic. /// </summary> /// <param name="task"></param> protected void SetInboundTimer(LogicTask task) { //default interval int interval = 2500; //milliseconds // Create a timer with other interval. if (task is InboundLogicTask) { interval = ((InboundLogicTask)task).GetInterval(); } System.Timers.Timer aTimer = new System.Timers.Timer(interval); InboundTimers.Add(aTimer); // Hook up the Elapsed event for the timer. aTimer.Elapsed += (e, v) => { logicTasks.Add(task); InboundTimers.Remove(aTimer); aTimer.Dispose(); }; aTimer.Enabled = true; }
public HttpResponseMessage Put([FromBody] Task value) { if (ModelState.IsValid) { return((LogicTask.UpdateTask(value)) ? Request.CreateResponse(HttpStatusCode.OK) : Request.CreateResponse(HttpStatusCode.BadRequest, "Can not update in DB")); } ; 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(Request.CreateResponse(HttpStatusCode.BadRequest, ErrorList)); }
public HttpResponseMessage GetWorkerTasksDictionary(int id) { return(Request.CreateResponse(HttpStatusCode.OK, LogicTask.GetWorkerTasksDictionary(id))); }
public HttpResponseMessage GetTasksWithUserAndProjectByUserId(int userId) { return(Request.CreateResponse(HttpStatusCode.OK, LogicTask.GetTasksWithUserAndProjectByUserId(userId))); }
public void DefaultMapper(IDataReader reader, LogicTask entity) { entity.Id = (int)reader["Id"]; entity.Description = reader["Descrition"].ToString(); }