private void Quantity_Type_Load(object sender, EventArgs e)
{
dt = Dom_SqlClass.retriveData("Quantity", "", new string[] { "*" });
DataQty.DataSource = dt;
dom_Design.GenerateColumHeader(new string[] { "Quantity Type", "Quantity in Package" }, 2, DataQty);
DataQty.ClearSelection();
}
private void category_Load(object sender, EventArgs e)
{
dt = Dom_SqlClass.retriveData("Category", "", new string[] { "*" });
dataCat.DataSource = dt;
dom_Design.GenerateColumHeader(new string[] { "ID", "Category Name" }, 2, dataCat);
ID = Dom_SqlClass.GetIDFromDB("CatID", "Category");
Clear();
}
private void branch_Load(object sender, EventArgs e)
{
dt = Dom_SqlClass.retriveData("Brand", "", new string[] { "*" });
dataBrand.DataSource = dt;
dom_Design.GenerateColumHeader(new string[] { "ID", "Brand Name" }, 2, dataBrand);
ID = Dom_SqlClass.GetIDFromDB("BrandID", "Brand");
Clear();
}
private void supplyer_Load(object sender, EventArgs e)
{
dt = Dom_SqlClass.retriveData("Supplier", "", new string[] { "*" });
datasupplier.DataSource = dt;
dom_Design.GenerateColumHeader(new string[] { "ID", "Supplier Name", "Phone", "Email", "Address" }, 5, datasupplier);
dom_Design.ColumnName(datasupplier, 5, new string[] { "ID", "SupName", "Tel", "Email", "Address" });
ID = Dom_SqlClass.GetIDFromDB("SupID", "_", "Supplier");
ID = dom_Design.GenerateID(ID, "SP00_");
Clear();
}
private void LogIN_Load(object sender, EventArgs e)
{
dataCon.getRateAndDaysAlmostExp();
dt = Dom_SqlClass.retriveData("Employee join UserAcc on Employee.EmpID=UserAcc.EmpID", "", new string[] { "*" });
string fileDir = AppDomain.CurrentDomain.BaseDirectory + @"Image\Product\";
DirectoryInfo di = Directory.CreateDirectory(fileDir);
dataCon.getRateAndDaysAlmostExp();
}
private void LogIN_Load(object sender, EventArgs e)
{
dt = Dom_SqlClass.retriveData("Employee join UserAcc on Employee.EmpID=UserAcc.EmpID", "", new string[] { "*" });
}
private void QuantityImportType_Load(object sender, EventArgs e)
{
DT = Dom_SqlClass.retriveData("Quantity", "where 1=1", new string[] { "*" });
ReadDatafromDataTable(comboBox1, DT, Data);
}