private void cboCateg_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCateg.Text == "ID")
{
sql = "SELECT USER_ID FROM useraccounts";
config.autocomplete(sql, txtseaarch);
}
else if (cboCateg.Text == "NAME")
{
sql = "SELECT UNAME FROM useraccounts";
config.autocomplete(sql, txtseaarch);
}
}
private void frmStockOut_Load(object sender, EventArgs e)
{
sql = "SELECT SUPLIERCUSTOMERID FROM tblperson WHERE TYPE = 'CUSTOMER'";
config.autocomplete(sql, txt_cusid);
sql = "SELECT `ITEMID` as 'Id Producto', `NAME` as 'Nombre', `DESCRIPTION` as 'Descripcion', `PRICE` as 'Precio', `QTY` as 'Cantidad Disponible' FROM `tblitems`";
config.Load_DTG(sql, dtgCus_itemlist);
funct.ResponsiveDtg(dtgCus_itemlist);
}
private void frmStockOut_Load(object sender, EventArgs e)
{
sql = "SELECT SUPLIERCUSTOMERID FROM tblperson WHERE TYPE = 'CUSTOMER'";
config.autocomplete(sql, txt_cusid);
sql = "SELECT `ITEMID` as 'Item Id', `NAME` as 'Name', `DESCRIPTION` as 'Description', `PRICE` as 'Price', `QTY` as 'Available Quantity' FROM `tblitems`";
config.Load_DTG(sql, dtgCus_itemlist);
funct.ResponsiveDtg(dtgCus_itemlist);
}
private void frmEnrollStudents_Load(object sender, EventArgs e)
{
sql = "SELECT CONCAT( `LNAME`,', ', `FNAME`,' ', `MNAME`) FROM `tblstudent`";
config.autocomplete(sql, txtsearch);
sql = "SELECT `IDNO`, CONCAT( `LNAME`,', ', `FNAME`,' ', `MNAME`) as 'FULL NAME' FROM `tblstudent`";
config.Load_DTG(sql, dtgList);
dtgList.Font = new Font("Arial", 9);
}
private void frmListScannedFiles_Load(object sender, EventArgs e)
{
sql = "SELECT ScannedId,EMPLOYEE_ID, concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) as 'Employees Name', `IMGCaption` as 'FilesName', `ImgType` as 'FilesType', `DateUpload` as 'DateUploaded' " +
" FROM `tblscannedfiles` s, `employees` e WHERE `EMPLOYEE_ID` = `EmpId` AND concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) Like '%" + txtSearch.Text + "%'";
config.Load_DTG(sql, dtglist);
dtglist.Columns[0].Visible = false;
dtglist.Columns[1].Visible = false;
sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`";
config.autocomplete(sql, txtSearch);
//sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`"
//append(sql, txtSearch)
}
private void frmReturn_Load(object sender, EventArgs e)
{
sql = "SELECT `TRANSACTIONNUMBER` FROM `tblstock_in_out` WHERE `REMARKS`='Stockout'";
config.autocomplete(sql, txttransactionid);
}
private void frmReports_Load(object sender, EventArgs e)
{
sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`";
config.autocomplete(sql, TextBox1);
}