public void DeleteFromDB(int id)
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
sqlcmd = "DELETE FROM Hardwares" +
" WHERE [IdHardware] = " + id;
aDB.ExecSQLNonQuery(sqlcmd);
}
public void SaveToDB()
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
if (this.Id == 0)
{
sqlcmd = "SELECT TOP 1 IdStorage FROM Storages ORDER BY IdStorage DESC";
Id = aDB.ExecSQLQuery(sqlcmd).Select().First().Field<int>("IdStorage") + 1;
sqlcmd = "INSERT INTO Storages" +
" ([IdStorage]) VALUES (" + this.Id + ")";
aDB.ExecSQLNonQuery(sqlcmd);
}
sqlcmd = "UPDATE Storages" +
" SET [StorageName] = '" + this.Name + "'" +
" WHERE [IdStorage] = " + this.Id;
aDB.ExecSQLNonQuery(sqlcmd);
}
public void SaveToDB()
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
if (this.Id == 0)
{
sqlcmd = "SELECT TOP 1 IdProducer FROM Producers ORDER BY IdProducer DESC";
this.Id = aDB.ExecSQLQuery(sqlcmd).Select().First().Field<int>("IdProducer")+1;
sqlcmd = "INSERT INTO Producers" +
" ([IdProducer]) VALUES (" + this.Id + ")";
aDB.ExecSQLNonQuery(sqlcmd);
}
sqlcmd = "UPDATE Producers" +
" SET [ProducerName] = '" + this.Name + "'," +
" [ProducerShortName] = '" + this.ShortName + "'" +
" WHERE [IdProducer] = " + this.Id;
aDB.ExecSQLNonQuery(sqlcmd);
}
public void SaveToDB()
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
if (this.Id == 0)
{
sqlcmd = "SELECT TOP 1 IdHardware FROM Hardwares ORDER BY IdHardware DESC";
this.Id = aDB.ExecSQLQuery(sqlcmd).Select().First().Field<int>("IdHardware") + 1;
sqlcmd = "INSERT INTO Hardwares" +
" ([IdHardware]) VALUES (" + this.Id + ")";
aDB.ExecSQLNonQuery(sqlcmd);
}
sqlcmd = "UPDATE Hardwares" +
" SET [HardwareName] = '" + this.Name + "'," +
" [ItemId] = " + ((this.ItemId != null) ? this.ItemId.ToString() : "NULL") + "," +
" [ParentHardware] = " + ((this.ParentHardware != null) ? this.ParentHardware.ToString() : "NULL") +
" WHERE [IdHardware] = " + this.Id;
aDB.ExecSQLNonQuery(sqlcmd);
}
public void SaveToDB()
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
if (this.Id == 0)
{
sqlcmd = "SELECT TOP 1 IdItem FROM Items ORDER BY IdItem DESC";
this.Id = aDB.ExecSQLQuery(sqlcmd).Select().First().Field<int>("IdItem") + 1;
sqlcmd = "INSERT INTO Items" +
" ([IdItem]) VALUES (" + this.Id + ")";
aDB.ExecSQLNonQuery(sqlcmd);
}
sqlcmd = "UPDATE Items" +
" SET [ItemName] = '" + this.Name + "'," +
" [OrderPrefix] = '" + this.OrderPrefix + "'," +
" [MachineBit] = " + this.MachineBit + "," +
" [ProducerId] = " + ((this.ProducerId != null) ? this.ProducerId.ToString() : "NULL") +
" WHERE [IdItem] = " + this.Id;
aDB.ExecSQLNonQuery(sqlcmd);
}
public void SaveToDB()
{
CAccessDB aDB = new CAccessDB();
string sqlcmd = null;
if (this.Id == 0)
{
sqlcmd = "SELECT TOP 1 IdProduct FROM Products ORDER BY IdProduct DESC";
this.Id = aDB.ExecSQLQuery(sqlcmd).Select().First().Field<int>("IdProduct") + 1;
sqlcmd = "INSERT INTO Products" +
" ([IdProduct]) VALUES (" + this.Id + ")";
aDB.ExecSQLNonQuery(sqlcmd);
}
sqlcmd = "UPDATE Products" +
" SET [ProductName] = '" + this.Name + "'," +
" [ItemId] = " + ((this.ItemId != null) ? this.ItemId.ToString() : "NULL") + "," +
" [SerialNumber] = '" + this.SerialNumber + "'," +
" [InventoryNumber] = '" + this.InventoryNumber + "'," +
" [ProductionDate] = " + ((this.ProductionDate != null) ? "'"+this.ProductionDate.Value.ToString()+"'" : "NULL") + "," +
" [PurchaseDate] = " + ((this.PurchaseDate != null) ? "'"+this.PurchaseDate.Value.ToString()+ "'" : "NULL") +
" WHERE [IdProduct] = " + this.Id;
aDB.ExecSQLNonQuery(sqlcmd);
}
