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