public ActionResult GetListFilter(string StoreId) { FilterResponseModel result = new FilterResponseModel(); FilterFactory _fac = new FilterFactory(); try { result.ListTable = _fac.GetListTable(Commons._StoreId, Commons.AppKey, Commons.AppSecret); result.ListZone = _fac.GetListZone(Commons._StoreId, Commons.AppKey, Commons.AppSecret); result.ListPrinter = _fac.GetListPrinter(Commons._StoreId, Commons.AppKey, Commons.AppSecret); if (result.ListZone != null && result.ListZone.Any()) { result.ListZone = result.ListZone.OrderBy(x => x.Name).ToList(); } if (result.ListTable != null && result.ListTable.Any()) { result.ListTable = result.ListTable.OrderBy(x => x.Name).ToList(); } if (result.ListPrinter != null && result.ListPrinter.Any()) { result.ListPrinter = result.ListPrinter.OrderBy(x => x.PrinterName).ToList(); } } catch (Exception ex) { NSLog.Logger.Error("GetListFilter_Error: ", ex); } var jsonResult = Json(result, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult);// Json(result, JsonRequestBehavior.AllowGet); }
public async Task <FilterResponseModel <ProjectLineTableViewModel> > GetProjectsFilterdAsync(FilterProjectLinesModel filter, string userId) { var result = new FilterResponseModel <ProjectLineTableViewModel>(); var userRole = _context.Users .Include(x => x.UserRoles) .First(x => x.Id == userId) .UserRoles .FirstOrDefault(); var query = _context.ProjectLines .Include(x => x.Project) .Include(x => x.Status) .ProjectTo <ProjectLineTableViewModel>(_mapper.ConfigurationProvider) .AsQueryable(); query = FilterProjects(query, filter); var allRecordsCount = await query.CountAsync(); // for pagination query = query.FilterByParams(filter); var resultData = await query.ToListAsync(); if (userRole != null) { resultData = await SetToNullNotAllowedPropertiesAsync(resultData, userRole.RoleId); } result.Data = resultData; result.Total = allRecordsCount; return(result); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputAcceptModel> listAccepts = null; MCodeCom mCodeCom = null; OutputAcceptModel accept = null; // Variable initialize responseModel = new FilterResponseModel(); listAccepts = new List <OutputAcceptModel>(); mCodeCom = new MCodeCom(); // Get value var slipStatusName = string.Empty; var paymentMethodsName = string.Empty; var deleteFlagName = string.Empty; var cbSlipStatus = new ComboModel(); foreach (var obj in resultObject.ListAccepts) { accept = new OutputAcceptModel(); accept.AcceptSlipNo = DataHelper.ToString(obj.AcceptSlipNo); accept.SlipStatus = DataHelper.ToString(obj.SlipStatus); slipStatusName = mCodeCom.GetCodeName(Logics.GROUP_SLIP_STATUS, accept.SlipStatus); accept.SlipStatusName = DataHelper.ToString(slipStatusName); accept.AcceptDate = DataHelper.ToString(Formats.DATE, obj.AcceptDate); accept.DeliveryDate = DataHelper.ToString(Formats.DATE, obj.DeliveryDate); accept.ClientCd = DataHelper.ToString(obj.ClientCd); accept.ClientName = DataHelper.ToString(obj.ClientName); accept.ClientAddress = DataHelper.ToString(obj.ClientAddress); accept.ClientTel = DataHelper.ToString(obj.ClientTel); accept.DeliveryCd = DataHelper.ToString(obj.DeliveryCd); accept.DeliveryName = DataHelper.ToString(obj.DeliveryName); accept.DeliveryAddress = DataHelper.ToString(obj.DeliveryAddress); accept.DeliveryTel = DataHelper.ToString(obj.DeliveryTel); accept.PaymentMethods = DataHelper.ToString(obj.PaymentMethods); paymentMethodsName = mCodeCom.GetCodeName(Logics.GROUP_PAYMENT_METHODS, accept.PaymentMethods); accept.PaymentMethodsName = DataHelper.ToString(paymentMethodsName); accept.GiftCd = DataHelper.ToString(obj.GiftCd); accept.ViewId = DataHelper.ToString(obj.ViewId); accept.Notes = DataHelper.ToString(obj.Notes); accept.UpdateUser = DataHelper.ToString(obj.UpdateUser); accept.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); accept.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, accept.DeleteFlag); accept.DeleteFlagName = DataHelper.ToString(deleteFlagName); cbSlipStatus = MCodeCom.ToComboItems(resultObject.ListSlipStatus, accept.SlipStatus); accept.ListSlipStatus = cbSlipStatus.ListItems; accept.SlipStatus = cbSlipStatus.SeletedValue; listAccepts.Add(accept); } // Set value responseModel.ListAccepts = listAccepts; // Return value return(responseModel); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputItemModel> listItems = null; MCodeCom mCodeCom = null; OutputItemModel item = null; // Variable initialize responseModel = new FilterResponseModel(); listItems = new List <OutputItemModel>(); mCodeCom = new MCodeCom(); // Get value var itemDivName = string.Empty; var deleteFlagName = string.Empty; foreach (var obj in resultObject.ListItems) { item = new OutputItemModel(); item.ItemCd = DataHelper.ToString(obj.ItemCd); item.ItemName = DataHelper.ToString(obj.ItemName); item.CategoryCd = DataHelper.ToString(obj.CategoryCd); item.CategoryName = DataHelper.ToString(obj.Category.CategoryName); item.AgeCd = DataHelper.ToString(obj.AgeCd); item.AgeName = DataHelper.ToString(obj.Age.AgeName); item.GenderCd = DataHelper.ToString(obj.GenderCd); item.GenderName = DataHelper.ToString(obj.Gender.GenderName); item.BrandCd = DataHelper.ToString(obj.BrandCd); item.BrandName = DataHelper.ToString(obj.Brand.BrandName); item.CountryCd = DataHelper.ToString(obj.CountryCd); item.CountryName = DataHelper.ToString(obj.Country.CountryName); item.UnitCd = DataHelper.ToString(obj.UnitCd); item.UnitName = DataHelper.ToString(obj.Unit.UnitName); item.ItemDiv = DataHelper.ToString(obj.ItemDiv); itemDivName = mCodeCom.GetCodeName(Logics.GROUP_ITEM_DIV, item.ItemDiv); item.ItemDivName = DataHelper.ToString(itemDivName); item.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); item.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, item.DeleteFlag); item.DeleteFlagName = DataHelper.ToString(deleteFlagName); listItems.Add(item); } // Set value responseModel.ListItems = listItems; // Return value return(responseModel); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputOfferModel> listOffers = null; MCodeCom mCodeCom = null; OutputOfferModel offer = null; // Variable initialize responseModel = new FilterResponseModel(); listOffers = new List <OutputOfferModel>(); mCodeCom = new MCodeCom(); // Get value var cbDeleteFlag = new ComboModel(); var offerDivName = string.Empty; foreach (var obj in resultObject.ListOffers) { offer = new OutputOfferModel(); offer.OfferCd = DataHelper.ToString(obj.OfferCd); offer.OfferGroupCd = DataHelper.ToString(obj.OfferGroupCd); offer.ItemCd = DataHelper.ToString(obj.ItemCd); offer.StartDate = DataHelper.ToString(Formats.DATE, obj.StartDate); offer.EndDate = DataHelper.ToString(Formats.DATE, obj.EndDate); offer.Percent = DataHelper.ToString(Formats.NUMBER, obj.Percent); offer.Notes = DataHelper.ToString(obj.Notes); offer.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); offer.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); offerDivName = mCodeCom.GetCodeName(Logics.GROUP_OFFER_DIV, obj.OfferDiv); offer.OfferDiv = DataHelper.ToString(obj.OfferDiv); offer.OfferDivName = DataHelper.ToString(offerDivName); cbDeleteFlag = MCodeCom.ToComboItems(resultObject.ListDeleteFlag, offer.DeleteFlag); offer.ListDeleteFlag = cbDeleteFlag.ListItems; offer.DeleteFlag = cbDeleteFlag.SeletedValue; listOffers.Add(offer); } // Set value responseModel.ListOffers = listOffers; // Return value return(responseModel); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList<OutputOfferModel> listOffers = null; MCodeCom mCodeCom = null; OutputOfferModel offer = null; // Variable initialize responseModel = new FilterResponseModel(); listOffers = new List<OutputOfferModel>(); mCodeCom = new MCodeCom(); // Get value var cbDeleteFlag = new ComboModel(); var offerDivName = string.Empty; foreach (var obj in resultObject.ListOffers) { offer = new OutputOfferModel(); offer.OfferCd = DataHelper.ToString(obj.OfferCd); offer.OfferGroupCd = DataHelper.ToString(obj.OfferGroupCd); offer.ItemCd = DataHelper.ToString(obj.ItemCd); offer.StartDate = DataHelper.ToString(Formats.DATE, obj.StartDate); offer.EndDate = DataHelper.ToString(Formats.DATE, obj.EndDate); offer.Percent = DataHelper.ToString(Formats.NUMBER, obj.Percent); offer.Notes = DataHelper.ToString(obj.Notes); offer.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); offer.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); offerDivName = mCodeCom.GetCodeName(Logics.GROUP_OFFER_DIV, obj.OfferDiv); offer.OfferDiv = DataHelper.ToString(obj.OfferDiv); offer.OfferDivName = DataHelper.ToString(offerDivName); cbDeleteFlag = MCodeCom.ToComboItems(resultObject.ListDeleteFlag, offer.DeleteFlag); offer.ListDeleteFlag = cbDeleteFlag.ListItems; offer.DeleteFlag = cbDeleteFlag.SeletedValue; listOffers.Add(offer); } // Set value responseModel.ListOffers = listOffers; // Return value return responseModel; }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputUserModel> listUsers = null; MCodeCom mCodeCom = null; OutputUserModel user = null; // Variable initialize responseModel = new FilterResponseModel(); listUsers = new List <OutputUserModel>(); mCodeCom = new MCodeCom(); // Get value var deleteFlagName = string.Empty; foreach (var obj in resultObject.ListUsers) { user = new OutputUserModel(); user.UserCd = DataHelper.ToString(obj.UserCd); user.Email = DataHelper.ToString(obj.Email); user.FullName = DataHelper.ToString(obj.FullName); user.Address = DataHelper.ToString(obj.Address); user.CityCd = DataHelper.ToString(obj.CityCd); user.CityName = DataHelper.ToString(obj.City.CityName); user.Phone1 = DataHelper.ToString(obj.Phone1); user.Phone2 = DataHelper.ToString(obj.Phone2); user.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); user.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, user.DeleteFlag); user.DeleteFlagName = DataHelper.ToString(deleteFlagName); if (obj.UserGroups.Count > decimal.Zero) { user.GroupCd = DataHelper.ToString(obj.UserGroups[0].GroupCd); user.GroupName = DataHelper.ToString(obj.UserGroups[0].Group.GroupName); } listUsers.Add(user); } // Set value responseModel.ListUsers = listUsers; // Return value return(responseModel); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputGiftModel> listGifts = null; MCodeCom mCodeCom = null; OutputGiftModel gift = null; // Variable initialize responseModel = new FilterResponseModel(); listGifts = new List <OutputGiftModel>(); mCodeCom = new MCodeCom(); // Get value var deleteFlagName = string.Empty; ComboModel cbGiftStatus = null; foreach (var obj in resultObject.ListGifts) { gift = new OutputGiftModel(); gift.GiftCd = DataHelper.ToString(obj.GiftCd); gift.GiftStatus = DataHelper.ToString(obj.GiftStatus); gift.StartDate = DataHelper.ToString(Formats.DATE, obj.StartDate); gift.EndDate = DataHelper.ToString(Formats.DATE, obj.EndDate); gift.Price = DataHelper.ToString(Formats.CURRENCY, obj.Price); gift.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); gift.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, gift.DeleteFlag); gift.DeleteFlagName = DataHelper.ToString(deleteFlagName); cbGiftStatus = MCodeCom.ToComboItems(resultObject.ListGiftStatus, gift.GiftStatus); gift.ListGiftStatus = cbGiftStatus.ListItems; gift.GiftStatus = cbGiftStatus.SeletedValue; listGifts.Add(gift); } // Set value responseModel.ListGifts = listGifts; // Return value return(responseModel); }
/// <summary> /// Execute convert ouput. /// </summary> /// <param name="resultObject">DataModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Convert(FilterDataModel resultObject) { // Local variable declaration FilterResponseModel responseModel = null; IList <OutputBrandModel> listBrands = null; MCodeCom mCodeCom = null; OutputBrandModel brand = null; // Variable initialize responseModel = new FilterResponseModel(); listBrands = new List <OutputBrandModel>(); mCodeCom = new MCodeCom(); // Get value var deleteFlagName = string.Empty; foreach (var obj in resultObject.ListBrands) { brand = new OutputBrandModel(); brand.BrandCd = DataHelper.ToString(obj.BrandCd); brand.BrandName = DataHelper.ToString(obj.BrandName); brand.FileId = DataHelper.ToString(obj.FileId); brand.SortKey = DataHelper.ToString(Formats.NUMBER, obj.SortKey); brand.Notes = DataHelper.ToString(obj.Notes); brand.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate); brand.DeleteFlag = DataHelper.ToString(obj.DeleteFlag); deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, brand.DeleteFlag); brand.DeleteFlagName = DataHelper.ToString(deleteFlagName); listBrands.Add(brand); } // Set value responseModel.ListBrands = listBrands; // Return value return(responseModel); }
/// <summary> /// Execute processing. /// </summary> /// <param name="request">RequestModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Execute(FilterRequestModel request) { // Local variable declaration FilterResponseModel responseModel = null; FilterDataModel inputObject = null; FilterDataModel resultObject = null; // Variable initialize responseModel = new FilterResponseModel(); // Execute convert input. inputObject = Convert(request); // Check infomation Check(inputObject); // Get infomation resultObject = GetInfo(inputObject); // Execute convert ouput. responseModel = Convert(resultObject); return(responseModel); }
/// <summary> /// Execute processing. /// </summary> /// <param name="request">RequestModel</param> /// <returns>ResponseModel</returns> private FilterResponseModel Execute(FilterRequestModel request) { // Local variable declaration FilterResponseModel responseModel = null; FilterDataModel inputObject = null; FilterDataModel resultObject = null; // Variable initialize responseModel = new FilterResponseModel(); // Execute convert input. inputObject = Convert(request); // Check infomation Check(inputObject); // Get infomation resultObject = GetInfo(inputObject); // Execute convert ouput. responseModel = Convert(resultObject); return responseModel; }