private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (navigationPane1.SelectedPage == navigationPage1)
{
new AddMaker().Show();
ShowMaker();
}
else if (navigationPane1.SelectedPage == navigationPage2)
{
new AddProduct().Show();
dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct");
}
else if (navigationPane1.SelectedPage == navigationPage3)
{
new AddAssortment().Show();
dataGridView5.DataSource = DbConn.GetDataTable("ShowPrice");
}
else if (navigationPane1.SelectedPage == navigationPage4)
{
}
else if (navigationPane1.SelectedPage == navigationPage5)
{
}
else if (navigationPane1.SelectedPage == navigationPage6)
{
}
else if (navigationPane1.SelectedPage == navigationPage7)
{
}
else if (navigationPane1.SelectedPage == navigationPage8)
{
}
}
private void XtraForm2_Load(object sender, EventArgs e)
{
dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct");
dataGridView1.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView2.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView3.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
dataGridView4.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
dataGridView5.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
dataGridView6.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView7.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView8.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView9.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel);
dataGridView3.DataSource = DbConn.GetData($"SELECT * FROM Greasiness");
dataGridView4.DataSource = DbConn.GetData($"SELECT Packaging.Id, TypePackaging.Namee, VolumePackaging.Valuee " +
" FROM Packaging JOIN TypePackaging ON TypePackaging.ID = Packaging.TypePackagingID " +
"JOIN VolumePackaging ON VolumePackaging.ID = Packaging.VolumePackagingID ");
dataGridView5.DataSource = DbConn.GetDataTable("ShowPrice");
ShowMaker();
ShowCheckProduct();
ShowCheckUnique();
RefreshSearchForm();
ShowAllSale();
CreateChartMakerProduct__Sum();
CreateChartTypePackaging__Sum();
CreateChartDataAffiliate__Sum();
navigationPane1.Font = new Font("Arial", 24, GraphicsUnit.Pixel);
navigationPage1.Font = new Font("Arial", 24F, GraphicsUnit.Pixel);
//navigationPage1.Appearance.FontSizeDelta = 4;
//navigationPage2.Appearance.FontSizeDelta = 1;
//navigationPage3.Appearance.FontSizeDelta = 12;
//navigationPage4.Appearance.FontSizeDelta = -2;
}
private void simpleButton11_Click(object sender, EventArgs e)//add new TypeProduct
{
Task task = new Task(InsertTypeProduct);
task.Start();
task.Wait();
textBox7.Text = "";
dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct");
}
private void simpleButton9_Click(object sender, EventArgs e)
{
Task task = new Task(DeleteTypeProduct);
task.Start();
task.Wait();
textBox1.Text = "";
dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct");
}
public void ShowGroup()
{
try
{
string columns = "";
if (checkBox1.Checked)
{
columns += "TypeProduct.Namee, ";
}
if (checkBox2.Checked)
{
columns += "Maker.Namee, ";
}
if (checkBox3.Checked)
{
columns += "TypePackaging.Namee, ";
}
if (checkBox4.Checked)
{
columns += "VolumePackaging.valuee, ";
}
if (checkBox5.Checked)
{
columns += "Greasiness.Valuee, ";
}
if (!string.IsNullOrEmpty(columns) && !string.IsNullOrWhiteSpace(columns))
{
int index = columns.LastIndexOf(",");
columns = columns.Remove(index);
}
string from = "Maker JOIN PriceList ON Maker.Id=PriceList.MakerID JOIN TypeProduct ON TypeProduct.Id = PriceList.TypeProductID JOIN Packaging ON Packaging.Id = PriceList.PackagingID JOIN TypePackaging ON TypePackaging.Id = Packaging.TypePackagingID JOIN VolumePackaging ON VolumePackaging.Id = Packaging.VolumePackagingID JOIN Greasiness ON Greasiness.Id = PriceList.GreasinessID JOIN CheckProduct ON CheckProduct.PriceListID = PriceList.Id JOIN CheckUnique ON CheckUnique.Id = CheckProduct.CheckUniqueID JOIN Affiliate ON Affiliate.Id = CheckUnique.AffiliateID";
string query = $"SELECT {columns}, Sum(CheckProduct.Countt) as Count, SUM(PriceList.Price*CheckProduct.Countt) as Sum FROM {from} GROUP BY {columns}";
dataGridView9.DataSource = null;
dataGridView9.DataSource = DbConn.GetData(query);
}
catch
{
}
}
public void ShowMaker()
{
Thread.Sleep(1000);
dataGridView1.DataSource = DbConn.GetData($"SELECT * FROM Maker");
}