示例#1
0
        /// <summary>
        /// Creates a new instance of the HANG_SAN_XUAT class and populates it with data from the specified SqlDataReader.
        /// </summary>
        private HANGSANXUAT_DTO MakeHANGSANXUAT_DTO(SqlDataReader dataReader)
        {
            HANGSANXUAT_DTO HangSanXuat = new HANGSANXUAT_DTO();

            HangSanXuat.Ma        = SqlClientUtility.GetInt32(dataReader, "MA", 0);
            HangSanXuat.TenHangXe = SqlClientUtility.GetString(dataReader, "TEN_HANG_XE", String.Empty);

            return(HangSanXuat);
        }
示例#2
0
        /// <summary>
        /// Saves a record to the HANG_SAN_XUAT table.
        /// </summary>
        public void Insert(HANGSANXUAT_DTO HangSanXuat)
        {
            ValidationUtility.ValidateArgument("HangSanXuat", HangSanXuat);

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@TEN_HANG_XE", HangSanXuat.TenHangXe)
            };

            HangSanXuat.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_HangSanXuat_Insert", parameters);
        }
示例#3
0
        /// <summary>
        /// Updates a record in the HANG_SAN_XUAT table.
        /// </summary>
        public void Update(HANGSANXUAT_DTO HangSanXuat)
        {
            ValidationUtility.ValidateArgument("HangSanXuat", HangSanXuat);

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@MA", HangSanXuat.Ma),
                new SqlParameter("@TEN_HANG_XE", HangSanXuat.TenHangXe)
            };

            SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_HangSanXuat_Update", parameters);
        }
示例#4
0
        /// <summary>
        /// Selects all records from the HANG_SAN_XUAT table.
        /// </summary>
        public List <HANGSANXUAT_DTO> SelectAll()
        {
            using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_HangSanXuat_SelectAll"))
            {
                List <HANGSANXUAT_DTO> HangSanXuatList = new List <HANGSANXUAT_DTO>();
                while (dataReader.Read())
                {
                    HANGSANXUAT_DTO HangSanXuat = MakeHANGSANXUAT_DTO(dataReader);
                    HangSanXuatList.Add(HangSanXuat);
                }

                return(HangSanXuatList);
            }
        }
示例#5
0
 /// <summary>
 /// Updates a record in the HANG_SAN_XUAT table.
 /// </summary>
 public void Update(HANGSANXUAT_DTO HangSanXuat)
 {
     ValidationUtility.ValidateArgument("HangSanXuat", HangSanXuat);
     new HANGSANXUAT_DAO().Update(HangSanXuat);
 }