public int RegisterNewOrder(int _customerID)
{
string query = "INSERT INTO [Orders](CustomerID) VALUES (@CustomerID); SELECT SCOPE_IDENTITY();";
List <KeyValuePair <string, object> > parameterlist = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@CustomerID", _customerID)
};
return(SQL_CRUD_Methods.SQLInsert(query, parameterlist));
}
public int GetNewDelivery()
{
string query = "INSERT INTO Delivery(DateTime,ExternalID) VALUES (@DateTime,@ExternalID); SELECT SCOPE_IDENTITY()";
List <KeyValuePair <string, Object> > parameterlist = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@DateTime", DateTime.Now),
new KeyValuePair <string, object>("@ExternalID", "X")
};
return(SQL_CRUD_Methods.SQLInsert(query, parameterlist));
}
public int SaveNewProduct(Product _product)
{
string query = "INSERT INTO Product(Type,Name,Volume,VolumeType,AmountInStock,Active) VALUES (@Type,@Name,@Volume,@VolumeType,@AmountInStock,@Active)";
List <KeyValuePair <string, object> > parameterlist = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@Type", _product.VolumeType),
new KeyValuePair <string, object>("@Name", _product.Name),
new KeyValuePair <string, object>("@Volume", _product.Volume),
new KeyValuePair <string, object>("@VolumeType", _product.VolumeType),
new KeyValuePair <string, object>("@AmountInStock", 0),
new KeyValuePair <string, object>("@Active", _product.Active)
};
return(SQL_CRUD_Methods.SQLInsert(query, parameterlist));
}
