public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(ShopIDGV);
lb.Items.Add(ShopnameGV);
lb.Items.Add(VendorIDGV);
lb.Items.Add(VendorGV);
lb.Items.Add(BranchnameGV);
lb.Items.Add(ManagerIDGV);
lb.Items.Add(ManagerGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchSHOPS", shops_dataGridView, lb, ht);
}
else
{
LoadShops();
}
}
public void LoadPayments()
{
ListBox lb = new ListBox();
lb.Items.Add(paymentsIDGV);
lb.Items.Add(dateGV);
lb.Items.Add(salesinvoiceIDGV);
lb.Items.Add(userIDGV);
lb.Items.Add(userGV);
lb.Items.Add(billnoGV);
lb.Items.Add(customernameGV);
lb.Items.Add(customerIDGV);
lb.Items.Add(shopIDGV);
lb.Items.Add(shopGV);
lb.Items.Add(amountGV);
lb.Items.Add(ChequenoGV);
lb.Items.Add(bankGV);
lb.Items.Add(clearingdateGV);
SQL_TASKS.load_data("st_getPAYMENTS", payments_dataGridView, lb);
}
public void LoadSalesReturn()
{
ListBox lb = new ListBox();
lb.Items.Add(salesreturnIDGV);
lb.Items.Add(dateGV);
lb.Items.Add(salesinvoiceIDGV);
lb.Items.Add(userIDGV);
lb.Items.Add(userGV);
lb.Items.Add(billnoGV);
lb.Items.Add(customernameGV);
lb.Items.Add(customerIDGV);
lb.Items.Add(shopIDGV);
lb.Items.Add(shopGV);
lb.Items.Add(amountGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchSALESRETURN", salesreturn_dataGridView, lb, ht);
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(CustomerIDGV);
lb.Items.Add(CustomernameGV);
lb.Items.Add(CustomerphoneGV);
lb.Items.Add(ShopIDGV);
lb.Items.Add(CustomeremailGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchCUSTOMERS", customers_dataGridView, lb, ht);
}
else
{
LoadCustomers();
}
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(VendorIDGV);
lb.Items.Add(NameGV);
lb.Items.Add(PhoneGV);
lb.Items.Add(AddressGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchVENDORS", vendors_dataGridView, lb, ht);
}
else
{
LoadVendors();
}
}
public void LoadSalesInvoice()
{
ListBox lb = new ListBox();
lb.Items.Add(salesIDGV);
lb.Items.Add(shopIDGV);
lb.Items.Add(customerIDGV);
lb.Items.Add(detailsGV);
lb.Items.Add(amountGV);
lb.Items.Add(typeGV);
lb.Items.Add(userIDGV);
lb.Items.Add(billnoGV);
lb.Items.Add(statusGV);
lb.Items.Add(customernameGV);
lb.Items.Add(shopGV);
lb.Items.Add(userGV);
SQL_TASKS.load_data("st_getSALESINVOICE", salesinvoice_dataGridView, lb);
}
public void LoadRoles()
{
ListBox lb = new ListBox();
lb.Items.Add(RoleIDGV);
lb.Items.Add(RoleGV);
SQL_TASKS.load_data("st_getROLES", roles_dataGridView, lb);
}
void LoadVendors()
{
ListBox lb = new ListBox();
lb.Items.Add(VendorIDGV);
lb.Items.Add(NameGV);
lb.Items.Add(PhoneGV);
lb.Items.Add(AddressGV);
SQL_TASKS.load_data("st_getVENDORSdata", vendors_dataGridView, lb);
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(paymentsIDGV); //0
lb.Items.Add(dateGV); //1
lb.Items.Add(salesinvoiceIDGV); //2
lb.Items.Add(userIDGV); //3
lb.Items.Add(userGV); //4
lb.Items.Add(billnoGV); //5
lb.Items.Add(customernameGV); //6
lb.Items.Add(customerIDGV); //7
lb.Items.Add(shopIDGV); //8
lb.Items.Add(shopGV); //9
lb.Items.Add(amountGV); //10
lb.Items.Add(ChequenoGV); //11
lb.Items.Add(bankGV); //12
lb.Items.Add(clearingdateGV); //13
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchPAYMENTS", payments_dataGridView, lb, ht);
}
else
{
LoadPayments();
}
}
public void LoadCustomers()
{
ListBox lb = new ListBox();
lb.Items.Add(CustomerIDGV);
lb.Items.Add(CustomernameGV);
lb.Items.Add(CustomerphoneGV);
lb.Items.Add(ShopIDGV);
lb.Items.Add(ShopnameGV);
lb.Items.Add(CustomeremailGV);
SQL_TASKS.load_data("st_getCUSTOMERS", customers_dataGridView, lb);
}
void LoadShops()
{
ListBox lb = new ListBox();
lb.Items.Add(ShopIDGV); //0
lb.Items.Add(ShopnameGV); //1
lb.Items.Add(VendorIDGV); //2
lb.Items.Add(VendorGV); //3
lb.Items.Add(BranchnameGV); //4
lb.Items.Add(ManagerIDGV); //5
lb.Items.Add(ManagerGV); //6
SQL_TASKS.load_data("st_getSHOPS", shops_dataGridView, lb);
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(RoleIDGV);
lb.Items.Add(RoleGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchROLES", roles_dataGridView, lb, ht);
}
else
{
LoadRoles();
}
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(salesreturnIDGV);
lb.Items.Add(dateGV);
lb.Items.Add(salesinvoiceIDGV);
lb.Items.Add(userIDGV);
lb.Items.Add(userGV);
lb.Items.Add(billnoGV);
lb.Items.Add(customernameGV);
lb.Items.Add(customerIDGV);
lb.Items.Add(shopIDGV);
lb.Items.Add(shopGV);
lb.Items.Add(amountGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchSALESRETURN", salesreturn_dataGridView, lb, ht);
}
else
{
LoadSalesReturn();
}
}
public void LoadUsers()
{
ListBox lb = new ListBox();
lb.Items.Add(UserIDGV);
lb.Items.Add(NameGV);
lb.Items.Add(UsernameGV);
lb.Items.Add(PasswordGV);
lb.Items.Add(PhoneGV);
lb.Items.Add(AddressGV);
lb.Items.Add(RoleIDGV);
lb.Items.Add(RoleGV);
SQL_TASKS.load_data("st_getUSERS", users_dataGridView, lb);
}
public override void search_textBox_TextChanged(object sender, EventArgs e)
{
if (search_textBox.Text != "")
{
ListBox lb = new ListBox();
lb.Items.Add(salesIDGV);
lb.Items.Add(customerIDGV);
lb.Items.Add(customernameGV);
lb.Items.Add(shopIDGV);
lb.Items.Add(shopGV);
lb.Items.Add(detailsGV);
lb.Items.Add(amountGV);
lb.Items.Add(typeGV);
lb.Items.Add(userGV);
lb.Items.Add(userIDGV);
Hashtable ht = new Hashtable();
ht.Add("@data", search_textBox.Text);
SQL_TASKS.load_data("st_searchSALESINVOICE", salesinvoice_dataGridView, lb, ht);
}
else
{
LoadSalesInvoice();
}
}