public ActionResult GetPicks(int index, int pageNo, int pageSize, string search, string sortColumn, int sortOrder, string dateFrom, string dateTo, int tz) { var model = createModel(); Response.Cookies.Remove("picks_txtDateFrom"); Response.Cookies.Remove("picks_txtDateTo"); if (dateFrom.Trim().Length <= 10) { dateFrom = dateFrom.Trim() + " 00:00:00"; } if (dateTo.Trim().Length <= 10) { dateTo = dateTo.Trim() + " 23:59:59"; } return(Json(PickService.FindPicksListModel(model.CurrentCompany.Id, dateFrom.ParseDateTime(CurrentUser.DateFormat + " HH:mm:ss", tz), dateTo.ParseDateTime(CurrentUser.DateFormat + " HH:mm:ss", tz), index, pageNo, pageSize, search, sortColumn, (SortOrder)sortOrder), JsonRequestBehavior.AllowGet)); }
public void SetPickSentToWarehouseDateTest() { int numSohs = 1, itemCount = 15; var testUser = GetTestUser(); var testCompany = GetTestCompany(testUser, true); CreateTestTransfers(testCompany, testUser); var testCustomer = GetTestCustomer(testCompany, testUser); var sohList = new List <SalesOrderHeaderModel>(); var pickHeaders = new List <PickHeaderModel>(); // Create some SOHs for (int i = 0; i < numSohs; i++) { sohList.Add(GetTestSalesOrderHeader(testCompany, testCustomer, testUser, itemCount, true)); } var error = PickService.CreatePicks(testCompany, sohList, true, pickHeaders); // Log all the files so they get cleaned up at test tear-down foreach (var pickH in pickHeaders) { db.LogTestFile(pickH.PickFiles); //PickService.SetPickSentToWarehouseDate(pickH, DateTimeOffset.Now); } // Check the sent to warehouse state var pickList = PickService.FindPicksListModel(testCompany.Id, null, null); int expected = 1, actual = pickList.Items.Count(); Assert.IsTrue(actual == expected, $"Error: {actual} picks were created when {expected} were expected"); Assert.IsTrue(pickList.Items[0].STWDate == null, $"Error: {pickList.Items[0].STWDate} for STW Date was found when NULL was expected"); // Change the state var stwDate = DateTimeOffset.Now; PickService.SetPickSentToWarehouseDate(pickList.Items[0], stwDate); // Check it pickList = PickService.FindPicksListModel(testCompany.Id, DateTimeOffset.Now.AddDays(-2), DateTimeOffset.Now); expected = 1; actual = pickList.Items.Count(); Assert.IsTrue(actual == expected, $"Error: {actual} picks were created when {expected} were expected"); Assert.IsTrue(pickList.Items[0].STWDate == stwDate, $"Error: {pickList.Items[0].STWDate} for STW Date was found when {stwDate} was expected"); }
public void FindPicksListModelTest() { int itemCount = 5, numSohs = 6; // Create a test sale var testUser = GetTestUser(); var testCompany = GetTestCompany(testUser, true); CreateTestTransfers(testCompany, testUser); var testCustomer = GetTestCustomer(testCompany, testUser); // Create some SOHs var sohList = new List <SalesOrderHeaderModel>(); var pickHeaders = new List <PickHeaderModel>(); for (int i = 0; i < numSohs; i++) { sohList.Add(GetTestSalesOrderHeader(testCompany, testCustomer, testUser, itemCount, true)); } var error = PickService.CreatePicks(testCompany, sohList, false, pickHeaders); foreach (var pickH in pickHeaders) { db.LogTestFile(pickH.PickFiles); PickService.SetPickSentToWarehouseDate(pickH, DateTimeOffset.Now); } Assert.IsTrue(!error.IsError, error.Message); // Now find the picks var pickList = PickService.FindPicksListModel(testCompany.Id, DateTimeOffset.Now.AddDays(-2), DateTimeOffset.Now) .Items .OrderBy(pl => pl.Id) .ToList(); // Check that the list contains all the picks we created int expected = numSohs, actual = pickList.Count(); Assert.IsTrue(actual == expected, "Error: {actual} picks were returned when {expected} were expected"); var exceptions = new List <string>(); exceptions.Add("PickDetails"); exceptions.Add("PickDropFolder"); // Because we don't know it at test prep for (int i = 0; i < numSohs; i++) { AreEqual(pickHeaders[i], pickList[i], exceptions); } // Delete the picks for (int i = 0; i < pickHeaders.Count(); i++) { PickService.DeletePick(pickHeaders[i]); } // Make sure they no longer exist pickList = PickService.FindPicksListModel(testCompany.Id, DateTimeOffset.Now.AddDays(-2), DateTimeOffset.Now).Items; expected = 0; actual = pickList.Count(); Assert.IsTrue(actual == expected, "Error: {actual} picks were returned when {expected} were expected"); }