/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CConfiguration_folder</returns> internal List <CConfiguration_folder> PopulateObjectsFromReader(IDataReader dataReader) { List <CConfiguration_folder> list = new List <CConfiguration_folder>(); while (dataReader.Read()) { CConfiguration_folder businessObject = new CConfiguration_folder(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CConfiguration_folder businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_configuration_folder_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idconfiguration_folder", businessObject.Idconfiguration_folder); sqlCommand.Parameters["p_idconfiguration_folder"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters["p_idconfiguration_folder"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_folder_name", businessObject.Folder_name); sqlCommand.Parameters["p_folder_name"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_description", businessObject.Description); sqlCommand.Parameters["p_description"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_path", businessObject.Path); sqlCommand.Parameters["p_path"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_folder_type", businessObject.Folder_type); sqlCommand.Parameters["p_folder_type"].NpgsqlDbType = NpgsqlDbType.Char; sqlCommand.Parameters.AddWithValue("p_usernew", businessObject.Usernew); sqlCommand.Parameters["p_usernew"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_datenew", businessObject.Datenew); sqlCommand.Parameters["p_datenew"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_useredit", businessObject.Useredit); sqlCommand.Parameters["p_useredit"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_dateedit", businessObject.Dateedit); sqlCommand.Parameters["p_dateedit"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status); sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean; MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.Idconfiguration_folder = Convert.ToInt16(sqlCommand.Parameters["p_idconfiguration_folder"].Value); return(true); } catch (Exception ex) { throw new Exception("CConfiguration_folder::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CConfiguration_folder business object</returns> public CConfiguration_folder SelectByPrimaryKey(CConfiguration_folderKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_configuration_folder_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idconfiguration_folder", NpgsqlDbType.Smallint, 2, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idconfiguration_folder)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CConfiguration_folder businessObject = new CConfiguration_folder(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CConfiguration_folder::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CConfiguration_folder businessObject, IDataReader dataReader) { businessObject.Idconfiguration_folder = (short)dataReader.GetInt16(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Idconfiguration_folder.ToString())); businessObject.Folder_name = dataReader.GetString(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Folder_name.ToString())); businessObject.Description = dataReader.GetString(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Description.ToString())); businessObject.Path = dataReader.GetString(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Path.ToString())); businessObject.Folder_type = dataReader.GetChar(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Folder_type.ToString())); businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Usernew.ToString())); businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Datenew.ToString())); businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Useredit.ToString())); businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Dateedit.ToString())); businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CConfiguration_folder.CConfiguration_folderFields.Status.ToString())); }