Exemple #1
0
        ///<Summary>
        ///</Summary>
        ///<returns>
        ///Int32
        ///</returns>
        ///<parameters>
        ///DAOVisitation daoVisitation
        ///</parameters>
        public static Int32 SelectAllBySearchFieldsCount(DAOVisitation daoVisitation)
        {
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprVisitation_SelectAllBySearchFieldsCount;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            try
            {
                command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Id ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Name ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Arrived", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Arrived ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Staffid", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Staffid ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Purpose", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Purpose ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Departed", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Departed ?? (object)DBNull.Value));

                staticConnection.Open();
                Int32 retCount = (Int32)command.ExecuteScalar();

                return(retCount);
            }
            catch
            {
                throw;
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
Exemple #2
0
        ///<Summary>
        ///</Summary>
        ///<returns>
        ///IList-DAOVisitation.
        ///</returns>
        ///<parameters>
        ///DAOVisitation daoVisitation
        ///</parameters>
        public static IList <DAOVisitation> SelectAllBySearchFields(DAOVisitation daoVisitation)
        {
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprVisitation_SelectAllBySearchFields;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Visitation");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Id ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Name ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Arrived", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Arrived ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Staffid", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Staffid ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Purpose", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Purpose ?? (object)DBNull.Value));
                command.Parameters.Add(new SqlParameter("@Departed", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, (object)daoVisitation.Departed ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);

                List <DAOVisitation> objList = new List <DAOVisitation>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOVisitation retObj = new DAOVisitation();
                        retObj._id       = Convert.IsDBNull(row["id"]) ? (Int32?)null : (Int32?)row["id"];
                        retObj._name     = Convert.IsDBNull(row["Name"]) ? null : (string)row["Name"];
                        retObj._arrived  = Convert.IsDBNull(row["Arrived"]) ? (DateTime?)null : (DateTime?)row["Arrived"];
                        retObj._staffid  = Convert.IsDBNull(row["Staffid"]) ? (Int32?)null : (Int32?)row["Staffid"];
                        retObj._purpose  = Convert.IsDBNull(row["Purpose"]) ? null : (string)row["Purpose"];
                        retObj._departed = Convert.IsDBNull(row["Departed"]) ? (DateTime?)null : (DateTime?)row["Departed"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch
            {
                throw;
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
Exemple #3
0
        ///<Summary>
        ///Select all rows
        ///This method returns all data rows in the table Visitation
        ///</Summary>
        ///<returns>
        ///IList-DAOVisitation.
        ///</returns>
        ///<parameters>
        ///
        ///</parameters>
        public static IList <DAOVisitation> SelectAll()
        {
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprVisitation_SelectAll;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Visitation");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                staticConnection.Open();
                sqlAdapter.Fill(dt);

                List <DAOVisitation> objList = new List <DAOVisitation>();
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DAOVisitation retObj = new DAOVisitation();
                        retObj._id       = Convert.IsDBNull(row["id"]) ? (Int32?)null : (Int32?)row["id"];
                        retObj._name     = Convert.IsDBNull(row["Name"]) ? null : (string)row["Name"];
                        retObj._arrived  = Convert.IsDBNull(row["Arrived"]) ? (DateTime?)null : (DateTime?)row["Arrived"];
                        retObj._staffid  = Convert.IsDBNull(row["Staffid"]) ? (Int32?)null : (Int32?)row["Staffid"];
                        retObj._purpose  = Convert.IsDBNull(row["Purpose"]) ? null : (string)row["Purpose"];
                        retObj._departed = Convert.IsDBNull(row["Departed"]) ? (DateTime?)null : (DateTime?)row["Departed"];
                        objList.Add(retObj);
                    }
                }
                return(objList);
            }
            catch
            {
                throw;
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }
Exemple #4
0
        ///<Summary>
        ///Select one row by primary key(s)
        ///This method returns one row from the table Visitation based on the primary key(s)
        ///</Summary>
        ///<returns>
        ///DAOVisitation
        ///</returns>
        ///<parameters>
        ///Int32? id
        ///</parameters>
        public static DAOVisitation SelectOne(Int32?id)
        {
            SqlCommand command = new SqlCommand();

            command.CommandText = InlineProcs.ctprVisitation_SelectOne;
            command.CommandType = CommandType.Text;
            SqlConnection staticConnection = StaticSqlConnection;

            command.Connection = staticConnection;

            DataTable      dt         = new DataTable("Visitation");
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);

            try
            {
                command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)id ?? (object)DBNull.Value));

                staticConnection.Open();
                sqlAdapter.Fill(dt);

                DAOVisitation retObj = null;
                if (dt.Rows.Count > 0)
                {
                    retObj           = new DAOVisitation();
                    retObj._id       = Convert.IsDBNull(dt.Rows[0]["id"]) ? (Int32?)null : (Int32?)dt.Rows[0]["id"];
                    retObj._name     = Convert.IsDBNull(dt.Rows[0]["Name"]) ? null : (string)dt.Rows[0]["Name"];
                    retObj._arrived  = Convert.IsDBNull(dt.Rows[0]["Arrived"]) ? (DateTime?)null : (DateTime?)dt.Rows[0]["Arrived"];
                    retObj._staffid  = Convert.IsDBNull(dt.Rows[0]["Staffid"]) ? (Int32?)null : (Int32?)dt.Rows[0]["Staffid"];
                    retObj._purpose  = Convert.IsDBNull(dt.Rows[0]["Purpose"]) ? null : (string)dt.Rows[0]["Purpose"];
                    retObj._departed = Convert.IsDBNull(dt.Rows[0]["Departed"]) ? (DateTime?)null : (DateTime?)dt.Rows[0]["Departed"];
                }
                return(retObj);
            }
            catch
            {
                throw;
            }
            finally
            {
                staticConnection.Close();
                command.Dispose();
            }
        }