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