// POST: api/Tour public IHttpActionResult Post([FromBody] ActivitySearch valFilter) { string vResult = "3"; IActivityData vActivityData = new ActivityData(); try { bool vNullField = VerifyNullFiledsSearch(valFilter); if (vNullField) { vResult = "1"; return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vListContainNullValue, Result = vResult }))); } string vResponse = vActivityData.SelectByTour(valFilter); if (!string.IsNullOrEmpty(vResponse)) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vOkListed, Result = vResponse }))); } vResult = "2"; return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NoContent, Message = Messages.vNotListed, Result = vResult }))); } catch (Exception) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.BadRequest, new { Code = HttpStatusCode.BadRequest, Message = Messages.vInternalServerError, Result = vResult }))); } }
public DbQueryResult GetDiscountQuery(ActivitySearch query) { StringBuilder builder = new StringBuilder("1=1 "); if (query.status != ActivityStatus.All) { if (query.status == ActivityStatus.In) { builder.AppendFormat("and [BeginTime] <= '{0}' and [EndTime] >= '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } else if (query.status == ActivityStatus.End) { builder.AppendFormat("and [EndTime] < '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } else if (query.status == ActivityStatus.unBegin) { builder.AppendFormat("and [BeginTime] > '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } } if (query.begin.HasValue) { builder.AppendFormat("and [BeginTime] >= '{0}'", query.begin.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if (query.end.HasValue) { builder.AppendFormat("and [EndTime] <= '{0}'", query.end.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(query.Name)) { builder.AppendFormat("and ActivityName like '%{0}%' ", query.Name); } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_hishop_DiscountList", "LimitedTimeDiscountId", builder.ToString(), "*")); }
private void CountTotal() { ActivitySearch activitySearch = new ActivitySearch(); activitySearch.status = ActivityStatus.All; activitySearch.IsCount = true; activitySearch.PageIndex = this.pager1.PageIndex; activitySearch.PageSize = this.pager1.PageSize; activitySearch.SortBy = "ActivitiesId"; activitySearch.SortOrder = SortAction.Desc; DbQueryResult dbQueryResult = ActivityHelper.Query(activitySearch); System.Data.DataTable dataTable = (System.Data.DataTable)dbQueryResult.Data; this.lblAll.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.In; dbQueryResult = ActivityHelper.Query(activitySearch); dataTable = (System.Data.DataTable)dbQueryResult.Data; this.lblIn.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.End; dbQueryResult = ActivityHelper.Query(activitySearch); dataTable = (System.Data.DataTable)dbQueryResult.Data; this.lblEnd.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); activitySearch.status = ActivityStatus.unBegin; dbQueryResult = ActivityHelper.Query(activitySearch); dataTable = (System.Data.DataTable)dbQueryResult.Data; this.lblUnBegin.Text = ((dataTable != null) ? dataTable.Rows.Count.ToString() : "0"); }
private long GetTotalRowsFilter(ActivitySearch valFilter) { long vResult = 0; DataTable vDatainTable = new DataTable(); SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); try { if (valFilter.DateStart == DateTime.MinValue) { valFilter.DateStart = new DateTime(1753, 1, 1); } List <SqlParameter> vParameterList = new List <SqlParameter> { new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()), new SqlParameter("@IdTour", valFilter.IdTour.ToString()), new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()), new SqlParameter("@DateStart", valFilter.DateStart), new SqlParameter("@MinimumPeople", valFilter.MinimumPeople), new SqlParameter("@RowsPerPage", valFilter.RowsPerPage), new SqlParameter("@PageNumber", valFilter.PageNumber) }; TourResponse vModel = new TourResponse(); vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity_Filter_Total", vConnection); vResult = DataTableToListFilterTotal(vDatainTable); } catch (Exception vEx) { string vMessage = vEx.Message; } return(vResult); }
public string SelectByTour(ActivitySearch valFilter) { string vResult = string.Empty; DataTable vDatainTable = new DataTable(); SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); try { if (valFilter.DateStart == DateTime.MinValue) { valFilter.DateStart = new DateTime(1753, 1, 1); } List <SqlParameter> vParameterList = new List <SqlParameter> { new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()), new SqlParameter("@IdTour", valFilter.IdTour.ToString()), new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()), new SqlParameter("@DateStart", valFilter.DateStart), new SqlParameter("@MinimumPeople", valFilter.MinimumPeople), new SqlParameter("@RowsPerPage", valFilter.RowsPerPage), new SqlParameter("@PageNumber", valFilter.PageNumber) }; ActivityResponse vModel = new ActivityResponse(); vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity_Filter", vConnection); List <Activity> vData = DataTableToListFilter(vDatainTable); vModel.Activities = vData; vModel.TotalRows = GetTotalRowsFilter(valFilter); if (vModel.Activities != null & vModel.Activities.Count > 0) { vResult = JsonConvert.SerializeObject(vModel, Formatting.Indented); } } catch (Exception vEx) { string vMessage = vEx.Message; vResult = string.Empty; } return(vResult); }
private void BindData() { string text = this.txtActivityName.Text; DateTime? selectedDate = this.calendarStartDate.SelectedDate; DateTime? nullable2 = this.calendarEndDate.SelectedDate; ActivitySearch query = new ActivitySearch { status = (ActivityStatus)this.status, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "LimitedTimeDiscountId", SortOrder = SortAction.Desc, Name = text, begin = selectedDate, end = nullable2 }; DbQueryResult discountQuery = LimitedTimeDiscountHelper.GetDiscountQuery(query); DataTable data = (DataTable)discountQuery.Data; this.grdLimitedTimeDiscountList.DataSource = data; this.grdLimitedTimeDiscountList.DataBind(); this.pager1.TotalRecords = discountQuery.TotalRecords; this.CountTotal(); }
public IActionResult SearchResult(ActivitySearch searchModel) { IList <Activity> activities = activityDao.GetAllActivities(searchModel.Neighborhood); searchModel.ActivityResults = activities; return(View(searchModel)); }
private void BindData() { string text = this.txt_name.Text; DateTime?selectedDate = null; DateTime?nullable2 = null; selectedDate = this.calendarStartDate.SelectedDate; nullable2 = this.calendarEndDate.SelectedDate; ActivitySearch query = new ActivitySearch { status = (ActivityStatus)this._status, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "ActivitiesId", SortOrder = SortAction.Desc, Name = text, begin = selectedDate, end = nullable2 }; DbQueryResult result = ActivityHelper.Query(query); DataTable data = (DataTable)result.Data; if (data != null) { data.Columns.Add("sStatus"); if (data.Rows.Count > 0) { for (int i = 0; i < data.Rows.Count; i++) { DateTime time = DateTime.Parse(data.Rows[i]["StartTime"].ToString()); DateTime time2 = DateTime.Parse(data.Rows[i]["EndTime"].ToString()); if (time > DateTime.Now) { data.Rows[i]["sStatus"] = "未开始"; } else if (time2 < DateTime.Now) { data.Rows[i]["sStatus"] = "已结束"; } else { data.Rows[i]["sStatus"] = "进行中"; } } } } this.grdCoupondsList.DataSource = data; this.grdCoupondsList.DataBind(); this.pager1.TotalRecords = result.TotalRecords; this.CountTotal(); }
public void FindNotContentType() { var search = new ActivitySearch(); search.NotContentTypes.Add("somethingRandom"); var result = service.SimpleSearchAsync(search).Result; Assert.Equal(4, result.Count); Assert.Equal(4, result.Count(x => x.contentType != "somethingRandom")); search.NotContentTypes.Add(unit.commonContent.type); result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.contentType != unit.commonContent.type)); }
public void FindContentType() { var search = new ActivitySearch() { ContentType = unit.commonContent.type }; var result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.contentType == unit.commonContent.type)); search.ContentType = "somethingRandom"; result = service.SimpleSearchAsync(search).Result; Assert.Empty(result); }
public void FindOnlyType() { var search = new ActivitySearch() { ActivityType = Keys.TypeNames[Keys.ContentType] }; var result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.type == Keys.TypeNames[Keys.ContentType])); search.ActivityType = Keys.TypeNames[Keys.UserType]; result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.type == Keys.TypeNames[Keys.UserType])); }
private bool VerifyNullFiledsSearch(ActivitySearch valActivitySearch) { bool vResult = false; if (valActivitySearch.IdTour == Guid.Empty || valActivitySearch.IdTour == null) { vResult = true; return(vResult); } if (valActivitySearch.IdLanguage == Guid.Empty || valActivitySearch.IdLanguage == null) { vResult = true; return(vResult); } if (valActivitySearch.IdCurrency == Guid.Empty || valActivitySearch.IdCurrency == null) { vResult = true; return(vResult); } return(vResult); }
public void FindNotType() { var search = new ActivitySearch(); search.NotActivityTypes.Add(Keys.TypeNames[Keys.UserType]); var result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.type != Keys.TypeNames[Keys.UserType])); search.NotActivityTypes.Add(Keys.TypeNames[Keys.ContentType]); result = service.SimpleSearchAsync(search).Result; Assert.Empty(result); search.NotActivityTypes.Remove(Keys.TypeNames[Keys.UserType]); result = service.SimpleSearchAsync(search).Result; Assert.Equal(2, result.Count); Assert.Equal(2, result.Count(x => x.type != Keys.TypeNames[Keys.ContentType])); }
private void CountTotal() { ActivitySearch query = new ActivitySearch { status = ActivityStatus.All, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "LimitedTimeDiscountId", SortOrder = SortAction.Desc }; DataTable data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblAll.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.In; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblIn.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.End; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblEnd.Text = (data != null) ? data.Rows.Count.ToString() : "0"; query.status = ActivityStatus.unBegin; data = (DataTable)LimitedTimeDiscountHelper.GetDiscountQuery(query).Data; this.lblUnBegin.Text = (data != null) ? data.Rows.Count.ToString() : "0"; }
public static DbQueryResult GetDiscountQuery(ActivitySearch query) { return(_act.GetDiscountQuery(query)); }
public static DbQueryResult Query(ActivitySearch query) { return(_act.Query(query)); }
public static DbQueryResult GetDiscountQuery(ActivitySearch query) { return(LimitedTimeDiscountHelper._act.GetDiscountQuery(query)); }
public Task <ActionResult <List <ActivityAggregateView> > > GetAggregateAsync([FromQuery] ActivitySearch search) { return(ThrowToAction(() => service.SearchAggregateAsync(search, GetRequesterNoFail()))); }