/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CRetest businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_retest_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idretest", businessObject.Idretest); sqlCommand.Parameters["p_idretest"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters["p_idretest"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_idrecep_sample_detail_elem", businessObject.Idrecep_sample_detail_elem); sqlCommand.Parameters["p_idrecep_sample_detail_elem"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_idrecep_sample_detail", businessObject.Idrecep_sample_detail); sqlCommand.Parameters["p_idrecep_sample_detail"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_origin_batch", businessObject.Origin_batch); sqlCommand.Parameters["p_origin_batch"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_destiny_batch", businessObject.Destiny_batch); sqlCommand.Parameters["p_destiny_batch"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_type_retest", businessObject.Type_retest); sqlCommand.Parameters["p_type_retest"].NpgsqlDbType = NpgsqlDbType.Char; sqlCommand.Parameters.AddWithValue("p_date_retest", businessObject.Date_retest); sqlCommand.Parameters["p_date_retest"].NpgsqlDbType = NpgsqlDbType.Date; 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.Date; sqlCommand.Parameters.AddWithValue("p_useredit1", businessObject.Useredit1); sqlCommand.Parameters["p_useredit1"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_dateedit1", businessObject.Dateedit1); sqlCommand.Parameters["p_dateedit1"].NpgsqlDbType = NpgsqlDbType.Date; sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status); sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_status_retest", businessObject.Status_retest); sqlCommand.Parameters["p_status_retest"].NpgsqlDbType = NpgsqlDbType.Smallint; MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.Idretest = Convert.ToInt64(sqlCommand.Parameters["p_idretest"].Value); return(true); } catch (Exception ex) { throw new Exception("CRetest::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CRetest</returns> internal List <CRetest> PopulateObjectsFromReader(IDataReader dataReader) { List <CRetest> list = new List <CRetest>(); while (dataReader.Read()) { CRetest businessObject = new CRetest(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CRetest business object</returns> public CRetest SelectByPrimaryKey(CRetestKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_retest_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idretest", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idretest)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CRetest businessObject = new CRetest(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CRetest::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(CRetest businessObject, IDataReader dataReader) { businessObject.Idretest = dataReader.GetInt64(dataReader.GetOrdinal(CRetest.CRetestFields.Idretest.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Idrecep_sample_detail_elem.ToString()))) { businessObject.Idrecep_sample_detail_elem = dataReader.GetInt64(dataReader.GetOrdinal(CRetest.CRetestFields.Idrecep_sample_detail_elem.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Idrecep_sample_detail.ToString()))) { businessObject.Idrecep_sample_detail = dataReader.GetInt64(dataReader.GetOrdinal(CRetest.CRetestFields.Idrecep_sample_detail.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Origin_batch.ToString()))) { businessObject.Origin_batch = dataReader.GetInt64(dataReader.GetOrdinal(CRetest.CRetestFields.Origin_batch.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Destiny_batch.ToString()))) { businessObject.Destiny_batch = dataReader.GetInt64(dataReader.GetOrdinal(CRetest.CRetestFields.Destiny_batch.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Type_retest.ToString()))) { businessObject.Type_retest = dataReader.GetChar(dataReader.GetOrdinal(CRetest.CRetestFields.Type_retest.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Date_retest.ToString()))) { businessObject.Date_retest = dataReader.GetDateTime(dataReader.GetOrdinal(CRetest.CRetestFields.Date_retest.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Usernew.ToString()))) { businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CRetest.CRetestFields.Usernew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Datenew.ToString()))) { businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CRetest.CRetestFields.Datenew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Useredit1.ToString()))) { businessObject.Useredit1 = dataReader.GetString(dataReader.GetOrdinal(CRetest.CRetestFields.Useredit1.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Dateedit1.ToString()))) { businessObject.Dateedit1 = dataReader.GetDateTime(dataReader.GetOrdinal(CRetest.CRetestFields.Dateedit1.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CRetest.CRetestFields.Status.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CRetest.CRetestFields.Status_retest.ToString()))) { businessObject.Status_retest = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CRetest.CRetestFields.Status_retest.ToString())); } }