// GENERIC CRUD will be coded here.... /// <summary> /// Extracts the query string. /// </summary> /// <param name="param1">The param1.</param> /// <param name="param2">The param2.</param> /// <returns></returns> protected DBParamEntity ExtractQueryString(ref int param1, ref int param2) { var queryString = Request.Query; var page = queryString.FirstOrDefault(w => w.Key.Equals("page")); var limit = queryString.FirstOrDefault(w => w.Key.Equals("limit")); var filter = queryString.FirstOrDefault(w => w.Key.Equals("filter")); var sort = queryString.FirstOrDefault(w => w.Key.Equals("sort")); var group = queryString.FirstOrDefault(w => w.Key.Equals("group")); if (String.IsNullOrEmpty(page.Value) == false) { int.TryParse(page.Value, out param1); } if (String.IsNullOrEmpty(limit.Value) == false) { int.TryParse(limit.Value, out param2); } var dbParamEntity = new DBParamEntity { Page = param1, Limit = param2 }; if (String.IsNullOrEmpty(filter.Value) == false) { dbParamEntity.Filter = JsonConvert.DeserializeObject <List <FilterDBParamEntity> >(filter.Value); } if (String.IsNullOrEmpty(sort.Value) == false) { dbParamEntity.Sort = JsonConvert.DeserializeObject <List <SortDBParamEntity> >(sort.Value); } //if (String.IsNullOrEmpty(group.Value) == false) //{ // //dbParamEntity.Group = JsonConvert.DeserializeObject<List<GroupDBParamEntity>>(group.Value); // // this is special behavior of ExtJS grouping feature on the Gridpanel // // so need to handle with care, to make it gridpanel grouping working fine // // ----------------------------------------------------------------------------------- // var groupBy = JsonConvert.DeserializeObject<GroupDBParamEntity>(group.Value); // // do not add to sort list when the property already on the list // if (dbParamEntity.Sort.Count(w => w.Property.Equals(groupBy.Property)) == 0) // { // dbParamEntity.Sort.Add(new SortDBParamEntity // { // Property = groupBy.Property, // Direction = groupBy.Direction // }); // } // dbParamEntity.Sort.Reverse(); // // ----------------------------------------------------------------------------------- //} //dbParamEntity.QueryStringEntity = UtilityHelper.GetFromQueryString<PredefinedQueryStringEntity>(); return(dbParamEntity); }
public int GetTotalRows(DBParamEntity dbParamEntity) { var query = @"SELECT COUNT(""ID"") FROM ""PromoImage"" {{Filter}}"; query = query.Replace("{{Filter}}", ExtractFilter(dbParamEntity)); return(DbConnection.Query <int>(query).Single()); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var appmessageDA = new AppMessageDA()) { validationResult.Value = appmessageDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var promoplacelocationDA = new PromoPlaceLocationDA()) { validationResult.Value = promoplacelocationDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var usercontentblockedDA = new UserContentBlockedDA()) { validationResult.Value = usercontentblockedDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var reportcontentDA = new ReportContentDA()) { validationResult.Value = reportcontentDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var parkingspacepriceDA = new ParkingSpacePriceDA()) { validationResult.Value = parkingspacepriceDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var placecategoryDA = new PlaceCategoryDA()) { validationResult.Value = placecategoryDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var eventimageDA = new EventImageDA()) { validationResult.Value = eventimageDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var countryDA = new CountryDA()) { validationResult.Value = countryDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <CountryEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <CountryEntity> >(); using (var countryDA = new CountryDA()) { validationResult.Value = countryDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var schedulersessionDA = new SchedulerSessionDA()) { validationResult.Value = schedulersessionDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <SchedulerSessionEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <SchedulerSessionEntity> >(); using (var schedulersessionDA = new SchedulerSessionDA()) { validationResult.Value = schedulersessionDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <PlaceUserImageEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <PlaceUserImageEntity> >(); using (var placeuserimageDA = new PlaceUserImageDA()) { validationResult.Value = placeuserimageDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <AdEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <AdEntity> >(); using (var adDA = new AdDA()) { validationResult.Value = adDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var userfavoriteDA = new UserFavoriteDA()) { validationResult.Value = userfavoriteDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <PlaceCategoryEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <PlaceCategoryEntity> >(); using (var placecategoryDA = new PlaceCategoryDA()) { validationResult.Value = placecategoryDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <EmailQueueEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <EmailQueueEntity> >(); using (var emailqueueDA = new EmailQueueDA()) { validationResult.Value = emailqueueDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <ParkingSpacePriceEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <ParkingSpacePriceEntity> >(); using (var parkingspacepriceDA = new ParkingSpacePriceDA()) { validationResult.Value = parkingspacepriceDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var emailqueueDA = new EmailQueueDA()) { validationResult.Value = emailqueueDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <ReportContentEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <ReportContentEntity> >(); using (var reportcontentDA = new ReportContentDA()) { validationResult.Value = reportcontentDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <EventCategoryEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <EventCategoryEntity> >(); using (var eventcategoryDA = new EventCategoryDA()) { validationResult.Value = eventcategoryDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <UserContentBlockedEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <UserContentBlockedEntity> >(); using (var usercontentblockedDA = new UserContentBlockedDA()) { validationResult.Value = usercontentblockedDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <PromoPlaceLocationEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <PromoPlaceLocationEntity> >(); using (var promoplacelocationDA = new PromoPlaceLocationDA()) { validationResult.Value = promoplacelocationDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var useradministratorDA = new UserAdministratorDA()) { validationResult.Value = useradministratorDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <UserFavoriteEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <UserFavoriteEntity> >(); using (var userfavoriteDA = new UserFavoriteDA()) { validationResult.Value = userfavoriteDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <int> GetTotalRows(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <int>(); using (var trackingDA = new TrackingDA()) { validationResult.Value = trackingDA.GetTotalRows(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <TrackingEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <TrackingEntity> >(); using (var trackingDA = new TrackingDA()) { validationResult.Value = trackingDA.GetAll(dbParamEntity); } return(validationResult); }
public ResultEntity <IEnumerable <UserAdminParkingEntity> > GetAll(DBParamEntity dbParamEntity) { var validationResult = new ResultEntity <IEnumerable <UserAdminParkingEntity> >(); using (var useradminparkingDA = new UserAdminParkingDA()) { validationResult.Value = useradminparkingDA.GetAll(dbParamEntity); } return(validationResult); }
public IEnumerable <PromoImageEntity> GetAll(DBParamEntity dbParamEntity) { var query = @"SELECT ""ID"",""IsMain"",""PromoID"",""Content"",""ModifiedDate"",""Checksum"" FROM ""PromoImage"" {{Filter}} {{Sorting}} {{Paging}}"; query = query.Replace("{{Filter}}", ExtractFilter(dbParamEntity)); query = query.Replace("{{Sorting}}", ExtractSort(dbParamEntity)); query = query.Replace("{{Paging}}", ExtractPaging(dbParamEntity)); var promoimageEntity = DbConnection.Query <PromoImageEntity>(query); return(promoimageEntity); }