Exemplo n.º 1
0
        public void AddCustomerandSaleHeader()
        {
            FFREntities ffrDb = new FFREntities();

            Customer customer = new Customer();
            customer.FirstName = "Nick";
            customer.LastName = "Olsen";
            customer.City = "Parker";
            customer.State = "CO";
            customer.Zip = "80134";
            //Need to Add Street Name and Suite Fields
            customer.Address = customer.FirstName + " " + customer.LastName + "11321 Lovage Way " + customer.City + ", " + customer.State + " " + customer.Zip;
            customer.Phone = "3037181336";
            customer.Email = "*****@*****.**";

            ffrDb.Customers.Add(customer);
            ffrDb.SaveChanges();

            SalesHeader salesHeader = new SalesHeader();

            //salesHeader.CustomerId = 1;
            salesHeader.SalesStatus = "Open";
            salesHeader.OrderSalesBalance = 50;
            salesHeader.OrderTaxAmount = 5;
            salesHeader.OrderTotal = salesHeader.OrderSalesBalance + salesHeader.OrderTaxAmount;

            ffrDb.SalesHeaders.Add(salesHeader);
            ffrDb.SaveChanges();
        }
Exemplo n.º 2
0
 public IQueryable<Item> GetItems([QueryString("id")] int? itemCategoryId)
 {
     var _db = new FFREntities();//PresentationWebForms.Models.DataContext();
     IQueryable<Item> query = _db.Items;
     if (itemCategoryId.HasValue && itemCategoryId > 0)
     {
         query = query.Where(p => p.ItemCategoryId == itemCategoryId);
     }
     return query;
 }
Exemplo n.º 3
0
 public IQueryable<Item> GetSingleItem([QueryString("ItemId")]int? ItemId)
 {
     var _db = new FFREntities();
     IQueryable<Item> query = _db.Items;
     if (ItemId.HasValue && ItemId > 0)
     {
         query = query.Where(p => p.ItemId == ItemId);
     }
     else
     {
         query = null;
     }
     return query;
 }
Exemplo n.º 4
0
        public void UpdateItemCategory()
        {
            FFREntities ffrDb = new FFREntities();
            ItemCategory itemCategory = new ItemCategory();

            itemCategory.Category = "Update";
            itemCategory.Description = "Update";

            ffrDb.ItemCategories.Add(itemCategory);
            ffrDb.SaveChanges();

            ItemCategory updateItemCategory = (from d in ffrDb.ItemCategories where d.Category == "Update" select d).Single();
            updateItemCategory.Description = "Item Category has been updated";
            ffrDb.SaveChanges();
        }
Exemplo n.º 5
0
        public void ReadDB()
        {
            FFREntities ffrDb = new FFREntities();

            Customer savedCustomer = (from d in ffrDb.Customers where d.FirstName == "Nick" select d).Single();

            Assert.AreEqual(savedCustomer.FirstName, "Nick");
        }
Exemplo n.º 6
0
        public void DeleteItemCategory()
        {
            FFREntities ffrDb = new FFREntities();
            ItemCategory itemCategory = new ItemCategory();

            itemCategory.Category = "Delete";
            itemCategory.Description = "Delete";

            ffrDb.ItemCategories.Add(itemCategory);
            ffrDb.SaveChanges();

            ItemCategory deleteItemCategory = (from d in ffrDb.ItemCategories where d.Category == "Delete" select d).Single();
            ffrDb.ItemCategories.Remove(deleteItemCategory);
            ffrDb.SaveChanges();
        }
Exemplo n.º 7
0
        public void UpdateSalesHeader()
        {
            FFREntities ffrDb = new FFREntities();

            SalesHeader salesHeader = new SalesHeader();
            salesHeader.CustomerId = 1;
            salesHeader.SalesStatus = "Update";
            salesHeader.OrderSalesBalance = 50;
            salesHeader.OrderTaxAmount = 5;
            salesHeader.OrderTotal = salesHeader.OrderSalesBalance + salesHeader.OrderTaxAmount;

            ffrDb.SalesHeaders.Add(salesHeader);
            ffrDb.SaveChanges();

            SalesHeader updateSalesHeader = (from d in ffrDb.SalesHeaders where d.SalesStatus == "Update" select d).Single();
            updateSalesHeader.SalesStatus = "Record has been updated!";
            ffrDb.SaveChanges();
        }
Exemplo n.º 8
0
        public void ReadDB()
        {
            FFREntities ffrDb = new FFREntities();

            Customer savedCustomer = (from d in ffrDb.Customers where d.CustomerId == 2 select d).Single();

            Assert.AreEqual(savedCustomer.CustomerId, 2);
        }
Exemplo n.º 9
0
        public void DeleteSalesHeader()
        {
            FFREntities ffrDb = new FFREntities();

            SalesHeader salesHeader = new SalesHeader();
            salesHeader.SalesStatus = "Delete";
            salesHeader.OrderSalesBalance = 50;
            salesHeader.OrderTaxAmount = 5;
            salesHeader.OrderTotal = salesHeader.OrderSalesBalance + salesHeader.OrderTaxAmount;

            ffrDb.SalesHeaders.Add(salesHeader);
            ffrDb.SaveChanges();

            SalesHeader deleteSalesHeader = (from d in ffrDb.SalesHeaders where d.SalesId == 2 select d).Single();
            ffrDb.SalesHeaders.Remove(deleteSalesHeader);
            ffrDb.SaveChanges();
        }
Exemplo n.º 10
0
 public IQueryable<ItemCategory> GetItemCategories()
 {
     var db = new FFREntities();
     IQueryable<ItemCategory> query = db.ItemCategories;
     return query;
 }