internal static int ExecuteQuery(string query)
{
// Getting oracle connection first
OracleConnection connection = DB_Conn.GetOracleConnection();
if (connection != null)
{
// Creating Oracle Command for perticular query through that connection
OracleCommand command = new OracleCommand(query, connection);
return(command.ExecuteNonQuery());
}
return(0);
}
public static int stockCheck(Software.Model.Order_Food food)
{
int stock = 0;
OracleConnection conn = DB_Conn.GetOracleConnection();
string sql = "select stock_count from food where id=" + food.Food_Id;
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
stock = Convert.ToInt32(dr["stock_count"].ToString());
}
conn.Close();
return(stock);
}
internal static DataSet GetDataSet(string query)
{
// Getting oracle connection first
OracleConnection connection = DB_Conn.GetOracleConnection();
if (connection != null)
{
// Creating Oracle Command for perticular query through that connection
OracleCommand command = new OracleCommand(query, connection);
// Converting the command into C# dataset
OracleDataAdapter dataAdapter = new OracleDataAdapter(command);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
// Closing the connection
connection.Close();
// Returning dataset
return(dataSet);
}
return(null);
}