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