public String DisplayCompany()
{
String compN;
customers = new DAO.CustomersDAO();
customers.DisplayCmp(Custcode);
compN = customers.DisplayCmp(Custcode);
return(compN);
}
public bool Correct()
{
Boolean Korek;
customers = new DAO.CustomersDAO();
customers.correct(Custcode, Companyname);
Korek = customers.correct(Custcode, Companyname);
return(Korek);
}
public String DisplayCustomerCode()
{
String Custc;
customers = new DAO.CustomersDAO();
customers.DisplayCustC(Companyname);
Custc = customers.DisplayCustC(Companyname);
return(Custc);
}
public String[,] ReadAged() //New
{
customers = new DAO.CustomersDAO();
Int32 yyy = customers.countSummary();
String[,] xxx = new String[4, yyy];
xxx = customers.ReadSummary();
return(xxx);
}
public String[,] ReadCustomersPayment()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCount();
String[,] yyy = new String[5, count];
customers.ReadCustomerForPayment();
yyy = customers.ReadCustomerForPayment();
return(yyy);
}
public String[,] SearchReadCustomers()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCountSearch(Companyname);
String[,] xxx = new String[7, count];
customers.ReadCustomerSearch(Companyname);
xxx = customers.ReadCustomerSearch(Companyname);
return(xxx);
}
public String[,] ReadCustomers()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCount();
String[,] xxx = new String[7, count];
customers.ReadCustomer();
xxx = customers.ReadCustomer();
return(xxx);
}
public String[,] ReadCustomersFilts()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCountFilter(Balance);
String[,] xxx = new String[6, count];
customers.ReadCustomerFilter(Balance);
xxx = customers.ReadCustomerFilter(Balance);
return(xxx);
}
public void PayToSale()
{
Double init_amount = 0;
Double fin_amount = 0;
customers = new DAO.CustomersDAO();
init_amount = AmountPaid / 1.12;
fin_amount = init_amount * customers.askTax();
customers.PaymentToSales(Pos_orno, Pos_terminal, Custcode, Customer, Pos_user, fin_amount, Vatable, AmountPaid, AmountPaid);
}
public String[,] ReadPaymentsAll()
{
customers = new DAO.CustomersDAO();
Int32 c**t = customers.PositionCountCRMAll(Custcode);
String[,] zzz = new String[3, c**t];
customers.ReadCRMAll(Custcode);
zzz = customers.ReadCRMAll(Custcode);
return(zzz);
}
public String[,] ReadPaymentsDefualt()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCountCRM(Custcode, Today);
String[,] xxx = new String[3, count];
customers.ReadCRMToday(Custcode, Today);
xxx = customers.ReadCRMToday(Custcode, Today);
return(xxx);
}
public String[,] ReadPaymentsDateFilter()
{
customers = new DAO.CustomersDAO();
Int32 count = customers.PositionCountCRMFilter(Custcode, From, To);
String[,] yyy = new String[3, count];
customers.ReadCRMFilterDate(Custcode, From, To);
yyy = customers.ReadCRMFilterDate(Custcode, From, To);
return(yyy);
}
public void CreditToAccount()
{
customers = new DAO.CustomersDAO();
customers.CreditAccount(Balance, Payable, Custcode);
}
public void PingInterest()
{
customers = new DAO.CustomersDAO();
customers.PingIR(Balance, Custcode);
}
public void DeleteCustomers()
{
customers = new DAO.CustomersDAO();
customers.Delete(Custcode);
}
public void PayToSale()
{
customers = new DAO.CustomersDAO();
customers.PaymentToSales(Pos_orno, Pos_terminal, Custcode, Customer, Pos_user, AmountPaid, AmountPaid);
}
public String first()
{
customers = new DAO.CustomersDAO();
return(customers.fname());
}
public void DebitToAccount()
{
customers = new DAO.CustomersDAO();
customers.DebitAccount(Balance, AmountPaid, Custcode);
}
public void AddCustomers()
{
customers = new DAO.CustomersDAO();
customers.Add(Custcode, Companyname, Firstname, Middlename, Lastname, Email, Phone_no, Address, City, Province, Zip_code, Tin, Sss, Creditlimit, Netdays, Interest_rate);
}
public void UpdateCustomers()
{
customers = new DAO.CustomersDAO();
customers.Update(Custcode, Companyname, Firstname, Middlename, Lastname, Email, Phone_no, Address, City, Province, Zip_code, Tin, Sss, Creditlimit, Netdays, Is_suspended, Has_summary, Interest_rate, Due_date);
}
public String last()
{
customers = new DAO.CustomersDAO();
return(customers.lname());
}
public void UpdateCustomers()
{
customers = new DAO.CustomersDAO();
customers.Update(Custcode, Companyname, Firstname, Middlename, Lastname, Email, Phone_no, Address, City, Province, Zip_code);
}