public bool addHopHoSo(HopHoSo newSec) { bool result = false; SqlConnection conn = new SqlConnection(connectionString); try { string query = "INSERT INTO Su_HopHoSo VALUES(N'" + newSec.Name + "', N'" + newSec.Description + "');"; conn.Open(); executeDataByQuery(query, conn, null); result = true; } catch (Exception e) { logUserManagement("addApprover()", e.Message); } finally { conn.Close(); } return(result); }
public HopHoSo getHopHoSo(int ID) { HopHoSo result = null; string query = "SELECT ID, Name, Description FROM Su_HopHoSo WHERE ID = " + ID + ""; DataTable dt = getData(query); if (dt.Rows.Count > 0) { result = new HopHoSo(); result.ID = ID; result.Name = dt.Rows[0][1].ToString(); result.Description = dt.Rows[0][2].ToString(); } return(result); }
public bool updateHopHoSo(HopHoSo Sec) { bool result = false; SqlConnection conn = new SqlConnection(connectionString); string query = "UPDATE Su_HopHoSo SET Name = N'" + Sec.Name + "', Description = N'" + Sec.Description + "' WHERE ID = " + Sec.ID + ""; try { conn.Open(); executeDataByQuery(query, conn, null); result = true; } catch (Exception e) { logUserManagement("updateHopHoSo()", e.Message); } finally { conn.Close(); } return(result); }