public static void AddNewExercice(TypeOfExercicies Ex)
{
Conn.Open();
string query = String.Format("Insert into [dbo].[TypeOfExercices](Name) Values('{0}')", Ex.GetExName());
command = new SqlCommand(query, Conn);
command.ExecuteNonQuery();
Conn.Close();
}
public static bool ExerciceExists(TypeOfExercicies ex)
{
bool Ok = true;
Conn.Open();
string query = String.Format("Select count(*) from [dbo].[TypeOfExercices] where Name='{0}'", ex.GetExName());
command = new SqlCommand(query, Conn);
if (Convert.ToInt32(command.ExecuteScalar()) >= 1)
Ok = true;
else
Ok = false;
Conn.Close();
return Ok;
}