//Inserting data into database
public bool Insert(FastFoodClass f)
{
//Creating default return type and setting its value to false
bool isSuccess = false;
//Step 1 Connect database
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Step 2 Creating SQL query to insert data
string sql = "INSERT INTO fastFood(Name, Address, PhoneNo) VALUES (@Name, @Address, @PhoneNo)";
//Creating sql command using sql and conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create parameter to add data
cmd.Parameters.AddWithValue("@Name", f.Name);
cmd.Parameters.AddWithValue("@PhoneNo", f.PhoneNo);
cmd.Parameters.AddWithValue("@Address", f.Address);
cmd.Connection = conn;
//Connection open
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs then the value of rows will be > 0 else it will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
