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 Import_Load(object sender, EventArgs e)
{
DTProduct = Dom_SqlClass.retriveDataMultiTable(@"Select p.ProID,p.ProName from Product p;");
ReadDatafromDataTable(cmProductName, DTProduct, DataProName);
DTSupllier = Dom_SqlClass.retriveDataMultiTable(@"Select s.SupID,s.SupName from Supplier s;");
ReadDatafromDataTable(cmSupllierName, DTSupllier, DataSupName);
txtEmpl.Text = UserLoginDetail.fName + " " + UserLoginDetail.lName;
DTAllData = Dom_SqlClass.retriveDataMultiTable(@"Select i.ImportID as 'Import ID',i.ImportDate as 'Import Date',CONCAT(e.Fname,e.Lname) as 'Employee Name',s.SupName as 'Suppllier Name', p.ProName as 'Product Name',id.Qty as 'Quality',id.UnitPrice,id.SubTotal,i.Total from Import i join ImportDetail id on i.ImportID=id.ImportID join Supplier s on i.SupID=s.SupID join Employee e on i.ImportID=e.EmpID join Product p on id.ProID=p.ProID;");
dataImport.DataSource = DTAllData;
ID = Dom_SqlClass.GetIDFromDB("ImportID", "_", "Import");
ID = dom_Design.GenerateID(ID, "I00_");
LblID.Text = ID;
}