public FieldCall(Guid fieldcallid, Dictionary fieldcallstatus, Employee employee, Contact contact, CustomerFacility customerfacility)
{
this.fieldcallid= fieldcallid;
this.fieldcallstatus= fieldcallstatus;
this.employee= employee;
this.contact= contact;
this.customerfacility= customerfacility;
}
public void BindData(CustomerFacility fac)
{
facility = fac;
this.lblName.Text = facility.Name;
this.lblRegion.Text = "Region: " + facility.Territory.Name;
this.lblUlica.Text = "Ulica: " + facility.Address.Street + " " + facility.Address.HouseNr + "/" + facility.Address.ApartmentNr;
this.lblKod.Text = "Kod: " + facility.Address.ZipCode;
this.lblKraj.Text = "Kraj: " + facility.Address.Country.Name;
this.lblMiasto.Text = "Miasto: " + facility.Address.City.Name;
}
public void BindData(CustomerFacility facility)
{
this.facility = facility;
if (facility != null)
{
this.ctrlCustomerFacility.BindData(facility);
this.ctrlCustomerFacility.ShowDetailsButton = false;
this.txtEmail.Text = facility.Email;
this.txtPhone.Text = facility.Phone;
}
}
public FieldCall(Guid fieldcallid, Dictionary fieldcallstatus, Employee employee, Contact contact, CustomerFacility customerfacility, string fulldescription, DateTime? date, DateTime? starttime, DateTime? endtime)
{
this.fieldcallid= fieldcallid;
this.fieldcallstatus= fieldcallstatus;
this.employee= employee;
this.contact= contact;
this.customerfacility= customerfacility;
this.fulldescription= fulldescription;
this.date= date;
this.starttime= starttime;
this.endtime= endtime;
}
private static CustomerFacility GetCustomerFacilityFromReader(IDataReader dataReader)
{
CustomerFacility customerFacility = new CustomerFacility();
customerFacility.CustomerFacilityID = DBHelper.GetGuid(dataReader, "CustomerFacilityID");
customerFacility.AddressID = DBHelper.GetGuid(dataReader, "AddressID");
customerFacility.TerritoryID = DBHelper.GetGuid(dataReader, "TerritoryID");
customerFacility.CustomerID = DBHelper.GetGuid(dataReader, "CustomerID");
customerFacility.Name = DBHelper.GetString(dataReader, "Name");
customerFacility.Email = DBHelper.GetString(dataReader, "Email");
customerFacility.Phone = DBHelper.GetString(dataReader, "Phone");
return customerFacility;
}
public Order(Guid orderid, CustomerFacility customerfacility, Territory territory, Employee employee, Dictionary orderstatus, string identifier, DateTime orderdate, decimal subtotal, decimal taxamount, decimal total)
{
this.orderid= orderid;
this.customerfacility= customerfacility;
this.territory= territory;
this.employee= employee;
this.orderstatus= orderstatus;
this.identifier= identifier;
this.orderdate= orderdate;
this.subtotal= subtotal;
this.taxamount= taxamount;
this.total= total;
}
public static IList<Order> GetOrders(CustomerFacility customerFacility)
{
if (customerFacility == null)
return GetOrders();
return OrderDB.GetOrders(customerFacility);
}
public static IList<Invoice> GetInvoices(CustomerFacility customerFacility)
{
if (customerFacility == null)
return GetInvoices();
return InvoiceDB.GetInvoices(customerFacility);
}
public static IList<Invoice> GetInvoices(CustomerFacility customerFacility)
{
string sqlQuery = "SELECT * FROM Invoice inv Join [Order] ord on inv.OrderID=ord.OrderID WHERE ord.CustomerFacilityID = '" + customerFacility.CustomerFacilityID + "'";
return GetInvoiceListFromQuery(sqlQuery);
}
public static IList<Order> GetOrders(CustomerFacility customerFacility)
{
string sqlQuery = "SELECT * FROM [Order] WHERE CustomerFacilityID = '" + customerFacility.CustomerFacilityID + "'";
return GetOrderListFromQuery(sqlQuery);
}
