public static void insert(ObjGroupsList obj)
{
string query = $@"insert into is_group(name, faculty_id, course_id, dt)
values(
'{obj.name}',
(select id from is_faculty where name = '{obj.faculty}' limit 1),
(select id from is_course where name = '{obj.course}' limit 1),
'{obj.dt}'
)
";
DBUtils.execQuery(query);
}
public static List <ObjGroupsList> getList()
{
List <ObjGroupsList> result = new List <ObjGroupsList>();
string query = $@"
select
isg.id,
isg.name as groupname,
isc.name as course,
isf.name as faculty,
isg.dt as dt
from is_group isg
join is_course isc on isc.id = isg.course_id
join is_faculty isf on isf.id = isg.faculty_id
";
MySqlConnection conn = DBUtils.getConnection();
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ObjGroupsList obj = new ObjGroupsList()
{
id = reader["id"].ToString(),
faculty = reader["faculty"].ToString(),
name = reader["groupname"].ToString(),
course = reader["course"].ToString(),
dt = reader["dt"].ToString()
};
result.Add(obj);
}
conn.Close();
return(result);
}
public static void update(ObjGroupsList obj)
{
string query = $@"
UPDATE is_group SET
name = '{obj.name}',
course_id = (select id from is_course where name = '{obj.course}' limit 1),
faculty_id = (select id from is_faculty where name = '{obj.faculty}' limit 1),
dt = {obj.dt}
WHERE id = '{obj.id}'
";
DBUtils.execQuery(query);
}
