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; }