public List <Code> QueryCodeView(string pageStr, string limitStr, string product, string platform, string alias, out int total) { int page = Convert.ToInt32(pageStr); int limit = Convert.ToInt32(limitStr); IEnumerable <Code> subCode = dal.GetAll <Code>(); if (alias != null) { subCode = from m in subCode where dal.GetEntities <CodeOwnership>(c => c.Type == "code" && c.support_alias == alias).Any(x => x.FkId == m.id) == true select m; } if (product != null) { subCode = subCode.Where(c => (c.Products != null ? c.Products.ToLower().Contains(product + ":") : false)); } if (platform != null) { subCode = subCode.Where(c => (c.Platform != null ? c.Platform.ToLower().Contains(platform + ":") : false)); } total = subCode.Count(); if (page != 0 || limit != 0) { page = page == 0 ? 1 : page; subCode = subCode.Skip((page - 1) * limit).Take(limit); } return(subCode.ToList()); }
private List <Issue> QueryIssueView(string pageStr, string limitStr, string alias, string type, out int total) { var issues = dal.GetAll <Issue>(); int page = Convert.ToInt32(pageStr); int limit = Convert.ToInt32(limitStr); IEnumerable <Issue> subIssue = dal.GetAll <Issue>(); if (alias != null) { subIssue = from m in subIssue where dal.GetEntities <CodeOwnership>(c => c.Type == "issue" && c.support_alias == alias).Any(x => x.FkId == m.id) == true select m; } if (type != null) { subIssue = subIssue.Where(c => (c.Type != null ? c.Type.ToLower().Contains(type.ToLower()) : false)); } total = subIssue.Count(); if (page != 0 || limit != 0) { page = page == 0 ? 1 : page; subIssue = subIssue.Skip((page - 1) * limit).Take(limit); } return(subIssue.ToList()); }
// GET api/<controller>/5 public IHttpActionResult Get(int fkid, string type) { var entities = dal.GetEntities <CodeOwnership>(c => c.FkId == fkid && c.Type == type).OrderByDescending(c => c.LogAt).FirstOrDefault(); if (entities != null) { return(Ok(entities.support_alias)); } else { return(null); } }
// POST: api/IssueStatus public HttpStatusCodeResult Post([FromBody] IssueStatusView value) { if (!ModelState.IsValid) { var errors = ModelState.Values.SelectMany(v => v.Errors).Select(e => e.Exception); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, string.Join(" | ", errors))); } IssueStatusLog log = new IssueStatusLog(); log.IssueID = value.IssueID; log.IssueStatusID = dal.GetEntities <IssueStatu>(c => c.name == value.IssueStatusName).FirstOrDefault().id; log.LogAt = DateTime.UtcNow; dal.AddOrUpdate <IssueStatusLog>(log, c => c.IssueID == value.IssueID, Basic.ToDictionary <IssueStatusLog>(log)); return(new HttpStatusCodeResult(HttpStatusCode.OK)); }
// GET api/<controller>/5 public List <Platform> Get(int id) { return(dal.GetEntities <Platform>(c => c.id == id)); }
// GET api/<controller>/5 public List <UTLog> Get(int fkid, string type) { return(dal.GetEntities <UTLog>(c => c.FkId == fkid && c.Type == type)); }
public static PageCodeView GetCodeView(List <Code> codes, int total) { PageCodeView pageview = new PageCodeView(); BasicCRUD dal = new BasicCRUD(); try { List <CodeView> views = new List <CodeView>(); pageview.Total = total; CodeView view = new CodeView(); foreach (var item in codes) { view = new CodeView(); view.ID = item.id; view.Author = item.Author; view.Description = item.Description; view.GitHubUrl = item.GitHubUrl; view.LastUpateDate = item.LastUpdateDate; view.Link = item.Link; var takeTimeEntity = dal.GetEntities <CodeOwnership>(c => c.FkId == item.id && c.Type == "code").OrderByDescending(c => c.LogAt).FirstOrDefault(); if (takeTimeEntity != null) { var takeTime = takeTimeEntity.LogAt; view.NewCommit = Basic.ConvertCommitToCommitView(dal.GetEntities <Commit>(c => item.GitHubUrl.IndexOf(c.GitHubUrl) >= 0 && c.CreateAt >= takeTime), dal); var newissues = dal.GetEntities <Issue>(c => c.CodeID == item.id && c.CreateAt >= takeTime); view.NewIssue = Basic.ConvertIssueToIssueView(newissues, dal, newissues.Count()); } int?ut = 0; foreach (var c in dal.GetEntities <UTLog>(c => c.Type == "code" && c.FkId == item.id)) { ut += c.UT; } view.UT = ut; view.Platforms = Basic.stringToList(item.Platform); view.Products = Basic.stringToList(item.Products); view.SyncDate = item.SyncDate; view.Title = item.Title; var alias = dal.GetEntities <CodeOwnership>(c => c.FkId == item.id && c.Type == "code").ToList().FirstOrDefault(); view.Alias = alias != null ? alias.support_alias : null; var process = dal.GetEntities <ProcessLog>(c => c.FkId == item.id && c.Type == "code").OrderByDescending(c => c.LogAT).FirstOrDefault(); if (process != null) { view.Process = dal.GetEntities <Process>(c => c.id == process.ProcessID).First().name; } else { view.Process = "Pending"; } views.Add(view); } pageview.Views = views; } catch (Exception) { throw; } return(pageview); }
// GET api/<controller>/5 public IHttpActionResult Get(int id) { var result = dal.GetEntities <Process>(c => c.id == id); return(Ok(result)); }