public List <US_HT_USER> GetAllUsers() { string query = string.Format("select * from [HT_USER]"); SqlParameter[] sqlParameters = new SqlParameter[0]; DataTable dataTable = conn.executeSelectQuery(query, sqlParameters); List <US_HT_USER> listUsers = new List <US_HT_USER>(); foreach (DataRow dr in dataTable.Rows) { US_HT_USER user = new US_HT_USER(); Guid id = new Guid(dr["ID"].ToString()); user.ID = id; user.BHYT = dr["BHYT"].ToString(); user.CMND = dr["CMND"].ToString(); user.MSBN = dr["MSBN"].ToString(); user.USERNAME = dr["USERNAME"].ToString(); user.PASSWORD = dr["PASSWORD"].ToString(); user.HO = dr["HO"].ToString(); user.TEN = dr["TEN"].ToString(); user.IS_ACTIVE = bool.Parse(dr["IS_ACTIVE"].ToString()); Guid idGroup = new Guid(dr["ID_USER_GROUP"].ToString()); user.ID_USER_GROUP = idGroup; listUsers.Add(user); } return(listUsers); }
public void Delete(US_HT_USER ip_us) { SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@ID", SqlDbType.UniqueIdentifier) { Value = ip_us.ID }; conn.executeUpdateQuery("pr_HT_USER_Delete", sqlParameters); }
public void Insert(US_HT_USER ip_us) { SqlParameter[] sqlParameters = new SqlParameter[10]; sqlParameters[0] = new SqlParameter("@ID", SqlDbType.UniqueIdentifier) { Value = ip_us.ID }; sqlParameters[1] = new SqlParameter("@BHYT", SqlDbType.NVarChar) { Value = ip_us.BHYT }; sqlParameters[2] = new SqlParameter("CMND", SqlDbType.NVarChar) { Value = ip_us.CMND }; sqlParameters[3] = new SqlParameter("MSBN", SqlDbType.NVarChar) { Value = ip_us.MSBN }; sqlParameters[4] = new SqlParameter("USERNAME", SqlDbType.NVarChar) { Value = ip_us.USERNAME }; sqlParameters[5] = new SqlParameter("PASSWORD", SqlDbType.NVarChar) { Value = ip_us.PASSWORD }; sqlParameters[6] = new SqlParameter("HO", SqlDbType.NVarChar) { Value = ip_us.HO }; sqlParameters[7] = new SqlParameter("TEN", SqlDbType.NVarChar) { Value = ip_us.TEN }; sqlParameters[8] = new SqlParameter("IS_ACTIVE", SqlDbType.Bit) { Value = ip_us.IS_ACTIVE }; sqlParameters[9] = new SqlParameter("ID_USER_GROUP", SqlDbType.UniqueIdentifier) { Value = ip_us.ID_USER_GROUP }; //string query = // "INSERT HT_USER ([ID], [BHYT], [CMND], [MSBN], [USERNAME], [PASSWORD], [HO], [TEN], [IS_ACTIVE], [ID_USER_GROUP]) " //+ "VALUES ('" + ip_us.ID + "', '" + ip_us.BHYT + "', '" + ip_us.CMND + "', '" + ip_us.MSBN + "', '" + ip_us.USERNAME + "', '" + ip_us.PASSWORD + "', '" + ip_us.HO + "', '" + ip_us.TEN + "', " + ip_us.IS_ACTIVE + ", '" + ip_us.ID_USER_GROUP + "')"; conn.executeInsertQuery("pr_HT_USER_Insert", sqlParameters); //conn.executeInsertQuery(query, sqlParameters); }
public void Update(US_HT_USER ip_us) { SqlParameter[] sqlParameters = new SqlParameter[10]; sqlParameters[0] = new SqlParameter("@ID", SqlDbType.UniqueIdentifier) { Value = ip_us.ID }; sqlParameters[1] = new SqlParameter("@BHYT", SqlDbType.NVarChar) { Value = ip_us.BHYT }; sqlParameters[2] = new SqlParameter("CMND", SqlDbType.NVarChar) { Value = ip_us.CMND }; sqlParameters[3] = new SqlParameter("MSBN", SqlDbType.NVarChar) { Value = ip_us.MSBN }; sqlParameters[4] = new SqlParameter("USERNAME", SqlDbType.NVarChar) { Value = ip_us.USERNAME }; sqlParameters[5] = new SqlParameter("PASSWORD", SqlDbType.NVarChar) { Value = ip_us.PASSWORD }; sqlParameters[6] = new SqlParameter("HO", SqlDbType.NVarChar) { Value = ip_us.HO }; sqlParameters[7] = new SqlParameter("TEN", SqlDbType.NVarChar) { Value = ip_us.TEN }; sqlParameters[8] = new SqlParameter("IS_ACTIVE", SqlDbType.Bit) { Value = ip_us.IS_ACTIVE }; sqlParameters[9] = new SqlParameter("ID_USER_GROUP", SqlDbType.UniqueIdentifier) { Value = ip_us.ID_USER_GROUP }; conn.executeUpdateQuery("pr_HT_USER_Update", sqlParameters); }