Esempio n. 1
0
 internal static ItemAttribute GetItemAttribute(string itemAttributeID)
 {
     string connectionString = ConfigurationManager.ConnectionStrings["Project1"].ToString();
     string sql = "select items.description as ItemDescription, " +
         "itemattribute.description as ItemAttributeDescription, itemattribute.MarkupPercentage, itemattribute.MarkupFlatRate, itemattribute.ItemAttributeID" +
         " from Items, ItemAttribute where Items.ItemID = itemattribute.itemid and ItemAttribute.ItemAttributeID = " + itemAttributeID;
     ItemAttribute itemAttribute = new ItemAttribute();
     using (SqlConnection myConnection = new SqlConnection(connectionString))
     {
         myConnection.Open();
         using (SqlCommand myCommand = new SqlCommand(sql, myConnection))
         {
             using (SqlDataReader myDataReader = myCommand.ExecuteReader())
             {
                 if (myDataReader.Read())
                 {
                     itemAttribute.Description = myDataReader["ItemAttributeDescription"].ToString();
                     itemAttribute.MarkupPertcentage = myDataReader["MarkupPercentage"].ToString();
                     itemAttribute.MarkupFlatRate = myDataReader["MarkupFlatRate"].ToString();
                     itemAttribute.ItemAttributeID = myDataReader["ItemAttributeID"].ToString();
                 }
             }
         }
     }
     return itemAttribute;
 }
Esempio n. 2
0
        internal static IEnumerable<ItemAttribute> GetItemAttributes(string itemID)
        {
            List<ItemAttribute> itemAttributes = new List<ItemAttribute>();
            ItemAttribute itemAttribute = new ItemAttribute();
            string connectionString = ConfigurationManager.ConnectionStrings["Project1"].ToString();
            string sql = "select Description, MarkupPercentage, MarkupFlatRate,ItemAttributeID " +
                " from ItemAttribute where ItemID = " + itemID;
            using (SqlConnection myConnection = new SqlConnection(connectionString))
            {
                myConnection.Open();
                using (SqlCommand myCommand = new SqlCommand(sql, myConnection))
                {
                    using (SqlDataReader myDataReader = myCommand.ExecuteReader())
                    {
                        while (myDataReader.Read())
                        {
                            itemAttributes.Add(new ItemAttribute(
                                myDataReader["Description"].ToString(),
                                myDataReader["MarkupPercentage"].ToString(),
                                myDataReader["MarkupFlatRate"].ToString(),
                                myDataReader["ItemAttributeID"].ToString()));

                        }
                    }
                }
            }
            return itemAttributes;
        }