public static bool isExists(ObjBelbinDeadline obj) { string query = $@" select * from is_test_deadline where group_id = (select id from is_group where name = '{obj.group}') and discipline_id = (select id from is_discipline where name = '{obj.discipline}') "; MySqlConnection connection = DBUtils.getConnection(); connection.Open(); MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { connection.Close(); return(true); } connection.Close(); return(false); }
public static void update(ObjBelbinDeadline obj) { string query = $@" update is_test_deadline set dt_begin = {obj.dt_begin}, dt_end = {obj.dt_end} where group_id = (select id from is_group where name = '{obj.group}') and discipline_id = (select id from is_discipline where name = '{obj.discipline}') "; DBUtils.execQuery(query); }
public static void insert(ObjBelbinDeadline obj) { string query = $@" insert into is_test_deadline(dt_begin, dt_end, group_id, discipline_id) values( {obj.dt_begin}, {obj.dt_end}, (select id from is_group where name = '{obj.group}'), (select id from is_discipline where name = '{obj.discipline}') ) "; DBUtils.execQuery(query); }