public ReadResponse <MachineSpinningModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <MachineSpinningModel> Query = _DbSet.Include(x => x.Types); Query = Query .Select(s => new MachineSpinningModel { Id = s.Id, _CreatedBy = s._CreatedBy, _CreatedUtc = s._CreatedUtc, Code = s.Code, _LastModifiedUtc = s._LastModifiedUtc, CapacityPerHour = s.CapacityPerHour, Condition = s.Condition, Delivery = s.Delivery, CounterCondition = s.CounterCondition, Brand = s.Brand, No = s.No, Name = s.Name, //Type = s.Type, Year = s.Year, Line = s.Line, UomId = s.UomId, UnitCode = s.UnitCode, UnitId = s.UnitId, UnitName = s.UnitName, UomUnit = s.UomUnit, MachineCode = s.MachineCode, Types = s.Types }); List <string> searchAttributes = new List <string>() { "Brand", "Name", "No", "UnitName" }; //Query = QueryHelper<MachineSpinningModel>.Search(Query, searchAttributes, keyword); if (keyword != null) { var machineSpinningTypes = _DbContext.MachineSpinningProcessType.Where(x => x.Type.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) >= 0).Select(x => x.MachineSpinningId).Distinct().ToList(); Query = Query.Where(x => machineSpinningTypes.Contains(x.Id) || x.Brand.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) >= 0 || x.Name.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) >= 0 || x.No.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) >= 0 || x.UnitName.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) >= 0); } Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); Query = QueryHelper <MachineSpinningModel> .Filter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); if (OrderDictionary.Count.Equals(0)) { Query = Query.OrderBy(x => x.MachineCode).ThenBy(x => x.Line).ThenBy(x => x.No); } else { Query = QueryHelper <MachineSpinningModel> .Order(Query, OrderDictionary); } Pageable <MachineSpinningModel> pageable = new Pageable <MachineSpinningModel>(Query, page - 1, size); List <MachineSpinningModel> Data = pageable.Data.ToList(); List <MachineSpinningModel> list = new List <MachineSpinningModel>(); list.AddRange( Data.Select(s => new MachineSpinningModel { Id = s.Id, _CreatedBy = s._CreatedBy, _CreatedUtc = s._CreatedUtc, Code = s.Code, _LastModifiedUtc = s._LastModifiedUtc, CapacityPerHour = s.CapacityPerHour, Condition = s.Condition, Delivery = s.Delivery, CounterCondition = s.CounterCondition, Brand = s.Brand, Name = s.Name, No = s.No, //Type = s.Type, Year = s.Year, Line = s.Line, UnitCode = s.UnitCode, UnitId = s.UnitId, UnitName = s.UnitName, UomId = s.UomId, UomUnit = s.UomUnit, MachineCode = s.MachineCode, Types = s.Types }).ToList() ); int TotalData = pageable.TotalCount; return(new ReadResponse <MachineSpinningModel>(list, TotalData, OrderDictionary, new List <string>())); }
public Tuple <List <GarmentInternalPurchaseOrderExternalPurchaseOrderDurationReportViewModel>, int> GetIPOEPODurationReport(string unit, string duration, DateTime?dateFrom, DateTime?dateTo, int page, int size, string Order, int offset) { var Query = GetIPOEPODurationReportQuery(unit, duration, dateFrom, dateTo, offset); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); if (OrderDictionary.Count.Equals(0)) { Query = Query.OrderByDescending(b => b.poIntCreatedDate); } //else //{ // string Key = OrderDictionary.Keys.First(); // string OrderType = OrderDictionary[Key]; // Query = Query.OrderBy(string.Concat(Key, " ", OrderType)); //} Pageable <GarmentInternalPurchaseOrderExternalPurchaseOrderDurationReportViewModel> pageable = new Pageable <GarmentInternalPurchaseOrderExternalPurchaseOrderDurationReportViewModel>(Query, page - 1, size); List <GarmentInternalPurchaseOrderExternalPurchaseOrderDurationReportViewModel> Data = pageable.Data.ToList <GarmentInternalPurchaseOrderExternalPurchaseOrderDurationReportViewModel>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData)); }
public Tuple <List <CategoryViewModel>, int, Dictionary <string, string> > JoinDivision(int Page = 1, int Size = 25, string Order = "{}", string Keyword = "", string Filter = "{}") { //IQueryable<Category> Query = this.DbContext.Categories; //IQueryable<Division> divisions = DbContext.Divisions; var Query = from t1 in DbContext.Categories from t2 in DbContext.Divisions where ((!string.IsNullOrEmpty(t1.Name) && t1.Name.IndexOf(Keyword, StringComparison.OrdinalIgnoreCase) >= 0) || (!string.IsNullOrEmpty(t2.Name) && t2.Name.IndexOf(Keyword, StringComparison.OrdinalIgnoreCase) >= 0)) select new CategoryViewModel() { code = t1.Code, codeRequirement = t1.CodeRequirement, divisionId = t2.Id, divisionName = t2.Name, name = t1.Name, UId = t1.UId, _id = t1.Id, _updatedDate = t1._LastModifiedUtc }; Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(Filter); if (FilterDictionary != null && !FilterDictionary.Count.Equals(0)) { foreach (var f in FilterDictionary) { string Key = f.Key; object Value = f.Value; string filterQuery = string.Concat(string.Empty, Key, " == @0"); Query = Query.Where(filterQuery, Value); } } //qu = ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); ///* Search With Keyword */ //if (Keyword != null) //{ // List<string> SearchAttributes = new List<string>() // { // "Code", "Name" // }; // Query = Query.Where(General.BuildSearch(SearchAttributes), Keyword); //} ///* Const Select */ //List<string> SelectedFields = new List<string>() //{ // "_id", "code", "name" //}; //Query = Query // .Select(b => new Category // { // Id = b.Id, // Code = b.Code, // Name = b.Name // }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_updatedDate", General.DESCENDING); Query = Query.OrderByDescending(b => b._updatedDate); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } /* Pagination */ Pageable <CategoryViewModel> pageable = new Pageable <CategoryViewModel>(Query, Page - 1, Size); List <CategoryViewModel> Data = pageable.Data.ToList <CategoryViewModel>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary)); }
public Tuple <List <UnitPaymentCorrectionNote>, int, Dictionary <string, string> > Read(int Page = 1, int Size = 25, string Order = "{}", string Keyword = null, string Filter = "{}") { IQueryable <UnitPaymentCorrectionNote> Query = this.dbSet; Query = Query .Select(s => new UnitPaymentCorrectionNote { Id = s.Id, UPCNo = s.UPCNo, CorrectionDate = s.CorrectionDate, CorrectionType = s.CorrectionType, UPOId = s.UPOId, UPONo = s.UPONo, SupplierCode = s.SupplierCode, SupplierName = s.SupplierName, InvoiceCorrectionNo = s.InvoiceCorrectionNo, InvoiceCorrectionDate = s.InvoiceCorrectionDate, useVat = s.useVat, useIncomeTax = s.useIncomeTax, ReleaseOrderNoteNo = s.ReleaseOrderNoteNo, DueDate = s.DueDate, Items = s.Items.Select( q => new UnitPaymentCorrectionNoteItem { Id = q.Id, UPCId = q.UPCId, UPODetailId = q.UPODetailId, URNNo = q.URNNo, EPONo = q.EPONo, PRId = q.PRId, PRNo = q.PRNo, PRDetailId = q.PRDetailId, } ) .ToList(), CreatedBy = s.CreatedBy, LastModifiedUtc = s.LastModifiedUtc }).Where(k => k.CorrectionType == "Jumlah") .OrderByDescending(j => j.LastModifiedUtc); List <string> searchAttributes = new List <string>() { "UPCNo", "UPONo", "SupplierName", "InvoiceCorrectionNo" }; Query = QueryHelper <UnitPaymentCorrectionNote> .ConfigureSearch(Query, searchAttributes, Keyword); Dictionary <string, string> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Filter); Query = QueryHelper <UnitPaymentCorrectionNote> .ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); Query = QueryHelper <UnitPaymentCorrectionNote> .ConfigureOrder(Query, OrderDictionary); Pageable <UnitPaymentCorrectionNote> pageable = new Pageable <UnitPaymentCorrectionNote>(Query, Page - 1, Size); List <UnitPaymentCorrectionNote> Data = pageable.Data.ToList <UnitPaymentCorrectionNote>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary)); }
public Tuple <List <PurchasingDisposition>, int, Dictionary <string, string> > Read(int Page = 1, int Size = 25, string Order = "{}", string Keyword = null, string Filter = "{}") { IQueryable <PurchasingDisposition> Query = this.dbSet; List <string> searchAttributes = new List <string>() { "DispositionNo", "SupplierName", "CurrencyCode", "DivisionName", "CategoryName" }; Query = QueryHelper <PurchasingDisposition> .ConfigureSearch(Query, searchAttributes, Keyword); Dictionary <string, string> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Filter); Query = QueryHelper <PurchasingDisposition> .ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); Query = QueryHelper <PurchasingDisposition> .ConfigureOrder(Query, OrderDictionary); Query = Query .Select(s => new PurchasingDisposition { DispositionNo = s.DispositionNo, Id = s.Id, SupplierCode = s.SupplierCode, SupplierId = s.SupplierId, SupplierName = s.SupplierName, Bank = s.Bank, CurrencyCode = s.CurrencyCode, CurrencyId = s.CurrencyId, CurrencyRate = s.CurrencyRate, ConfirmationOrderNo = s.ConfirmationOrderNo, //InvoiceNo = s.InvoiceNo, PaymentMethod = s.PaymentMethod, PaymentDueDate = s.PaymentDueDate, CreatedBy = s.CreatedBy, LastModifiedUtc = s.LastModifiedUtc, CreatedUtc = s.CreatedUtc, Amount = s.Amount, Calculation = s.Calculation, //Investation = s.Investation, Position = s.Position, ProformaNo = s.ProformaNo, Remark = s.Remark, UId = s.UId, CategoryCode = s.CategoryCode, CategoryId = s.CategoryId, CategoryName = s.CategoryName, DPP = s.DPP, IncomeTaxValue = s.IncomeTaxValue, VatValue = s.VatValue, IncomeTaxBy = s.IncomeTaxBy, DivisionCode = s.DivisionCode, DivisionId = s.DivisionId, DivisionName = s.DivisionName, PaymentCorrection = s.PaymentCorrection, Items = s.Items.Select(x => new PurchasingDispositionItem() { EPOId = x.EPOId, EPONo = x.EPONo, Id = x.Id, IncomeTaxId = x.IncomeTaxId, IncomeTaxName = x.IncomeTaxName, IncomeTaxRate = x.IncomeTaxRate, UseVat = x.UseVat, UseIncomeTax = x.UseIncomeTax, UId = x.UId, Details = x.Details.Select(y => new PurchasingDispositionDetail() { UId = y.UId, DealQuantity = y.DealQuantity, DealUomId = y.DealUomId, DealUomUnit = y.DealUomUnit, Id = y.Id, PaidPrice = y.PaidPrice, PaidQuantity = y.PaidQuantity, PricePerDealUnit = y.PricePerDealUnit, PriceTotal = y.PriceTotal, PRId = y.PRId, PRNo = y.PRNo, ProductCode = y.ProductCode, ProductId = y.ProductId, ProductName = y.ProductName, PurchasingDispositionItem = y.PurchasingDispositionItem, PurchasingDispositionItemId = y.PurchasingDispositionItemId, UnitCode = y.UnitCode, UnitId = y.UnitId, UnitName = y.UnitName }).ToList() }).ToList() }); Pageable <PurchasingDisposition> pageable = new Pageable <PurchasingDisposition>(Query, Page - 1, Size); List <PurchasingDisposition> Data = pageable.Data.ToList <PurchasingDisposition>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary)); }
public override ReadResponse <ProductionOrderModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <ProductionOrderModel> Query = DbSet; List <string> SearchAttributes = new List <string>() { "OrderNo", "SalesContractNo", "BuyerType", "BuyerName", "ProcessTypeName", "MaterialName", "MaterialConstructionName", "MaterialWidth" }; Query = QueryHelper <ProductionOrderModel> .Search(Query, SearchAttributes, keyword); Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); Query = QueryHelper <ProductionOrderModel> .Filter(Query, FilterDictionary); List <string> SelectedFields = new List <string>() { "Id", "POType", "Code", "Buyer", "ProcessType", "LastModifiedUtc", "FinishingPrintingSalesContract", "OrderNo", "Details", "OrderType", "HandlingStandard", "Material", "YarnMaterial", "DeliveryDate", "SalesContractNo", "MaterialConstruction", "FinishWidth", "DesignCode", "DesignNumber", "OrderQuantity", "Uom", "DistributedQuantity", "IsCompleted", "IsClosed", "IsCalculated", "Account", "MaterialWidth", "PackingInstruction", "MaterialOrigin" }; Query = Query .Select(field => new ProductionOrderModel { Id = field.Id, POType = field.POType, Code = field.Code, DeliveryDate = field.DeliveryDate, HandlingStandard = field.HandlingStandard, FinishWidth = field.FinishWidth, MaterialId = field.MaterialId, MaterialCode = field.MaterialCode, MaterialName = field.MaterialName, MaterialConstructionId = field.MaterialConstructionId, MaterialConstructionCode = field.MaterialConstructionCode, MaterialConstructionName = field.MaterialConstructionName, SalesContractId = field.SalesContractId, SalesContractNo = field.SalesContractNo, BuyerType = field.BuyerType, BuyerName = field.BuyerName, IsCalculated = field.IsCalculated, BuyerId = field.BuyerId, OrderNo = field.OrderNo, ProcessTypeId = field.ProcessTypeId, ProcessTypeCode = field.ProcessTypeCode, ProcessTypeName = field.ProcessTypeName, UomId = field.UomId, MaterialWidth = field.MaterialWidth, UomUnit = field.UomUnit, YarnMaterialId = field.YarnMaterialId, YarnMaterialCode = field.YarnMaterialCode, YarnMaterialName = field.YarnMaterialName, OrderTypeId = field.OrderTypeId, OrderTypeCode = field.OrderTypeCode, OrderTypeName = field.OrderTypeName, OrderQuantity = field.OrderQuantity, LastModifiedUtc = field.LastModifiedUtc, Details = field.Details, DesignCode = field.DesignCode, DesignNumber = field.DesignNumber, ProcessTypeSPPCode = field.ProcessTypeSPPCode, ProcessTypeUnit = field.ProcessTypeUnit, DistributedQuantity = field.DistributedQuantity, IsCompleted = field.IsCompleted, IsClosed = field.IsClosed, AccountId = field.AccountId, AccountUserName = field.AccountUserName, ProfileFirstName = field.ProfileFirstName, ProfileGender = field.ProfileGender, ProfileLastName = field.ProfileLastName, PackingInstruction = field.PackingInstruction, MaterialOrigin = field.MaterialOrigin }); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); Query = QueryHelper <ProductionOrderModel> .Order(Query, OrderDictionary); Pageable <ProductionOrderModel> pageable = new Pageable <ProductionOrderModel>(Query, page - 1, size); List <ProductionOrderModel> data = pageable.Data.ToList <ProductionOrderModel>(); int totalData = pageable.TotalCount; return(new ReadResponse <ProductionOrderModel>(data, totalData, OrderDictionary, SelectedFields)); }
public static void ToPageableGridSortingViewModel(IEnumerable <SortModel> source, Pageable <GridSortingViewModel> destination) { if (destination == null) { destination = new Pageable <GridSortingViewModel>(); } foreach (var sortModel in source) { var gridSortingViewModel = new GridSortingViewModel(); Map(sortModel, gridSortingViewModel); destination.Add(gridSortingViewModel); } }
public IActionResult Get([FromQuery] Pageable pageable) { var result = _blockListRepository.GetBlockListByUserId(UserId, pageable); return(Ok(result)); }
public ReadResponse <KanbanModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <KanbanModel> query = DbSet; List <string> searchAttributes = new List <string>() { "Code", "ProductionOrderOrderNo", "CartCartNumber" }; query = QueryHelper <KanbanModel> .Search(query, searchAttributes, keyword); object processFilterData = null; if (filter.Contains("CustomFilter#IntructionStepProcess")) { var processFilter = filter; Dictionary <string, object> processFilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(processFilter); foreach (var f in processFilterDictionary) { string key = f.Key; object Value = f.Value; //string filterQuery = Value; processFilterData = Value; } filter = "{}"; query = query .Where(x => x.Instruction.Steps.Any(y => y.Process == processFilterData.ToString())); } Dictionary <string, object> filterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); query = QueryHelper <KanbanModel> .Filter(query, filterDictionary); List <string> selectedFields = new List <string>() { "Id", "Code", "ProductionOrder", "CurrentStepIndex", "Cart", "Instruction", "SelectedProductionOrderDetail", "LastModifiedUtc", "OldKanbanId", "IsComplete", "IsInactive" }; query = query .Select(field => new KanbanModel { Id = field.Id, Code = field.Code, CartCartNumber = field.CartCartNumber, CurrentStepIndex = field.CurrentStepIndex, CartQty = field.CartQty, IsBadOutput = field.IsBadOutput, IsComplete = field.IsComplete, IsInactive = field.IsInactive, IsReprocess = field.IsReprocess, Instruction = new KanbanInstructionModel() { Id = field.Instruction.Id, Name = field.Instruction.Name, Steps = new List <KanbanStepModel>(field.Instruction.Steps.OrderBy(x => x.StepIndex).ThenBy(x => x.Id).Select(i => new KanbanStepModel() { Id = i.Id, Process = i.Process, ProcessArea = i.ProcessArea, SelectedIndex = i.SelectedIndex, StepIndex = i.StepIndex })) }, OldKanbanId = field.OldKanbanId, LastModifiedUtc = field.LastModifiedUtc, ProductionOrderMaterialName = field.ProductionOrderMaterialName, ProductionOrderMaterialConstructionName = field.ProductionOrderMaterialConstructionName, ProductionOrderYarnMaterialName = field.ProductionOrderYarnMaterialName, FinishWidth = field.FinishWidth, ProductionOrderOrderNo = field.ProductionOrderOrderNo, SelectedProductionOrderDetailColorRequest = field.SelectedProductionOrderDetailColorRequest, SelectedProductionOrderDetailColorTemplate = field.SelectedProductionOrderDetailColorTemplate, SelectedProductionOrderDetailColorTypeCode = field.SelectedProductionOrderDetailColorTypeCode, SelectedProductionOrderDetailColorTypeName = field.SelectedProductionOrderDetailColorTypeName, SelectedProductionOrderDetailId = field.SelectedProductionOrderDetailId, SelectedProductionOrderDetailQuantity = field.SelectedProductionOrderDetailQuantity, SelectedProductionOrderDetailUomUnit = field.SelectedProductionOrderDetailUomUnit }); Dictionary <string, string> orderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); query = QueryHelper <KanbanModel> .Order(query, orderDictionary); Pageable <KanbanModel> pageable = new Pageable <KanbanModel>(query, page - 1, size); List <KanbanModel> data = pageable.Data.ToList(); int totalData = pageable.TotalCount; return(new ReadResponse <KanbanModel>(data, totalData, orderDictionary, selectedFields)); }
public override Tuple <List <BudgetCurrency>, int, Dictionary <string, string>, List <string> > ReadModel(int Page = 1, int Size = 25, string Order = "{}", List <string> Select = null, string Keyword = null, string Filter = "{}") { IQueryable <BudgetCurrency> Query = this.DbContext.BudgetCurrencies; Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); /* Search With Keyword */ if (Keyword != null) { List <string> SearchAttributes = new List <string>() { "Code" }; Query = Query.Where(General.BuildSearch(SearchAttributes), Keyword); } /* Const Select */ List <string> SelectedFields = new List <string>() { "Id", "code", "rate", "date", "remark" }; Query = Query .Select(g => new BudgetCurrency { Id = g.Id, Code = g.Code, Rate = g.Rate, Date = g.Date, Remark = g.Remark }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_updatedDate", General.DESCENDING); Query = Query.OrderByDescending(b => b._LastModifiedUtc); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } /* Pagination */ Pageable <BudgetCurrency> pageable = new Pageable <BudgetCurrency>(Query, Page - 1, Size); List <BudgetCurrency> Data = pageable.Data.ToList <BudgetCurrency>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary, SelectedFields)); }
public override Tuple <List <SpinningInputProduction>, int, Dictionary <string, string>, List <string> > ReadModel(int Page = 1, int Size = 25, string Order = "{}", List <string> Select = null, string Keyword = null, string Filter = "{}") { IQueryable <SpinningInputProduction> Query = this.DbContext.WinderInputProductions; Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); if (Keyword != null) { List <string> SearchAttributes = new List <string>() { "NomorInputProduksi", "YarnName", "UnitName", "MachineName", "Lot" }; Query = ConfigureSearch(Query, SearchAttributes, Keyword); } /* Const Select */ List <string> SelectedFields = new List <string>() { "Id", "NomorInputProduksi", "Yarn", "Unit", "Machine", "Lot", "Shift", "Date", "Counter", "Hank", "Input" }; Query = Query .Select(o => new SpinningInputProduction { Id = o.Id, NomorInputProduksi = o.NomorInputProduksi, YarnId = o.YarnId, YarnName = o.YarnName, UnitId = o.UnitId, UnitName = o.UnitName, MachineId = o.MachineId, MachineName = o.MachineName, Lot = o.Lot, Shift = o.Shift, Date = o.Date, Counter = o.Counter, Hank = o.Hank, Ne = o.Ne, Bale = o.Bale, }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_updatedDate", General.DESCENDING); Query = Query.OrderByDescending(b => b._LastModifiedUtc); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } //Dictionary<string, string> FilterDictionary = JsonConvert.DeserializeObject<Dictionary<string, string>>(Filter); //Query = ConfigureFilter(Query, FilterDictionary); /* Pagination */ Pageable <SpinningInputProduction> pageable = new Pageable <SpinningInputProduction>(Query, Page - 1, Size); List <SpinningInputProduction> Data = pageable.Data.ToList <SpinningInputProduction>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary, SelectedFields)); }
/// <summary> /// Kullanıcıya ait mesaj listesi /// </summary> /// <param name="userId">Kullanıcı id</param> /// <param name="pageable">Sayfalama</param> /// <returns>Mesaj listesi</returns> public IPagedList <DirectMessageModel> GetDirectMessageByUserId(string userId, Pageable pageable) { return(Query() .Where(x => x.UserId == userId) .Select(model => _mapper.Map <DirectMessageModel>(model)) .ToPagedList(pageable)); }
public ReadResponse <ShipmentDocumentModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <ShipmentDocumentModel> Query = _DbSet.Include(x => x.Details).ThenInclude(x => x.Items).ThenInclude(x => x.PackingReceiptItems); List <string> searchAttributes = new List <string>() { "Code", "BuyerCode", "BuyerName", "CreatedBy" }; Query = QueryHelper <ShipmentDocumentModel> .Search(Query, searchAttributes, keyword); Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); Query = QueryHelper <ShipmentDocumentModel> .Filter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); Query = QueryHelper <ShipmentDocumentModel> .Order(Query, OrderDictionary); Pageable <ShipmentDocumentModel> pageable = new Pageable <ShipmentDocumentModel>(Query, page - 1, size); List <ShipmentDocumentModel> Data = pageable.Data.ToList(); List <ShipmentDocumentModel> list = new List <ShipmentDocumentModel>(); list.AddRange( Data.Select(s => new ShipmentDocumentModel { Id = s.Id, CreatedUtc = s.CreatedUtc, CreatedBy = s.CreatedBy, Code = s.Code, LastModifiedUtc = s.LastModifiedUtc, DeliveryCode = s.DeliveryCode, DeliveryDate = s.DeliveryDate, BuyerId = s.BuyerId, BuyerAddress = s.BuyerAddress, BuyerNPWP = s.BuyerNPWP, BuyerCode = s.BuyerCode, BuyerName = s.BuyerName, Details = s.Details.Select(t => new ShipmentDocumentDetailModel { Items = t.Items.Select(u => new ShipmentDocumentItemModel { PackingReceiptItems = u.PackingReceiptItems.Select(v => new ShipmentDocumentPackingReceiptItemModel { ProductName = v.ProductName, ProductCode = v.ProductCode, Quantity = v.Quantity, Weight = v.Weight, Length = v.Length, UOMId = v.UOMId, UOMUnit = v.UOMUnit, }).ToList(), }).ToList(), }).ToList(), }).ToList() ); int TotalData = pageable.TotalCount; return(new ReadResponse <ShipmentDocumentModel>(list, TotalData, OrderDictionary, new List <string>())); }
public ReadResponse <MachineSpinningModel> ReadNoOnly(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <MachineSpinningModel> Query = _DbSet.Include(x => x.Types); Query = Query .Select(s => new MachineSpinningModel { Id = s.Id, _CreatedBy = s._CreatedBy, _CreatedUtc = s._CreatedUtc, Code = s.Code, _LastModifiedUtc = s._LastModifiedUtc, CapacityPerHour = s.CapacityPerHour, Condition = s.Condition, Delivery = s.Delivery, CounterCondition = s.CounterCondition, Brand = s.Brand, No = s.No, Name = s.Name, //Type = s.Type, Year = s.Year, Line = s.Line, UomId = s.UomId, UnitCode = s.UnitCode, UnitId = s.UnitId, UnitName = s.UnitName, UomUnit = s.UomUnit, MachineCode = s.MachineCode, Types = s.Types }); List <string> searchAttributes = new List <string>() { "No" }; Query = QueryHelper <MachineSpinningModel> .Search(Query, searchAttributes, keyword); Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); Query = QueryHelper <MachineSpinningModel> .Filter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); Query = QueryHelper <MachineSpinningModel> .Order(Query, OrderDictionary); Pageable <MachineSpinningModel> pageable = new Pageable <MachineSpinningModel>(Query, page - 1, size); List <MachineSpinningModel> Data = pageable.Data.ToList(); List <MachineSpinningModel> list = new List <MachineSpinningModel>(); list.AddRange( Data.Select(s => new MachineSpinningModel { Id = s.Id, _CreatedBy = s._CreatedBy, _CreatedUtc = s._CreatedUtc, Code = s.Code, _LastModifiedUtc = s._LastModifiedUtc, CapacityPerHour = s.CapacityPerHour, Condition = s.Condition, Delivery = s.Delivery, CounterCondition = s.CounterCondition, Brand = s.Brand, Name = s.Name, No = s.No, //Type = s.Type, Year = s.Year, Line = s.Line, UnitCode = s.UnitCode, UnitId = s.UnitId, UnitName = s.UnitName, UomId = s.UomId, UomUnit = s.UomUnit, MachineCode = s.MachineCode, Types = s.Types }).ToList() ); int TotalData = pageable.TotalCount; return(new ReadResponse <MachineSpinningModel>(Query.ToList(), TotalData, OrderDictionary, new List <string>())); }
public override Tuple <List <AccountBank>, int, Dictionary <string, string>, List <string> > ReadModel(int Page = 1, int Size = 25, string Order = "{}", List <string> Select = null, string Keyword = null, string Filter = "{}") { IQueryable <AccountBank> Query = this.DbContext.AccountBanks; Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(Filter); Query = ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); /* Search With Keyword */ if (Keyword != null) { List <string> SearchAttributes = new List <string>() { "BankName", "BankAddress", "AccountName", "AccountNumber", "BankCode" }; Query = Query.Where(General.BuildSearch(SearchAttributes), Keyword); } /* Const Select */ List <string> SelectedFields = new List <string>() { "Id", "Code", "BankCode", "BankName", "BankAddress", "AccountName", "AccountNumber", "SwiftCode", "Currency", "Division", "AccountCOA" }; Query = Query .Select(a => new AccountBank { Id = a.Id, Code = a.Code, BankCode = a.BankCode, BankName = a.BankName, BankAddress = a.BankAddress, AccountName = a.AccountName, AccountNumber = a.AccountNumber, SwiftCode = a.SwiftCode, CurrencyId = a.CurrencyId, CurrencyCode = a.CurrencyCode, DivisionCode = a.DivisionCode, DivisionId = a.DivisionId, DivisionName = a.DivisionName, _LastModifiedUtc = a._LastModifiedUtc, AccountCOA = a.AccountCOA }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_LastModifiedUtc", General.DESCENDING); Query = Query.OrderByDescending(b => b._LastModifiedUtc); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } /* Pagination */ Pageable <AccountBank> pageable = new Pageable <AccountBank>(Query, Page - 1, Size); List <AccountBank> Data = pageable.Data.ToList <AccountBank>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary, SelectedFields)); }
public ReadResponse <object> GetAllByPosition(int Page, int Size, string Order, string Keyword, string Filter) { var query = dbContext.PurchasingDocumentExpeditions.AsQueryable(); query = query.Include(i => i.Items); if (!string.IsNullOrWhiteSpace(Keyword)) { List <string> searchAttributes = new List <string>() { "UnitPaymentOrderNo", "SupplierName", "DivisionName", "SupplierCode", "InvoiceNo" }; query = QueryHelper <PurchasingDocumentExpedition> .ConfigureSearch(query, searchAttributes, Keyword); } if (Filter.Contains("verificationFilter")) { Filter = "{}"; List <ExpeditionPosition> positions = new List <ExpeditionPosition> { ExpeditionPosition.SEND_TO_PURCHASING_DIVISION, ExpeditionPosition.SEND_TO_ACCOUNTING_DIVISION, ExpeditionPosition.SEND_TO_CASHIER_DIVISION }; query = query.Where(p => positions.Contains(p.Position)); } Dictionary <string, string> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Filter); query = QueryHelper <PurchasingDocumentExpedition> .ConfigureFilter(query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); query = QueryHelper <PurchasingDocumentExpedition> .ConfigureOrder(query, OrderDictionary); Pageable <PurchasingDocumentExpedition> pageable = new Pageable <PurchasingDocumentExpedition>(query, Page - 1, Size); List <PurchasingDocumentExpedition> Data = pageable.Data.ToList(); int TotalData = pageable.TotalCount; List <object> list = new List <object>(); list.AddRange(Data.Select(s => new { UnitPaymentOrderId = s.Id, s.UnitPaymentOrderNo, s.UPODate, s.DueDate, s.InvoiceNo, s.SupplierCode, s.SupplierName, s.CategoryCode, s.CategoryName, s.DivisionCode, s.DivisionName, s.Vat, s.IncomeTax, s.IncomeTaxBy, s.IsPaid, s.TotalPaid, s.Currency, s.PaymentMethod, s.URNId, s.URNNo, Items = s.Items.Select(sl => new { UnitPaymentOrderItemId = sl.Id, sl.UnitId, sl.UnitCode, sl.UnitName, sl.ProductId, sl.ProductCode, sl.ProductName, sl.Quantity, sl.Uom, sl.Price, sl.URNId, sl.URNNo }).ToList() })); return(new ReadResponse <object>(list, TotalData, OrderDictionary)); }
public override Tuple <List <IncomeTax>, int, Dictionary <string, string>, List <string> > ReadModel(int Page = 1, int Size = 25, string Order = "{}", List <string> Select = null, string Keyword = null, string Filter = "{}") { IQueryable <IncomeTax> Query = this.DbContext.IncomeTaxes; Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(Filter); Query = ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); /* Search With Keyword */ if (Keyword != null) { List <string> SearchAttributes = new List <string>() { "Name" }; Query = Query.Where(General.BuildSearch(SearchAttributes), Keyword); } /* Const Select */ List <string> SelectedFields = new List <string>() { "Id", "name", "rate", "description" }; Query = Query .Select(v => new IncomeTax { Id = v.Id, Name = v.Name, Rate = v.Rate, Description = v.Description, COACodeCredit = v.COACodeCredit }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_updatedDate", General.DESCENDING); Query = Query.OrderByDescending(b => b._LastModifiedUtc); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } /* Pagination */ Pageable <IncomeTax> pageable = new Pageable <IncomeTax>(Query, Page - 1, Size); List <IncomeTax> Data = pageable.Data.ToList <IncomeTax>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary, SelectedFields)); }
public ReadResponse <object> GetReport(int Size, int Page, string DocumentNo, string UnitPaymentOrderNo, string InvoiceNo, string SupplierCode, string DivisionCode, string PaymentMethod, DateTimeOffset?DateFrom, DateTimeOffset?DateTo, int Offset) { IQueryable <BankExpenditureNoteReportViewModel> Query; if (DateFrom == null || DateTo == null) { Query = (from a in dbContext.BankExpenditureNotes join b in dbContext.BankExpenditureNoteDetails on a.Id equals b.BankExpenditureNoteId join c in dbContext.PurchasingDocumentExpeditions on b.UnitPaymentOrderId equals c.Id where c.InvoiceNo == (InvoiceNo ?? c.InvoiceNo) && c.SupplierCode == (SupplierCode ?? c.SupplierCode) && c.UnitPaymentOrderNo == (UnitPaymentOrderNo ?? c.UnitPaymentOrderNo) && c.DivisionCode == (DivisionCode ?? c.DivisionCode) && !c.PaymentMethod.ToUpper().Equals("CASH") && c.IsPaid && c.PaymentMethod == (PaymentMethod ?? c.PaymentMethod) where a.DocumentNo == (DocumentNo ?? a.DocumentNo) orderby a.DocumentNo select new BankExpenditureNoteReportViewModel { DocumentNo = a.DocumentNo, Currency = a.BankCurrencyCode, Date = a.Date, SupplierName = c.SupplierName, CategoryName = c.CategoryName == null ? "-" : c.CategoryName, DivisionName = c.DivisionName, PaymentMethod = c.PaymentMethod, UnitPaymentOrderNo = b.UnitPaymentOrderNo, BankName = string.Concat(a.BankAccountName, " - ", a.BankName, " - ", a.BankAccountNumber, " - ", a.BankCurrencyCode), DPP = c.TotalPaid - c.Vat, VAT = c.Vat, TotalPaid = c.TotalPaid, InvoiceNumber = c.InvoiceNo } ); } else { Query = (from a in dbContext.BankExpenditureNotes join b in dbContext.BankExpenditureNoteDetails on a.Id equals b.BankExpenditureNoteId join c in dbContext.PurchasingDocumentExpeditions on b.UnitPaymentOrderId equals c.Id where c.InvoiceNo == (InvoiceNo ?? c.InvoiceNo) && c.SupplierCode == (SupplierCode ?? c.SupplierCode) && c.UnitPaymentOrderNo == (UnitPaymentOrderNo ?? c.UnitPaymentOrderNo) && c.DivisionCode == (DivisionCode ?? c.DivisionCode) && !c.PaymentMethod.ToUpper().Equals("CASH") && c.IsPaid && c.PaymentMethod == (PaymentMethod ?? c.PaymentMethod) where a.DocumentNo == (DocumentNo ?? a.DocumentNo) && a.Date.AddHours(Offset).Date >= DateFrom.Value.Date && a.Date.AddHours(Offset).Date <= DateTo.Value.Date orderby a.DocumentNo select new BankExpenditureNoteReportViewModel { DocumentNo = a.DocumentNo, Currency = a.BankCurrencyCode, Date = a.Date, SupplierName = c.SupplierName, CategoryName = c.CategoryName == null ? "-" : c.CategoryName, DivisionName = c.DivisionName, PaymentMethod = c.PaymentMethod, UnitPaymentOrderNo = b.UnitPaymentOrderNo, BankName = string.Concat(a.BankAccountName, " - ", a.BankName, " - ", a.BankAccountNumber, " - ", a.BankCurrencyCode), DPP = c.TotalPaid - c.Vat, VAT = c.Vat, TotalPaid = c.TotalPaid, InvoiceNumber = c.InvoiceNo } ); } Pageable <BankExpenditureNoteReportViewModel> pageable = new Pageable <BankExpenditureNoteReportViewModel>(Query, Page - 1, Size); List <object> data = pageable.Data.ToList <object>(); return(new ReadResponse <object>(data, pageable.TotalCount, new Dictionary <string, string>())); }
public static Pageable <GridSortingViewModel> ToGridSortingViewModelList(this IEnumerable <SortModel> src, Pageable <GridSortingViewModel> dest) { if (src != null) { foreach (var s in src) { dest.Add(ExampleMapper.MapToGridSortingViewModel(s)); } } return(dest); }
public ReadResponse <object> Read(int Page = 1, int Size = 25, string Order = "{}", string Keyword = null, string Filter = "{}") { IQueryable <BankExpenditureNoteModel> Query = this.dbSet; var queryItems = Query.Select(x => x.Details.Select(y => y.Items).ToList()); Query = Query .Select(s => new BankExpenditureNoteModel { Id = s.Id, CreatedUtc = s.CreatedUtc, LastModifiedUtc = s.LastModifiedUtc, BankName = s.BankName, BankAccountName = s.BankAccountName, BankAccountNumber = s.BankAccountNumber, DocumentNo = s.DocumentNo, SupplierName = s.SupplierName, GrandTotal = s.GrandTotal, BankCurrencyCode = s.BankCurrencyCode, CurrencyRate = s.CurrencyRate, IsPosted = s.IsPosted, Details = s.Details.Where(x => x.BankExpenditureNoteId == s.Id).Select(a => new BankExpenditureNoteDetailModel { SupplierName = a.SupplierName, UnitPaymentOrderNo = a.UnitPaymentOrderNo, Items = a.Items.Where(b => b.BankExpenditureNoteDetailId == a.Id).ToList() }).ToList() }); List <string> searchAttributes = new List <string>() { "DocumentNo", "BankName", "SupplierName", "BankCurrencyCode" }; Query = QueryHelper <BankExpenditureNoteModel> .ConfigureSearch(Query, searchAttributes, Keyword); Dictionary <string, string> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Filter); Query = QueryHelper <BankExpenditureNoteModel> .ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); Query = QueryHelper <BankExpenditureNoteModel> .ConfigureOrder(Query, OrderDictionary); Pageable <BankExpenditureNoteModel> pageable = new Pageable <BankExpenditureNoteModel>(Query, Page - 1, Size); List <BankExpenditureNoteModel> Data = pageable.Data.ToList(); List <object> list = new List <object>(); list.AddRange( Data.Select(s => new { s.Id, s.DocumentNo, s.CreatedUtc, s.BankName, s.BankAccountName, s.BankAccountNumber, s.SupplierName, s.GrandTotal, s.BankCurrencyCode, s.IsPosted, Details = s.Details.Select(sl => new { sl.SupplierName, sl.UnitPaymentOrderNo, sl.Items }).ToList(), }).ToList() ); int TotalData = pageable.TotalCount; return(new ReadResponse <object>(list, TotalData, OrderDictionary)); }
public static Pageable <DummyViewModel> ToPageableDummyViewModel(IEnumerable <DummyModel> src, Pageable <DummyViewModel> dest) { if (src != null) { foreach (var s in src) { var dummyViewModel = new DummyViewModel(); Map(s, dummyViewModel); dest.Add(dummyViewModel); } } return(dest); }
public Tuple <List <object>, int, Dictionary <string, string> > Read(int page = 1, int size = 25, string order = "{}", string keyword = null, string filter = "{}") { IQueryable <PurchasingDocumentExpedition> Query = this.dbContext.PurchasingDocumentExpeditions; Query = Query .Select(s => new PurchasingDocumentExpedition { Id = s.Id, UnitPaymentOrderNo = s.UnitPaymentOrderNo, UPODate = s.UPODate, DueDate = s.DueDate, InvoiceNo = s.InvoiceNo, PaymentMethod = s.PaymentMethod, SupplierCode = s.SupplierCode, SupplierName = s.SupplierName, CategoryCode = s.CategoryCode, CategoryName = s.CategoryName, DivisionCode = s.DivisionCode, DivisionName = s.DivisionName, TotalPaid = s.TotalPaid, Currency = s.Currency, Position = s.Position, IsPaid = s.IsPaid, IsPaidPPH = s.IsPaidPPH, VerifyDate = s.VerifyDate, LastModifiedUtc = s.LastModifiedUtc, Active = s.Active, IsDeleted = s.IsDeleted, Vat = s.Vat, IncomeTax = s.IncomeTax }); List <string> searchAttributes = new List <string>() { "UnitPaymentOrderNo", "InvoiceNo", "SupplierName", "DivisionName" }; Query = QueryHelper <PurchasingDocumentExpedition> .ConfigureSearch(Query, searchAttributes, keyword); if (filter.Contains("verificationFilter")) { filter = "{}"; List <ExpeditionPosition> positions = new List <ExpeditionPosition> { ExpeditionPosition.SEND_TO_PURCHASING_DIVISION, ExpeditionPosition.SEND_TO_ACCOUNTING_DIVISION, ExpeditionPosition.SEND_TO_CASHIER_DIVISION }; Query = Query.Where(p => positions.Contains(p.Position)); } Dictionary <string, string> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(filter); Query = QueryHelper <PurchasingDocumentExpedition> .ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); Query = QueryHelper <PurchasingDocumentExpedition> .ConfigureOrder(Query, OrderDictionary); Pageable <PurchasingDocumentExpedition> pageable = new Pageable <PurchasingDocumentExpedition>(Query, page - 1, size); List <PurchasingDocumentExpedition> Data = pageable.Data.ToList <PurchasingDocumentExpedition>(); int TotalData = pageable.TotalCount; List <object> list = new List <object>(); list.AddRange( Data.Select(s => new { Id = s.Id, UnitPaymentOrderNo = s.UnitPaymentOrderNo, UPODate = s.UPODate, InvoiceNo = s.InvoiceNo, PaymentMethod = s.PaymentMethod, DueDate = s.DueDate, SupplierName = s.SupplierName, CategoryName = s.CategoryName, DivisionName = s.DivisionName, TotalPaid = s.TotalPaid, Currency = s.Currency, Position = s.Position, VerifyDate = s.VerifyDate, _LastModifiedUtc = s.LastModifiedUtc, s.Active, s.IsDeleted, s.IncomeTax, s.Vat }).ToList() ); return(Tuple.Create(list, TotalData, OrderDictionary)); }
public void QueryEntities() { string storageUri = StorageUri; string accountName = StorageAccountName; string storageAccountKey = PrimaryStorageAccountKey; string tableName = "OfficeSupplies4p1"; string partitionKey = "somePartition"; string rowKey = "1"; string rowKey2 = "2"; var serviceClient = new TableServiceClient( new Uri(storageUri), new TableSharedKeyCredential(accountName, storageAccountKey)); serviceClient.CreateTable(tableName); var tableClient = serviceClient.GetTableClient(tableName); var entity = new TableEntity(partitionKey, rowKey) { { "Product", "Markers" }, { "Price", 5.00 }, { "Quantity", 34 } }; tableClient.AddEntity(entity); var entity2 = new TableEntity(partitionKey, rowKey2) { { "Product", "Planner" }, { "Price", 7.00 }, { "Quantity", 34 } }; tableClient.AddEntity(entity2); #region Snippet:TablesSample4QueryEntitiesFilter Pageable <TableEntity> queryResultsFilter = tableClient.Query <TableEntity>(filter: $"PartitionKey eq '{partitionKey}'"); // Iterate the <see cref="Pageable"> to access all queried entities. foreach (TableEntity qEntity in queryResultsFilter) { Console.WriteLine($"{qEntity.GetString("Product")}: {qEntity.GetDouble("Price")}"); } Console.WriteLine($"The query returned {queryResultsFilter.Count()} entities."); #endregion #region Snippet:TablesSample4QueryEntitiesFilterWithQueryFilter // The CreateQueryFilter method is also available to assist with properly formatting and escaping OData queries. #if SNIPPET Pageable <TableEntity> queryResultsFilter = tableClient.Query <TableEntity>(filter: TableClient.CreateQueryFilter($"PartitionKey eq {partitionKey}")); #else queryResultsFilter = tableClient.Query <TableEntity>(filter: TableClient.CreateQueryFilter($"PartitionKey eq {partitionKey}")); #endif // Iterate the <see cref="Pageable"> to access all queried entities. foreach (TableEntity qEntity in queryResultsFilter) { Console.WriteLine($"{qEntity.GetString("Product")}: {qEntity.GetDouble("Price")}"); } Console.WriteLine($"The query returned {queryResultsFilter.Count()} entities."); #endregion #region Snippet:TablesSample4QueryEntitiesExpression double priceCutOff = 6.00; Pageable <OfficeSupplyEntity> queryResultsLINQ = tableClient.Query <OfficeSupplyEntity>(ent => ent.Price >= priceCutOff); #endregion #region Snippet:TablesMigrationQuery // Execute the query. Pageable <OfficeSupplyEntity> queryResults = tableClient.Query <OfficeSupplyEntity>(e => e.PartitionKey == partitionKey && e.RowKey == rowKey); // Display the results foreach (var item in queryResults.ToList()) { Console.WriteLine($"{item.PartitionKey}, {item.RowKey}, {item.Product}, {item.Price}, {item.Quantity}"); } #endregion #region Snippet:TablesSample4QueryEntitiesSelect Pageable <TableEntity> queryResultsSelect = tableClient.Query <TableEntity>(select: new List <string>() { "Product", "Price" }); #endregion #region Snippet:TablesSample4QueryEntitiesMaxPerPage Pageable <TableEntity> queryResultsMaxPerPage = tableClient.Query <TableEntity>(maxPerPage: 10); // Iterate the <see cref="Pageable"> by page. foreach (Page <TableEntity> page in queryResultsMaxPerPage.AsPages()) { Console.WriteLine("This is a new page!"); foreach (TableEntity qEntity in page.Values) { Console.WriteLine($"# of {qEntity.GetString("Product")} inventoried: {qEntity.GetInt32("Quantity")}"); } } #endregion serviceClient.DeleteTable(tableName); }
public ReadResponse <ClearaceVBViewModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { var query = _RequestDbSet.AsQueryable(); var realizationQuery = _RealizationDbSet.AsQueryable().Where(s => s.Position == VBRealizationPosition.Cashier); List <string> SearchAttributes = new List <string>() { "RqstNo", "Appliciant", "RealNo", "Status", "DiffStatus" }; var vbRequestQuery = _RequestDbSet.AsQueryable(); var vbRealizationQuery = _RealizationDbSet.AsQueryable().Where(s => s.Position == VBRealizationPosition.Cashier); var newQuery = from realization in vbRealizationQuery join request in vbRequestQuery on realization.VBRequestDocumentId equals request.Id into vbRequestRealizations from vbRequestRealization in vbRequestRealizations.DefaultIfEmpty() select new ClearaceVBViewModel() { Id = realization.VBRequestDocumentId, VBRealizationDocumentId = realization.Id, RqstNo = realization.VBRequestDocumentNo, VBCategory = realization.Type, RqstDate = realization.VBRequestDocumentDate, //RqstDate = rqst.Date.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")), Unit = new Unit() { Id = realization.SuppliantUnitId, Name = realization.SuppliantUnitName, }, Appliciant = realization.VBRequestDocumentCreatedBy, RealNo = realization.DocumentNo, RealDate = realization.Date, //RealDate = rqst.Realization_Status == true ? real.Date.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")) : "", VerDate = realization.VerificationDate, //VerDate = real.isVerified == true ? real.VerifiedDate.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")) : "", //DiffStatus = real.StatusReqReal, DiffAmount = realization.VBRequestDocumentAmount - realization.Amount, ClearanceDate = vbRequestRealization != null ? vbRequestRealization.CompletedDate : realization.CompletedDate, DiffStatus = realization.VBRequestDocumentAmount - realization.Amount < 0 ? "Kurang" : realization.VBRequestDocumentAmount - realization.Amount > 0 ? "Sisa" : "Sesuai", //ClearanceDate = rqst.Complete_Status == true ? rqst.CompleteDate.ToString() : "", IsPosted = vbRequestRealization != null ? vbRequestRealization.IsCompleted : realization.IsCompleted, Status = vbRequestRealization != null ? vbRequestRealization.IsCompleted ? "Completed" : "Uncompleted" : "", LastModifiedUtc = realization.LastModifiedUtc, CurrencyCode = realization.CurrencyCode }; //var data = query // .Join(realizationQuery, // (rqst) => rqst.Id, // (real) => real.VBRequestDocumentId, // (rqst, real) => new ClearaceVBViewModel() // { // Id = rqst.Id, // VBRealizationDocumentId = real.Id, // RqstNo = rqst.DocumentNo, // VBCategory = rqst.Type, // RqstDate = rqst.Date, // //RqstDate = rqst.Date.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")), // Unit = new Unit() // { // Id = rqst.SuppliantUnitId, // Name = rqst.SuppliantUnitName, // }, // Appliciant = rqst.CreatedBy, // RealNo = real.DocumentNo, // RealDate = real.Date, // //RealDate = rqst.Realization_Status == true ? real.Date.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")) : "", // VerDate = real.VerificationDate, // //VerDate = real.isVerified == true ? real.VerifiedDate.AddHours(7).ToString("dd MMMM yyyy", new CultureInfo("id-ID")) : "", // //DiffStatus = real.StatusReqReal, // DiffAmount = rqst.Amount - real.Amount, // ClearanceDate = rqst.CompletedDate, // DiffStatus = rqst.Amount - real.Amount < 0 ? "Kurang" : rqst.Amount - real.Amount > 0 ? "Sisa" : "Sesuai", // //ClearanceDate = rqst.Complete_Status == true ? rqst.CompleteDate.ToString() : "", // IsPosted = rqst.IsCompleted, // Status = rqst.IsCompleted ? "Completed" : "Uncompleted", // LastModifiedUtc = real.LastModifiedUtc, // }) // .OrderByDescending(s => s.LastModifiedUtc).AsQueryable(); newQuery = newQuery.OrderByDescending(entity => entity.LastModifiedUtc); newQuery = Search(newQuery, SearchAttributes, keyword); var filterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); newQuery = Filter(newQuery, filterDictionary); var orderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); newQuery = Order(newQuery, orderDictionary); var pageable = new Pageable <ClearaceVBViewModel>(newQuery, page - 1, size); var data = pageable.Data.ToList(); int totalData = pageable.TotalCount; return(new ReadResponse <ClearaceVBViewModel>(data, totalData, orderDictionary, new List <string>())); }
/// <summary> /// /// </summary> public Resources([JsonProperty("list")] IEnumerable <T> resourcesList, [JsonProperty("totalCount")] long total, [JsonProperty("Pageable")] Pageable pageable) : this(resourcesList, total, pageable.PageNo, pageable.PageSize) { }
public void ThreadCGUD_ParticipantAUR_MessageGSU_NotificationT() { //arr Console.WriteLine($"ThreadCGUD_ParticipantAUR_MessageGSU_NotificationT Running on RecordedTestMode : {Mode}"); CommunicationIdentityClient communicationIdentityClient = CreateInstrumentedCommunicationIdentityClient(); (CommunicationUserIdentifier user1, string token1) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user2, _) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user3, string token3) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user4, _) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user5, _) = CreateUserAndToken(communicationIdentityClient); string repeatabilityRequestId1 = "contoso-F0A747F1-6245-4307-8267-B974340677D2"; string repeatabilityRequestId2 = "contoso-A0A747F1-6245-4307-8267-B974340677DA"; var topic = "Thread sync from C# sdk"; var displayNameMessage = "DisplayName sender message 1"; var participants = new[] { new ChatParticipant(user1), new ChatParticipant(user2), new ChatParticipant(user3) }; ChatClient chatClient = CreateInstrumentedChatClient(token1); ChatClient chatClient3 = CreateInstrumentedChatClient(token3); //act CreateChatThreadResult createChatThreadResult = chatClient.CreateChatThread(topic, participants, repeatabilityRequestId1); ChatThreadClient chatThreadClient = GetInstrumentedChatThreadClient(chatClient, createChatThreadResult.ChatThread.Id); var threadId = chatThreadClient.Id; CreateChatThreadResult createChatThreadResult2 = chatClient.CreateChatThread(topic, participants, repeatabilityRequestId2); ChatThreadClient chatThreadClient2 = GetInstrumentedChatThreadClient(chatClient, createChatThreadResult2.ChatThread.Id); ChatThreadClient chatThreadClient3 = GetInstrumentedChatThreadClient(chatClient3, threadId); Pageable <ChatParticipant> chatParticipantsOnCreation = chatThreadClient.GetParticipants(); var chatParticipantsOnCreationCount = chatParticipantsOnCreation.Count(); string updatedTopic = "Launch meeting"; chatThreadClient.UpdateTopic(topic: "Launch meeting"); ChatThread chatThread = chatClient.GetChatThread(threadId); string messageContent = "Let's meet at 11am"; string messageId = chatThreadClient.SendMessage("Let's meet at 11am"); string messageContent2 = "Content for message 2"; string messageId2 = chatThreadClient2.SendMessage(messageContent2, ChatMessageType.Text, displayNameMessage); string messageContent3 = "Content for message 3"; string messageId3 = chatThreadClient3.SendMessage(messageContent3, ChatMessageType.Html, displayNameMessage); string messageContent4 = "Content for message 4"; string messageId4 = chatThreadClient3.SendMessage(messageContent4, ChatMessageType.Text, displayNameMessage); string messageContent5 = "Content for message 5"; string messageId5 = chatThreadClient3.SendMessage(messageContent5, ChatMessageType.Html, displayNameMessage); string messageContent6 = "Content for message 6"; string messageId6 = chatThreadClient3.SendMessage(messageContent6, ChatMessageType.Text, displayNameMessage); ChatMessage message = chatThreadClient.GetMessage(messageId); ChatMessage message2 = chatThreadClient2.GetMessage(messageId2); ChatMessage message3 = chatThreadClient3.GetMessage(messageId3); ChatMessage message4 = chatThreadClient3.GetMessage(messageId4); ChatMessage message5 = chatThreadClient3.GetMessage(messageId5); ChatMessage message6 = chatThreadClient3.GetMessage(messageId6); Pageable <ChatMessage> messages = chatThreadClient.GetMessages(); Pageable <ChatMessage> messages2 = chatThreadClient2.GetMessages(); var getMessagesCount = messages.Count(); var getMessagesCount2 = messages2.Count(); Pageable <ChatMessage> pageableMessages = chatThreadClient.GetMessages(); PageableTester <ChatMessage> .AssertPagination(enumerableResource : pageableMessages, expectedPageSize : 2, expectedTotalResources : 8); string updatedMessageContent = "Instead of 11am, let's meet at 2pm"; chatThreadClient.UpdateMessage(messageId, content: "Instead of 11am, let's meet at 2pm"); Response <ChatMessage> actualUpdateMessage = chatThreadClient.GetMessage(messageId); chatThreadClient.DeleteMessage(messageId); Pageable <ChatMessage> messagesAfterOneDeleted = chatThreadClient.GetMessages(); ChatMessage deletedChatMessage = messagesAfterOneDeleted.First(x => x.Id == messageId); Pageable <ChatParticipant> chatParticipants = chatThreadClient.GetParticipants(); var chatParticipantsCount = chatParticipants.Count(); var newParticipant = new ChatParticipant(user4); var newParticipant2 = new ChatParticipant(user5); chatThreadClient.AddParticipants(participants: new[] { newParticipant }); AddChatParticipantsResult addChatParticipantsResult = chatThreadClient.AddParticipant(newParticipant2); Pageable <ChatParticipant> chatParticipantsAfterTwoAdded = chatThreadClient.GetParticipants(); PageableTester <ChatParticipant> .AssertPagination(enumerableResource : chatParticipantsAfterTwoAdded, expectedPageSize : 2, expectedTotalResources : 5); var chatParticipantsAfterTwoAddedCount = chatParticipantsAfterTwoAdded.Count(); CommunicationUserIdentifier participantToBeRemoved = user4; chatThreadClient.RemoveParticipant(user: participantToBeRemoved); Pageable <ChatParticipant> chatParticipantAfterOneDeleted = chatThreadClient.GetParticipants(); var chatParticipantAfterOneDeletedCount = chatParticipantAfterOneDeleted.Count(); Response typingNotificationResponse = chatThreadClient.SendTypingNotification(); chatThreadClient.SendTypingNotification(); Pageable <ChatThreadInfo> threads = chatClient.GetChatThreadsInfo(); var threadsCount = threads.Count(); chatClient.DeleteChatThread(threadId); //assert Assert.AreEqual(updatedTopic, chatThread.Topic); Assert.AreEqual(3, chatParticipantsOnCreationCount); Assert.AreEqual(messageContent, message.Content.Message); Assert.AreEqual(updatedMessageContent, actualUpdateMessage.Value.Content.Message); Assert.AreEqual(ChatMessageType.Text, message.Type); Assert.AreEqual(messageContent2, message2.Content.Message); Assert.AreEqual(displayNameMessage, message2.SenderDisplayName); Assert.AreEqual(messageContent3, message3.Content.Message); Assert.AreEqual(messageContent4, message4.Content.Message); Assert.AreEqual(messageContent5, message5.Content.Message); Assert.AreEqual(messageContent6, message6.Content.Message); Assert.AreEqual(2, threadsCount); Assert.AreEqual(8, getMessagesCount); //Including all types : 5 text message, 3 control messages Assert.AreEqual(3, getMessagesCount2); //Including all types : 1 text message, 2 control messages Assert.IsTrue(deletedChatMessage.DeletedOn.HasValue); Assert.AreEqual(3, chatParticipantsCount); Assert.AreEqual(5, chatParticipantsAfterTwoAddedCount); Assert.AreEqual(4, chatParticipantAfterOneDeletedCount); Assert.IsNull(addChatParticipantsResult.Errors); Assert.AreEqual((int)HttpStatusCode.OK, typingNotificationResponse.Status); }
public override Tuple <List <Category>, int, Dictionary <string, string>, List <string> > ReadModel(int Page = 1, int Size = 25, string Order = "{}", List <string> Select = null, string Keyword = null, string Filter = "{}") { IQueryable <Category> Query = this.DbContext.Categories; Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(Filter); Query = ConfigureFilter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); /* Search With Keyword */ if (Keyword != null) { List <string> SearchAttributes = new List <string>() { "Code", "Name" }; Query = Query.Where(General.BuildSearch(SearchAttributes), Keyword); } /* Const Select */ List <string> SelectedFields = new List <string>() { "_id", "code", "name", "PurchasingCOA", "StockCOA", "LocalDebtCOA", "ImportDebtCOA" }; Query = Query .Select(b => new Category { Id = b.Id, Code = b.Code, Name = b.Name, PurchasingCOA = b.PurchasingCOA, StockCOA = b.StockCOA, LocalDebtCOA = b.LocalDebtCOA, ImportDebtCOA = b.ImportDebtCOA }); /* Order */ if (OrderDictionary.Count.Equals(0)) { OrderDictionary.Add("_updatedDate", General.DESCENDING); Query = Query.OrderByDescending(b => b._LastModifiedUtc); /* Default Order */ } else { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string TransformKey = General.TransformOrderBy(Key); BindingFlags IgnoreCase = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance; Query = OrderType.Equals(General.ASCENDING) ? Query.OrderBy(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)) : Query.OrderByDescending(b => b.GetType().GetProperty(TransformKey, IgnoreCase).GetValue(b)); } /* Pagination */ Pageable <Category> pageable = new Pageable <Category>(Query, Page - 1, Size); List <Category> Data = pageable.Data.ToList <Category>(); int TotalData = pageable.TotalCount; return(Tuple.Create(Data, TotalData, OrderDictionary, SelectedFields)); }
public ReadResponse <DailyBankTransactionModel> Read(int page, int size, string order, List <string> select, string keyword, string filter) { IQueryable <DailyBankTransactionModel> Query = _DbSet; Query = Query .Select(s => new DailyBankTransactionModel { Id = s.Id, CreatedUtc = s.CreatedUtc, Code = s.Code, LastModifiedUtc = s.LastModifiedUtc, AccountBankName = s.AccountBankName, AccountBankAccountName = s.AccountBankAccountName, AccountBankAccountNumber = s.AccountBankAccountNumber, AccountBankCode = s.AccountBankCode, AccountBankCurrencyCode = s.AccountBankCurrencyCode, AccountBankCurrencyId = s.AccountBankCurrencyId, AccountBankCurrencySymbol = s.AccountBankCurrencySymbol, AccountBankId = s.AccountBankId, Date = s.Date, ReferenceNo = s.ReferenceNo, ReferenceType = s.ReferenceType, Status = s.Status, SourceType = s.SourceType }); List <string> searchAttributes = new List <string>() { "Code", "ReferenceNo", "ReferenceType", "AccountBankName", "AccountBankCurrencyCode", "Status", "SourceType" }; Query = QueryHelper <DailyBankTransactionModel> .Search(Query, searchAttributes, keyword); Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter); Query = QueryHelper <DailyBankTransactionModel> .Filter(Query, FilterDictionary); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order); Query = QueryHelper <DailyBankTransactionModel> .Order(Query, OrderDictionary); Pageable <DailyBankTransactionModel> pageable = new Pageable <DailyBankTransactionModel>(Query, page - 1, size); List <DailyBankTransactionModel> Data = pageable.Data.ToList(); List <DailyBankTransactionModel> list = new List <DailyBankTransactionModel>(); list.AddRange( Data.Select(s => new DailyBankTransactionModel { Id = s.Id, CreatedUtc = s.CreatedUtc, Code = s.Code, LastModifiedUtc = s.LastModifiedUtc, AccountBankName = s.AccountBankName, AccountBankAccountName = s.AccountBankAccountName, AccountBankAccountNumber = s.AccountBankAccountNumber, AccountBankCode = s.AccountBankCode, AccountBankCurrencyCode = s.AccountBankCurrencyCode, AccountBankCurrencyId = s.AccountBankCurrencyId, AccountBankCurrencySymbol = s.AccountBankCurrencySymbol, AccountBankId = s.AccountBankId, Date = s.Date, ReferenceNo = s.ReferenceNo, ReferenceType = s.ReferenceType, Status = s.Status, SourceType = s.SourceType }).ToList() ); int TotalData = pageable.TotalCount; return(new ReadResponse <DailyBankTransactionModel>(list, TotalData, OrderDictionary, new List <string>())); }
public void ThreadCGUD_MemberAUR_MessageGSU_NotificationT() { //arr Console.WriteLine($"ThreadCGUD_MemberAUR_MessageGSU_NotificationT Running on RecordedTestMode : {Mode}"); CommunicationIdentityClient communicationIdentityClient = CreateInstrumentedCommunicationIdentityClient(); (CommunicationUserIdentifier user1, string token1) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user2, string token2) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user3, string token3) = CreateUserAndToken(communicationIdentityClient); (CommunicationUserIdentifier user4, string token4) = CreateUserAndToken(communicationIdentityClient); var topic = "Thread sync from C# sdk"; var displayNameMessage = "DisplayName sender message 1"; var members = new List <ChatThreadMember> { new ChatThreadMember(user1), new ChatThreadMember(user2), new ChatThreadMember(user3) }; ChatClient chatClient = CreateInstrumentedChatClient(token1); ChatClient chatClient2 = CreateInstrumentedChatClient(token2); ChatClient chatClient3 = CreateInstrumentedChatClient(token3); //act #region Snippet:Azure_Communication_Chat_Tests_E2E_InitializeChatThreadClient //@@ChatThreadClient chatThreadClient1 = chatClient.CreateChatThread("Thread topic", members); // Alternatively, if you have created a chat thread before and you have its threadId, you can create a ChatThreadClient instance using: //@@ChatThreadClient chatThreadClient2 = chatClient.GetChatThreadClient("threadId"); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_InitializeChatThreadClient ChatThreadClient chatThreadClient = CreateInstrumentedChatThreadClient(chatClient, topic, members); var threadId = chatThreadClient.Id; ChatThreadClient chatThreadClient2 = CreateInstrumentedChatThreadClient(chatClient, topic, members); ChatThreadClient chatThreadClient3 = GetInstrumentedChatThreadClient(chatClient3, threadId); string updatedTopic = "Launch meeting"; #region Snippet:Azure_Communication_Chat_Tests_E2E_UpdateThread chatThreadClient.UpdateThread(topic: "Launch meeting"); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_UpdateThread #region Snippet:Azure_Communication_Chat_Tests_E2E_GetChatThread ChatThread chatThread = chatClient.GetChatThread(threadId); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_GetChatThread #region Snippet:Azure_Communication_Chat_Tests_E2E_GetChatThreadsInfo Pageable <ChatThreadInfo> threads = chatClient.GetChatThreadsInfo(); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_GetChatThreadsInfo var threadsCount = threads.Count(); string messageContent = "Let's meet at 11am"; #region Snippet:Azure_Communication_Chat_Tests_E2E_SendMessage SendChatMessageResult sendChatMessageResult = chatThreadClient.SendMessage("Let's meet at 11am"); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_SendMessage var messageContent2 = "Content for message 2"; SendChatMessageResult sendChatMessageResult2 = chatThreadClient2.SendMessage(messageContent2, ChatMessagePriority.High, displayNameMessage); var messageContent3 = "Content for message 3"; SendChatMessageResult sendChatMessageResult3 = chatThreadClient3.SendMessage(messageContent3, ChatMessagePriority.High, displayNameMessage); var messageContent4 = "Content for message 4"; SendChatMessageResult sendChatMessageResult4 = chatThreadClient3.SendMessage(messageContent4, ChatMessagePriority.High, displayNameMessage); var messageContent5 = "Content for message 5"; SendChatMessageResult sendChatMessageResult5 = chatThreadClient3.SendMessage(messageContent5, ChatMessagePriority.High, displayNameMessage); var messageContent6 = "Content for message 6"; SendChatMessageResult sendChatMessageResult6 = chatThreadClient3.SendMessage(messageContent6, ChatMessagePriority.High, displayNameMessage); var messageId = sendChatMessageResult.Id; var messageId2 = sendChatMessageResult2.Id; var messageId3 = sendChatMessageResult3.Id; var messageId4 = sendChatMessageResult4.Id; var messageId5 = sendChatMessageResult5.Id; var messageId6 = sendChatMessageResult6.Id; #region Snippet:Azure_Communication_Chat_Tests_E2E_GetMessage ChatMessage message = chatThreadClient.GetMessage(messageId); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_GetMessage ChatMessage message2 = chatThreadClient2.GetMessage(messageId2); ChatMessage message3 = chatThreadClient3.GetMessage(messageId3); ChatMessage message4 = chatThreadClient3.GetMessage(messageId4); ChatMessage message5 = chatThreadClient3.GetMessage(messageId5); ChatMessage message6 = chatThreadClient3.GetMessage(messageId6); #region Snippet:Azure_Communication_Chat_Tests_E2E_GetMessages Pageable <ChatMessage> messages = chatThreadClient.GetMessages(); #endregion Snippet:Azure_Communication_Chat_Tests_E2E_GetMessages Pageable <ChatMessage> messages2 = chatThreadClient2.GetMessages(); var getMessagesCount = messages.Count(); var getMessagesCount2 = messages2.Count(); # region Pagination assertions
public async Task <ReadResponse <object> > GetReport(int Size, int Page, string Order, string UnitPaymentOrderNo, string SupplierCode, DateTimeOffset?DateFrom, DateTimeOffset?DateTo, int Offset) { if (!DateFrom.HasValue && !DateTo.HasValue) { DateFrom = DateTimeOffset.Now.AddHours(Offset).AddMonths(-1); DateTo = DateTimeOffset.Now.AddHours(Offset); } else if (!DateFrom.HasValue && DateTo.HasValue) { DateTo = DateTo.Value.AddHours(Offset); DateFrom = DateTo.Value.AddMonths(-1); } else if (DateFrom.HasValue && !DateTo.HasValue) { DateFrom = DateFrom.Value.AddHours(Offset); DateTo = DateFrom.Value.AddMonths(1); } else { DateFrom = DateFrom.Value.AddHours(Offset); DateTo = DateTo.Value.AddHours(Offset); } var listData = GetPurchasingDocumentExpedition(Size, Page, UnitPaymentOrderNo, SupplierCode, DateFrom.Value, DateTo.Value); List <UnitPaymentOrderUnpaidViewModel> dataMongo = await GetReportMongo(UnitPaymentOrderNo, SupplierCode, DateFrom.Value, DateTo.Value); IQueryable <UnitPaymentOrderUnpaidViewModel> resultQuery = (from a in dataMongo join b in listData on a.UnitPaymentOrderNo equals b.UnitPaymentOrderNo into ab from b in ab.DefaultIfEmpty() select new UnitPaymentOrderUnpaidViewModel { UnitPaymentOrderNo = a.UnitPaymentOrderNo, UPODate = a.UPODate, InvoiceNo = a.InvoiceNo, SupplierName = a.SupplierName, Currency = a.Currency, IncomeTax = b == null ? 0 : b.IncomeTax, DPPVat = b == null ? 0 : b.DPPVat, DueDate = a.DueDate, ProductName = a.ProductName, Quantity = a.Quantity, UnitName = a.UnitName, TotalPaid = 0 }).AsQueryable(); Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(Order); if (OrderDictionary.Count > 0) { string Key = OrderDictionary.Keys.First(); string OrderType = OrderDictionary[Key]; string orderField = string.Concat(Key.Replace(".", ""), " ", OrderType); resultQuery = resultQuery.OrderBy(orderField); } Pageable <UnitPaymentOrderUnpaidViewModel> pageable = new Pageable <UnitPaymentOrderUnpaidViewModel>(resultQuery, Page - 1, Size); List <UnitPaymentOrderUnpaidViewModel> Data = await pageable.Data.ToDynamicListAsync <UnitPaymentOrderUnpaidViewModel>(); int TotalData = pageable.TotalCount; return(new ReadResponse <object>(Data.ToList <object>(), TotalData, OrderDictionary)); }