Пример #1
0
 public void AddContact(Customers firm, Customers agent)
 {
     if (!db.Contacts.Any(c => c.firmID == firm.customerID && c.agentID == agent.customerID))
     {
         Contacts newContact = new Contacts()
         {
             agentID = agent.customerID,
             firmID = firm.customerID
         };
         db.Contacts.Add(newContact);
         db.SaveChanges();
     }
 }
Пример #2
0
        public static CustomerBaseRepresentation convertCustomer(Customers customer)
        {
            if (customer == null) return null;

            CustomerBaseRepresentation convertedCustomer;

            if (customer.isFirm)
                convertedCustomer = new FirmRepresentation();
            else
                convertedCustomer = new PersonRepresentation();

            // TODO: Implement concurency checking (rowVersion)
            convertedCustomer.id = customer.customerID;
            convertedCustomer.comment = customer.comment;
            convertedCustomer.customerAddress = customer.customerAddress;
            convertedCustomer.customerName = customer.customerName;
            convertedCustomer.customerPhone = customer.customerPhone;
            convertedCustomer.defaultDiscount = customer.defaultDiscount == null ? 0 : (customer.defaultDiscount ?? 0) / 100;
            convertedCustomer.IDNumber = customer.IDNumber;
            convertedCustomer.isDeleted = customer.isDeleted;
            convertedCustomer.isFirm = customer.isFirm;
            convertedCustomer.problems = customer.problems;
            convertedCustomer.rentCounter = customer.rentCounter;
            convertedCustomer.serviceCounter = customer.serviceCounter;
            if (customer.isFirm)
            {
                ((FirmRepresentation)convertedCustomer).contacts = new ObservableCollection<CustomerBaseRepresentation>();
                if (customer.Contacts != null)
                {
                    foreach (Contacts contact in customer.Contacts)
                    {
                        ((FirmRepresentation)convertedCustomer).contacts.Add(DataProxy.Instance.GetCustomerById(contact.agentID));
                    }
                }
            }
            else
            {
                ((PersonRepresentation)convertedCustomer).birthDate = customer.birthDate;
                ((PersonRepresentation)convertedCustomer).mothersName = customer.mothersName;
                ((PersonRepresentation)convertedCustomer).workplace = customer.workPlace;
            }

            if (customer.Cities != null)
            {
                convertedCustomer.city = convertCity(customer.Cities);
            }

            return convertedCustomer;
        }
