public ActionResult SaveComments(string key, string comment) { var results = listIssues.Where(x => x.key == key).FirstOrDefault(); results.comment = comment; chia = new ChiaDetails(); chia.issueInfo = listIssues; ViewBag.From = from; ViewBag.To = to; ViewBag.DeptList = DeptList; ViewBag.SelectedDept = SelectedDept; using (OleDbConnection connection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "App_Data\\CommentsDB.accdb"))) { try { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE CHIAComments SET Comments = ? WHERE key = ?"; cmd.Parameters.Add("@p1", OleDbType.VarChar).Value = comment; cmd.Parameters.Add("@p2", OleDbType.VarChar).Value = key; cmd.Connection = connection; connection.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { TempData["ErrorMessage"] = ErrorMessage = e.Message; } } return(View(chia)); }
public ActionResult GetChiaList() { if (Session["userName"] != null) { if (Getdata == 1) { try { Getdata = 0; return(View("GetChiaList", GettingCHIAIssues())); } catch (Exception e) { TempData["ErrorMessage"] = "Error in fetching data Check your internet connection and try again "; return(View("GetChiaList")); } } else { chia = new ChiaDetails(); chia.issueInfo = listIssues; chia.DeptList = DeptList; ViewBag.From = from; ViewBag.To = to; ViewBag.DeptList = DeptList; ViewBag.SelectedDept = SelectedDept; return(View(chia)); } } else { return(View("Login")); } }
public void WhenClickOnSort() { var obj = new ChiaApplicationController(); var actResult = obj.GetChiaList() as ViewResult; ChiaDetails chiaDetails = (ChiaDetails)actResult.Model; Assert.That(chiaDetails.issueInfo.Count > 0); Assert.That(actResult.View, Is.EqualTo(null)); }
public void ValidUserNamePassword() { var obj = new ChiaApplicationController(); LoginModel uspw = new LoginModel(); uspw.UserName = "******"; uspw.Password = "******"; var actResult = obj.GetChia(uspw) as ViewResult; ChiaDetails model = (ChiaDetails)actResult.Model; Assert.That(actResult.ViewName, Is.EqualTo("GetChiaList")); Assert.That(model.FromDate, Is.EqualTo(null)); Assert.That(model.ToDate, Is.EqualTo(null)); Assert.That(model.issueInfo.Count, Is.EqualTo(0)); }
public ChiaDetails GettingCHIAIssues() { Dictionary <string, string> CommentDict = new Dictionary <string, string>(); ViewBag.From = from; ViewBag.To = to; ViewBag.DeptList = DeptList; ViewBag.SelectedDept = SelectedDept; string teams = "("; for (int k = 0; k < SelectedDept.Length; k++) { if (SelectedDept[k] != null) { if (k > 0) { teams = teams + " OR "; } teams = teams + "\"Originating Team\" ~ " + SelectedDept[k]; } } teams = teams + ")"; string url = "https://jira3.cerner.com/rest/api/2/search?jql=project = CHIA AND issuetype = Assessment AND createdDate >=" + "'" + from + "'" + " AND createdDate<=" + "'" + to + "'" + " AND Assessment = \"CHIA Required\" AND status != Reviewed AND " + teams + " &maxResults=1000"; WebRequest myReq = WebRequest.Create(url); string credentials = user + ":" + pwd; myReq.Headers["Authorization"] = "Basic " + Convert.ToBase64String(Encoding.ASCII.GetBytes(credentials)); WebResponse wr = myReq.GetResponse(); Stream receiveStream = wr.GetResponseStream(); StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8); string content = reader.ReadToEnd(); Rootobjectdetails = JsonConvert.DeserializeObject <Rootobject>(content); getComments(ref CommentDict); listIssues = new List <ChiaIssueDetails>(); for (int i = 0; i < Rootobjectdetails.issues.Length; i++) { Dictionary <string, string> CRList = new Dictionary <string, string>(); chiaobj = new ChiaIssueDetails(); chiaobj.key = Rootobjectdetails.issues[i].key; chiaobj.summary = Rootobjectdetails.issues[i].fields.summary.ToString(); chiaobj.createdDate = Rootobjectdetails.issues[i].fields.created.Date.ToShortDateString(); chiaobj.status = Rootobjectdetails.issues[i].fields.status.name.ToString(); chiaobj.CHIA_Id = Rootobjectdetails.issues[i].fields.customfield_13331 == null ? "NA" : Rootobjectdetails.issues[i].fields.customfield_13331.ToString(); chiaobj.compliance_Analyst = Rootobjectdetails.issues[i].fields.customfield_13310 == null ? "NA" : Rootobjectdetails.issues[i].fields.customfield_13310.displayName.ToString(); chiaobj.age = (int)Math.Floor((DateTime.Now - Rootobjectdetails.issues[i].fields.created.Date).TotalDays); getremotelinks(chiaobj.key.ToString(), ref CRList); var results = CommentDict.Where(x => x.Key == chiaobj.key).FirstOrDefault(); if (results.Key != null) { chiaobj.comment = results.Value; } else { createDatabaseEntry(chiaobj.key); } if (CRList.Count == 0) { chiaobj.CHIA_CR = ""; chiaobj.CR_url = ""; } else { foreach (var obj in CRList) { chiaobj.CHIA_CR = obj.Key; chiaobj.CR_url = obj.Value; } } listIssues.Add(chiaobj); } chia = new ChiaDetails(); listIssues = listIssues.OrderByDescending(o => o.status).ThenBy(o => o.createdDate).ToList(); chia.issueInfo = listIssues; return(chia); }