Ejemplo n.º 1
0
        // summary log of single item dispensary
        private void Summary_Dispensary()
        {
            try
            {
                var dis_summ = new DispenseSummary();
                dis_summ.GroupId       = txtRandom.Text;
                dis_summ.GroupDate     = DateTime.Parse(txtgroupDate.Text);
                dis_summ.SubAmount     = float.Parse(txtAmountTotal.Text);
                dis_summ.Discount      = (float)nudDiscount.Value;
                dis_summ.Vat           = (float)nudVat.Value;
                dis_summ.Total         = float.Parse(txtTotalFinal.Text);
                dis_summ.DateDispensed = DateTime.Parse(txtDateAmend.Text);
                dis_summ.UserDispensed = Environment.UserName;

                using (var ctx = new InventoryModel())
                {
                    ctx.DispenseSummaries.Add(dis_summ);

                    ctx.SaveChanges();
                }

                MessageBox.Show("Item successfully dispensed");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Dispense Item");
            }
        }
Ejemplo n.º 2
0
        internal void SaveDispensedItems(DispenseCartSaveEventArgs e)
        {
            try
            {
                var ds = new DispenseSummary();
                ds.DateDispensed = DateTime.Now;
                ds.Discount      = (float)e.Discount;
                ds.SubAmount     = (float)e.SubTotal;
                ds.Total         = (float)e.Total;
                ds.UserDispensed = Environment.UserName;
                ds.Vat           = (float)e.Vat;
                ds.GroupId       = string.Empty;
                ds.GroupDate     = DateTime.Now;

                using (var ctx = new InventoryModel())
                {
                    foreach (var item in e.Items)
                    {
                        var aItem = ctx
                                    .Items
                                    .Single(x => x.Identifier == item.ItemId);

                        aItem.StockLevel -= item.Quantity;
                    }

                    ctx.DispenseSummaries.Add(ds);

                    ctx.SaveChanges();
                }

                using (var db = new InventoryDocumentStorage())
                {
                    db.DispenseSummaries.Insert(ds);
                }
            }
            catch (Exception ex)
            {
                View.ShowError(ex);
            }
        }
