public MapsForm(int id, object orders, object services)
{
InitializeComponent();
//User label
userid = id;
setup(userid.ToString(), "FAFOS Day Itinerary");
//Tables
DataTable dt = new SalesOrder().getWorkOrders(userid);
workOrderTable.DataSource = dt;
DataTable dt2 = new ClientContract().getServices(userid.ToString());
servicesTable.DataSource = dt2;
order = (WorkOrder[])orders;
service = (ContractService[])services;
prefetch = true;
//Load the map
AsyncMapLoadCaller asyncMapLoad = new AsyncMapLoadCaller(LoadMap);
asyncMapLoad.BeginInvoke(new AsyncCallback(MapLoaded), null);
//LoadMap();
}
public InvoiceController()
{
sales_order = new SalesOrder();
order_items = new OrderItems();
item = new Item();
SAddress = new ServiceAddress();
client = new Client();
contract = new ClientContract();
franchisee = new Franchisee();
inventory = new Inventory();
}
public void Notifications()
{
DataTable dt2 = new ClientContract().getServices(userid.ToString());
serviceNotification.Text = "";
for (int i = 0; i < dt2.Rows.Count; i++)
{
if (Convert.ToDateTime(dt2.Rows[i][2]) == DateTime.Today)
{
String service = dt2.Rows[i][0].ToString();
serviceNotification.Text += "\n" + service + " needs to be completed by today ";
serviceNotification.Text += "location - " + dt2.Rows[i][5].ToString() + "\n";
}
}
if (serviceNotification.Text == "")
{
serviceNotification.Text = "";
}
DataTable dt = new Payment().getNotPaid(userid);
paymentNotification.Text = "";
for (int i = 2; i < dt.Rows.Count; i++)
{
if (Convert.ToDateTime(dt.Rows[i][2]) == DateTime.Today)
{
String name = new Client().getName(new ClientContract().getClient(new SalesOrder().getSAddress(new Invoice().getSalesOrderID(dt.Rows[i][0].ToString()).ToString())));
paymentNotification.Text += "\n" + name + " has an outstanding balance of ";
DataTable payments = new Payment().getAmount(dt.Rows[i][0].ToString());
double total = 0;
for (int j = 0; j < payments.Rows.Count; j++)
{
total += Convert.ToDouble(payments.Rows[j][2]);
}
paymentNotification.Text += "$" + String.Format("{0:0.00}", Math.Round(Convert.ToDouble(dt.Rows[i][3].ToString()) - total, 2))
+ " on invoice #" + dt.Rows[i][0].ToString() + "\n";
}
}
if (paymentNotification.Text == "")
{
paymentNotification.Text = "None";
}
}
public MapsForm(int id, object orders, object services)
{
InitializeComponent();
//User label
userid = id;
setup(userid.ToString(), "FAFOS Day Itinerary");
//Tables
DataTable dt = new SalesOrder().getWorkOrders(userid);
workOrderTable.DataSource = dt;
DataTable dt2 = new ClientContract().getServices(userid.ToString());
servicesTable.DataSource = dt2;
order = (WorkOrder[])orders;
service = (ContractService[])services;
prefetch = true;
//Load the map
AsyncMapLoadCaller asyncMapLoad = new AsyncMapLoadCaller(LoadMap);
asyncMapLoad.BeginInvoke(new AsyncCallback(MapLoaded), null);
//LoadMap();
}
public void Notifications()
{
DataTable dt2 = new ClientContract().getServices(userid.ToString());
serviceNotification.Text = "";
for (int i = 0; i < dt2.Rows.Count; i++)
{
if (Convert.ToDateTime(dt2.Rows[i][2]) == DateTime.Today)
{
String service = dt2.Rows[i][0].ToString();
serviceNotification.Text += "\n" + service + " needs to be completed by today ";
serviceNotification.Text += "location - " + dt2.Rows[i][5].ToString() + "\n";
}
}
if (serviceNotification.Text == "")
serviceNotification.Text = "";
DataTable dt = new Payment().getNotPaid(userid);
paymentNotification.Text = "";
for (int i = 2; i < dt.Rows.Count; i++)
{
if (Convert.ToDateTime(dt.Rows[i][2]) == DateTime.Today)
{
String name = new Client().getName(new ClientContract().getClient(new SalesOrder().getSAddress(new Invoice().getSalesOrderID(dt.Rows[i][0].ToString()).ToString())));
paymentNotification.Text += "\n"+name+" has an outstanding balance of ";
DataTable payments = new Payment().getAmount(dt.Rows[i][0].ToString());
double total=0;
for (int j = 0; j < payments.Rows.Count; j++)
{
total += Convert.ToDouble(payments.Rows[j][2]);
}
paymentNotification.Text += "$" +String.Format("{0:0.00}",Math.Round(Convert.ToDouble(dt.Rows[i][3].ToString()) - total,2))
+ " on invoice #" + dt.Rows[i][0].ToString()+"\n";
}
}
if (paymentNotification.Text == "")
paymentNotification.Text = "None";
}
