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