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
{
}
}
