protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
accumulation = db.Accumulation.FirstOrDefault(a => a.Id == id);
curObjForCurAbrevv = db.Currency.FirstOrDefault(c => c.Id == accumulation.CurrencyId);
purseCollection = new ObservableCollection <Purse>(db.Purse.Where(p => p.CurrencyId == accumulation.CurrencyId).ToList());
}
}
if (accumulation != null)
{
if (purseCollection.Count == 0)
{
errorText.Text = "Нет доступных счетов";
}
else
{
purseListCB.ItemsSource = purseCollection;
}
curAbbrev.Text = curObjForCurAbrevv.Abbreviation;
}
else
{
GoToPreviousPage();
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
displacement = db.Displacement.FirstOrDefault(d => d.Id == id);
}
}
if (displacement != null)
{
Displacement d;
headerBlock.Text = "Редактировать перемещение";
summaDispl.Text = displacement.SummaOut.ToString();
dateDispl.Date = Convert.ToDateTime(displacement.DateOperation);
rate1.Text = displacement.RateCur1.ToString();
rate2.Text = displacement.RateCur2.ToString();
// comboBox
using (PFContext db = new PFContext())
{
displacementCollection = new ObservableCollection <Displacement>(db.Displacement.Include(x => x.Currency));
d = displacementCollection.FirstOrDefault(x => x.Id == id);
purseSealed1 = db.Purse.FirstOrDefault(p => p.Id == d.PurseId1);
purseSealed2 = db.Purse.FirstOrDefault(p => p.Id == d.PurseId2);
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
income = db.Income.FirstOrDefault(i => i.Id == id);
}
}
if (income != null)
{
Income i;
headerBlock.Text = "Редактировать доход";
incomeSum.Text = income.Summa.ToString();
dateIncome.Date = Convert.ToDateTime(income.DateOperation);
incomeComment.Text = income.Comment;
// ComboBox
using (PFContext db = new PFContext())
{
incomeCollection = new ObservableCollection <Income>(db.Income.Include(x => x.Purse)
.Include(y => y.SourceOfIncome).ToList());
i = incomeCollection.FirstOrDefault(x => x.Id == id);
purseSealed = i.Purse;
sourceOfIncomeSealed = i.SourceOfIncome;
}
}
else
{
dateIncome.Date = DateTime.Today;
}
}
// Add CostCategories
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
if (nameCostCategories.Text.Length == 0)
{
errorText.Text = "Введите название";
return;
}
using (PFContext db = new PFContext())
{
if (costCategor != null)
{
costCategor.Name = nameCostCategories.Text;
db.CostCategories.Update(costCategor);
}
else
{
CostCategories costCategorNew = new CostCategories
{
Name = nameCostCategories.Text
};
db.CostCategories.Add(costCategorNew);
}
db.SaveChanges();
}
GoToPreviousPage();
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
purse = db.Purse.FirstOrDefault(c => c.Id == id);
}
}
if (purse != null)
{
Purse p;
headerBlock.Text = "Редактировать счет";
purseNameBox.Text = purse.Name;
purseBalanceBox.Text = purse.Balance.ToString();
using (PFContext db = new PFContext())
{
purseCollection = new ObservableCollection <Purse>(db.Purse.Include(x => x.Currency).ToList());
p = purseCollection.FirstOrDefault(x => x.Id == id);
curSealed = p.Currency;
}
}
}
private void DeleteAccumulationItem(Accumulation a)
{
using (PFContext db = new PFContext())
{
try
{
foreach (AccumulationOperation ao in db.AccumulationOperation)
{
if (ao.AccumulationId == a.Id)
{
db.AccumulationOperation.Remove(ao);
}
}
db.Accumulation.Remove(a);
db.SaveChanges();
accumulationCollection = new ObservableCollection <Accumulation>(db.Accumulation
.Include(x => x.Currency).ToList());
accumulationList.ItemsSource = accumulationCollection;
}
catch
{
errorText.Text = "Не возможно удалить цель. Попробуйте позже.";
}
}
}
private void ReportPage_Loaded(object sender, RoutedEventArgs e)
{
// для того, что-бы выбиралось из comboBox в flyoutMenu
if (Windows.Foundation.Metadata.ApiInformation
.IsPropertyPresent("Windows.UI.Xaml.FrameworkElement", "AllowFocusOnInteraction"))
{
purseListCB.AllowFocusOnInteraction = true;
costsCategoriesCB.AllowFocusOnInteraction = true;
}
using (PFContext db = new PFContext())
{
purseCollection = new ObservableCollection <Purse>(db.Purse.ToList());
costsCategoriesCollection = new ObservableCollection <CostCategories>(db.CostCategories.ToList());
costsCollection = new ObservableCollection <Costs>(db.Costs.Include(x => x.CostCategories)
.Include(x => x.Purse).Include(x => x.Currency).ToList());
}
purseListCB.ItemsSource = purseCollection;
costsCategoriesCB.ItemsSource = costsCategoriesCollection;
amountSumma.Text = "Сумма расходов: " + GetTotalAmount(costsCollection).ToString() + " BYN";
ChangeCollectionForDiagramm(costsCollection);
if (!SortCostCollection(costsCollection))
{
costList.ItemsSource = costsCollection;
}
isAllPurse.IsChecked = true;
isAllCostsCategories.IsChecked = true;
isAllDate.IsChecked = true;
}
private void bDeletar_Click(object sender, EventArgs e)
{
PFContext context = new PFContext();
int indice = this.dataGridView1.CurrentRow.Index;
DataGridViewRow rowData = dataGridView1.Rows[indice];
String aux = rowData.Cells[5].Value.ToString().Trim();
int clienteIdAux = Convert.ToInt32(aux);
Cliente pf = context.PessoaFisicas.Single(x => x.ClienteID == clienteIdAux);
string message = "Deseja realmente remover este Cliente?";
string caption = "Error";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
context.PessoaFisicas.Attach(pf);
context.PessoaFisicas.Remove(pf);
context.SaveChanges();
MessageBox.Show("Cliente removido com sucesso.", "Alerta");
this.PreencheGrid();
}
}
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
string value = ConvertToStringFormat(rateBox.Text);
double finalRate;
if (!Double.TryParse(ConvertToStringFormat(value), out finalRate))
{
errorText.Text = "Некоректный курс";
return;
}
if (finalRate <= 0)
{
errorText.Text = "Некоректный курс";
return;
}
using (PFContext db = new PFContext())
{
currency.Rate = finalRate;
db.Currency.Update(currency);
db.SaveChanges();
}
GoToPreviousPage();
}
private void ReportCostsIncomesPage_Loaded(object sender, RoutedEventArgs e)
{
// для того, что-бы выбиралось из comboBox в flyoutMenu
if (Windows.Foundation.Metadata.ApiInformation
.IsPropertyPresent("Windows.UI.Xaml.FrameworkElement", "AllowFocusOnInteraction"))
{
purseListCB.AllowFocusOnInteraction = true;
}
using (PFContext db = new PFContext())
{
purseCollection = new ObservableCollection <Purse>(db.Purse.ToList());
costsCollection = new ObservableCollection <Costs>(db.Costs.Include(x => x.Purse)
.Include(x => x.Currency).Include(x => x.CostCategories).ToList());
incomesCollection = new ObservableCollection <Income>(db.Income.Include(x => x.Purse)
.Include(x => x.Currency).Include(x => x.SourceOfIncome).ToList());
}
purseListCB.ItemsSource = purseCollection;
ChangeCollectionForDiagramm(costsCollection, incomesCollection);
amountSumma.Text = "Доходы - расходы : "
+ (GetSumma(incomesStructListNoDuplicates) - GetSumma(costsStructListNoDuplicates)).ToString()
+ " BYN";
isAllPurse.IsChecked = true;
isAllDate.IsChecked = true;
}
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
if (nameSourceOfIncome.Text.Length == 0)
{
errorText.Text = "Введите название";
return;
}
using (PFContext db = new PFContext())
{
if (income != null)
{
income.Name = nameSourceOfIncome.Text;
db.SourceOfIncome.Update(income);
}
else
{
SourceOfIncome incomeNew = new SourceOfIncome
{
Name = nameSourceOfIncome.Text
};
db.SourceOfIncome.Add(incomeNew);
}
db.SaveChanges();
}
GoToPreviousPage();
}
private void CategoriesPage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
costCategorCollection = new ObservableCollection <CostCategories>(db.CostCategories.ToList());
sourceOfIncomeCollection = new ObservableCollection <SourceOfIncome>(db.SourceOfIncome.ToList());
}
localSettings = ApplicationData.Current.LocalSettings;
object value = localSettings.Values["sortCategoriesSettings"];
if (value != null)
{
if (value.ToString() == "byNameDesc")
{
SortCategoriesByNameDesc(costCategorCollection, sourceOfIncomeCollection);
}
else
{
SortCategoriesByName(costCategorCollection, sourceOfIncomeCollection);
}
}
else
{
costCategorList.ItemsSource = costCategorCollection;
sourceOfIncomeList.ItemsSource = sourceOfIncomeCollection;
}
}
private void PursePage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
purseCollection = new ObservableCollection <Purse>(db.Purse.Include(x => x.Currency).ToList());
}
localSettings = ApplicationData.Current.LocalSettings;
object value = localSettings.Values["sortPurseSetting"];
if (value != null)
{
if (value.ToString() == "byName")
{
SortPurseName(purseCollection);
}
else if (value.ToString() == "byBalanceDesc")
{
SortPurseBalanceDesc(purseCollection);
}
else
{
SortPurseBalance(purseCollection);
}
}
else
{
purseList.ItemsSource = purseCollection;
}
}
public void PreencheGrid()
{
PFContext context = new PFContext();
var query = context.PessoaFisicas
.Select(x => new { x.Nome, x.Cpf, x.Endereco, x.Data_Nasc, x.Telefone, x.ClienteID }).ToList();
dataGridView1.DataSource = query;
}
private void CurrencyPage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
cList = new ObservableCollection <Currency>(db.Currency.Where(c => c.Id != 1).ToList());
currencyList.ItemsSource = cList;
}
}
private void AccumulationPage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
accumulationCollection = new ObservableCollection <Accumulation>(db.Accumulation
.Include(x => x.Currency).ToList());
}
accumulationList.ItemsSource = accumulationCollection;
}
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
string currentSum = ConvertToStringFormat(accumCurrentSum.Text);
string finalSum = ConvertToStringFormat(accumFinalSum.Text);
Currency cur = currencyList.SelectedItem as Currency;
double cSumm;
double fSumm;
if (accumNameBox.Text.Length == 0)
{
errorText.Text = "Введите имя";
return;
}
if (!Double.TryParse(currentSum, out cSumm) || !Double.TryParse(finalSum, out fSumm))
{
errorText.Text = "Некоректная сумма";
return;
}
if (cur == null)
{
errorText.Text = "Выберите валюту";
return;
}
using (PFContext db = new PFContext())
{
if (accumulation != null)
{
accumulation.Name = accumNameBox.Text;
accumulation.CurrentSumma = cSumm;
accumulation.FinalSumma = fSumm;
accumulation.Currency = cur;
accumulation.CurrencyId = cur.Id;
db.Accumulation.Update(accumulation);
}
else
{
Accumulation accumulationNew = new Accumulation
{
Name = accumNameBox.Text,
CurrentSumma = cSumm,
FinalSumma = fSumm,
CurrencyId = cur.Id,
Currency = cur
};
db.Currency.Attach(cur);
db.Accumulation.Add(accumulationNew);
}
db.SaveChanges();
}
GoToPreviousPage();
}
private void IncomeAddEditPage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
purseListCB.ItemsSource = db.Purse.ToList();
incomeCategorListCB.ItemsSource = db.SourceOfIncome.ToList();
}
if (purseSealed != null && sourceOfIncomeSealed != null)
{
purseListCB.SelectedValue = purseSealed.Id;
incomeCategorListCB.SelectedValue = sourceOfIncomeSealed.Id;
}
}
private void PursePageAddEdit_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
currency = db.Currency.ToList();
}
currencyList.ItemsSource = currency;
// for edit
if (curSealed != null)
{
currencyList.SelectedValue = curSealed.Id;
}
}
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
double sum;
Purse purseElement = purseListCB.SelectedItem as Purse;
if (purseElement == null)
{
errorText.Text = "Не выбран счет";
return;
}
if (!Double.TryParse(ConvertToStringFormat(accumulationSum.Text), out sum))
{
errorText.Text = "Некоректная сумма";
return;
}
if (sum < 0)
{
errorText.Text = "Некоректная сумма";
return;
}
using (PFContext db = new PFContext())
{
Purse purseUpdate;
Currency currrencyElement = db.Currency.FirstOrDefault(c => c.Id == purseElement.CurrencyId);
AccumulationOperation accumulationOperation = new AccumulationOperation
{
AccumulationId = accumulation.Id,
Summa = sum,
PurseId = purseElement.Id,
CurrencyId = currrencyElement.Id,
Purse = purseElement,
Currency = currrencyElement,
Accumulation = accumulation
};
db.Purse.Attach(purseElement);
db.Currency.Attach(currrencyElement);
db.Accumulation.Attach(accumulation);
/* Update Purse */
purseUpdate = db.Purse.FirstOrDefault(p => p.Id == accumulationOperation.PurseId);
purseUpdate.Balance = purseUpdate.Balance - accumulationOperation.Summa;
db.Purse.Update(purseUpdate);
/* Update Accumulation */
accumulation.CurrentSumma += accumulationOperation.Summa;
db.Update(accumulation);
db.AccumulationOperation.Add(accumulationOperation);
db.SaveChanges();
}
GoToPreviousPage();
}
private void purseListCB_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Purse purseElemComboBox = purseListCB.SelectedItem as Purse;
Currency currencyForCB;
if (purseElemComboBox != null)
{
using (PFContext db = new PFContext())
{
currencyForCB = db.Currency.FirstOrDefault(c => c.Id == purseElemComboBox.CurrencyId);
}
curAbbrev.Text = currencyForCB.Abbreviation;
}
}
private void DisplacementAddEditPage_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
purse_1ListCB.ItemsSource = db.Purse.ToList();
purse_2ListCB.ItemsSource = db.Purse.ToList();
}
if (purseSealed1 != null && purseSealed2 != null)
{
purse_1ListCB.SelectedValue = purseSealed1.Id;
purse_2ListCB.SelectedValue = purseSealed2.Id;
}
dateDispl.Date = DateTime.Today;
}
private void CostAddEdit_Loaded(object sender, RoutedEventArgs e)
{
using (PFContext db = new PFContext())
{
purseListCB.ItemsSource = db.Purse.ToList();
costCategorListCB.ItemsSource = db.CostCategories.ToList();
}
if (purseSealed != null && costCategoriesSealed != null)
{
purseListCB.SelectedValue = purseSealed.Id;
costCategorListCB.SelectedValue = costCategoriesSealed.Id;
//curAbbrev.Text =
}
}
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
string value = ConvertToStringFormat(purseBalanceBox.Text);
double balance;
Currency cur = currencyList.SelectedItem as Currency;
if (purseNameBox.Text.Length == 0)
{
errorText.Text = "Введите имя счета";
return;
}
if (!Double.TryParse(value, out balance))
{
errorText.Text = "Некоректный баланс";
return;
}
if (cur == null)
{
errorText.Text = "Выберите валюту";
return;
}
using (PFContext db = new PFContext())
{
if (purse != null)
{
purse.Name = purseNameBox.Text;
purse.Balance = balance;
purse.CurrencyId = cur.Id;
purse.Currency = cur;
db.Purse.Update(purse);
}
else
{
Purse purseNew = new Purse
{
Name = purseNameBox.Text,
Balance = balance,
Currency = cur,
CurrencyId = cur.Id
};
db.Currency.Attach(cur);
db.Purse.Add(purseNew);
}
db.SaveChanges();
}
GoToPreviousPage();
}
private void btSalvar_Click(object sender, EventArgs e)
{
if (modificaPessoa == false)
{
string nome = tbNome.Text;
string endereco = tbEndereco.Text;
string cpf = tbCpf.Text;
string telefone = tbTelefone.Text;
DateTime data_nasc = DateTime.Parse(tbData_Nasc.Text);
Cliente pf = new Cliente();
pf.Nome = nome;
pf.Endereco = endereco;
pf.Cpf = cpf;
pf.Telefone = telefone;
pf.Data_Nasc = data_nasc;
var context = new PFContext();
context.PessoaFisicas.Add(pf);
context.SaveChanges();
MessageBox.Show("Cliente Inserido com sucesso.", "Alerta");
LimpaCamposPessoa();
PreencheGrid();
}
else
{
var context = new PFContext();
int aux = Convert.ToInt32(id);
Cliente pf = context.PessoaFisicas.Single(x => x.ClienteID == aux);
pf.Nome = tbNome.Text.ToString();
pf.Endereco = tbEndereco.Text.ToString();
pf.Cpf = tbCpf.Text.ToString();
pf.Data_Nasc = DateTime.Parse(tbData_Nasc.Text);
pf.Telefone = tbTelefone.Text.ToString();
context.PessoaFisicas.Attach(pf);
context.Entry(pf).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
LimpaCamposPessoa();
MessageBox.Show("Cliente Alterado com sucesso.", "Alerta");
modificaPessoa = false;
PreencheGrid();
}
}
private void DeletePurseItem(Purse p)
{
using (PFContext db = new PFContext())
{
try
{
foreach (Costs c in db.Costs)
{
if (c.PurseId == p.Id)
{
db.Costs.Remove(c);
}
}
foreach (Income i in db.Income)
{
if (i.PurseId == p.Id)
{
db.Income.Remove(i);
}
}
foreach (Displacement d in db.Displacement)
{
if (d.PurseId1 == p.Id || d.PurseId2 == p.Id)
{
db.Displacement.Remove(d);
}
}
foreach (AccumulationOperation a in db.AccumulationOperation)
{
if (a.PurseId == p.Id)
{
db.AccumulationOperation.Remove(a);
}
}
db.Purse.Remove(p);
db.SaveChanges();
purseList.ItemsSource = db.Purse.ToList();
}
catch
{
errorText.Text = "Удаление не возможно.Повторите попытку позже";
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
income = db.SourceOfIncome.FirstOrDefault(c => c.Id == id);
}
}
if (income != null)
{
headerBlock.Text = "Редактировать категорию доходов";
nameSourceOfIncome.Text = income.Name;
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
id = (int)e.Parameter;
using (PFContext db = new PFContext())
{
costCategor = db.CostCategories.FirstOrDefault(c => c.Id == id);
}
}
if (costCategor != null)
{
headerBlock.Text = "Редактировать категорию расходов";
nameCostCategories.Text = costCategor.Name;
}
}
private void DeleteCostItem(Costs c)
{
Purse purseChangeBalance;
using (PFContext db = new PFContext())
{
db.Costs.Remove(c);
purseChangeBalance = db.Purse.FirstOrDefault(p => p.Id == c.PurseId);
purseChangeBalance.Balance = purseChangeBalance.Balance + c.Summa;
db.Purse.Update(purseChangeBalance);
db.SaveChanges();
costsCollection = new ObservableCollection <Costs>(db.Costs.Include(x => x.CostCategories)
.Include(x => x.Purse).Include(x => x.Currency).ToList());
SortCostDateDesc(costsCollection);
}
}
private void DeleteIncomeItem(Income i)
{
Purse purseChangeBalance;
using (PFContext db = new PFContext())
{
db.Income.Remove(i);
purseChangeBalance = db.Purse.FirstOrDefault(p => p.Id == i.PurseId);
purseChangeBalance.Balance = purseChangeBalance.Balance - i.Summa;
db.Purse.Update(purseChangeBalance);
db.SaveChanges();
incomesCollection = new ObservableCollection <Income>(db.Income.Include(x => x.SourceOfIncome)
.Include(x => x.Purse).Include(x => x.Currency).ToList());
SortIncomeDateDesc(incomesCollection);
}
}
