public void AddPickslipsPerDim(int bucketId, string customerId,
PickslipDimension dimRow, DimensionValue dimRowVal,
PickslipDimension dimCol, DimensionValue dimColVal, string vwhId)
{
_repos.AddPickslipsPerDim(bucketId, customerId, new[] {
Tuple.Create(dimRow, dimRowVal),
Tuple.Create(dimCol, dimColVal)
}, vwhId, false);
}
public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
var x = bindingContext.ValueProvider.GetValue(bindingContext.ModelName);
if (x == null || String.IsNullOrWhiteSpace(x.AttemptedValue))
{
return(DimensionValue.Empty);
}
return(DimensionValue.FromString(x.AttemptedValue));
}
public virtual ActionResult AddPickslipsToBucket(int?bucketId, long[] pickslips, string customerId, PickslipDimension groupDimIndex,
DimensionValue GroupDimVal, PickslipDimension subgroupDimIndex, DimensionValue subgroupDimVal, string vwhId)
{
if (pickslips == null || pickslips.Length == 0)
{
AddStatusMessage("Please select pickslip.");
}
else
{
using (var trans = _service.Value.BeginTransaction())
{
if (bucketId == null)
{
bucketId = _service.Value.CreateDefaultWave();
AddStatusMessage(string.Format("New PickWave {1} created", pickslips.Length, bucketId));
}
_service.Value.AddPickslipsToWave(bucketId.Value, pickslips);
trans.Commit();
AddStatusMessage(string.Format("{0} pickslips have been added to PickWave {1}", pickslips.Length, bucketId));
}
}
return(RedirectToAction(this.Actions.PickslipList(customerId, groupDimIndex, GroupDimVal, subgroupDimIndex, subgroupDimVal, vwhId, bucketId)));
}
/// <summary>
/// Populates the passed PickslipMatrixPartialViewModel
/// </summary>
/// <param name="model"> </param>
/// <param name="customerId"> </param>
/// <param name="selectedRowDimIndex"> </param>
/// <param name="selectedColDimIndex"> </param>
/// <returns>Whether pickslips exist which can be added to a bucket</returns>
/// <remarks>
/// Passed selectedRowDimIndex and selectedColDimIndex are ignored if it turns out that either of them have no pickslips
/// </remarks>
private bool PopulatePickslipMatrixPartialModel(IndexViewModel model)
{
model.VwhList = (from item in _service.Value.GetVWhListOfCustomer(model.CustomerId)
select new SelectListItem
{
Text = item.VWhId + " : " + item.Description,
Value = item.VWhId,
Selected = item.VWhId == model.VwhId
}).ToList();
if (model.VwhList.Count == 0)
{
return(false);
}
if (string.IsNullOrWhiteSpace(model.VwhId))
{
// If Vwh has not been passed, use this one
model.VwhId = model.VwhList.Select(p => p.Value).First();
}
var summary = _service.Value.GetOrderSummary(model.CustomerId, model.VwhId, model.GroupDimIndex, model.SubgroupDimIndex);
if (summary.CountValuesPerDimension == null)
{
// No more pickslips which can be added to a bucket. The dimension matrix will be empty.
// This happens when the last set of pickslips has been added to the bucket.
return(false);
}
var requery = false;
if (summary.CountValuesPerDimension[model.GroupDimIndex] == 0)
{
model.GroupDimIndex = summary.CountValuesPerDimension.First(p => p.Value > 0).Key;
requery = true;
}
if (summary.CountValuesPerDimension[model.SubgroupDimIndex] == 0)
{
model.SubgroupDimIndex = summary.CountValuesPerDimension.First(p => p.Value > 0).Key;
requery = true;
}
if (requery)
{
summary = _service.Value.GetOrderSummary(model.CustomerId, model.VwhId, model.GroupDimIndex, model.SubgroupDimIndex);
}
model.GroupDimDisplayName = PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()[model.GroupDimIndex].Name;
model.SubgroupDimDisplayName = PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()[model.SubgroupDimIndex].Name;
const int MAX_COL_DIMENSIONS = 30;
model.GroupDimensionList = (from kvp in PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()
let count = summary.CountValuesPerDimension[kvp.Key]
select new SelectListItem
{
Value = count == 0 ? "" : ((int)(kvp.Key)).ToString(),
Text = string.Format("{0} ({1:N0})", kvp.Value.Name, count),
Selected = kvp.Key == model.GroupDimIndex
}).OrderBy(p => p.Text).ToArray();
// Dimensions which have too many distinct values are not displayed as column dimensions
model.SubgroupDimensionList = (from kvp in PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()
let count = summary.CountValuesPerDimension[kvp.Key]
where count <= MAX_COL_DIMENSIONS
select new SelectListItem
{
Value = count > MAX_COL_DIMENSIONS || count == 0 ? "" : ((int)(kvp.Key)).ToString(),
Text = string.Format("{0} ({1:N0})", kvp.Value.Name, count),
Selected = kvp.Key == model.SubgroupDimIndex
}).OrderBy(p => p.Text).ToArray();
//model.Rows = (from rowVal in summary.AllValues.RowValues
// let row = summary.AllValues.GetRow(rowVal)
// select new RowDimensionModel
// {
// PickslipCounts = row.ToDictionary(p => FormatDimensionValue(p.Key), p => p.Value.PickslipCount),
// OrderedPieces = row.ToDictionary(p => FormatDimensionValue(p.Key), p => p.Value.OrderedPieces),
// DimensionValue = FormatDimensionValue(rowVal)
// }).ToArray();
//model.Rows = (from rowVal in summary.AllValues3.FirstKeys
// //let row = summary.AllValues.GetRow(rowVal)
// select new RowDimensionModel
// {
// PickslipCounts = summary.AllValues3[rowVal].ToDictionary(p => FormatDimensionValue(p.Key), p => p.Value.PickslipCount),
// OrderedPieces = summary.AllValues3[rowVal].ToDictionary(p => FormatDimensionValue(p.Key), p => p.Value.OrderedPieces),
// DimensionValue = FormatDimensionValue(rowVal)
// }).ToArray();
var query = from item in summary.AllValues3
select Tuple.Create(DimensionValue.FromValue(item.Key.Item1),
DimensionValue.FromValue(item.Key.Item2),
new DimensionValueModel(item.Value));
model.DimensionMatrix = new SparseMatrix <DimensionValue, DimensionValue, DimensionValueModel>();
model.DimensionMatrix.AddRange(query);
//var list = new List<RowDimensionModel>();
//foreach (var rowVal in summary.AllValues2.RowValues())
//{
// var x = new RowDimensionModel
// {
// PickslipCounts = summary.AllValues2.PickslipCounts(rowVal),
// OrderedPieces = summary.AllValues2.OrderedPieces(rowVal),
// DimensionValue = SparseMatrix.FormatValue(rowVal)
// };
// list.Add(x);
//}
//model.ColDimensionValues = summary.AllValues.ColValues.Select(p => FormatDimensionValue(p)).ToArray();
return(true);
}
public virtual ActionResult PickslipList(
[Required]
string customerId,
PickslipDimension groupDimIndex,
[Required]
DimensionValue groupDimVal,
PickslipDimension subgroupDimIndex,
[Required]
DimensionValue subgroupDimVal,
[Required]
string vwhId,
int?bucketId)
{
if (string.IsNullOrWhiteSpace(customerId))
{
throw new ArgumentNullException("customerId");
}
if (string.IsNullOrWhiteSpace(vwhId))
{
throw new ArgumentNullException("vwhId");
}
//if (string.IsNullOrWhiteSpace(groupDimVal))
//{
// throw new ArgumentNullException("rowDimVal");
//}
//if (string.IsNullOrWhiteSpace(subgroupDimVal))
//{
// throw new ArgumentNullException("colDimVal");
//}
var model = new PickslipListViewModel();
model.CustomerId = customerId;
model.GroupDimIndex = groupDimIndex;
model.SubgroupDimIndex = subgroupDimIndex;
model.VwhId = vwhId;
model.GroupDimVal = groupDimVal;
model.SubgroupDimVal = subgroupDimVal;
// Pickslip list of passed dimension.
var pickslips = _service.Value.GetPickslipList(model.CustomerId, model.VwhId, model.GroupDimIndex, model.GroupDimVal, model.SubgroupDimIndex, model.SubgroupDimVal);
model.PickslipList = (from pickslip in pickslips
let routePickslip = Url.RouteCollection[DcmsLibrary.Mvc.PublicRoutes.DcmsConnect_SearchPickslipImported1]
// let routePickslip = Url.RouteCollection[DcmsLibrary.Mvc.PublicRoutes.DcmsConnect_SearchPickslip1]
let routePo = Url.RouteCollection[DcmsLibrary.Mvc.PublicRoutes.DcmsConnect_SearchPoImported3]
select new CreateWavePickslipModel(pickslip)
{
UrlInquiryPickslip = routePickslip == null ? null : Url.RouteUrl(DcmsLibrary.Mvc.PublicRoutes.DcmsConnect_SearchPickslipImported1, new
{
id = pickslip.PickslipId
}),
UrlInquiryPurchaseOrder = routePo == null ? null : Url.RouteUrl(DcmsLibrary.Mvc.PublicRoutes.DcmsConnect_SearchPoImported3, new
{
id = pickslip.PurchaseOrder,
pk1 = pickslip.CustomerId,
pk2 = pickslip.Iteration
})
}).ToArray();
model.ManagerRoleName = ROLE_WAVE_MANAGER;
model.GroupDimDisplayName = PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()[model.GroupDimIndex].Name;
model.SubgroupDimDisplayName = PickWaveHelpers.GetEnumMemberAttributes <PickslipDimension, DisplayAttribute>()[model.SubgroupDimIndex].Name;
model.GroupDimVal = model.GroupDimVal;
model.CustomerName = _service.Value.GetCustomerName(customerId);
model.BucketId = bucketId;
if (model.BucketId.HasValue)
{
var bucket = _service.Value.GetBucket(model.BucketId.Value);
model.Bucket = new BucketModel(bucket, _service.Value.GetCustomerName(customerId), BucketModelFlags.Default);
}
return(View(Views.PickslipList, model));
}
public virtual ActionResult AddPickslipsOfDim(int?bucketId, string customerId,
PickslipDimension groupDimIndex, DimensionValue groupDimVal,
PickslipDimension subgroupDimIndex, DimensionValue subgroupDimVal,
string vwhId)
{
if (string.IsNullOrWhiteSpace(customerId))
{
throw new ArgumentNullException("customerId");
}
if (string.IsNullOrWhiteSpace(vwhId))
{
throw new ArgumentNullException("vwhId");
}
using (var trans = _service.Value.BeginTransaction())
{
// If bucket is not created.create it first.
if (bucketId == null)
{
//Now Create bucket
bucketId = _service.Value.CreateDefaultWave();
AddStatusMessage(string.Format("Pick Wave {0} created.", bucketId));
}
// Add pickslip to bucket
_service.Value.AddPickslipsPerDim(bucketId.Value, customerId,
groupDimIndex,
groupDimVal, subgroupDimIndex, subgroupDimVal, vwhId);
trans.Commit();
}
AddStatusMessage(string.Format("Pickslips added to Pick Wave {0}", bucketId));
return(RedirectToAction(Actions.Index(customerId, groupDimIndex, subgroupDimIndex,
vwhId, bucketId, groupDimVal)));
}
public virtual ActionResult Index(string customerId,
PickslipDimension groupDimIndex = PickslipDimension.NotSet,
PickslipDimension subgroupDimIndex = PickslipDimension.NotSet,
string vwhId = null,
int?lastBucketId = null,
DimensionValue groupDimVal = default(DimensionValue))
{
if (string.IsNullOrWhiteSpace(customerId))
{
throw new NotImplementedException();
}
var model = new IndexViewModel
{
GroupDimVal = groupDimVal
};
//Showing only those area where order of customer are available.
//var areas = _service.Value.GetAreasForCustomer(customerId);
#region Manage Cookie
// SelectedDimension : If null, then a reasonable default is used. The default is cookie => factory default
// If non null, then it is used and written to a cookie.
var cookie = Request.Cookies[COOKIE_PICKWAVE];
if (groupDimIndex == PickslipDimension.NotSet || subgroupDimIndex == PickslipDimension.NotSet)
{
// Read cookie
int dimRowIndex, dimColIndex;
if (cookie != null && cookie[COOKIE_ROW_DIMENSION] != null && int.TryParse(cookie[COOKIE_ROW_DIMENSION], out dimRowIndex) &&
int.TryParse(cookie[COOKIE_COL_DIMENSION], out dimColIndex))
{
model.GroupDimIndex = (PickslipDimension)dimRowIndex;
model.SubgroupDimIndex = (PickslipDimension)dimColIndex;
}
else
{
// Factory defaults
model.GroupDimIndex = PickslipDimension.CustomerDcCancelDate;
model.SubgroupDimIndex = PickslipDimension.CustomerDc;
}
}
else
{
model.GroupDimIndex = groupDimIndex;
model.SubgroupDimIndex = subgroupDimIndex;
// Write cookie
if (cookie == null)
{
cookie = new HttpCookie(COOKIE_PICKWAVE)
{
Expires = DateTime.Now.AddDays(7)
};
cookie.Values.Add(COOKIE_ROW_DIMENSION, model.GroupDimIndex.ToString());
cookie.Values.Add(COOKIE_COL_DIMENSION, model.SubgroupDimIndex.ToString());
}
else
{
if (cookie[COOKIE_ROW_DIMENSION] != null)
{
cookie.Values.Set(COOKIE_ROW_DIMENSION, model.GroupDimIndex.ToString());
}
if (cookie[COOKIE_COL_DIMENSION] != null)
{
cookie.Values.Set(COOKIE_COL_DIMENSION, model.SubgroupDimIndex.ToString());
}
}
HttpContext.Response.Cookies.Add(cookie);
}
#endregion
model.CustomerId = customerId;
//var cust = _service.Value.GetCustomer(model.CustomerId);
model.CustomerName = _service.Value.GetCustomerName(model.CustomerId);
// Make sure that selected row and dimension are within the bounds of their respective drop downs
if (!PopulatePickslipMatrixPartialModel(model))
{
AddStatusMessage("No more pickslips available to add");
if (lastBucketId.HasValue)
{
return(RedirectToAction(MVC_PickWaves.PickWaves.ManageWaves.WavePickslips(lastBucketId.Value)));
}
else
{
return(RedirectToAction(Actions.Index(customerId, groupDimIndex, subgroupDimIndex, vwhId, lastBucketId, groupDimVal)));
}
}
// If Bucket is created.
if (lastBucketId.HasValue)
{
// Retrive some information of bucket.
model.LastBucketId = lastBucketId;
var bucket = _service.Value.GetPickWave(model.LastBucketId.Value);
if (bucket != null)
{
model.PullAreaShortName = bucket.PullAreaShortName;
model.PitchAreaShortName = bucket.PitchAreaShortName;
model.PickslipCount = bucket.PickslipCount;
}
}
return(View(Views.Index, model));
}
public IEnumerable <Pickslip> GetPickslipList(string customerId, string vwhId, PickslipDimension dimRow, DimensionValue dimRowVal, PickslipDimension dimCol, DimensionValue dimColVal)
{
return(_repos.GetPickslips(customerId, vwhId, new[] { Tuple.Create(dimRow, dimRowVal), Tuple.Create(dimCol, dimColVal) }));
}
