private void btn_AddOrder_Click(object sender, EventArgs e)
{
bool check = InsertErrorManager.OrderChecker(txt_Customer.Text, comboBox_StoreNames.Text,
comboBox1.Text, dateTimePicker.Text, txt_Total.Text);
if (check == true)
{
MessageBox.Show("All field must be filled");
}
else
{
int total = Convert.ToInt32(txt_Total.Text);
string orderCode = DaoOrder.AddNewOrder(txt_Customer.Text, comboBox_StoreNames.Text,
comboBox1.Text, dateTimePicker.Text, total);
int count = datGridView_Items.Rows.Count - 1;
for (int i = 0; i < count; i++)
{
string name = datGridView_Items.Rows[i].Cells[0].Value.ToString();
string strquantity = datGridView_Items.Rows[i].Cells[1].Value.ToString();
string strprice = datGridView_Items.Rows[i].Cells[2].Value.ToString();
int quantity = Convert.ToInt32(strquantity);
int price = Convert.ToInt32(strprice);
DaoItems.AddItem(name, quantity, price, orderCode);
}
MessageBox.Show("Order Added, Order Code:" + orderCode);
}
}
private void AddItems_Click(object sender, EventArgs e)
{
using (FormItems newForm = new FormItems()
{
})
{
newForm.ShowDialog();
bool check = InsertErrorManager.AddItemsChecker(newForm.getItem().getName(), newForm.getItem().getQuantity());
if (check == true)
{
int errorPrice = newForm.getItem().getTotalprice();
if (errorPrice == 0)
{
MessageBox.Show("Item name entered invalid");
}
else
{
datGridView_Items.Rows.Add(newForm.getItem().getName(), newForm.getItem().getQuantity(), newForm.getItem().getTotalprice(),
"Delete");
int Total = datGridView_Items.Rows.Cast <DataGridViewRow>()
.Sum(t => Convert.ToInt32(t.Cells[2].Value));
txt_Total.Text = Total.ToString();
}
}
}
}
private void btn_fatturato_Click(object sender, EventArgs e)
{
if (InsertErrorManager.YearChecker(txt_sales.Text))
{
dataGridView.DataSource = DaoStatistics.SalesByYear(txt_sales.Text);
}
else
{
var txt = InsertErrorManager.YearAlert();
MessageBox.Show(txt.Item1, txt.Item2);
}
}
private void btn_search_Click(object sender, EventArgs e)
{
if (InsertErrorManager.CityChecker(txt_city.Text))
{
dataGridView.DataSource = DaoShops.ShopsByCity(txt_city.Text);
}
else
{
var txt = InsertErrorManager.CityAlert();
MessageBox.Show(txt.Item1, txt.Item2);
}
}
private void btn_search_Click(object sender, EventArgs e)
{
dataGridView_Items.ClearSelection();
if (InsertErrorManager.ItemChecker(txt_Item.Text))
{
dataGridView_Items.DataSource = DaoItems.Items(txt_Item.Text);
}
else
{
MessageBox.Show("Search field is empty!");
}
}
private void btn_add_Click(object sender, EventArgs e)
{
if (InsertErrorManager.AddItemsChecker(txt_Item.Text, (int)numericUpDown.Value))
{
item.setItem((string)txt_Item.Text);
item.setQuantity((int)numericUpDown.Value);
item.setTotalprice((string)txt_Item.Text, (int)numericUpDown.Value);
this.Close();
}
else
{
MessageBox.Show("All field must be filled up!");
}
}
private void Export_Click(object sender, EventArgs e)
{
string fileName = InsertErrorManager.FileNameChecker(txt_exp.Text);
TextWriter writer = new StreamWriter(@"C:\folder\" + fileName + ".csv");
for (int i = 0; i < dataGridView.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView.Columns.Count; j++)
{
writer.Write(dataGridView.Rows[i].Cells[j].Value.ToString() + "\t");
}
writer.WriteLine("");
}
writer.Close();
MessageBox.Show("Data Exported");
}
private void btn_ChangeOrder_Click(object sender, EventArgs e)
{
bool val = InsertErrorManager.OrderChecker(txt_Customer.Text, comboBox_StoreNames.Text,
comboBox1.Text, dateTimePicker.Text, txt_Total.Text);
if (val == false)
{
MessageBox.Show("All field must be filled");
}
else
{
int total = Convert.ToInt32(txt_Total.Text);
string orderCode = YourOrders.SetCode;
if (DaoOrder.UpdateOrder(txt_Customer.Text, comboBox_StoreNames.Text,
comboBox1.Text, dateTimePicker.Text, txt_OrderCode.Text))
{
DaoItems.DeleteItemsByCode(orderCode);
int count = datGridView_Items.Rows.Count - 1;
for (int i = 0; i < count; i++)
{
string name = datGridView_Items.Rows[i].Cells[0].Value.ToString();
string strquantity = datGridView_Items.Rows[i].Cells[1].Value.ToString();
string strprice = datGridView_Items.Rows[i].Cells[2].Value.ToString();
int quantity = Convert.ToInt32(strquantity);
int price = Convert.ToInt32(strprice);
DaoItems.AddItem(name, quantity, price, orderCode);
}
MessageBox.Show("Order Saved, Order Code:" + orderCode);
}
else
{
MessageBox.Show("Error during the update, try check customer id again");
}
}
}
