public HttpResponseMessage AddActualHours([FromBody] ActualHours value, [FromUri] int userId)
        {
            if (ModelState.IsValid)
            {
                return((LogicHours.AddActualHours(value, userId)) ?
                       new HttpResponseMessage(HttpStatusCode.Created) :
                       new HttpResponseMessage(HttpStatusCode.BadRequest)
                {
                    Content = new ObjectContent <String>("Can not add to DB", new JsonMediaTypeFormatter())
                });
            }
            ;

            List <string> ErrorList = new List <string>();

            //if the code reached this part - the ActualHours 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 AddActualHours(ActualHours actualHours)
      {
          try
          {
              var httpWebRequest = (HttpWebRequest)WebRequest.Create("http://localhost:56028/api/Hours/AddActualHours/" + Global.UserId);
              httpWebRequest.ContentType           = "application/json";
              httpWebRequest.Method                = "POST";
              ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls;

              using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
              {
                  string json = new JavaScriptSerializer().Serialize(actualHours);
                  streamWriter.Write(json);
                  streamWriter.Flush();
                  streamWriter.Close();
              }

              var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
              if (httpResponse.StatusCode == HttpStatusCode.Created)
              {
                  return(true);
              }
              else
              {
                  return(false);
              }
          }
          catch (Exception ex)
          {
              MessageBox.Show("error", ex.Message.ToString());
              return(false);
          }
      }
Esempio n. 3
0
        public double GetTotalActualHour()
        {
            if (!ActualHours.IsEmpty())
            {
                return(ActualHours.Sum(o => o.Value));
            }

            return(0);
        }
Esempio n. 4
0
        private void addActulHoursToWorker()
        {  //-----------------------------צריך לסכום את מספר השעות!!!!!!!!!!!!------------
            ActualHours actualHours = new ActualHours()
            {
                CountHours = time, date = DateTime.Now, UserId = Global.UserId, ProjectId = projectId
            };

            HoursRequst.AddActualHours(actualHours);
        }
Esempio n. 5
0
        internal QueryParameters ToApiParameters(bool toCreate)
        {
            var parameters = new QueryParameters();

            parameters.Add("summary", Summary, toCreate);
            parameters.Add("issueTypeId", Type.Id, toCreate);
            parameters.Add("priorityId", Priority.Id, toCreate);

            parameters.Add("description", Description ?? "");
            parameters.Add("dueDate", DueDate?.ToString("yyyy-MM-dd") ?? "");
            parameters.Add("startDate", StartDate?.ToString("yyyy-MM-dd") ?? "");
            parameters.AddRange("categoryId[]", Categories.Select(x => x.Id));
            parameters.AddRange("versionId[]", Versions.Select(x => x.Id));
            parameters.AddRange("milestoneId[]", Milestones.Select(x => x.Id));
            parameters.AddRange("attachmentId[]", Attachments.Select(x => x.Id));
            parameters.Add("parentIssueId", ParentTicketId?.ToString() ?? "");
            parameters.Add("estimatedHours", EstimatedHours?.ToString() ?? "");
            parameters.Add("actualHours", ActualHours?.ToString() ?? "");
            parameters.Add("assigneeId", Assignee?.Id.ToString() ?? "");

            if (!toCreate)
            {
                parameters.Add("statusId", Status?.Id.ToString() ?? "");
                parameters.Add("resolutionId", Resolution?.Id.ToString() ?? "");
            }

            if (CustomFields != null)
            {
                foreach (var field in CustomFields)
                {
                    parameters.Add($"customField_{field.Id}", field.ToJsonValue());
                    if (field.OtherValue != null)
                    {
                        parameters.Add($"customField_{field.Id}_otherValue", field.OtherValue);
                    }
                }
            }

            return(parameters);
        }
        public static bool AddActualHours(ActualHours actualHours, int userId)
        {
            string query = $"INSERT INTO `tasks`.`actual_hours`(`user_id`, `project_id`, `count_houers`, `date`) VALUES ('{actualHours.UserId}','{actualHours.ProjectId}','{actualHours.CountHours}','{actualHours.date.Year}-{actualHours.date.Month}-{actualHours.date.Day}')";

            return(DBaccess.RunNonQuery(query) == 1);
        }