public virtual ActionResult Size(ModelSizeViewModel viewModel, FormCollection collection)
{
using (var trans = new TransactionScope())
{
using (var context = new TTTEntities())
{
var modelSizes = context.lnkmodelsizes
.Where(a => a.ModelID == viewModel.ModelID && a.ColourDescID == viewModel.ColourDescID)
.ToList();
var beginSize = Convert.ToInt16((Properties.Settings.Default.InitialSize.Split(',')[0]).Split('|')[0]);
var sizeRange = Convert.ToInt16((Properties.Settings.Default.InitialSize.Split(',')[1]));
for (var i = beginSize; i <= beginSize + sizeRange; i++)
{
var modelSize = modelSizes.Where(a => a.Size == i.ToString()).SingleOrDefault();
if (modelSize == null)
{
context.lnkmodelsizes.Add(new lnkmodelsize()
{
ModelID = viewModel.ModelID,
ColourDescID = viewModel.ColourDescID,
Active = true,
CreateDT = DateTime.Now,
Size = i.ToString(),
Quantity = Convert.ToInt32(collection[string.Format("txt_{0}", i.ToString())])
});
}
else
{
modelSize.Quantity = Convert.ToInt32(collection[string.Format("txt_{0}", modelSize.Size)]);
modelSize.UpdateDT = DateTime.Now;
}
}
context.SaveChanges();
}
trans.Complete();
}
return RedirectToAction("Edit", new { id = viewModel.ModelColourDescID });
}
public virtual ActionResult Size(int modelID, int colourDescID)
{
var modelSizeViewModel = new ModelSizeViewModel()
{
ModelID = modelID,
ColourDescID = colourDescID
};
using (var context = new TTTEntities())
{
modelSizeViewModel.ModelSizes = context.lnkmodelsizes.Where(a => a.ModelID == modelID && a.ColourDescID == colourDescID).ToList();
modelSizeViewModel.ModelColourDescID = context.lnkmodelcolourdescs.Where(a => a.ModelID == modelID && a.ColourDescID == colourDescID).First().ID;
}
//35|5|2|4,8
var beginSize = Convert.ToInt16((Properties.Settings.Default.InitialSize.Split(',')[0]).Split('|')[0]);
var sizeRange = Convert.ToInt16((Properties.Settings.Default.InitialSize.Split(',')[1]));
for (var i = beginSize; i <= beginSize + sizeRange; i++)
modelSizeViewModel.AvailableSize.Add(i.ToString());
return View(modelSizeViewModel);
}