Пример #1
0
        public DataTable GetDriverTable(string driverFullName)
        {
            DataTable newTable = GenerateEmptyDriverTable();

            using (var connection = new FridgeBussinessEntities2())
            {
                var driverTable =
                    from dd in connection.Driver
                    join ff in connection.Fridge on dd.PersonalCode equals ff.DeliveringDriverPersonalCode
                    select new
                {
                    driver    = dd.FirstName + " " + dd.LastName,
                    FridgeId  = ff.FridgeID,
                    cust      = ff.Customer,
                    until     = ff.DeliverUntil,
                    delivered = ff.DeliveredAt
                };
                foreach (var car in driverTable)
                {
                    if (car.driver.Equals(driverFullName) && car.delivered == null)
                    {
                        DataRow newRow = newTable.NewRow();
                        newRow["FridgeId"]     = car.FridgeId;
                        newRow["Client"]       = car.cust;
                        newRow["Address"]      = connection.Customer.Single(c => c.CustomerName == car.cust).Address;
                        newRow["DeliverUntil"] = car.until;
                        newTable.Rows.Add(newRow);
                    }
                }
            }
            return(newTable);
        }
Пример #2
0
        private void DriverForm_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (deliveredFridgesTodayIdList.Count > 0)
            {
                string line = "";
                using (var connection = new FridgeBussinessEntities2())
                {
                    foreach (int id in deliveredFridgesTodayIdList)
                    {
                        Fridge temp = new Fridge();
                        temp  = connection.Fridge.Single(f => f.FridgeID == id);
                        line += "Klientas: " + temp.Customer + " | Saldytuvo nr: " + temp.FridgeID + "\n";
                    }
                }

                DialogResult result = MessageBox.Show("Pakeitimai:\n" + line + "Issaugoti?", "Warning",
                                                      MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);
                if (result == DialogResult.Yes)
                {
                    using (var connection = new FridgeBussinessEntities2())
                    {
                        foreach (var fr in deliveredFridgesTodayIdList)
                        {
                            connection.Fridge.Single(f => f.FridgeID == fr).DeliveredAt = DateTime.Today;
                        }
                        connection.SaveChanges();
                    }
                }
                else if (result == DialogResult.Cancel)
                {
                    e.Cancel = true;
                }
            }
        }
Пример #3
0
 private void StartupForm_Load(object sender, EventArgs e)
 {
     using (var connection = new FridgeBussinessEntities2())
     {
         ChooseDriverBox.DataSource = connection.Driver.Select(d => d.FirstName + " " + d.LastName).ToList();
         ChooseClientBox.DataSource = connection.Customer.Select(d => d.CustomerName).ToList();
     }
 }
Пример #4
0
        private void DeleteFridgeButton_Click(object sender, EventArgs e)
        {
            int fridgeid = (int)FridgeGridView.CurrentRow.Cells[0].Value;

            using (var con = new FridgeBussinessEntities2())
            {
                con.Fridge.Remove(con.Fridge.FirstOrDefault(f => f.FridgeID == fridgeid));
                con.SaveChanges();
            }
            Form1_Load(this, e);
        }
        private int AverageDeliveriesPerDay()
        {
            int days;
            int fridges;

            using (var connection = new FridgeBussinessEntities2())
            {
                days    = connection.Fridge.Select(f => f.DeliveredAt).Distinct().Count();
                fridges = connection.Fridge.Count();
            }
            return(fridges / days);
        }
        private void tesstt(DataTable table)
        {
            using (var sms = new FridgeBussinessEntities2())
            {
                var fridges = sms.Fridge.AsQueryable().Where(c => c.Customer == currentClient);
                fridges = fridges.OrderBy(f => f.DeliveringDriverPersonalCode).ThenBy(f => f.DeliverUntil);


                foreach (var fr in fridges)
                {
                    label1.Text += "\n" +
                                   sms.Driver.First(d => d.PersonalCode == fr.DeliveringDriverPersonalCode).FirstName +
                                   " " + fr.DeliverUntil;
                }
                //var collection = sms.Fridge.AsQueryable().Where(c => c.Customer == currentClient).GroupBy(c=>c.DeliveringDriverPersonalCode);
            }
        }
        private TimeSpan AverageOrderToDeliveryTime()
        {
            TimeSpan total = new TimeSpan(0);
            int      counter;

            using (var connection = new FridgeBussinessEntities2())
            {
                Fridge[] fridges = connection.Fridge.ToArray();
                foreach (var fr in fridges.Where(f => f.DeliveredAt != null))
                {
                    TimeSpan span = fr.DeliverUntil.Value - fr.DeliveredAt.Value;
                    total += span + new TimeSpan(ClientForm.OrderToDeliverDayCount);
                }
                counter = connection.Fridge.Count(c => c.DeliveredAt != null);
            }
            return(new TimeSpan(total.Ticks / counter));
        }