Ejemplo n.º 3
0
        protected override void Seed(InventoryModel context)
        {
            var aUser = new User {
                FirstName = "Irene", LastName = "A.", UserName = "******", Password = "******", Role = "Admin", Email = "*****@*****.**", Phone = "0801"
            };

            context.Users.Add(aUser);

            var aSupplier1 = new Supplier {
                Name = "XYZ Drugs Limited", ContactPerson = "Mr Chacha Nedo", Address = "Ikeja, Lagos, Nigeria", Email = "*****@*****.**", Phone = "080333222"
            };
            var aSupplier2 = new Supplier {
                Name = "Makinga", ContactPerson = "Mr Toba", Address = "Iwaya Road, Yaba, Lagos", Email = "*****@*****.**", Phone = "080000"
            };

            context.Suppliers.AddRange(new[] { aSupplier1, aSupplier2 });

            var aDispese1 = new Dispense {
                ItemId = "1", GroupId = "27695", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 20, UnitPrice = 5, DispenseQuantity = 1, SubAmount = 5, StockBalance = 20, DateDispensed = new DateTime(2017, 07, 01, 17, 51, 25)
            };
            var aDispese2 = new Dispense {
                ItemId = "1", GroupId = "11358", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 18, UnitPrice = 5, DispenseQuantity = 2, SubAmount = 10, StockBalance = 18, DateDispensed = new DateTime(2017, 07, 01, 18, 01, 29)
            };
            var aDispese3 = new Dispense {
                ItemId = "1", GroupId = "3439", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 15, UnitPrice = 4, DispenseQuantity = 3, SubAmount = 12, StockBalance = 15, DateDispensed = new DateTime(2017, 07, 01, 18, 06, 06)
            };
            var aDispese4 = new Dispense {
                ItemId = "1", GroupId = "85908", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 13, UnitPrice = 3, DispenseQuantity = 2, SubAmount = 6, StockBalance = 13, DateDispensed = new DateTime(2017, 07, 01, 18, 12, 02)
            };
            var aDispese5 = new Dispense {
                ItemId = "1", GroupId = "21550", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 10, UnitPrice = 3, DispenseQuantity = 3, SubAmount = 9, StockBalance = 10, DateDispensed = new DateTime(2017, 07, 01, 18, 16, 45), DispenseCompleted = "YES"
            };
            var aDispese6 = new Dispense {
                ItemId = "1", GroupId = "18689", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 8, UnitPrice = 5, DispenseQuantity = 2, SubAmount = 10, StockBalance = 8, DateDispensed = new DateTime(2017, 07, 01, 18, 28, 35)
            };
            var aDispese7 = new Dispense {
                ItemId = "1", GroupId = "71243", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 6, UnitPrice = 3, DispenseQuantity = 2, SubAmount = 6, StockBalance = 6, DateDispensed = new DateTime(2017, 07, 01, 18, 35, 20)
            };
            var aDispese8 = new Dispense {
                ItemId = "1", GroupId = "60611", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 5, UnitPrice = 5, DispenseQuantity = 1, SubAmount = 5, StockBalance = 5, DateDispensed = new DateTime(2017, 07, 01, 18, 39, 10), DispenseCompleted = "YES"
            };
            var aDispese9 = new Dispense {
                ItemId = "1", GroupId = "26130", GroupDate = new DateTime(2017, 07, 01), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 4, UnitPrice = 2, DispenseQuantity = 1, SubAmount = 2, StockBalance = 4, DateDispensed = new DateTime(2017, 07, 01, 20, 09, 37)
            };
            var aDispese10 = new Dispense {
                ItemId = "2", GroupId = "88108", GroupDate = new DateTime(2017, 07, 01), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 14, UnitPrice = 5, DispenseQuantity = 2, SubAmount = 10, StockBalance = 14, DateDispensed = new DateTime(2017, 07, 01, 20, 10, 18)
            };
            var aDispese11 = new Dispense {
                ItemId = "2", GroupId = "10657", GroupDate = new DateTime(2017, 07, 01), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 13, UnitPrice = 5, DispenseQuantity = 1, SubAmount = 5, StockBalance = 13, DateDispensed = new DateTime(2017, 07, 01, 20, 11, 28), DispenseCompleted = "YES"
            };
            var aDispese12 = new Dispense {
                ItemId = "2", GroupId = "21132", GroupDate = new DateTime(2017, 07, 02), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 3, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 3, DateDispensed = new DateTime(2017, 07, 02, 15, 21, 21), DispenseCompleted = "YES"
            };
            var aDispese13 = new Dispense {
                ItemId = "3", GroupId = "21132", GroupDate = new DateTime(2017, 07, 02), ItemName = "Felvin", StockLevel = 47, UnitPrice = 50, DispenseQuantity = 1, SubAmount = 50, StockBalance = 47, DateDispensed = new DateTime(2017, 07, 02, 15, 21, 21), DispenseCompleted = "YES"
            };
            var aDispese14 = new Dispense {
                ItemId = "3", GroupId = "4141", GroupDate = new DateTime(2017, 07, 02), ItemName = "Felvin", StockLevel = 46, UnitPrice = 50, DispenseQuantity = 1, SubAmount = 50, StockBalance = 46, DateDispensed = new DateTime(2017, 07, 02, 15, 25, 04), DispenseCompleted = "YES"
            };
            var aDispese15 = new Dispense {
                ItemId = "1", GroupId = "4141", GroupDate = new DateTime(2017, 07, 02), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 3, UnitPrice = 40, DispenseQuantity = 1, SubAmount = 40, StockBalance = 3, DateDispensed = new DateTime(2017, 07, 02, 15, 25, 04), DispenseCompleted = "YES"
            };
            var aDispese16 = new Dispense {
                ItemId = "3", GroupId = "42799", GroupDate = new DateTime(2017, 07, 11), ItemName = "Felvin", StockLevel = 43, UnitPrice = 55, DispenseQuantity = 1, SubAmount = 55, StockBalance = 43, DateDispensed = new DateTime(2017, 07, 11, 22, 07, 18)
            };
            var aDispese17 = new Dispense {
                ItemId = "3", GroupId = "60105", GroupDate = new DateTime(2017, 07, 11), ItemName = "Felvin", StockLevel = 42, UnitPrice = 55, DispenseQuantity = 1, SubAmount = 55, StockBalance = 42, DateDispensed = new DateTime(2017, 07, 11, 22, 27, 23), DispenseCompleted = "YES"
            };
            var aDispese18 = new Dispense {
                ItemId = "1", GroupId = "60105", GroupDate = new DateTime(2017, 07, 11), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 2, UnitPrice = 12, DispenseQuantity = 1, SubAmount = 12, StockBalance = 2, DateDispensed = new DateTime(2017, 07, 11, 22, 27, 23), DispenseCompleted = "YES"
            };
            var aDispese19 = new Dispense {
                ItemId = "3", GroupId = "26499", GroupDate = new DateTime(2017, 07, 11), ItemName = "Felvin", StockLevel = 41, UnitPrice = 55, DispenseQuantity = 1, SubAmount = 55, StockBalance = 41, DateDispensed = new DateTime(2017, 07, 11, 22, 37, 54)
            };
            var aDispese20 = new Dispense {
                ItemId = "1", GroupId = "26499", GroupDate = new DateTime(2017, 07, 11), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 1, UnitPrice = 12, DispenseQuantity = 1, SubAmount = 12, StockBalance = 1, DateDispensed = new DateTime(2017, 07, 11, 22, 37, 54)
            };
            var aDispese21 = new Dispense {
                ItemId = "3", GroupId = "71337", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 17, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 70, StockBalance = 17, DateDispensed = new DateTime(2017, 07, 16, 15, 48, 51)
            };
            var aDispese22 = new Dispense {
                ItemId = "3", GroupId = "37887", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 13, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 0, StockBalance = 0, DateDispensed = new DateTime(2017, 07, 16, 20, 17, 35)
            };
            var aDispese23 = new Dispense {
                ItemId = "3", GroupId = "66011", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 13, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 0, StockBalance = 12, DateDispensed = new DateTime(2017, 07, 16, 20, 52, 25)
            };
            var aDispese24 = new Dispense {
                ItemId = "3", GroupId = "60419", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 12, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 70, StockBalance = 11, DateDispensed = new DateTime(2017, 07, 16, 20, 54, 54), DispenseCompleted = "YES"
            };
            var aDispese25 = new Dispense {
                ItemId = "3", GroupId = "84483", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 11, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 70, StockBalance = 10, DateDispensed = new DateTime(2017, 07, 16, 21, 19, 07), DispenseCompleted = "YES"
            };
            var aDispese26 = new Dispense {
                ItemId = "2", GroupId = "84483", GroupDate = new DateTime(2017, 07, 16), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 8, UnitPrice = 58, DispenseQuantity = 2, SubAmount = 116, StockBalance = 6, DateDispensed = new DateTime(2017, 07, 16, 21, 19, 07), DispenseCompleted = "YES"
            };
            var aDispese27 = new Dispense {
                ItemId = "1", GroupId = "84483", GroupDate = new DateTime(2017, 07, 16), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 10, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 9, DateDispensed = new DateTime(2017, 07, 16, 21, 19, 07), DispenseCompleted = "YES"
            };
            var aDispese28 = new Dispense {
                ItemId = "1", GroupId = "84269", GroupDate = new DateTime(2017, 07, 16), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 9, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 8, DateDispensed = new DateTime(2017, 07, 16, 21, 35, 23), DispenseCompleted = "YES"
            };
            var aDispese29 = new Dispense {
                ItemId = "1", GroupId = "84269", GroupDate = new DateTime(2017, 07, 16), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 8, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 7, DateDispensed = new DateTime(2017, 07, 16, 21, 35, 23)
            };
            var aDispese30 = new Dispense {
                ItemId = "1", GroupId = "74996", GroupDate = new DateTime(2017, 07, 16), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 7, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 6, DateDispensed = new DateTime(2017, 07, 16, 21, 36, 32), DispenseCompleted = "YES"
            };
            var aDispese31 = new Dispense {
                ItemId = "2", GroupId = "74996", GroupDate = new DateTime(2017, 07, 16), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 7, UnitPrice = 58, DispenseQuantity = 1, SubAmount = 58, StockBalance = 6, DateDispensed = new DateTime(2017, 07, 16, 21, 36, 32), DispenseCompleted = "YES"
            };
            var aDispese32 = new Dispense {
                ItemId = "2", GroupId = "74996", GroupDate = new DateTime(2017, 07, 16), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 6, UnitPrice = 58, DispenseQuantity = 1, SubAmount = 58, StockBalance = 5, DateDispensed = new DateTime(2017, 07, 16, 21, 36, 32)
            };
            var aDispese33 = new Dispense {
                ItemId = "3", GroupId = "11913", GroupDate = new DateTime(2017, 07, 16), ItemName = "Felvin", StockLevel = 10, UnitPrice = 70, DispenseQuantity = 1, SubAmount = 70, StockBalance = 9, DateDispensed = new DateTime(2017, 07, 16, 21, 41, 06), DispenseCompleted = "YES"
            };
            var aDispese34 = new Dispense {
                ItemId = "2", GroupId = "11913", GroupDate = new DateTime(2017, 07, 16), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 5, UnitPrice = 58, DispenseQuantity = 1, SubAmount = 58, StockBalance = 4, DateDispensed = new DateTime(2017, 07, 16, 21, 41, 06), DispenseCompleted = "YES"
            };
            var aDispese35 = new Dispense {
                ItemId = "2", GroupId = "11913", GroupDate = new DateTime(2017, 07, 16), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 4, UnitPrice = 58, DispenseQuantity = 1, SubAmount = 58, StockBalance = 3, DateDispensed = new DateTime(2017, 07, 16, 21, 41, 06), DispenseCompleted = "YES"
            };
            var aDispese36 = new Dispense {
                ItemId = "1", GroupId = "11913", GroupDate = new DateTime(2017, 07, 16), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 6, UnitPrice = 10, DispenseQuantity = 1, SubAmount = 10, StockBalance = 5, DateDispensed = new DateTime(2017, 07, 16, 21, 41, 06), DispenseCompleted = "YES"
            };
            var aDispese37 = new Dispense {
                ItemId = "3", GroupId = "31610", GroupDate = new DateTime(2017, 07, 22), ItemName = "Felvin", StockLevel = 9, UnitPrice = 80, DispenseQuantity = 1, SubAmount = 80, StockBalance = 8, DateDispensed = new DateTime(2017, 07, 22, 11, 40, 06), DispenseCompleted = "YES"
            };
            var aDispese38 = new Dispense {
                ItemId = "2", GroupId = "31610", GroupDate = new DateTime(2017, 07, 22), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 2, UnitPrice = 60, DispenseQuantity = 2, SubAmount = 120, StockBalance = 0, DateDispensed = new DateTime(2017, 07, 22, 11, 40, 06), DispenseCompleted = "YES"
            };
            var aDispese39 = new Dispense {
                ItemId = "3", GroupId = "31610", GroupDate = new DateTime(2017, 07, 22), ItemName = "Felvin", StockLevel = 8, UnitPrice = 80, DispenseQuantity = 1, SubAmount = 80, StockBalance = 7, DateDispensed = new DateTime(2017, 07, 22, 11, 40, 06), DispenseCompleted = "YES"
            };
            var aDispese40 = new Dispense {
                ItemId = "2", GroupId = "2304", GroupDate = new DateTime(2017, 07, 22), ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 19, UnitPrice = 60, DispenseQuantity = 1, SubAmount = 60, StockBalance = 18, DateDispensed = new DateTime(2017, 07, 22, 20, 03, 00), DispenseCompleted = "YES"
            };
            var aDispese41 = new Dispense {
                ItemId = "1", GroupId = "2304", GroupDate = new DateTime(2017, 07, 22), ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 19, UnitPrice = 20, DispenseQuantity = 1, SubAmount = 20, StockBalance = 18, DateDispensed = new DateTime(2017, 07, 22, 20, 03, 00), DispenseCompleted = "YES"
            };
            var aDispese42 = new Dispense {
                ItemId = "3", GroupId = "2304", GroupDate = new DateTime(2017, 07, 22), ItemName = "Felvin", StockLevel = 19, UnitPrice = 80, DispenseQuantity = 1, SubAmount = 80, StockBalance = 18, DateDispensed = new DateTime(2017, 07, 22, 20, 03, 00), DispenseCompleted = "YES"
            };

            context.Dispenses.AddRange(new[] { aDispese1, aDispese2, aDispese3, aDispese4, aDispese5, aDispese6, aDispese7, aDispese8, aDispese9, aDispese10, aDispese11, aDispese12, aDispese13, aDispese14, aDispese15, aDispese16, aDispese17, aDispese18, aDispese19, aDispese20, aDispese21, aDispese22, aDispese23, aDispese24, aDispese25, aDispese26, aDispese27, aDispese28, aDispese29, aDispese30, aDispese31, aDispese32, aDispese33, aDispese34, aDispese35, aDispese36, aDispese37, aDispese38, aDispese39, aDispese40, aDispese41 });

            var stockUpdate1 = new StockUpdate {
                ItemId = "1", ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 21, QuantityAdded = 20, StockBalance = 21, UpdatedAt = new DateTime(2017, 7, 1, 17, 50, 14)
            };
            var stockUpdate2 = new StockUpdate {
                ItemId = "2", ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 20, QuantityAdded = 20, StockBalance = 20, UpdatedAt = new DateTime(2017, 7, 1, 20, 0, 21)
            };
            var stockUpdate3 = new StockUpdate {
                ItemId = "2", ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 20, QuantityAdded = 20, StockBalance = 20, UpdatedAt = new DateTime(2017, 7, 1, 20, 0, 21)
            };
            var stockUpdate4 = new StockUpdate {
                ItemId = "3", ItemCode = string.Empty, ItemName = "Felvin", StockLevel = 50, QuantityAdded = 50, StockBalance = 50, UpdatedAt = new DateTime(2017, 7, 2, 10, 59, 47)
            };
            var stockUpdate5 = new StockUpdate {
                ItemId = "2", ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 10, QuantityAdded = 10, StockBalance = 10, UpdatedAt = new DateTime(2017, 7, 11, 22, 39, 12)
            };
            var stockUpdate6 = new StockUpdate {
                ItemId = "1", ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 11, QuantityAdded = 10, StockBalance = 11, UpdatedAt = new DateTime(2017, 7, 11, 22, 48, 53)
            };
            var stockUpdate7 = new StockUpdate {
                ItemId = "1", ItemCode = "PARA-01", ItemName = "Paracetamol", StockLevel = 20, QuantityAdded = 14, StockBalance = 20, UpdatedAt = new DateTime(2017, 7, 22, 11, 41, 36)
            };
            var stockUpdate8 = new StockUpdate {
                ItemId = "2", ItemCode = "Asp01", ItemName = "Aspirin", StockLevel = 20, QuantityAdded = 18, StockBalance = 20, UpdatedAt = new DateTime(2017, 7, 22, 11, 41, 36)
            };
            var stockUpdate9 = new StockUpdate {
                ItemId = "3", ItemCode = string.Empty, ItemName = "Felvin", StockLevel = 20, QuantityAdded = 12, StockBalance = 20, UpdatedAt = new DateTime(2017, 7, 22, 11, 41, 36)
            };

            context.StockUpdates.AddRange(new[] { stockUpdate1, stockUpdate2, stockUpdate3, stockUpdate4, stockUpdate5, stockUpdate6, stockUpdate7, stockUpdate8, stockUpdate9 });

            var item1 = new Item {
                Code = "PARA-01", Name = "Paracetamol", Description = "500mg tablet", Manufacturer = "Emzor", MajorSupplier = "Emzor Distributor", PackQuantity = "10", PackDescription = "Sachet", AlternativeItem = "2", StandardIssueQuantity = "Aspirin", EconomicOrderQuantity = "100", PurchasePrice = 10, MarkupPercent = 0, SellingPrice = 20, StockLevel = 19, MinimumLevel = 40, ReOrderLevel = 500, MaximumLevel = 50, LeadDays = 3, CreatedAt = new DateTime(2017, 6, 26, 19, 49, 1), ModifiedAt = new DateTime(2017, 7, 22, 20, 3, 0)
            };
            var item2 = new Item {
                Code = "Asp01", Name = "Aspirin", Description = "300mg", Manufacturer = "Emzor", MajorSupplier = "Emzor Distributor", PackQuantity = "20", PackDescription = "Sachet", AlternativeItem = "2", StandardIssueQuantity = "Aspirin", EconomicOrderQuantity = "100", PurchasePrice = 55, MarkupPercent = 15, SellingPrice = 65, StockLevel = 19, MinimumLevel = 100, ReOrderLevel = 200, MaximumLevel = 2000, LeadDays = 3, CreatedAt = new DateTime(2017, 7, 1, 19, 57, 12), ModifiedAt = new DateTime(2017, 7, 22, 22, 03, 47)
            };
            var item3 = new Item {
                Code = "", Name = "Felvin", Description = "pain killer, 2mg", AlternativeName = "Piroxicam", MajorSupplier = "Nich", PackQuantity = "10", PackDescription = "Pack", StandardIssueQuantity = "Ricam", EconomicOrderQuantity = "5", PurchasePrice = 70, MarkupPercent = 0, SellingPrice = 80, StockLevel = 19, MinimumLevel = 10, ReOrderLevel = 5, MaximumLevel = 0, LeadDays = 1, CreatedAt = new DateTime(2017, 7, 2, 10, 43, 40), ModifiedAt = new DateTime(2017, 7, 22, 20, 3, 0)
            };

            context.Items.AddRange(new[] { item1, item2, item3 });

            var dis1 = new DispenseSummary {
                GroupId = "21550", GroupDate = new DateTime(2017, 07, 01), SubAmount = 9, Discount = 1, Vat = 5f, Total = 8, DateDispensed = new DateTime(2017, 07, 01, 18, 16, 45)
            };
            var dis2 = new DispenseSummary {
                GroupId = "60611", GroupDate = new DateTime(2017, 07, 01), SubAmount = 5, Discount = 2, Vat = 4.5f, Total = 3, DateDispensed = new DateTime(2017, 07, 01, 18, 39, 10)
            };
            var dis3 = new DispenseSummary {
                GroupId = "10657", GroupDate = new DateTime(2017, 07, 01), SubAmount = 5, Discount = 1, Vat = 5f, Total = 4, DateDispensed = new DateTime(2017, 07, 01, 20, 11, 28)
            };
            var dis4 = new DispenseSummary {
                GroupId = "21132", GroupDate = new DateTime(2017, 07, 02), SubAmount = 60, Discount = 10, Vat = 0f, Total = 50, DateDispensed = new DateTime(2017, 07, 02, 15, 21, 21)
            };
            var dis5 = new DispenseSummary {
                GroupId = "60105", GroupDate = new DateTime(2017, 07, 11), SubAmount = 67, Discount = 7, Vat = 0f, Total = 60, DateDispensed = new DateTime(2017, 07, 11, 22, 27, 23)
            };
            var dis6 = new DispenseSummary {
                GroupId = "60419", GroupDate = new DateTime(2017, 07, 16), SubAmount = 70, Discount = 0, Vat = 0f, Total = 70, DateDispensed = new DateTime(2017, 07, 16, 20, 54, 54)
            };
            var dis7 = new DispenseSummary {
                GroupId = "84269", GroupDate = new DateTime(2017, 07, 16), SubAmount = 10, Discount = 0, Vat = 0f, Total = 10, DateDispensed = new DateTime(2017, 07, 16, 21, 35, 23)
            };
            var dis8 = new DispenseSummary {
                GroupId = "74996", GroupDate = new DateTime(2017, 07, 16), SubAmount = 68, Discount = 0, Vat = 0f, Total = 68, DateDispensed = new DateTime(2017, 07, 16, 21, 36, 32)
            };
            var dis9 = new DispenseSummary {
                GroupId = "11913", GroupDate = new DateTime(2017, 07, 16), SubAmount = 196, Discount = 0, Vat = 0f, Total = 196, DateDispensed = new DateTime(2017, 07, 16, 21, 41, 06)
            };
            var dis10 = new DispenseSummary {
                GroupId = "31610", GroupDate = new DateTime(2017, 07, 22), SubAmount = 280, Discount = 50, Vat = 0f, Total = 230, DateDispensed = new DateTime(2017, 07, 22, 11, 40, 06)
            };
            var dis11 = new DispenseSummary {
                GroupId = "2304", GroupDate = new DateTime(2017, 07, 22), SubAmount = 160, Discount = 0, Vat = 0f, Total = 160, DateDispensed = new DateTime(2017, 07, 22, 20, 03, 00)
            };

            context.DispenseSummaries.AddRange(new[] { dis1, dis2, dis3, dis4, dis5, dis6, dis7, dis8, dis9, dis10, dis11 });

            base.Seed(context);
        }