public DepartmentDTO getDepartmentDetail(String id) { sqlCon = new SqlConnection(stringConn); sqlCon.Open(); DepartmentDTO result = null; cmd = new SqlCommand("SELECT TENKHOA, NAMTHANHLAP FROM KHOA WHERE MAKHOA = '" + id + "'", sqlCon); reader = cmd.ExecuteReader(); if (reader.Read()) { var name = reader.GetString(0); var year = reader.GetInt32(1); result = new DepartmentDTO(id, name, year); } closeConnection(); return(result); }
public bool addDepartment(DepartmentDTO dto) { bool check = false; try { sqlCon = new SqlConnection(stringConn); sqlCon.Open(); cmd = new SqlCommand(String.Format("INSERT INTO KHOA VALUES('{0}','{1}','{2}')", dto.Id, dto.Name, dto.Year), sqlCon); check = cmd.ExecuteNonQuery() > 0 ? true : false; closeConnection(); } catch (Exception e) { } return(check); }