/// <summary>
/// remove the selected rows from the current visible table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void mB_Remove_Click(object sender, EventArgs e)
{
DialogResult a = new DialogResult();
using (DatabaseContext db = new DatabaseContext())
{
if ((List_Customer.Visible == true) && (List_Customer.SelectedItems.Count > 0))
{
customerBindingSource.Position = (List_Customer.SelectedItems[0].Index);
Customer del_customer = customerBindingSource.Current as Customer;
a = MetroMessageBox.Show(this, "Do really want to delete the customer " + List_Customer.SelectedItems[0].SubItems[1].Text, "Attantion", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (a == DialogResult.No)
{
return;
}
if (del_customer != null)
{
db.Entry <Customer>(del_customer).State = System.Data.Entity.EntityState.Deleted;
db.Set <Customer>().Remove(del_customer);
customerBindingSource.RemoveCurrent();
TabControl.RemoveRow(List_Customer);
}
db.SaveChanges();
}
else if ((List_Income.Visible == true) && (List_Income.SelectedItems.Count > 0))
{
incomeBindingSource.Position = (List_Income.SelectedItems[0].Index);
Income del_Income = incomeBindingSource.Current as Income;
a = MetroMessageBox.Show(this, "Do you really want to delete the selectet row?", "Attantion", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (a == DialogResult.No)
{
return;
}
if (del_Income != null)
{
db.Entry <Income>(del_Income).State = System.Data.Entity.EntityState.Deleted;
db.Set <Income>().Remove(del_Income);
incomeBindingSource.RemoveCurrent();
TabControl.RemoveRow(List_Income);
}
db.SaveChanges();
}
else if ((List_Expenses.Visible == true) && (List_Expenses.SelectedItems.Count > 0))
{
expensesBindingSource.Position = List_Expenses.SelectedItems[0].Index;
Expense del_Expenses = expensesBindingSource.Current as Expense;
a = MetroMessageBox.Show(this, "Do you really want to delete the selectet row?", "Attation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (a == DialogResult.No)
{
return;
}
if (del_Expenses != null)
{
db.Entry <Expense>(del_Expenses).State = System.Data.Entity.EntityState.Deleted;
db.Set <Expense>().Remove(del_Expenses);
expensesBindingSource.RemoveCurrent();
TabControl.RemoveRow(List_Expenses);
}
db.SaveChanges();
}
else if ((List_Produkts.Visible == true) && (List_Produkts.SelectedItems.Count > 0))
{
produktBindingSource.Position = List_Produkts.SelectedItems[0].Index;
Produkt del_Produkt = produktBindingSource.Current as Produkt;
a = MetroMessageBox.Show(this, "Do you really want to delete the selected row?", "Attation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (a == DialogResult.No)
{
return;
}
if (del_Produkt != null)
{
db.Entry <Produkt>(del_Produkt).State = System.Data.Entity.EntityState.Deleted;
db.Set <Produkt>().Remove(del_Produkt);
produktBindingSource.RemoveCurrent();
mlV_Products_Income.Items[produktBindingSource.Position + 1].Remove();
TabControl.RemoveRow(List_Produkts);
}
db.SaveChanges();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void mB_Save_Tables_Click(object sender, EventArgs e)
{
using (DatabaseContext db = new DatabaseContext())
{
if (mTC_Accounting.SelectedTab == mTP_Customer)
{
Customer obj_Customer = customerBindingSource.Current as Customer;
if (obj_Customer != null)
{
if (db.Entry <Customer>(obj_Customer).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Customer>().Attach(obj_Customer);
}
if (obj_Customer.ObjectState == 1)
{
db.Entry <Customer>(obj_Customer).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Customer.ObjectState == 2)
{
db.Entry <Customer>(obj_Customer).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Customer.Enabled = false;
obj_Customer.ObjectState = 0;
TabControl.AddCustomer(List_Customer, obj_Customer);
}
}
else if (mTC_Accounting.SelectedTab == mTP_Income)
{
Income obj_Income = incomeBindingSource.Current as Income;
if (obj_Income != null)
{
obj_Income.Customer = db.Customers.First(c => c.Id == obj_Income.Customer_Id);
foreach (var item in mlV_Products_Income.CheckedIndices)
{
string a = mlV_Products_Income.Items[Convert.ToInt32(item)].Text;
obj_Income.Products = obj_Income.Products + a;
}
if (db.Entry <Income>(obj_Income).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Income>().Attach(obj_Income);
}
if (obj_Income.ObjectState == 1)
{
db.Entry <Income>(obj_Income).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Income.ObjectState == 2)
{
db.Entry <Income>(obj_Income).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Income.Enabled = false;
obj_Income.ObjectState = 0;
TabControl.AddIncome(List_Income, obj_Income);
return;
}
}
else if (mTC_Accounting.SelectedTab == mTP_Expenses)
{
Expense obj_Expense = expensesBindingSource.Current as Expense;
if (obj_Expense != null)
{
if (db.Entry <Expense>(obj_Expense).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Expense>().Attach(obj_Expense);
}
if (obj_Expense.ObjectState == 1)
{
db.Entry <Expense>(obj_Expense).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Expense.ObjectState == 2)
{
db.Entry <Expense>(obj_Expense).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Expenses.Enabled = false;
obj_Expense.ObjectState = 0;
TabControl.AddExpenses(List_Expenses, obj_Expense);
return;
}
}
else if (mTC_Accounting.SelectedTab == mTP_Produkts)
{
Produkt obj_Produkt = produktBindingSource.Current as Produkt;
if (obj_Produkt != null)
{
obj_Produkt.Unit = mCB_Produkts_Unit.SelectedIndex;
if (db.Entry <Produkt>(obj_Produkt).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Produkt>().Attach(obj_Produkt);
}
if (obj_Produkt.ObjectState == 1)
{
db.Entry <Produkt>(obj_Produkt).State = System.Data.Entity.EntityState.Added;
}
if (obj_Produkt.ObjectState == 2)
{
db.Entry <Produkt>(obj_Produkt).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Produkts.Enabled = false;
obj_Produkt.ObjectState = 0;
TabControl.RefreshProdukt(List_Produkts, mlV_Products_Income);
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void mB_Save_Click(object sender, EventArgs e)
{
using (DatabaseContext db = new DatabaseContext())
{
if (mTC_Accounting.SelectedTab == mTP_Customer)
{
Customer obj_Customer = customerBindingSource.Current as Customer;
if (obj_Customer != null)
{
if (db.Entry <Customer>(obj_Customer).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Customer>().Attach(obj_Customer);
}
if (obj_Customer.ObjectState == 1)
{
db.Entry <Customer>(obj_Customer).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Customer.ObjectState == 2)
{
db.Entry <Customer>(obj_Customer).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Customer.Enabled = false;
obj_Customer.ObjectState = 0;
TabControl.RefreshCustomer(List_Customer);
}
}
else if (mTC_Accounting.SelectedTab == mTP_Income)
{
Income obj_Income = incomeBindingSource.Current as Income;
if (obj_Income != null)
{
try
{
obj_Income.Customer = db.Customers.First(c => c.Id == obj_Income.Customer_Id);
}
catch (Exception)
{
MetroMessageBox.Show(this, "Pleaser enter one Cutomer Name \n\r " + e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (mlV_Products_Income.CheckedItems.Count != 0)
{
foreach (var item in mlV_Products_Income.CheckedIndices)
{
string a = mlV_Products_Income.Items[Convert.ToInt32(item)].Text;
obj_Income.Products = obj_Income.Products + a + ", ";
}
}
else
{
obj_Income.Products = " ";
}
if (db.Entry <Income>(obj_Income).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Income>().Attach(obj_Income);
}
if (obj_Income.ObjectState == 1)
{
db.Entry <Income>(obj_Income).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Income.ObjectState == 2)
{
db.Entry <Income>(obj_Income).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Income.Enabled = false;
obj_Income.ObjectState = 0;
TabControl.RefreshIncome(List_Income);
return;
}
}
else if (mTC_Accounting.SelectedTab == mTP_Expenses)
{
Expense obj_Expense = expensesBindingSource.Current as Expense;
if (obj_Expense != null)
{
if (obj_Expense.Details == null)
{
obj_Expense.Details = "No Details ";
}
if (db.Entry <Expense>(obj_Expense).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Expense>().Attach(obj_Expense);
}
if (obj_Expense.ObjectState == 1)
{
db.Entry <Expense>(obj_Expense).State = System.Data.Entity.EntityState.Added;
}
else if (obj_Expense.ObjectState == 2)
{
db.Entry <Expense>(obj_Expense).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Expenses.Enabled = false;
obj_Expense.ObjectState = 0;
TabControl.RefreshExpenses(List_Expenses);
return;
}
}
else if (mTC_Accounting.SelectedTab == mTP_Produkts)
{
Produkt obj_Produkt = produktBindingSource.Current as Produkt;
if ((obj_Produkt.Unit < 0) && (obj_Produkt.Unit > obj_Produkt.Units.Count))
{
MetroMessageBox.Show(this, "Pleaser select one Unit\n\r " + e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (obj_Produkt != null)
{
obj_Produkt.Unit = mCB_Produkts_Unit.SelectedIndex;
if (db.Entry <Produkt>(obj_Produkt).State == System.Data.Entity.EntityState.Detached)
{
db.Set <Produkt>().Attach(obj_Produkt);
}
if (obj_Produkt.ObjectState == 1)
{
db.Entry <Produkt>(obj_Produkt).State = System.Data.Entity.EntityState.Added;
}
if (obj_Produkt.ObjectState == 2)
{
db.Entry <Produkt>(obj_Produkt).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
mP_Produkts.Enabled = false;
obj_Produkt.ObjectState = 0;
TabControl.RefreshProdukt(List_Produkts, mlV_Products_Income);
}
}
}
}