Пример #3
0
        public TestDatabase()
        {
            Cities city01 = new Cities() { cityID = 1, city = "Dunaújváros", isDeleted = false, postalCode = "2400" };
            testCities.Add(city01);
            Cities city02 = new Cities() { cityID = 2, city = "Győr", isDeleted = false, postalCode = "1234" };
            testCities.Add(city02);
            Cities city03 = new Cities() { cityID = 3, city = "Balassagyarmat", isDeleted = false, postalCode = "5847" };
            testCities.Add(city03);

            Customers person01 = new Customers() { customerID = 1, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Teszt Béla Károly", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr" };
            testCustomers.Add(person01);
            Customers person02 = new Customers() { customerID = 2, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Gipsz Jakab", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr" };
            testCustomers.Add(person02);
            Customers person03 = new Customers() { customerID = 3, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Halocsekerentyű Leokádia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr" };
            testCustomers.Add(person03);
            Customers person04 = new Customers() { customerID = 4, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Vaszlavics Ilona", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr" };
            testCustomers.Add(person04);
            Customers person05 = new Customers() { customerID = 5, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Kotyogó Júlia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr" };
            testCustomers.Add(person05);

            Customers firm01 = new Customers() { customerID = 100, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Óvárosi Csavarbolt", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true,  serviceCounter = 0, rentCounter = 0 };
            testCustomers.Add(firm01);
            Customers firm02 = new Customers() { customerID = 101, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "ISD Dunaferr", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true, serviceCounter = 0, rentCounter = 0 };
            testCustomers.Add(firm02);
            Customers firm03 = new Customers() { customerID = 102, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Hankook", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true, serviceCounter = 0, rentCounter = 0 };
            testCustomers.Add(firm03);

            Contacts firm01contact01 = new Contacts() { contactID = 1, firmID = firm01.customerID, agentID = person02.customerID };
            testContacts.Add(firm01contact01);
            Contacts firm02contact01 = new Contacts() { contactID = 2, firmID = firm02.customerID, agentID = person01.customerID };
            testContacts.Add(firm02contact01);
            Contacts firm02contact02 = new Contacts() { contactID = 3, firmID = firm02.customerID, agentID = person04.customerID };
            testContacts.Add(firm02contact02);

            testDetailedCustomers.Add(new DetailedCustomers() { customerID = 5, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Kotyogó Júlia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr", city = "Dunaújváros", cityDeleted = false, customerDeleted = false, postalCode = "2400" });

            testDetailedCustomers.Add(new DetailedCustomers() { customerID = 102, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Hankook", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isFirm = true, serviceCounter = 0, rentCounter = 0, city = "Dunaújváros", cityDeleted = false, customerDeleted = false, postalCode = "2400" });
        }
Пример #4
0
 public Contacts GetContactByFirmAndAgent(Customers firm, Customers agent)
 {
     return db.Contacts.SingleOrDefault(c => c.firmID == firm.customerID && c.agentID == agent.customerID);
 }
Пример #5
0
 public void DeleteContact(Customers firm, Customers agent)
 {
     Contacts contactForDelete = db.Contacts.SingleOrDefault(c => c.firmID == firm.customerID && c.agentID == agent.customerID);
     if (contactForDelete != null)
     {
         db.Contacts.Remove(contactForDelete);
         db.SaveChanges();
     }
 }
Пример #6
0
 public Contacts GetContactByFirmAndAgent(Customers firm, Customers agent)
 {
     return(testContacts.SingleOrDefault(c => c.firmID == firm.customerID && c.agentID == agent.customerID));
 }
Пример #7
0
 public void UpdateCustomer(Customers customer)
 {
     testCustomers[testCustomers.FindIndex(c => c.customerID == customer.customerID)] = customer;
 }
Пример #8
0
        public TestDatabase()
        {
            Cities city01 = new Cities()
            {
                cityID = 1, city = "Dunaújváros", isDeleted = false, postalCode = "2400"
            };

            testCities.Add(city01);
            Cities city02 = new Cities()
            {
                cityID = 2, city = "Győr", isDeleted = false, postalCode = "1234"
            };

            testCities.Add(city02);
            Cities city03 = new Cities()
            {
                cityID = 3, city = "Balassagyarmat", isDeleted = false, postalCode = "5847"
            };

            testCities.Add(city03);

            Customers person01 = new Customers()
            {
                customerID = 1, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Teszt Béla Károly", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr"
            };

            testCustomers.Add(person01);
            Customers person02 = new Customers()
            {
                customerID = 2, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Gipsz Jakab", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr"
            };

            testCustomers.Add(person02);
            Customers person03 = new Customers()
            {
                customerID = 3, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Halocsekerentyű Leokádia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr"
            };

            testCustomers.Add(person03);
            Customers person04 = new Customers()
            {
                customerID = 4, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Vaszlavics Ilona", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr"
            };

            testCustomers.Add(person04);
            Customers person05 = new Customers()
            {
                customerID = 5, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Kotyogó Júlia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr"
            };

            testCustomers.Add(person05);

            Customers firm01 = new Customers()
            {
                customerID = 100, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Óvárosi Csavarbolt", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true, serviceCounter = 0, rentCounter = 0
            };

            testCustomers.Add(firm01);
            Customers firm02 = new Customers()
            {
                customerID = 101, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "ISD Dunaferr", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true, serviceCounter = 0, rentCounter = 0
            };

            testCustomers.Add(firm02);
            Customers firm03 = new Customers()
            {
                customerID = 102, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Hankook", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isDeleted = false, isFirm = true, serviceCounter = 0, rentCounter = 0
            };

            testCustomers.Add(firm03);

            Contacts firm01contact01 = new Contacts()
            {
                contactID = 1, firmID = firm01.customerID, agentID = person02.customerID
            };

            testContacts.Add(firm01contact01);
            Contacts firm02contact01 = new Contacts()
            {
                contactID = 2, firmID = firm02.customerID, agentID = person01.customerID
            };

            testContacts.Add(firm02contact01);
            Contacts firm02contact02 = new Contacts()
            {
                contactID = 3, firmID = firm02.customerID, agentID = person04.customerID
            };

            testContacts.Add(firm02contact02);

            testDetailedCustomers.Add(new DetailedCustomers()
            {
                customerID = 5, birthDate = new DateTime(1980, 3, 2), cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Kotyogó Júlia", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isFirm = false, mothersName = "Kovács Laura", serviceCounter = 0, rentCounter = 0, workPlace = "ISD Dunaferr", city = "Dunaújváros", cityDeleted = false, customerDeleted = false, postalCode = "2400"
            });

            testDetailedCustomers.Add(new DetailedCustomers()
            {
                customerID = 102, cityID = city01.cityID, customerAddress = "Almafa utca 32.", customerName = "Hankook", customerPhone = "+36/30/517-6289", IDNumber = "JD245874", isFirm = true, serviceCounter = 0, rentCounter = 0, city = "Dunaújváros", cityDeleted = false, customerDeleted = false, postalCode = "2400"
            });
        }
Пример #9
0
        public static Customers convertCustomer(CustomerBaseRepresentation customer)
        {
            // TODO: Implement concurency checking (rowVersion)
            var convertedCustomer = new Customers()
            {
                customerID = customer.id,
                comment = customer.comment,
                customerAddress = customer.customerAddress,
                customerName = customer.customerName,
                customerPhone = customer.customerPhone,
                defaultDiscount = customer.defaultDiscount * 100,
                IDNumber = customer.IDNumber,
                isDeleted = customer.isDeleted,
                isFirm = customer.isFirm,
                problems = customer.problems,
                rentCounter = customer.rentCounter,
                serviceCounter = customer.serviceCounter
            };

            if (customer.GetType() == typeof(PersonRepresentation))
            {
                convertedCustomer.birthDate = ((PersonRepresentation)customer).birthDate;
                convertedCustomer.mothersName = ((PersonRepresentation)customer).mothersName;
                convertedCustomer.workPlace = ((PersonRepresentation)customer).workplace;
            }

            if (customer.city != null)
            {
                convertedCustomer.cityID = customer.city.id;
            }

            return convertedCustomer;
        }
Пример #10
0
 public void DeleteContact(Customers firm, Customers agent)
 {
     Contacts contactToDelete = GetContactByFirmAndAgent(firm, agent);
     if (contactToDelete != null)
     {
         testContacts.Remove(contactToDelete);
     }
 }
Пример #11
0
 public long AddCustomer(Customers customer)
 {
     testCustomers.Add(customer);
     return customer.customerID;
 }
Пример #12
0
 public void AddContact(Customers firm, Customers agent)
 {
     long maxID = testContacts.Max(c => c.contactID);
     testContacts.Add(new Contacts() { contactID = maxID + 1, firmID = firm.customerID, agentID = agent.customerID });
 }
Пример #13
0
 public void UpdateCustomer(Customers customer)
 {
     testCustomers[testCustomers.FindIndex(c => c.customerID == customer.customerID)] = customer;
 }
Пример #14
0
 public List<Customers> GetContacts(Customers firm)
 {
     List<long> agentIDList = testContacts.Where(c => c.firmID == firm.customerID).Select(co => co.agentID).ToList();
     return testCustomers.Where(c => agentIDList.Contains(c.customerID)).ToList();
 }
Пример #15
0
        void acceptGroupExecute()
        {
            Customers c = new Customers();
            ServiceGroups sg = new ServiceGroups();
            long cIDTemp;

            cIDTemp = newWorksheets[0].customerID;
            //c = SQLConnection.Execute.CustomersTable.Single(cust => cust.customerID == cIDTemp);
            c.serviceCounter += 1;

            sg.deposit = deposit;
            //SQLConnection.Execute.ServiceGroupsTable.AddObject(sg);
            //db.SaveChanges();
            foreach (ServiceWorksheets item in newWorksheets)
            {
                item.groupID = sg.serviceGroupID;
                //SQLConnection.Execute.ServiceWorksheetsTable.AddObject(item);
            }
            SQLConnection.Execute.SaveDb();
            foreach (ServiceWorksheets item in newWorksheets)
            {
                new Print.printService(item, Print.servicePrintType.bringIn);
            }
            AppMessages.ServiceGroupClosed.Send(newWorksheets);
        }
Пример #16
0
 public List<Customers> GetContacts(Customers firm)
 {
     return db.Customers.Where(c => c.Contacts1.Any(ca => ca.firmID == firm.customerID)).ToList();
 }
Пример #17
0
 public void UpdateCustomer(Customers customer)
 {
     Customers customerToUpdate = db.Customers.SingleOrDefault(c => c.customerID == customer.customerID);
     // TODO: Implement
     //if (customerToUpdate.rowVersion != customer.rowVersion)
     //{
     //    throw new Exception("Customer modification conflicted");
     //}
     customerToUpdate.birthDate = customer.birthDate;
     customerToUpdate.cityID = customer.cityID;
     customerToUpdate.comment = customer.comment;
     customerToUpdate.customerAddress = customer.customerAddress;
     customerToUpdate.customerName = customer.customerName;
     customerToUpdate.customerPhone = customer.customerPhone;
     customerToUpdate.defaultDiscount = customer.defaultDiscount;
     customerToUpdate.IDNumber = customer.IDNumber;
     customerToUpdate.isDeleted = customer.isDeleted;
     customerToUpdate.isFirm = customer.isFirm;
     customerToUpdate.mothersName = customer.mothersName;
     customerToUpdate.problems = customer.problems;
     customerToUpdate.rentCounter = customer.rentCounter;
     customerToUpdate.serviceCounter = customer.serviceCounter;
     customerToUpdate.workPlace = customer.workPlace;
     db.SaveChanges();
 }
Пример #18
0
 public long AddCustomer(Customers customer)
 {
     testCustomers.Add(customer);
     return(customer.customerID);
 }
Пример #19
0
 public long AddCustomer(Customers customer)
 {
     db.Customers.Add(customer);
     db.SaveChanges();
     return customer.customerID;
 }
Пример #20
0
        public List <Customers> GetContacts(Customers firm)
        {
            List <long> agentIDList = testContacts.Where(c => c.firmID == firm.customerID).Select(co => co.agentID).ToList();

            return(testCustomers.Where(c => agentIDList.Contains(c.customerID)).ToList());
        }