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