Пример #8
0
        private void AddFridgeForm_Load(object sender, EventArgs e)
        {
            ManufactureDateYYBox.DataSource = Enumerable.Range(2006, DateTime.Now.Year - 2005).Reverse().ToList();
            ManufactureDateMMBox.DataSource = Enumerable.Range(1, 12).ToList();
            ManufactureDateDDBox.DataSource = Enumerable.Range(1, 31).ToList();

            DeliverYYBox.DataSource = Enumerable.Range(DateTime.Now.Year, 4).ToList();
            DeliverMMBox.DataSource = Enumerable.Range(1, 12).ToList();
            DeliverDDBox.DataSource = Enumerable.Range(1, 31).ToList();

            using (var temp = new FridgeBussinessEntities2())
            {
                CustomerBox.DataSource = temp.Customer.Select(c => c.CustomerName).ToList();
                DriverBox.DataSource   = temp.Driver.Select(d => d.FirstName + " " + d.LastName).ToList();
            }

            if (fridgeID == -1)
            {
                CustomerBox.SelectedIndex = -1;
                DriverBox.SelectedIndex   = -1;

                DeliverYYBox.SelectedIndex = -1;
                DeliverMMBox.SelectedIndex = -1;
                DeliverDDBox.SelectedIndex = -1;
            }
            else
            {
                Text         = "Edit Fridge";
                button1.Text = "Save edit";
                using (var conn = new FridgeBussinessEntities2())
                {
                    Fridge current = conn.Fridge.FirstOrDefault(c => c.FridgeID == fridgeID);
                    MassBox.Text   = current.Mass.ToString();
                    VolumeBox.Text = current.Volume.ToString();
                    ManufactureDateYYBox.SelectedItem = current.ManufacturedOn.Year;
                    ManufactureDateMMBox.SelectedItem = current.ManufacturedOn.Month;
                    ManufactureDateDDBox.SelectedItem = current.ManufacturedOn.Day;
                    CustomerBox.SelectedItem          = current.Customer;
                    DriverBox.SelectedItem            = (current.Driver != null) ? current.Driver.FirstName + " " + current.Driver.LastName : null;
                    DeliverYYBox.SelectedItem         = current.DeliverUntil.Value.Year;
                    DeliverMMBox.SelectedItem         = current.DeliverUntil.Value.Month;
                    DeliverDDBox.SelectedItem         = current.DeliverUntil.Value.Day;
                }
            }
        }
Пример #9
0
 private void SaveFridge(Fridge newFridge)
 {
     using (var conn = new FridgeBussinessEntities2())
     {
         if (fridgeID == -1)
         {
             conn.Fridge.Add(newFridge);
             conn.SaveChanges();
         }
         else
         {
             Fridge temp = conn.Fridge.FirstOrDefault(f => f.FridgeID == newFridge.FridgeID);
             conn.Fridge.Remove(temp);
             conn.Fridge.Add(newFridge);
             conn.SaveChanges();
         }
     }
 }
Пример #10
0
        private void transferBetweenTables(DataGridView tableView, DataTable test, DataTable table)
        {
            string currentFridgeId = tableView.CurrentRow.Cells["FridgeId"].Value.ToString();
            var    row             = test.AsEnumerable().Single(r => r["FridgeId"].ToString() == currentFridgeId);

            test.Rows.Remove(row);
            DataRow newRow = table.NewRow();

            using (var connenction = new FridgeBussinessEntities2())
            {
                Fridge current = connenction.Fridge.Single(f => f.FridgeID.ToString() == currentFridgeId);
                newRow["Volume"]         = current.Volume;
                newRow["Mass"]           = current.Mass;
                newRow["ManufacturedOn"] = current.ManufacturedOn;
                newRow["FridgeId"]       = currentFridgeId;
                table.Rows.Add(newRow);
            }
        }
Пример #11
0
 private Fridge CreateFridge(decimal volume, int mass)
 {
     using (var conn = new FridgeBussinessEntities2())
     {
         DateOperations dop = new DateOperations();
         return(new Fridge
         {
             FridgeID = fridgeID != -1 ? fridgeID : -1,
             Mass = mass,
             Volume = volume,
             ManufacturedOn =
                 dop.DateParsing(ManufactureDateYYBox.Text, ManufactureDateMMBox.Text, ManufactureDateDDBox.Text),
             Customer = conn.Customer.FirstOrDefault(c => c.CustomerName == CustomerBox.Text).CustomerName,
             DeliverUntil =
                 dop.DateParsing(DeliverYYBox.Text, DeliverMMBox.Text, DeliverDDBox.Text),
             DeliveringDriverPersonalCode =
                 conn.Driver.First(d => d.FirstName + " " + d.LastName == DriverBox.Text).PersonalCode,
             Driver = conn.Driver.First(d => d.FirstName + " " + d.LastName == DriverBox.Text)
         });
     }
 }
Пример #12
0
 private void PlaceOrderButton_Click(object sender, EventArgs e)
 {
     if (CartGridView.Rows.Count > 0)
     {
         using (var connection = new FridgeBussinessEntities2())
         {
             foreach (DataRow row in shoppingCartTable.Rows)
             {
                 if (!string.IsNullOrEmpty(row["FridgeId"].ToString()))
                 {
                     int    frid      = (int)row["FridgeId"];
                     Fridge toReplace = connection.Fridge.First(f => f.FridgeID == frid);
                     connection.Fridge.Remove(toReplace);
                     connection.SaveChanges();
                     toReplace.Customer     = currentClient;
                     toReplace.DeliverUntil = DateTime.Today.AddDays(OrderToDeliverDayCount);
                     connection.Fridge.Add(toReplace);
                 }
                 else
                 {
                     connection.Fridge.Add(new Fridge
                     {
                         Volume   = (decimal)row["Volume"],
                         Customer = currentClient
                     });
                 }
                 connection.SaveChanges();
             }
         }
         MessageBox.Show("Order successful");
         Close();
     }
     else
     {
         MessageBox.Show("The cart is empty");
     }
 }