示例#1
0
 public CustomerFacility(Guid customerfacilityid, Address address, Territory territory, Customer customer)
 {
     this.customerfacilityid= customerfacilityid;
     this.address= address;
     this.territory= territory;
     this.customer= customer;
 }
示例#2
0
 public void BindData(Guid customerID)
 {
     customer = CustomerManager.GetCustomerByID(customerID);
     if (customer != null)
     {
         this.Text = customer.Name + " - Szczegóły";
         this.txtName.Text = customer.Name;
         this.txtCode.Text = customer.Code;
         this.txtNIP.Text = customer.NIP;
         this.txtREGON.Text = customer.REGON;
         this.txtKRS.Text = customer.KRS;
         this.txtDesc.Text = customer.FullDescription;
         this.txtEmail.Text = customer.Email;
         this.txtPhone.Text = customer.Phone;
     }
 }
示例#3
0
        public static IList<Invoice> GetInvoices(Customer customer)
        {
            IList<CustomerFacility> facilities = CustomerFacilityDB.GetCustomerFacilities(customer.CustomerID, Guid.Empty);
            string sqlQuery = "SELECT * FROM Invoice inv Join [Order] ord on inv.OrderID=ord.OrderID WHERE ord.CustomerFacilityID IN ";
            StringBuilder INBuilder = new StringBuilder();
            INBuilder.Append("( ");
            for (int i = 0; i < facilities.Count; i++)
            {
                INBuilder.Append("'" + facilities[i].CustomerFacilityID + "',");
            }
            INBuilder.Remove(INBuilder.Length - 1, 1);
            INBuilder.Append(") ");
            sqlQuery += INBuilder.ToString();

            return GetInvoiceListFromQuery(sqlQuery);
        }
示例#4
0
 private static Customer GetCustomerFromReader(IDataReader dataReader)
 {
     Customer customer = new Customer();
     customer.CustomerID = DBHelper.GetGuid(dataReader, "CustomerID");
     customer.ContactID = DBHelper.GetGuid(dataReader, "ContactID");
     customer.FullDescription = DBHelper.GetString(dataReader, "FullDescription");
     customer.CustomerSince = DBHelper.GetNullableDateTime(dataReader, "CustomerSince");
     customer.CustomerTo = DBHelper.GetNullableDateTime(dataReader, "CustomerTo");
     customer.Code = DBHelper.GetString(dataReader, "Code");
     customer.Name = DBHelper.GetString(dataReader, "Name");
     customer.NIP = DBHelper.GetString(dataReader, "NIP");
     customer.KRS = DBHelper.GetString(dataReader, "KRS");
     customer.REGON = DBHelper.GetString(dataReader, "REGON");
     customer.Email = DBHelper.GetString(dataReader, "Email");
     customer.Phone = DBHelper.GetString(dataReader, "Phone");
     return customer;
 }
示例#5
0
 public static IList<Order> GetOrders(Customer customer)
 {
     if (customer == null)
         return GetOrders();
     return OrderDB.GetOrders(customer);
 }
示例#6
0
 public static IList<Invoice> GetInvoices(Customer customer)
 {
     if (customer == null)
         return GetInvoices();
     return InvoiceDB.GetInvoices(customer);
 }