/// <summary> /// Delete an user postition /// </summary> /// <param name="inItem">input user position</param> /// <returns></returns> public int Delete(m_user_position inItem) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "DELETE FROM m_user_position WHERE user_position_id ='" + inItem.user_position_id + "'"; //Execute non query for add item int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; //Close SQL connection SQL.Close(); return(result); }
/// <summary> /// Add an user position /// </summary> /// <param name="inItem">input user position</param> /// <returns></returns> public int Add(m_user_position inItem) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "INSERT INTO m_user_position(user_position_cd, user_position_name, registration_user_cd) "; query += "VALUES('" + inItem.user_position_cd + "','" + inItem.user_position_name + "','"; query += inItem.registration_user_cd + "') "; //Execute non query for add item int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; //Close SQL connection SQL.Close(); return(result); }
/// <summary> /// Update an user position /// </summary> /// <param name="inItem">input user position</param> /// <returns></returns> public int Update(m_user_position inItem) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "UPDATE m_user_position "; query += "SET user_position_cd ='" + inItem.user_position_cd + "', user_position_name ='" + inItem.user_position_name; query += "', registration_user_cd ='" + inItem.registration_user_cd + "', registration_date_time = now() "; query += "WHERE user_position_id ='" + inItem.user_position_id + "'"; //Execute non query for add item int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; //Close SQL connection SQL.Close(); return(result); }
/// <summary> /// Get list user position /// </summary> /// <param name="position_code">string.emty if get all items</param> public void Search(string position_code) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; listUserPosition = new BindingList <m_user_position>(); //Open SQL connection SQL.Open(); //SQL query string query = "SELECT user_position_id, user_position_cd, user_position_name, registration_user_cd, registration_date_time "; query += "FROM m_user_position WHERE 1=1 "; if (!string.IsNullOrEmpty(position_code)) { query += "and user_position_cd = '" + position_code + "' "; } query += "ORDER BY user_position_id"; //Execute reader for read database IDataReader reader = SQL.Command(query).ExecuteReader(); query = string.Empty; while (reader.Read()) { //Get an item m_user_position outItem = new m_user_position { user_position_id = (int)reader["user_position_id"], user_position_cd = reader["user_position_cd"].ToString(), user_position_name = reader["user_position_name"].ToString(), registration_date_time = (DateTime)reader["registration_date_time"], registration_user_cd = reader["registration_user_cd"].ToString() }; //Add item into list listUserPosition.Add(outItem); } reader.Close(); //Close SQL connection SQL.Close(); }