//[begin coding function block]//[end coding function block] #region QueryFunctions public IEnumerable <ENT_CycleCountValidation> ENT_CycleCountValidation_Query(Kendo.Mvc.UI.DataSourceRequest request, out int Total) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_CycleCountValidation.AsEnumerable().Select(s => new ENT_CycleCountValidation() { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Cycle_Count_Discrepancy_Template = s.Cycle_Count_Discrepancy_Template, Description = s.Description, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, }) .ToDataSourceResult(request); Total = result.Total; return(result.Data as IEnumerable <ENT_CycleCountValidation>); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "IEnumerable<ENT_CycleCountValidation> ENT_CycleCountValidation_Query", ex.Message)); Total = 0; return(null); } }
public DataSourceResult ENT_BOM_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_BOM.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Component_ID = s.Component_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Notes = s.Notes, Owner_Code = s.Owner_Code, Quantity = s.Quantity, Sequence = s.Sequence, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_BOM_Read", ex.Message)); return(null); } }
//[begin coding function block]//[end coding function block] #region QueryFunctions public IEnumerable <ENT_Delivery_Note> ENT_Delivery_Note_Query(Kendo.Mvc.UI.DataSourceRequest request, out int Total) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_Delivery_Note.AsEnumerable().Select(s => new ENT_Delivery_Note() { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Note = s.Note, Printed_Date = s.Printed_Date, SO_Detail_ID = s.SO_Detail_ID, Warehouse_ID = s.Warehouse_ID, }) .ToDataSourceResult(request); Total = result.Total; return(result.Data as IEnumerable <ENT_Delivery_Note>); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "IEnumerable<ENT_Delivery_Note> ENT_Delivery_Note_Query", ex.Message)); Total = 0; return(null); } }
public DataSourceResult WHS_Pick_Detail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Pick_Detail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, Location_ID = s.Location_ID, Lot_Attribute_ID = s.Lot_Attribute_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Pack_ID = s.Pack_ID, Picking_Line_No = s.Picking_Line_No, PickStatus_ID = s.PickStatus_ID, Quantity = s.Quantity, SO_Detail_ID = s.SO_Detail_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Pick_Detail_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_ReceiptReversal_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_ReceiptReversal.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Adjustment_number_ID = s.Adjustment_number_ID, ASN_ID = s.ASN_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Effective_date = s.Effective_date, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_ReceiptReversal_Read", ex.Message)); return(null); } }
public DataSourceResult ENT_User_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_User.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Encrypt = s.Encrypt, Full_Name = s.Full_Name, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Name = s.Name, Password = s.Password, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_User_Read", ex.Message)); return(null); } }
public DataSourceResult ENT_LottableValidationDetail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_LottableValidationDetail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, GenerateMask = s.GenerateMask, ID = s.ID, IsDeleted = s.IsDeleted, Lottable_name = s.Lottable_name, MaximumLength = s.MaximumLength, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Required = s.Required, V_Lot_ID = s.V_Lot_ID, Visible = s.Visible, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_LottableValidationDetail_Read", ex.Message)); return(null); } }
public DataSourceResult ENT_OutboundValidation_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_OutboundValidation.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Conditional_Validation_ID = s.Conditional_Validation_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Customer_ID = s.Customer_ID, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Outbound_validation_code = s.Outbound_validation_code, Owner_ID = s.Owner_ID, Type = s.Type, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_OutboundValidation_Read", ex.Message)); return(null); } }
public void CanCreateUserWarehouse() { var request = new DataSourceRequest(); var userWarehouseViewModel = new HubUserViewModel { UserHubID = 2, HubID = 1, UserProfileID = 2, IsDefault = "False" }; var result = _userWarehouseController.Create(request,userWarehouseViewModel); Assert.IsInstanceOf<JsonResult>(result); }
public DataSourceResult WHS_Transaction_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Transaction.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Activity_ID = s.Activity_ID, Add_Date = s.Add_Date, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Edit_Date = s.Edit_Date, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, User_Add = s.User_Add, User_Update = s.User_Update, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Transaction_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_GoodReceiptNote_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_GoodReceiptNote.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, ASN_Detail_ID = s.ASN_Detail_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Date_time_print_GRN = s.Date_time_print_GRN, ID = s.ID, IsDeleted = s.IsDeleted, Line_No = s.Line_No, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Note = s.Note, Total_quantity = s.Total_quantity, User_ID = s.User_ID, Warehouse_ID = s.Warehouse_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_GoodReceiptNote_Read", ex.Message)); return(null); } }
public void ShouldUpdateCommodityType() { var commdityType = new CommodityTypeViewModel() { CommodityTypeId = 1, Name = "CSB" }; var request = new DataSourceRequest(); var result = _commodityTypeController.CommodityType_Update(request,commdityType); Assert.IsInstanceOf<JsonResult>(result); }
public DataSourceResult ENT_CycleClass_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_CycleClass.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Cycle_Class_Code = s.Cycle_Class_Code, Days = s.Days, Description = s.Description, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Percent_Negative_Variance = s.Percent_Negative_Variance, Percent_Positive_Variance = s.Percent_Positive_Variance, Value_Negative_Variance = s.Value_Negative_Variance, Value_Positive_Variance = s.Value_Positive_Variance, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_CycleClass_Read", ex.Message)); return(null); } }
//[begin coding function block]//[end coding function block] #region QueryFunctions public IEnumerable <WHS_Strategy_Putaway> WHS_Strategy_Putaway_Query(Kendo.Mvc.UI.DataSourceRequest request, out int Total) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Strategy_Putaway.AsEnumerable().Select(s => new WHS_Strategy_Putaway() { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Description = s.Description, ID = s.ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Name = s.Name, }) .ToDataSourceResult(request); Total = result.Total; return(result.Data as IEnumerable <WHS_Strategy_Putaway>); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "IEnumerable<WHS_Strategy_Putaway> WHS_Strategy_Putaway_Query", ex.Message)); Total = 0; return(null); } }
//[begin coding function block]//[end coding function block] #region QueryFunctions public IEnumerable <ENT_V_DateFormat> ENT_V_DateFormat_Query(Kendo.Mvc.UI.DataSourceRequest request, out int Total) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_V_DateFormat.AsEnumerable().Select(s => new ENT_V_DateFormat() { IsSelected = false, TagStr = s.TagStr, Converts_to = s.Converts_to, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Description = s.Description, Example = s.Example, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, V_Date_format_code = s.V_Date_format_code, }) .ToDataSourceResult(request); Total = result.Total; return(result.Data as IEnumerable <ENT_V_DateFormat>); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "IEnumerable<ENT_V_DateFormat> ENT_V_DateFormat_Query", ex.Message)); Total = 0; return(null); } }
public JsonResult GetProductDetails([DataSourceRequest] Kendo.Mvc.UI.DataSourceRequest request) // public JsonResult GetProductDetails(int take, int skip, IEnumerable<Kendo.DynamicLinq.Sort> sort, Kendo.DynamicLinq.Filter filter) { try { //dynamic BCVM = new ExpandoObject(); //BCVM.products = _IProductRepository.GetAll().ToDataSourceResult(request); //return Json(BCVM.products,JsonRequestBehavior.AllowGet); var products = _IProductRepository.GetAll(); var productsList = (from p in products select new ProductDetailsViewModel() { ProductId = p.ProductId, Name = p.Name, UnitPrice = p.UnitPrice, UnitsInStock = p.UnitsInStock, Discontinued = p.Discontinued, SupplierName = p.supplier.SupplierName, CategoryName = p.category.CategoryName }).ToDataSourceResult(request); // }).ToDataSourceResult(take, skip, sort, filter); return(Json(productsList, JsonRequestBehavior.AllowGet)); } catch (Exception e) { throw e; } }
public DataSourceResult ENT_Item_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_Item.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Allocation_Strategy_Id = s.Allocation_Strategy_Id, Batch_No = s.Batch_No, C_System_Itemtype = s.C_System_Itemtype, Carton_ID = s.Carton_ID, Code_UOM_ID = s.Code_UOM_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Cube = s.Cube, CycleClass_ID = s.CycleClass_ID, Gross_weight = s.Gross_weight, ID = s.ID, IsDeleted = s.IsDeleted, Item_Code = s.Item_Code, Item_Description = s.Item_Description, ItemtypeDetail_ID = s.ItemtypeDetail_ID, Last_cycle_count = s.Last_cycle_count, Location_ID = s.Location_ID, Lot_No = s.Lot_No, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Net_weight = s.Net_weight, Notes = s.Notes, Owner_Id = s.Owner_Id, Pack_Id = s.Pack_Id, Putaway_Strategy_Id = s.Putaway_Strategy_Id, RotatebyDetail_ID = s.RotatebyDetail_ID, RotationDetail_ID = s.RotationDetail_ID, Tare_weight = s.Tare_weight, To_Best_By_Day = s.To_Best_By_Day, To_Deliver_By_Days = s.To_Deliver_By_Days, To_Expire_Days = s.To_Expire_Days, UDF_1 = s.UDF_1, UDF_2 = s.UDF_2, UDF_3 = s.UDF_3, UDF_4 = s.UDF_4, UDF_5 = s.UDF_5, V_CycleCount_ID = s.V_CycleCount_ID, V_Lot_ID = s.V_Lot_ID, V_Receipt_ID = s.V_Receipt_ID, Zone_Id = s.Zone_Id, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_Item_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_Consolidate_Query(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Consolidate.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, ASN_Detail_ID = s.ASN_Detail_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, LPN_New = s.LPN_New, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "DataSourceResult WHS_Consolidate_Query", ex.Message)); return(null); } }
public void CanReadProgram() { var request = new DataSourceRequest(); var result = _programController.Program_Read(request); Assert.IsInstanceOf<JsonResult>(result); Assert.IsNotNull(result); }
public void CanReadUnit() { var request = new DataSourceRequest(); var result = _unitController.Unit_Read(request); Assert.IsInstanceOf<JsonResult>(result); Assert.IsNotNull(result); }
public static EmployeeDirectoryModel ToEmployeeDirectoryModel(this EmployeeDirectory employee, DataSourceRequest request) { var filters = request.Filters; if (!filters.Any()) { return employee.ToEmployeeDirectoryModel(); } var predicate = ExpressionBuilder.Expression<EmployeeDirectory>(filters, false).Compile(); return new EmployeeDirectoryModel { EmployeeId = employee.EmployeeID, ReportsTo = employee.ReportsTo, FirstName = employee.FirstName, LastName = employee.LastName, Address = employee.Address, City = employee.City, Country = employee.Country, BirthDate = employee.BirthDate, HireDate = employee.HireDate, Phone = employee.Phone, Position = employee.Position, Extension = employee.Extension, hasChildren = employee.InverseReportsToNavigation.Any(predicate) }; }
public DataSourceResult ENT_OutboundValidationDetail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_OutboundValidationDetail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Code_Validation_routine_ID = s.Code_Validation_routine_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Enable = s.Enable, ID = s.ID, IsDeleted = s.IsDeleted, Minimum_shelf_life = s.Minimum_shelf_life, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Outbound_validation_ID = s.Outbound_validation_ID, RF_assisted_picking = s.RF_assisted_picking, RF_directed_picking = s.RF_directed_picking, Sequence = s.Sequence, Validation_routine = s.Validation_routine, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_OutboundValidationDetail_Read", ex.Message)); return(null); } }
public DataSourceResult ENT_LottableValidationDetailDetail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_LottableValidationDetailDetail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Conversion = s.Conversion, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, DateCodeFormat = s.DateCodeFormat, ID = s.ID, IsDeleted = s.IsDeleted, Lottable_conversion_ID = s.Lottable_conversion_ID, Lottable_Validation_Detail_ID = s.Lottable_Validation_Detail_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Sequence = s.Sequence, ShelfLifeValidation = s.ShelfLifeValidation, V_Date_fortmat_ID = s.V_Date_fortmat_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_LottableValidationDetailDetail_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_Packing_List_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Packing_List.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Batch_Note = s.Batch_Note, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, Kg_Note = s.Kg_Note, Lot_No_Note = s.Lot_No_Note, M3_Note = s.M3_Note, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Pack_Note = s.Pack_Note, Packing_List_Note_No = s.Packing_List_Note_No, Qty_Note = s.Qty_Note, SO_Detail_ID = s.SO_Detail_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Packing_List_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_Picking_List_Query(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Picking_List.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Note = s.Note, Printed_Date = s.Printed_Date, SO_Detail_ID = s.SO_Detail_ID, Warehouse_ID = s.Warehouse_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "DataSourceResult WHS_Picking_List_Query", ex.Message)); return(null); } }
public DataSourceResult WHS_Owner_Label_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Owner_Label.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Case_Label_Type = s.Case_Label_Type, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, LPN_Barcode_Format = s.LPN_Barcode_Format, LPN_Length = s.LPN_Length, LPN_Next_Number = s.LPN_Next_Number, LPN_Start_Number = s.LPN_Start_Number, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Owner_ID = s.Owner_ID, Roll_Back_Number = s.Roll_Back_Number, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Owner_Label_Read", ex.Message)); return(null); } }
public void CanReadHubOwner() { var request = new DataSourceRequest(); var result = _hubOwnerController.Read(request); Assert.IsInstanceOf<JsonResult>(result); }
public DataSourceResult ENT_CycleCountValidationDetail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_CycleCountValidationDetail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, IsDeleted = s.IsDeleted, LottableAdjustmentRule_ID = s.LottableAdjustmentRule_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Negative_adjustment_lot = s.Negative_adjustment_lot, Negative_adjustment_lottable3 = s.Negative_adjustment_lottable3, Negative_adjustment_lottable4 = s.Negative_adjustment_lottable4, Positive_adjustment_lot = s.Positive_adjustment_lot, Positive_adjustment_lottable3 = s.Positive_adjustment_lottable3, Positive_adjustment_lottable4 = s.Positive_adjustment_lottable4, V_CycleCount_ID = s.V_CycleCount_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_CycleCountValidationDetail_Read", ex.Message)); return(null); } }
public DataSourceResult LIST_Code_Query(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_LIST_Code.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Description = s.Description, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Name = s.Name, Type = s.Type, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "DataSourceResult LIST_Code_Query", ex.Message)); return(null); } }
public void CanCreateStore() { var store = new StoreViewModel { StoreID = 1, Name = "One", Number = 1, IsActive = true, IsTemporary = false, HubID = 1, StackCount = 1, StoreManName = "Store man1" }; var request = new DataSourceRequest(); var result = _storeController.Store_Create(request, store); Assert.IsInstanceOf<JsonResult>(result); }
public DataSourceResult ENT_Wave_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_Wave.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Create_On = s.Create_On, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Description = s.Description, ID = s.ID, IsDelete = s.IsDelete, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, SO_ID = s.SO_ID, User_ID = s.User_ID, Wave_Code = s.Wave_Code, Wave_Status_ID = s.Wave_Status_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_Wave_Read", ex.Message)); return(null); } }
public DataSourceResult ENT_ReceiptValidation_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_ENT_ReceiptValidation.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Default = s.Default, ID = s.ID, IsDeleted = s.IsDeleted, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, V_Receipt_code = s.V_Receipt_code, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult ENT_ReceiptValidation_Read", ex.Message)); return(null); } }
//[begin coding function block]//[end coding function block] #region QueryFunctions public IEnumerable <WHS_Replenishment> WHS_Replenishment_Query(Kendo.Mvc.UI.DataSourceRequest request, out int Total) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Replenishment.AsEnumerable().Select(s => new WHS_Replenishment() { IsSelected = false, TagStr = s.TagStr, ASN_Receipt_ID = s.ASN_Receipt_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, ID = s.ID, Input_Qty = s.Input_Qty, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, }) .ToDataSourceResult(request); Total = result.Total; return(result.Data as IEnumerable <WHS_Replenishment>); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "IEnumerable<WHS_Replenishment> WHS_Replenishment_Query", ex.Message)); Total = 0; return(null); } }
public JsonResult List_Read(DataSourceRequest request) { var items = _activityBusinessLogic.GetAllEntities().ToArray();//.Select(x => new ActivityModel //{ // Id = x.Id, // ActivityDate = x.CreateDate, // UserName = x.Author.Name, // Type = x.Type.Name, // UserAgent = x.UserAgent, // //Tags = x.GetAllTags(), //}).ToList(); items.FirstOrDefault(); var act = new List<ActivityModel>(); foreach (var activity in items) { act.Add(new ActivityModel { Tags = activity.GetAllTags(), Id = activity.Id, UserAgent = activity.UserAgent, ActivityDate = activity.CreateDate, UserName = activity.Author.Name, //Type = activity.Type.Name }); } DataSourceResult result = act.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public DataSourceResult WHS_Adjustment_Detail_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Adjustment_Detail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, Adjustment_ID = s.Adjustment_ID, Adjustment_Quantity = s.Adjustment_Quantity, AdjustmentReasonID = s.AdjustmentReasonID, ASN_Detail_ID = s.ASN_Detail_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Current_Quantity = s.Current_Quantity, ID = s.ID, IsDeleted = s.IsDeleted, Line = s.Line, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Pack_ID = s.Pack_ID, Target_Quantity = s.Target_Quantity, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Adjustment_Detail_Read", ex.Message)); return(null); } }
public DataSourceResult WHS_Maintain_Hold_Read(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_Maintain_Hold.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Date_Off = s.Date_Off, Date_On = s.Date_On, Holdreason_ID = s.Holdreason_ID, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, Location_ID = s.Location_ID, Lot_ID = s.Lot_ID, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, User_ID = s.User_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "MyDataSourceResult WHS_Maintain_Hold_Read", ex.Message)); return(null); } }
public void CanShowSubstituteTransporters() { //Act var request = new Kendo.Mvc.UI.DataSourceRequest(); var result = _transportOrderController.SuggestedSubstituteTransporters(request, 1); //Assert Assert.IsInstanceOf<JsonResult>(result); }
public void Can_Show_List_Of_Active_Bids() { var dataSourceRequest = new DataSourceRequest(); var result = _bidController.Bid_Read(dataSourceRequest,(int)BidStatus.Active); Assert.IsNotNull(result); }
public void CanCreateUnit() { var request = new DataSourceRequest(); var unitViewModel = new UnitViewModel{UnitID = 1,UnitName = "Killo Gram"}; var result = _unitController.Unit_Create(request, unitViewModel); Assert.IsInstanceOf<JsonResult>(result); }
public void CanCreateProgram() { var request = new DataSourceRequest(); var programViewModel = new ProgramViewModel {ProgramID = 1, ProgramName = "PSNP", Description = "PSNP Program"}; var result = _programController.Program_Create(request, programViewModel); //Assert Assert.IsInstanceOf<JsonResult>(result); }
public void CanDestroyHubOwner() { var request = new DataSourceRequest(); var hubOwnerViewModel = new HubOwnerViewModel { HubOwnerID = 1, HubId = 1, Name = "Owner2", LongName = "Hub Owner 2" }; var result = _hubOwnerController.HubOwnerUpdate(request, hubOwnerViewModel); //Assert Assert.IsInstanceOf<JsonResult>(result); }
public void CanReadHRDDetail() { var hrdDetail = new DataSourceRequest(); var id = 2; var result = (RedirectToRouteResult)_hrdController.HRDDetail_Read(hrdDetail, id); Assert.IsNotNull(result); }
public void CanReadHRD() { var hrd = new DataSourceRequest(); var result = (JsonResult)_hrdController.HRD_Read(hrd); Assert.IsNotNull(result); // Assert.AreEqual(1, (((DataSourceResult)result.Data).Total)); }
public Kendo.Mvc.UI.DataSourceResult GetCategorizedNews(DataSourceRequest request) { return this.Data.NewsItems.All() .Where(s=>s.IsForTest !=true) //this should be == but for the test .Project() .To<NewsItemViewModel>() .OrderByDescending(s=>s.DatePublished) .ToDataSourceResult(request); }
public void CanShowSubstituteTransporters() { //Act var request = new Kendo.Mvc.UI.DataSourceRequest(); var result = _transportOrderController.SuggestedSubstituteTransporters(request, 1); //Assert Assert.IsInstanceOf <JsonResult>(result); }
public void CanReadHub() { var request = new DataSourceRequest(); var result = _hubController.Hub_Read(request); //Assert Assert.IsInstanceOf<JsonResult>(result); }
public void CanReadContributionDetail() { var contributionDetail = new DataSourceRequest(); var id = 2; var result = (RedirectToRouteResult)_contributionController.ContributionDetail_Read(contributionDetail, id); Assert.IsNotNull(result); }
public DataSourceResult WHS_ASNDetail_Query(Kendo.Mvc.UI.DataSourceRequest request) { try { WMS.Models.DBContext model = new DBContext(); var result = model.DBSet_WHS_ASNDetail.AsEnumerable().Select(s => new { IsSelected = false, TagStr = s.TagStr, ASN_ID = s.ASN_ID, C_System_HoldCode_ID = s.C_System_HoldCode_ID, CreatedBy = s.CreatedBy, CreatedDate = s.CreatedDate, Discrepancy_Qty = s.Discrepancy_Qty, Expected_Qty = s.Expected_Qty, ID = s.ID, IsDeleted = s.IsDeleted, Item_ID = s.Item_ID, Location_ID = s.Location_ID, Lotable_1 = s.Lotable_1, Lotable_10 = s.Lotable_10, Lotable_11 = s.Lotable_11, Lotable_12 = s.Lotable_12, Lotable_2 = s.Lotable_2, Lotable_3 = s.Lotable_3, Lotable_4 = s.Lotable_4, Lotable_5 = s.Lotable_5, Lotable_6 = s.Lotable_6, LPN = s.LPN, ModifiedBy = s.ModifiedBy, ModifiedDate = s.ModifiedDate, Notes = s.Notes, Pack_ID = s.Pack_ID, Pallet_Label = s.Pallet_Label, Receipt_Line_No = s.Receipt_Line_No, ReceiptStatus_ID = s.ReceiptStatus_ID, Received_Qty = s.Received_Qty, UDF_1 = s.UDF_1, UDF_2 = s.UDF_2, UDF_3 = s.UDF_3, UDF_4 = s.UDF_4, UDF_5 = s.UDF_5, UOM_ID = s.UOM_ID, }) .ToDataSourceResult(request); return(result); } catch (Exception ex) { Common.log.Error(ex.Message, ex); Common.log.Info(string.Format("Function: {0} - [error message]: {1}", "DataSourceResult WHS_ASNDetail_Query", ex.Message)); return(null); } }
public void CanReadCUrrency() { var currency = new DataSourceRequest(); var result = _currencyController.Currency_Read(currency); Assert.IsNotNull(result); Assert.IsInstanceOf<JsonResult>(result); //Assert.AreEqual(1, (((DataSourceResult)result.Data).Total)); }
public void CanReadRation() { //Act var request = new DataSourceRequest(); var result = _rationController.Ration_Read(request); //Assert Assert.IsInstanceOf<JsonResult>(result); }
public JsonResult List_Read(DataSourceRequest request) { var items = _leadTypeBusinessLogic.GetAllEntities();//.Select(x => ConvertToSiteModel(x)); var models = new List<LeadTypeModel>(); foreach (var clientSite in items) { //models.Add(ConvertToLeadModel(clientSite)); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult List_Read(DataSourceRequest request, Guid id) { var items = _siteBusinessLogic.GetAllEntities().Where(x => x.Owner.Id == id);//.Select(x => ConvertToSiteModel(x)); var models = new List<SiteModel>(); foreach (var clientSite in items) { models.Add(clientSite.ConvertToSiteModel()); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetCompanies(DataSourceRequest request) { var items = _companyBusinessLogic.GetAllEntities().ToList(); var models = new List<CompanyModel>(); foreach (var company in items) { models.Add(company.ConvertToCompanyModel()); } var result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetCompanySites(DataSourceRequest request, Guid id) { var items = _companyBusinessLogic.GetAllEntities().Where(x => x.Id == id).SelectMany(x => x.Sites).ToList(); var models = new List<SiteModel>(); foreach (var site in items) { models.Add(site.ConvertToSiteModel()); } var result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult Get(DataSourceRequest request) { var skills = (from skill in this.Database.Skills.All() orderby skill.Name select new SkillAdministrationModel { Id = skill.Id, Name = skill.Name }).AsQueryable(); return Json(skills.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public void CountOfRequistionShouldBe2() { //Arange //Act var request = new DataSourceRequest(); var view = _reliefRequisitionController.Requisition_Read(request,1); //Asert Assert.IsInstanceOf<JsonResult>(view); // Assert.AreEqual(((IEnumerable<ReliefRequisitionViewModel>)view.Model).Count(), 2); }
public JsonResult GetUsers(DataSourceRequest request) { var users = (from user in this.database.Users.All() select new UserAdministrationModel() { UserName = user.UserName, IsBanned = user.IsDisalbed, Id = user.Id }).AsQueryable(); return Json(users.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public JsonResult List_Read(DataSourceRequest request) { var items = _contactBusinessLogic.GetAllEntities().ToList();//.Select(x => x.ConvertToContactModel()); var models = new List<ContactModel>(); foreach (var contact in items) { models.Add(contact.ConvertToContactModel()); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result); }
public void CanFDPJsonRead() { //Act var kendoDataRequest = new DataSourceRequest(); var jsonResult= _fdpController.FDP_Read(kendoDataRequest,1); //Assert Assert.NotNull(jsonResult); //dynamic data = jsonResult.Data; //var results = data.Data as List<FDPViewModel>; //Assert.IsInstanceOf<List<FDPViewModel>>(results); //Assert.NotNull(results); //Assert.AreEqual(1, results.Count); }
public ActionResult List_Read(DataSourceRequest request) { var items = _contactBusinessLogic.GetAllEntities().Select(x => new ContactModel { Score = x.Score, ReadyToSell = x.ReadyToSell.Name, Name = x.Name, CreateDate = x.CreateDate, Email = x.Email, Id = x.Id }); DataSourceResult result = items.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }