private void button4_Click(object sender, EventArgs e) /// done button click
{
int mount = Convert.ToInt32(dl_exp_amouth.Text);
// save data to databse and show in gridview
// Display the selected date and time:
// Display today's date and time:
MessageBox.Show("Today is: " + DateTime.Today);
MessageBox.Show("nexr day is: " + DateTime.Today.AddDays(1));
string[] data = { dl_exp_type.Text, dl_exp_discription.Text, dl_exp_amouth.Text, dl_exp_today.Value.ToString() };
string msg = lgic.ins_expence(data);
MessageBox.Show(msg);
dl_exp_amouth.Text = "";
dl_exp_discription.Text = "";
addexpnc(dl_exp_type.Text, mount);
ds.Clear();
ds = lgic.get_tabl("expence");
dl_exp_datagrid.DataSource = ds.Tables[0];
dl_exp_type.Select();
}
private void sal_ad_done_Click(object sender, EventArgs e)
{
sal_ad_name.Select();
string[] at = { sal_ad_name.Text, sal_ad_invoicenmbr.Text, sal_ad_detail.Text,
sal_ad_total.Text, sal_ad_pay.Text, sal_ad_balance.Text,
sal_ad_status.Text, sal_datetoday.Value.ToString() };
string msg = lgic.invoicesale(at);
MessageBox.Show(msg);
ds = lgic.get_tabl("perchas");
sal_gridview.DataSource = ds.Tables[0];
count(ds);
sal_srch_sal_name.DataSource = lgic.combodata("perchas", "saller_name");
int index = sal_srch_sal_name.FindString(sal_ad_name.Text);
sal_srch_sal_name.SelectedIndex = index;
sal_ad_name.Text = "";
sal_ad_invoicenmbr.Text = "";
sal_ad_detail.Text = "";
sal_ad_total.Text = "0";
sal_ad_pay.Text = "0";
sal_ad_balance.Text = "0";
sal_ad_name.Select();
}
public Expences()
{
InitializeComponent();
lgic = new logic();
ds = lgic.get_tabl("expence");
dl_exp_datagrid.DataSource = ds.Tables[0];
}
public Monthlyexpence()
{
InitializeComponent();
lgic = new logic();
ds = lgic.get_tabl("account");
acc_grid.DataSource = ds.Tables[0];
}
private void button4_Click(object sender, EventArgs e) //done button
{
// here write function that save data
string[] at = { invn_ad_cst_name.Text, invn_ad_invoicenmbr.Text, inv1_ad_detail.Text,
invn_ad_total.Text, invn_ad_receive.Text, invn_ad_balance.Text,
invn_ad_status.Text, inv_datetoday.Value.ToString() };
string msg = lgic.invoicedata(at);
MessageBox.Show(msg);
ds = lgic.get_tabl("invoice");
invn_gridview.DataSource = ds.Tables[0];
count(ds);
invn_srch_cst_name.DataSource = lgic.combodata("invoice", "customer_name");
int index = invn_srch_cst_name.FindString(invn_ad_cst_name.Text);
invn_srch_cst_name.SelectedIndex = index;
inv1_ad_detail.Text = "";
invn_ad_invoicenmbr.Text = "";
invn_ad_receive.Text = "";
invn_ad_total.Text = "";
invn_ad_balance.Text = "";
invn_ad_cst_name.Select();
}
public Buyinvoices()
{
InitializeComponent();
lgic = new logic();
ds = lgic.get_tabl("perchas");
sal_gridview.DataSource = ds.Tables[0];
count(ds);
sal_ad_name.DataSource = lgic.combodata("perchas", "saller_name");
sal_srch_sal_name.DataSource = lgic.combodata("perchas", "saller_name");
}
public Invoices()
{
InitializeComponent();
lgic = new logic();
ds = lgic.get_tabl("invoice");
invn_gridview.DataSource = ds.Tables[0];
count(ds);
invn_ad_cst_name.DataSource = lgic.combodata("invoice", "customer_name");
invn_srch_cst_name.DataSource = lgic.combodata("invoice", "customer_name");
}
void refrash()
{
// get from invoice table
sal_totl = lgic.sumfun("total", "invoice");
sal_rec = lgic.sumfun("receive", "invoice");
Sal_blnc = lgic.sumfun("balance", "invoice");
// get sum from perchase table
pr_totl = lgic.sumfun("total", "perchas");
pr_pay = lgic.sumfun("pay", "perchas");
pr_blnc = lgic.sumfun("balance", "perchas");
// get from expence table
expnc = lgic.sumfun("expence", "expence");
addexpence(lgic.get_tabl("expence"));
putdata();
}
private void button3_Click(object sender, EventArgs e)
{
ds = lgic.get_tabl("account");
acc_grid.DataSource = ds.Tables[0];
}