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());
}
public IHttpActionResult Get()
{
var paras = ControllerContext.Request.GetQueryNameValuePairs();
string page = paras.Where(c => c.Key == "page").FirstOrDefault().Value;
string limit = paras.Where(c => c.Key == "limit").FirstOrDefault().Value;
string product = paras.Where(c => c.Key == "product").FirstOrDefault().Value;
string platform = paras.Where(c => c.Key == "platform").FirstOrDefault().Value;
string alias = paras.Where(c => c.Key == "alias").FirstOrDefault().Value;
var codes = dal.GetAll <Code>();
int total;
List <Code> queryCodes = QueryCodeView(page, limit, product, platform, alias, out total);
var pageview = DAL.DALGenerateView.GetCodeView(queryCodes, total);
return(Ok(pageview));
}
/// <summary>
/// sync commit to database
/// </summary>
/// <param name="value"></param>
// POST api/<controller>
public IHttpActionResult Post()
{
var codes = dal.GetAll <Code>();
foreach (var item in codes)
{
GitAPI gitApi = new GitAPI();
gitApi.GetGitHubCommitObject(item.GitHubUrl).ConvertToCommit(gitApi.CommitBody, item.id).InsertToDatabase(gitApi.Commits, dal, item.GitHubUrl);
}
return(Ok());
}
// GET api/<controller>
public string Get()
{
string str = "";
foreach (var item in dal.GetAll <Process>())
{
str += item.name + ",";
}
str = str.Substring(0, str.Length - 1);
return(str);
}
// GET: api/IssueStatus
public IHttpActionResult Get()
{
string str = "";
foreach (var item in dal.GetAll <IssueStatu>())
{
str += item.name + ",";
}
str = str.Substring(0, str.Length - 1);
return(Ok(str));
}
/// <summary>
/// sync all issues to database
/// </summary>
/// <param name="value"></param>
// POST api/<controller>
public HttpStatusCodeResult Post()
{
if (!ModelState.IsValid)
{
var errors = ModelState.Values.SelectMany(v => v.Errors).Select(e => e.Exception);
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, string.Join(" | ", errors)));
}
var codes = dal.GetAll <Code>();
foreach (var item in codes)
{
GitAPI api = new GitAPI();
api.GetGitHubIssueObject(item.GitHubUrl).ConvertToIssue(api.issueBody, item.id).InsertToDatabase(api.issues, dal);
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
// GET api/<controller>
public IEnumerable <Platform> Get()
{
return(dal.GetAll <Platform>());
}