public void Create(Entities.SostavIzdeliaTo newSostavIzdelia) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); SostavIzdelia _sostavIzdelia; /*создание объекта добавляемой строки*/ _sostavIzdelia= new SostavIzdelia { Count = newSostavIzdelia.count, IdCurrent = newSostavIzdelia.idCurrent, IdIzdelia = newSostavIzdelia.idIzdelia, IdLast = newSostavIzdelia.idLast }; // Вставка данных db.SostavIzdelia.InsertOnSubmit(_sostavIzdelia); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void CreateDirectory(Entities.DirectoryTo newDirectory) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); DirectoryTable _directory; /*создание объекта добавляемой строки*/ _directory = new DirectoryTable { MaterialCode = newDirectory.MaterialCode, NormMaterial = newDirectory.NormMaterial, NormWaste = newDirectory.NormWaste, ProductionCode = newDirectory.ProductionCode }; // Вставка данных db.DirectoryTable.InsertOnSubmit(_directory); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public List<Entities.ProductionEntity> GetAllProductions() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.ProductionEntity> productions = from production in db.ProductionTable select new Entities.ProductionEntity( production.ProductionCode, production.NameProduction, production.DesignationProduction, //production.UnitTable.ShortNameUnit, //production.UnitCode, //production.CountProduction, production.TypeTable.NameType, production.TypeCode, production.SortTable.NameSort, production.SortCode, production.SignTable.NameSign, production.SignCode); return productions.ToList(); } catch (Exception ex) { throw ex; } }
public void CreateProduction(Entities.ProductionTo newProduction) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); ProductionTable _production; /*создание объекта добавляемой строки*/ _production = new ProductionTable { SignCode = newProduction.SignCode, SortCode = newProduction.SortCode, TypeCode = newProduction.TypeCode, ProductionCode = newProduction.ProductionCode, NameProduction = newProduction.NameProduction, DesignationProduction = newProduction.DesignationProduction, //CountProduction = newProduction.CountProduction, //UnitCode = newProduction.UnitCode }; // Вставка данных db.ProductionTable.InsertOnSubmit(_production); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public List<Entities.TypeEntity> GetAllTypes() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.TypeEntity> types = from type in db.TypeTable select new Entities.TypeEntity( type.TypeCode, type.NameType); return types.ToList(); } catch (Exception ex) { throw ex; } }
public List<Entities.SortEntity> GetAllSorts() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.SortEntity> sorts = from sort in db.SortTable select new Entities.SortEntity( sort.SortCode, sort.NameSort); return sorts.ToList(); } catch (Exception ex) { throw ex; } }
public List<Entities.SignEntity> GetAllSigns() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.SignEntity> signs = from sign in db.SignTable select new Entities.SignEntity( sign.SignCode, sign.NameSign); return signs.ToList(); } catch (Exception ex) { throw ex; } }
public Entities.SortEntity GetSort(int idSort) { try { var db = new DBElectricDataContext(); IEnumerable<Entities.SortEntity> sorts = from sort in db.SortTable where sort.SortCode == idSort select new Entities.SortEntity( sort.SortCode, sort.NameSort); return sorts.First(); } catch (Exception ex) { throw ex; } }
public List<Entities.UnitEntity> GetAllUnits() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.UnitEntity> units = from unit in db.UnitTable select new Entities.UnitEntity( unit.UnitCode, unit.NameUnit, unit.ShortNameUnit); return units.ToList(); } catch (Exception ex) { throw ex; } }
public Entities.TypeEntity GetType(int idType) { try { var db = new DBElectricDataContext(); IEnumerable<Entities.TypeEntity> types = from type in db.TypeTable where type.TypeCode == idType select new Entities.TypeEntity( type.TypeCode, type.NameType); return types.First(); } catch (Exception ex) { throw ex; } }
public List<Entities.MaterialEntity> GetAllMaterials() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.MaterialEntity> materials = from material in db.MaterialTable select new Entities.MaterialEntity( material.MaterialCode, material.NameMaterial, material.UnitTable.NameUnit); return materials.ToList(); } catch (Exception ex) { throw ex; } }
public Entities.SignEntity GetSign(int idSign) { try { var db = new DBElectricDataContext(); IEnumerable<Entities.SignEntity> signs = from sign in db.SignTable where sign.SignCode == idSign select new Entities.SignEntity( sign.SignCode, sign.NameSign); return signs.First(); } catch (Exception ex) { throw ex; } }
public Entities.UnitEntity GetUnit(int idUnit) { try { var db = new DBElectricDataContext(); IEnumerable<Entities.UnitEntity> units = from unit in db.UnitTable where unit.UnitCode == idUnit select new Entities.UnitEntity( unit.UnitCode, unit.NameUnit, unit.ShortNameUnit); return units.First(); } catch (Exception ex) { throw ex; } }
public List<Entities.PolnayaPrimenyaemostEntity> getAll() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.PolnayaPrimenyaemostEntity> polnayaPrimenyaemosts = from polnayaPrimenyaemost in db.PolnayaPrimenyaemost select new Entities.PolnayaPrimenyaemostEntity( polnayaPrimenyaemost.Id, polnayaPrimenyaemost.detalCode, db.ProductionTable.Where(x => x.ProductionCode == polnayaPrimenyaemost.detalCode).First().NameProduction, polnayaPrimenyaemost.Count); return polnayaPrimenyaemosts.ToList(); } catch (Exception ex) { throw ex; } }
public List<Entities.DirectoryEntity> GetAllDirectorys() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.DirectoryEntity> directorys = from directory in db.DirectoryTable select new Entities.DirectoryEntity( directory.ProductionCode, directory.ProductionTable.NameProduction, directory.MaterialCode, directory.MaterialTable.NameMaterial, directory.NormMaterial, directory.NormWaste); return directorys.ToList(); } catch (Exception ex) { throw ex; } }
public List<Entities.SostavIzdeliaEntity> getAll() { try { var db = new DBElectricDataContext(); IEnumerable<Entities.SostavIzdeliaEntity> sostavIzdelias = from sostavIzdelia in db.SostavIzdelia select new Entities.SostavIzdeliaEntity(sostavIzdelia.Id, sostavIzdelia.IdIzdelia, db.ProductionTable.Where(x => x.ProductionCode == sostavIzdelia.IdIzdelia).First().NameProduction, sostavIzdelia.IdLast, db.ProductionTable.Where(x => x.ProductionCode == sostavIzdelia.IdLast).First().NameProduction, sostavIzdelia.IdCurrent, db.ProductionTable.Where(x => x.ProductionCode == sostavIzdelia.IdCurrent).First().NameProduction, sostavIzdelia.Count); return sostavIzdelias.ToList(); } catch { throw; } }
public void DeleteDirectory(long idDirectory) { var db = new DBElectricDataContext(); var deleteOrderDirectory = from directorys in db.DirectoryTable where directorys.ProductionCode == idDirectory select directorys; foreach (var directory in deleteOrderDirectory) { db.DirectoryTable.DeleteOnSubmit(directory); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void clearAll() { var db = new DBElectricDataContext(); /*var deleteOrderMaterial = from materials in db.MaterialTable where materials.MaterialCode == idMaterial select materials;*/ foreach (var polnayaPrimenyaemost in db.PolnayaPrimenyaemost) { db.PolnayaPrimenyaemost.DeleteOnSubmit(polnayaPrimenyaemost); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteSign(int idSign) { var db = new DBElectricDataContext(); var deleteOrderSign = from signs in db.SignTable where signs.SignCode == idSign select signs; foreach (var sign in deleteOrderSign) { db.SignTable.DeleteOnSubmit(sign); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteType(int idType) { var db = new DBElectricDataContext(); var deleteOrderType = from types in db.TypeTable where types.TypeCode == idType select types; foreach (var type in deleteOrderType) { db.TypeTable.DeleteOnSubmit(type); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void CreateType(Entities.TypeTo newType) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); TypeTable _type; /*создание объекта добавляемой строки*/ _type = new TypeTable { NameType = newType.NameType }; // Вставка данных db.TypeTable.InsertOnSubmit(_type); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteProduction(long idProduction) { var db = new DBElectricDataContext(); var deleteOrderProduction = from productions in db.ProductionTable where productions.ProductionCode == idProduction select productions; foreach (var production in deleteOrderProduction) { db.ProductionTable.DeleteOnSubmit(production); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteUnit(int idUnit) { var db = new DBElectricDataContext(); var deleteOrderUnit = from units in db.UnitTable where units.UnitCode == idUnit select units; foreach (var unit in deleteOrderUnit) { db.UnitTable.DeleteOnSubmit(unit); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void CreateSign(Entities.SignTo newSign) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); SignTable _sign; /*создание объекта добавляемой строки*/ _sign = new SignTable { NameSign = newSign.NameSign }; // Вставка данных db.SignTable.InsertOnSubmit(_sign); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Delete(long IdDeliting) { var db = new DBElectricDataContext(); var deleteOrderSostavIzdelia = from sostavIzdelia in db.SostavIzdelia where sostavIzdelia.Id== IdDeliting select sostavIzdelia; foreach (var sostavIzdelia in deleteOrderSostavIzdelia) { db.SostavIzdelia.DeleteOnSubmit(sostavIzdelia); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteSort(int idSort) { var db = new DBElectricDataContext(); var deleteOrderSort = from sorts in db.SortTable where sorts.SortCode == idSort select sorts; foreach (var sort in deleteOrderSort) { db.SortTable.DeleteOnSubmit(sort); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void DeleteMaterial(long idMaterial) { var db = new DBElectricDataContext(); var deleteOrderMaterial = from materials in db.MaterialTable where materials.MaterialCode == idMaterial select materials; foreach (var material in deleteOrderMaterial) { db.MaterialTable.DeleteOnSubmit(material); } try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Create(Entities.PolnayaPrimenyaemostTo newPolnayaPrimenyaemost) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); PolnayaPrimenyaemost _polnayaPrimenyaemost; /*создание объекта добавляемой строки*/ _polnayaPrimenyaemost = new PolnayaPrimenyaemost { Count = newPolnayaPrimenyaemost.count, detalCode = newPolnayaPrimenyaemost.idDetali }; // Вставка данных db.PolnayaPrimenyaemost.InsertOnSubmit(_polnayaPrimenyaemost); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void CreateUnit(Entities.UnitTo newUnit) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); UnitTable _unit; /*создание объекта добавляемой строки*/ _unit = new UnitTable { NameUnit = newUnit.NameUnit, ShortNameUnit = newUnit.ShortNameUnit }; // Вставка данных db.UnitTable.InsertOnSubmit(_unit); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void CreateMaterial(Entities.MaterialTo newMaterial) { /*добавить запрись в базу данных*/ /*создание объекта БД*/ var db = new DBElectricDataContext(); MaterialTable _material; /*создание объекта добавляемой строки*/ _material = new MaterialTable { MaterialCode = newMaterial.MaterialCode, NameMaterial = newMaterial.NameMaterial, UnitCode = newMaterial.UnitCode }; // Вставка данных db.MaterialTable.InsertOnSubmit(_material); // Отправка изменений в базу данных try { db.SubmitChanges(); } catch (Exception ex) { throw ex; } }