public PlannedProduction GetPlannedProduction(PlannedProduction plannedProduction)
{
using (var context = new ManufacturingDataContext(_connectionString))
{
return(context.PlannedProductions.Where(x => !x.Deleted).FirstOrDefault(p => p.ProductionCatergoryId == plannedProduction.ProductionCatergoryId && p.ProductionCatYear == plannedProduction.ProductionCatYear));
}
}
//PLANNED PRODUCTIONS
public void AddPlannedProduction(PlannedProduction plannedProduction)
{
using (var context = new ManufacturingDataContext(_connectionString))
{
context.PlannedProductions.InsertOnSubmit(plannedProduction);
context.SubmitChanges();
}
}
public void DeletePlannedProduction(PlannedProduction plannedProduction)
{
using (var context = new ManufacturingDataContext(_connectionString))
{
plannedProduction.Deleted = true;
context.PlannedProductions.Attach(plannedProduction);
context.Refresh(RefreshMode.KeepCurrentValues, plannedProduction);
context.SubmitChanges();
}
}
public void UpdatePlannedProduction(PlannedProduction plannedProduction)
{
using (var context = new ManufacturingDataContext(_connectionString))
{
plannedProduction.ModifiedOn = DateTime.Now;
context.PlannedProductions.Attach(plannedProduction);
context.Refresh(RefreshMode.KeepCurrentValues, plannedProduction);
context.SubmitChanges();
}
}
public void UpdatePlannedProductionNotes(PlannedProduction plannedProduction)
{
var repo = new ProductionRespository(Properties.Settings.Default.ManufacturingConStr);
//var currentItem = repo.GetPlannedProduction(plannedProduction.Id).GetObjectBasePropertiesOnDbObject();
//repo.AddNewUpdateHistory(currentItem);
//currentItem.Notes = plannedProduction.Notes;
var currentItem = repo.GetPlannedProduction(plannedProduction.Id);
repo.AddNewUpdateHistory(currentItem);
repo.UpdatePlannedProduction(currentItem.SetOrginalDbObjToUpdated(plannedProduction));
}
public PlannedProduction GetPlannedProductionWithDetails(PlannedProduction plannedProduction)
{
using (var context = new ManufacturingDataContext(_connectionString))
{
var loadOption = new DataLoadOptions();
loadOption.LoadWith <PlannedProduction>(p => p.PlannedProductionDetails);
loadOption.LoadWith <PlannedProductionDetail>(p => p.Item);
context.LoadOptions = loadOption;
var result = context.PlannedProductions.NotDeleted().FirstOrDefault(p => p.ProductionCatergoryId == plannedProduction.ProductionCatergoryId && p.ProductionCatYear == plannedProduction.ProductionCatYear);
if (result.NotNull())
{
result.PlannedProductionDetails = result.PlannedProductionDetails.Where(x => !x.Deleted).ToEntitySet();
}
return(result);
}
}
public void SubmitPlannedProduction(PlannedProduction plannedProduction, IEnumerable <PlannedProductionDetail> items)
{
var repo = new ProductionRespository(Properties.Settings.Default.ManufacturingConStr);
//if it's a new prdoduction then we add a new one
if (plannedProduction.Id == 0)
{
repo.AddPlannedProduction(plannedProduction);
}
items = items.Select(i =>
{
i.PlannedProductionId = plannedProduction.Id;
return(i);
});
repo.AddPlannedProductionDetails(items);
var pc = repo.GetProductionCatergory(plannedProduction.ProductionCatergoryId);
TempData["Message"] = $"You succsesfully added a new season planned production for {pc.Name} {plannedProduction.ProductionCatYear} <br/>" +
$"With {items.Count()} Items : Total Quantity {items.Sum(i => i.Quantity)}";
}
public ActionResult GetPlannedProduction(PlannedProduction plannedProduction)
{
var list = new List <string>();
var test = list.NotNUllOrEmpty();
var repo = new ProductionRespository(Properties.Settings.Default.ManufacturingConStr);
var pp = repo.GetPlannedProductionWithDetails(plannedProduction);
return(Json(pp != null ? new
{
pp.Id,
pp.ProductionCatergoryId,
pp.ProductionCatYear,
Items = pp.PlannedProductionDetails.NotNUllOrEmpty() ? pp.PlannedProductionDetails.Select(p => {
return new
{
p.Id,
ItemId = p.Item.Id,
p.Item.SKU,
p.Quantity,
Edit = false
};
}) : null
} : null));
}