public int AddSaleToHistory(string Sale_ID, string SalePrice, string CustomerID)
{
string query = "Insert Into Sales_History Values(" + Sale_ID + " , " + SalePrice + ",0,null, " + CustomerID + " ,getdate() )";
return(dbMan.ExecuteNonQuery(query));
}
public int InsertBook(int Book_ID, string BookName, string Book_Language, string Genre, int Price, int Quantity, string Book_Description, int Rating, int Author_ID, int Publisher_ID)
{
string StoredProcedureName = "AddBooks";
Dictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters.Add("@Book_ID", Book_ID);
Parameters.Add("@BookName", BookName);
Parameters.Add("@Book_Language", Book_Language);
Parameters.Add("@Genre", Genre);
Parameters.Add("@Price", Price);
Parameters.Add("@Quantity", Quantity);
Parameters.Add("@Book_Description", Book_Description);
Parameters.Add("@Rating", Rating);
Parameters.Add("@Author_ID", Author_ID);
Parameters.Add("@Publisher_ID", Publisher_ID);
return(dbMan.ExecuteNonQuery(StoredProcedureName, Parameters));
}
