void worker_DoWork(object sender, DoWorkEventArgs e)
{
dr = new autocomplete().getdatatable("select l_name,l_id from ledger where l_groupid = 3", "ledger");
dr1 = new autocomplete().getdatatable("select com_name , com_id,com_balstock,com_sp from [stock]", "[stock]");
pr = new purchasemodel().getpurchasereport();
por = new purchasemodel().getpurchaseorderreport();
vid = new purchasemodel().getvid();
f = new Fillcombo("u_sym", "uom");
orderid = new purchasemodel().getordervid();
}
void worker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
autocomplete a = new autocomplete(txtcustomer, list_customer, dr, "l_name", "l_id", layout);
txtcustomer.KeyUp += new KeyEventHandler(a.tkupid);
list_customer.MouseUp += new MouseButtonEventHandler(a.lmd);
list_customer.KeyDown += new KeyEventHandler(a.lkd);
txtcustomer.LostFocus += new RoutedEventHandler(a.tlf);
a.nameseleceted += new EventHandler(cusnameselected);
lst_report.ItemsSource = pr;
autocomplete b = new autocomplete(txtcomname, list_comname, dr1, "com_name", "com_id,com_balstock,com_sp", layout, "com_sp");
txtcomname.KeyUp += new KeyEventHandler(b.tkupcom);
list_comname.MouseUp += new MouseButtonEventHandler(b.lmd);
list_comname.KeyDown += new KeyEventHandler(b.lkd);
txtcomname.LostFocus += new RoutedEventHandler(b.tlf);
b.nameseleceted += new EventHandler(comnameselected);
listBox1.ItemsSource = pc;
datePicker1.SelectedDate = DateTime.Now;
// displayseting();
// txtvno.Text = vid.ToString();
txtorderno.Text = orderid.ToString();
f.fillcombo(cmb_uom);
invoicedetail = true;
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
//MessageBox.Show(application.l[0].Lname.ToString());
this.ca = (from a in application.tb where a.Lgroup == 1 || a.Lgroup == 14 select a).ToList();
this.lc = (from a in application.tb where a.Lgroup == 2 select a).ToList();
this.ls = (from a in application.tb where a.Lgroup == 3 select a).ToList();
this.li = (from a in application.tb where a.Lgroup == 15 select a).ToList();
this.le = (from a in application.tb where a.Lgroup == 12 select a).ToList();
ac = new autocomplete(txtac, lstname, lc, cashtrans);
txtac.KeyUp += new KeyEventHandler(ac.tkuplid);
lstname.MouseUp += new MouseButtonEventHandler(ac.lmd);
lstname.KeyDown += new KeyEventHandler(ac.lkd);
txtac.LostFocus += new RoutedEventHandler(ac.tlf);
ac.nameseleceted += new EventHandler(acnameselected);
autocomplete act = new autocomplete(txtacshac, lstcashac, ca, cashtrans);
txtacshac.KeyUp += new KeyEventHandler(act.tkuplid);
lstcashac.MouseUp += new MouseButtonEventHandler(act.lmd);
lstcashac.KeyDown += new KeyEventHandler(act.lkd);
txtacshac.LostFocus += new RoutedEventHandler(act.tlf);
act.nameseleceted += new EventHandler(cashacselected);
//date = dpcradate.Text.ToString();
//worker.RunWorkerAsync();
dpcradate.Text = DateTime.Now.Date.ToString();
dpcashfdate.Text = DateTime.Now.Date.ToString();
}
