/// <summary> /// Get list of all item type /// </summary> public void GetListItemType() { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; listItemType = new BindingList <pts_item_type>(); //Open SQL connection SQL.Open(); //SQL query string query = "select type_id, type_name, registration_user_cd, registration_date_time from pts_item_type where 1=1 "; query += "order by type_id"; //Execute reader for read database IDataReader reader = SQL.Command(query).ExecuteReader(); query = string.Empty; while (reader.Read()) { //Get an item pts_item_type outItem = new pts_item_type { type_id = (int)reader["type_id"], type_name = reader["type_name"].ToString(), registration_date_time = (DateTime)reader["registration_date_time"], registration_user_cd = reader["registration_user_cd"].ToString() }; //Add item into list listItemType.Add(outItem); } reader.Close(); //Close SQL connection SQL.Close(); }
/// <summary> /// Get infomation of an item type /// </summary> /// <param name="typeID">type id</param> /// <returns></returns> public pts_item_type GetItemType(int typeID) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "select * from pts_item_type where 1=1 "; query += "and type_id = '" + typeID + "' "; query += "order by type_id"; //Execute reader for read database IDataReader reader = SQL.Command(query).ExecuteReader(); query = string.Empty; //Get an item reader.Read(); pts_item_type outItem = new pts_item_type { type_id = (int)reader["type_id"], type_name = reader["type_name"].ToString(), registration_date_time = (DateTime)reader["registration_date_time"], registration_user_cd = reader["registration_user_cd"].ToString() }; reader.Close(); //Close SQL connection SQL.Close(); return(outItem); }
/// <summary> /// Add an item type /// </summary> /// <param name="inItem">new item type</param> /// <returns></returns> public int AddItemType(pts_item_type inItem) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "INSERT INTO pts_item_type(type_id, type_name, registration_user_cd)"; query += "VALUES ('" + inItem.type_id + "','" + inItem.type_name + "','" + inItem.registration_user_cd + "')"; //Execute non query for read database int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; return(result); }
/// <summary> /// Update an item type /// </summary> /// <param name="inItem">input item type</param> /// <returns></returns> public int Update(pts_item_type inItem) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "UPDATE pts_item_type SET type_id='" + inItem.type_id + "', type_name='" + inItem.type_name; query += "', registration_user_cd ='" + inItem.registration_user_cd; query += "', registration_date_time = now() where type_id ='" + inItem.type_id + "'"; //Execute non query for read database int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; return(result); }