// 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())));
}
