Exemple #1
0
        public IPackageType GetPackageType(string packageTypeName)
        {
            IPackageType result = null;

            using (var Conn = new SqlConnection(_connectionString))
            {
                using (var Cmd = new SqlCommand($"SELECT PackageTypeID, PackageTypeName from Warehouse.PackageTypes where PackageTypeName = @PackageTypeName", Conn))
                {
                    Cmd.Parameters.Add("@PackageTypeName", SqlDbType.NVarChar);
                    Cmd.Parameters["@PackageTypeName"].Value = packageTypeName;
                    // Open SQL Connection
                    Conn.Open();

                    // Execute SQL Command
                    SqlDataReader rdr = Cmd.ExecuteReader();

                    // Loop through the results and add to list
                    while (rdr.Read())
                    {
                        result    = new PackageType();
                        result.ID = rdr.GetInt32(0);
                        result.PackageTypeName = rdr.GetString(1);
                    }
                }
            }
            return(result);
        }
Exemple #2
0
 public PackageTypeBL()
 {
     packageTypeDAL = new PackageTypeRepository();
 }