public bool PrivateCustomerUpdate(int id, string name, string surname, string address, int zip, string phoneNo,
string altPhoneNo, string email)
{
var rdg = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
try
{
rdg.Update(new InterfaceAdaptor.PrivetCustomer()
{
Active = true,
AltPhoneNo = altPhoneNo,
Email = email,
HomeAddress = address,
Name = name,
PhoneNo = phoneNo,
PostNo = this.postNumbers.GetAtPostNumber(zip),
PrivateCustomersNo = id,
Surname = surname
});
}
catch (Exception)
{
return(false);
}
return(true);
}
private void FildPrivateCustomers(bool?activet)
{
this.privateCustomers.Clear();
var rdg = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
foreach (var item in rdg.Get(activet))
{
this.privateCustomers.Add(item);
}
}
public List <string> ListOfPrivateCustomers()
{
var list = new List <string>();
var rdg = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
foreach (var item in rdg.Get(true))
{
list.Add("#" + item.PrivateCustomersNo + " - " + item.Name + " " + item.Surname);
}
return(list);
}
public Interface.IprivetCustomer FindPrivateCustomer(int id)
{
var rdg = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
try
{
return(rdg.Find(id));
}
catch (Exception)
{
return(null);
}
}
public bool PrivateCustomersDelete(int id)
{
var rdg = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
try
{
rdg.Delete(id);
}
catch (Exception)
{
return(false);
}
this.privateCustomers.RemoveAtId(id);
return(true);
}
public DataTable GetInvoice()
{
var dataTable = new DataTable();
dataTable.Columns.Add("Faktura nr", typeof(string));
dataTable.Columns.Add("Kunde", typeof(string));
dataTable.Columns.Add("Ordrenr 1", typeof(string));
dataTable.Columns.Add("Ordrenr 2", typeof(string));
dataTable.Columns.Add("Ordrenr 3", typeof(string));
dataTable.Columns.Add("Ordrenr 4", typeof(string));
dataTable.Columns.Add("Ordrenr 5", typeof(string));
dataTable.Columns.Add("Ordrenr 6", typeof(string));
dataTable.Columns.Add("Ordrenr 7", typeof(string));
dataTable.Columns.Add("Ordrenr 8", typeof(string));
dataTable.Columns.Add("Ordrenr 9", typeof(string));
dataTable.Columns.Add("Ordrenr 10", typeof(string));
dataTable.Columns.Add("Ordrenr 11", typeof(string));
dataTable.Columns.Add("Ordrenr 12", typeof(string));
dataTable.Columns.Add("Ordrenr 13", typeof(string));
dataTable.Columns.Add("Ordrenr 14", typeof(string));
dataTable.Columns.Add("Ordrenr 15", typeof(string));
dataTable.Columns.Add("Ordrenr 16", typeof(string));
dataTable.Columns.Add("Ordrenr 17", typeof(string));
dataTable.Columns.Add("Ordrenr 18", typeof(string));
dataTable.Columns.Add("Ordernr 19", typeof(string));
dataTable.Columns.Add("Ordrenr 20", typeof(string));
var rdgCustomersC = new RDGs.RDGtblCompanyCustomers(this.session.ConnectionString);
var invoiceCompany = new RDGs.RDGtblInvoiceCompany(this.session.ConnectionString).Get(true);
foreach (var item in invoiceCompany)
{
var customers = rdgCustomersC.Find((int)item.Order[0]);
dataTable.Rows.Add(
"C-" + item.Id,
"#" + customers.CompanyCustomersNo + ": " + customers.Name,
item.Order[0].ToString(),
item.Order[1].ToString(),
item.Order[2].ToString(),
item.Order[3].ToString(),
item.Order[4].ToString(),
item.Order[5].ToString(),
item.Order[6].ToString(),
item.Order[7].ToString(),
item.Order[8].ToString(),
item.Order[9].ToString(),
item.Order[10].ToString(),
item.Order[11].ToString(),
item.Order[12].ToString(),
item.Order[13].ToString(),
item.Order[14].ToString(),
item.Order[15].ToString(),
item.Order[16].ToString(),
item.Order[17].ToString(),
item.Order[18].ToString(),
item.Order[19].ToString());
}
var rdgCustomersP = new RDGs.RDGtblPrivateCustomers(this.session.ConnectionString);
var invoicePrivet = new RDGs.RDGtblInvoicePrivet(this.session.ConnectionString).Get(true);
foreach (var item in invoicePrivet)
{
var customers = rdgCustomersP.Find((int)item.Order[0]);
dataTable.Rows.Add(
"P-" + item.Id,
"#" + customers.PrivateCustomersNo + ": " + customers.Name + " " + customers.Surname,
item.Order[0].ToString(),
item.Order[1].ToString(),
item.Order[2].ToString(),
item.Order[3].ToString(),
item.Order[4].ToString(),
item.Order[5].ToString(),
item.Order[6].ToString(),
item.Order[7].ToString(),
item.Order[8].ToString(),
item.Order[9].ToString(),
item.Order[10].ToString(),
item.Order[11].ToString(),
item.Order[12].ToString(),
item.Order[13].ToString(),
item.Order[14].ToString(),
item.Order[15].ToString(),
item.Order[16].ToString(),
item.Order[17].ToString(),
item.Order[18].ToString(),
item.Order[19].ToString());
}
return(dataTable);
}
