public bool RemoveSpecifications(int idSpecifications) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Specification specification = (from s in context.Specifications where s.Id == idSpecifications select s).Single <WorkLinqToSql.Specification>(); var macnineSpecifications = from ms in context.MachineSpecifications where ms.SpecificationID == specification.Id select ms; foreach (WorkLinqToSql.MachineSpecification ms in macnineSpecifications) { context.MachineSpecifications.DeleteOnSubmit(ms); } context.MachineSpecifications.Context.SubmitChanges(); context.Specifications.DeleteOnSubmit(specification); context.Specifications.Context.SubmitChanges(); } catch { return(false); } return(true); }
public bool CreateSpecifications(Specification specificationModel, int recordID) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Specification specification = new WorkLinqToSql.Specification(); WorkLinqToSql.MachineSpecification machinespecification = new MachineSpecification(); specification.Name = specificationModel.Name; specification.Value = specificationModel.Value; machinespecification.MachineID = recordID; machinespecification.Specification = specification; context.Specifications.InsertOnSubmit(specification); context.MachineSpecifications.InsertOnSubmit(machinespecification); context.Specifications.Context.SubmitChanges(); context.MachineSpecifications.Context.SubmitChanges(); } catch { return(false); } return(true); }
public Specification ToSpecification(WorkLinqToSql.Specification specificationFromBase) { Specification specification = new Specification(); specification.ID = specificationFromBase.Id; specification.Name = specificationFromBase.Name; specification.Value = specificationFromBase.Value; return(specification); }
public void RemoveMandatSpecification(int specificationID) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Specification specification = new WorkLinqToSql.Specification(); var mSpecification = (from s in context.MandatSpecificCatalogCategories where (s.SpecificationID == specificationID) select s).Single(); context.MandatSpecificCatalogCategories.DeleteOnSubmit(mSpecification); context.MandatSpecificCatalogCategories.Context.SubmitChanges(); } catch { } }
public bool UpdateSpecifications(Specification specificationModel) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Specification specification = (from s in context.Specifications where s.Id == specificationModel.ID select s).Single <WorkLinqToSql.Specification>(); specification.Name = specificationModel.Name; specification.Value = specificationModel.Value; context.Specifications.Context.SubmitChanges(); } catch { return(false); } return(true); }
public void CreateMandatSpecification(Specification specificationModel, int categoryID) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.MandatSpecificCatalogCategory mSpecification = new WorkLinqToSql.MandatSpecificCatalogCategory(); WorkLinqToSql.Specification Specification = new WorkLinqToSql.Specification(); Specification.Name = specificationModel.Name; Specification.Value = "-"; context.Specifications.InsertOnSubmit(Specification); context.Specifications.Context.SubmitChanges(); mSpecification.CatalogCategoryID = categoryID; mSpecification.SpecificationID = Specification.Id; context.MandatSpecificCatalogCategories.InsertOnSubmit(mSpecification); context.MandatSpecificCatalogCategories.Context.SubmitChanges(); } catch { } }