public IHttpActionResult AddBugQuery([FromBody] JObject value)
{
int id = (int)value["UserId"];
int countryId = (int)value["CountryId"];
string registeredEmail = value["RegisteredEmail"].ToString();
string sellerIdOrASIN = value["SellerIdOrASIN"].ToString();
decimal price = (decimal)value["Price"];
string serviceName = value["ServiceName"].ToString();
BugQuery bug = new BugQuery
{
UserId = id,
CountryId = countryId,
RegisteredEmail = registeredEmail,
SellerIdOrAsin = sellerIdOrASIN,
Price = price,
State = 1,
ServiceName = serviceName,
SubTime = DateTime.Now
};
entities.BugQuery.Add(bug);
int result = entities.SaveChanges();
if (result > 0)
{
return(Ok(Respone.Success("提交成功")));
}
else
{
return(Ok(Respone.No("发生了点问题，请稍后再试")));
}
}
void UpsertVstsBugToDb(SqlConnection sqlConnection, BugQuery bugQuery, int bugCount)
{
var cmd = new SqlCommand
{
Connection = sqlConnection,
CommandType = CommandType.StoredProcedure,
CommandText = "UpsertVstsBug"
};
cmd.Parameters.Add(new SqlParameter("@Title", bugQuery.Title));
cmd.Parameters.Add(new SqlParameter("@AreaPath", bugQuery.Area));
cmd.Parameters.Add(new SqlParameter("@Priority", bugQuery.BugPriorityGrouping.Priority));
cmd.Parameters.Add(new SqlParameter("@InProgress", bugQuery.InProgress));
cmd.Parameters.Add(new SqlParameter("@BugCount", bugCount));
cmd.ExecuteNonQuery();
}
public IHttpActionResult Get([FromUri] BugQuery query)
{
if (query.Status == null && query.Date != null)
{
var allBugs = this.bugService.AllAfterDate(query.Date.Value);
return(this.Ok(allBugs));
}
else if (query.Status != null && query.Date == null)
{
var allBugs = this.bugService.AllByStatus(query.Status.Value);
return(this.Ok(allBugs));
}
else if (query.Status != null & query.Date != null)
{
var allBugs = this.bugService.AllByDateAndStatus(query);
return(this.Ok(allBugs));
}
var all = this.bugService.All();
return(this.Ok(all));
}
public IQueryable <Bug> AllByDateAndStatus(BugQuery query)
{
return(this.bugs.All().Where(b => b.LogDate >= query.Date && b.Status == query.Status));
}
