public static ResultModel VerifySD(string issueNumber, string userName, string password)
        {
            ResultModel result = new ResultModel();

            try
            {
                using (JiraSoapServiceService jiraService = new JiraSoapServiceService())
                {
                    var token = jiraService.login(userName, password);
                    result.Success = true;
                }
            }

            catch (Exception)
            {
                result.Success = false;
                result.Message = "This SD does not Exist";
            }

            return result;
        }
        public static ResultModel LogWork(List<ExcelEntryModel> entries)
        {
            ResultModel result = new ResultModel();

            try
            {

                using (JiraSoapServiceService jiraService = new JiraSoapServiceService())
                {
                    foreach (var entry in entries)
                    {
                        if (!entry.IssueNumber.Equals("SD-00001"))
                        {
                            try
                            {
                                jiraService.addWorklogAndAutoAdjustRemainingEstimate(_token, entry.IssueNumber, new RemoteWorklog()
                                {
                                    startDate = entry.Date,
                                    timeSpent = entry.BilledMinutes + "m",
                                    comment = entry.ActivitiesPerformed,
                                });
                            }
                            catch (Exception Ex)
                            {

                            }
                        }
                    }
                }

                result.Success = true;

            }
            catch (InvalidCastException ex)
            {
            }
            catch (Exception ex)
            {
                result.Success = false;
                result.Message = ex.Message;
            }

            return result;
        }