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 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 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 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 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 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 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 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 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 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 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 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 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; }
}
public void UpdateProduction(Entities.ProductionTo newProduction)
{
var db = new DBElectricDataContext();
var query =
from production in db.ProductionTable
where production.ProductionCode == newProduction.ProductionCode
select production;
foreach (ProductionTable production in query)
{
production.SignCode = newProduction.SignCode;
production.SortCode = newProduction.SortCode;
production.TypeCode = newProduction.TypeCode;
//production.UnitCode = newProduction.UnitCode;
//production.CountProduction = newProduction.CountProduction;
production.NameProduction = newProduction.NameProduction;
production.DesignationProduction = newProduction.DesignationProduction;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateSort(Entities.SortTo newSort)
{
var db = new DBElectricDataContext();
var query =
from sort in db.SortTable
where sort.SortCode == newSort.SortCode
select sort;
foreach (SortTable sort in query)
{
sort.NameSort = newSort.NameSort;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(Entities.SostavIzdeliaTo updSostavIzdelia)
{
var db = new DBElectricDataContext();
var query =
from sostavIzdelia in db.SostavIzdelia
where sostavIzdelia.Id == updSostavIzdelia.id
select sostavIzdelia;
foreach (SostavIzdelia sostavIzdelia in query)
{
sostavIzdelia.Count = updSostavIzdelia.count;
sostavIzdelia.IdCurrent = updSostavIzdelia.idCurrent;
sostavIzdelia.IdIzdelia = updSostavIzdelia.idIzdelia;
sostavIzdelia.IdLast = updSostavIzdelia.idLast;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateMaterial(Entities.MaterialTo newMaterial)
{
var db = new DBElectricDataContext();
var query =
from material in db.MaterialTable
where material.MaterialCode == newMaterial.MaterialCode
select material;
foreach (MaterialTable material in query)
{
material.NameMaterial = newMaterial.NameMaterial;
material.UnitCode = newMaterial.UnitCode;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateDirectory(Entities.DirectoryTo newDirectory)
{
var db = new DBElectricDataContext();
var query =
from directory in db.DirectoryTable
where directory.ProductionCode == newDirectory.ProductionCode
select directory;
foreach (DirectoryTable directory in query)
{
directory.NormMaterial = newDirectory.NormMaterial;
directory.NormWaste = newDirectory.NormWaste;
directory.MaterialCode = newDirectory.MaterialCode;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateType(Entities.TypeTo newType)
{
var db = new DBElectricDataContext();
var query =
from type in db.TypeTable
where type.TypeCode == newType.TypeCode
select type;
foreach (TypeTable type in query)
{
type.NameType = newType.NameType;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateSign(Entities.SignTo newSign)
{
var db = new DBElectricDataContext();
var query =
from sign in db.SignTable
where sign.SignCode == newSign.SignCode
select sign;
foreach (SignTable sign in query)
{
sign.NameSign = newSign.NameSign;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateUnit(Entities.UnitTo newUnit)
{
var db = new DBElectricDataContext();
var query =
from unit in db.UnitTable
where unit.UnitCode == newUnit.UnitCode
select unit;
foreach (UnitTable unit in query)
{
unit.NameUnit = newUnit.NameUnit;
unit.ShortNameUnit = newUnit.ShortNameUnit;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
