private void DeletePeriodButton_Click(object sender, RoutedEventArgs e)
{
if (PeriodsComboBox.SelectedIndex > -1)
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <MonthConsumption> lst = container.Set <MonthConsumption>().ToList();
string deleteStr = PeriodsComboBox.SelectedItem.ToString();
foreach (MonthConsumption item in lst)
{
string str = (item.Date / 100).ToString() + "/" + (item.Date % 100 < 10 ? "0" + (item.Date % 100).ToString() : (item.Date % 100).ToString());
if (string.Equals(str, deleteStr))
{
var billingLst = container.Set <Billing>().ToList();
foreach (var bill in billingLst)
{
if (bill.MonthConsumption.MonthBillingID == item.MonthBillingID)
{
container.BillingSet.Remove(bill);
}
}
container.MonthConsumptionSet.Remove(item);
break;
}
}
container.SaveChanges();
Close();
}
else
{
MessageBox.Show("Выберите нужный период из списка", "Ошибка");
}
}
private void isRecordsExist()
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
if (container.CottagerSet.Count() == 0 && container.MonthConsumptionSet.Count() == 0)
{
ViewDataGrid.ItemsSource = null;
currentViewTextBlock.Text = "";
}
}
private void CreateCostBtn_Click(object sender, RoutedEventArgs e)
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
container.CostOfWaterSet.Add(new CostOfWater()
{
Cost = Decimal.Parse(CostOfWaterTB.Text)
});
container.SaveChanges();
Close();
}
public DeleteCottagerWindow(string connectionString)
{
InitializeComponent();
connString = connectionString;
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <Cottager> lst = container.Set <Cottager>().ToList();
lst.Sort();
foreach (Cottager item in lst)
{
CottagersComboBox.Items.Add(item.Author + "; S = " + item.Square.ToString());
}
}
public DeleteMonthConsWindow(string connectionString)
{
InitializeComponent();
connString = connectionString;
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <MonthConsumption> lst = container.Set <MonthConsumption>().ToList();
lst.Sort();
foreach (MonthConsumption item in lst)
{
PeriodsComboBox.Items.Add((item.Date / 100).ToString() + "/" + (item.Date % 100 < 10 ? "0" + (item.Date % 100).ToString() : (item.Date % 100).ToString()));
}
}
private void ShowCostOfWaterBtn_Click(object sender, RoutedEventArgs e)
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <CostOfWater> lst = container.Set <CostOfWater>().ToList();
string str = "";
int cost = Convert.ToInt32(lst[0].Cost * 100);
str = (cost / 100).ToString() + " руб. ";
if (cost % 100 > 0)
{
str += (cost % 100).ToString() + " коп.";
}
MessageBox.Show("Кубический метр воды стоит " + str, "Цена за воду");
}
private void SetMonthConsAsItemSource()
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <MonthConsumption> lst = container.Set <MonthConsumption>().ToList();
if (lst.Count > 0)
{
ViewDataGrid.ItemsSource = lst;
ViewDataGrid.Columns.RemoveAt(0);
ViewDataGrid.Columns.RemoveAt(2);
ViewDataGrid.Columns[0].Header = "Дата";
ViewDataGrid.Columns[1].Header = "Потребление за месяц";
SortByFirstColumn();
currentViewTextBlock.Text = "Потребление воды по месяцам";
}
}
private void SetCottagersAsItemsSource()
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
List <Cottager> lst = container.Set <Cottager>().ToList();
if (lst.Count > 0)
{
ViewDataGrid.ItemsSource = lst;
ViewDataGrid.Columns.RemoveAt(0);
ViewDataGrid.Columns.RemoveAt(2);
ViewDataGrid.Columns[0].Header = "ФИО дачника";
ViewDataGrid.Columns[1].Header = "Площадь участка";
SortByFirstColumn();
currentViewTextBlock.Text = "Дачники";
}
}
private void Wizard_Next(object sender, Xceed.Wpf.Toolkit.Core.CancelRoutedEventArgs e)
{
if (WizardWindow.CurrentPage == Page3)
{
int cost = Convert.ToInt32(costOfWater * 100);
costTextBlock.Text += (cost / 100).ToString() + " руб. ";
if (cost % 100 > 0)
{
costTextBlock.Text += (cost % 100).ToString() + " коп.";
}
countCottagersTextBlock.Text += cottagers.Count.ToString();
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
var CollCost = from item in container.CostOfWaterSet
select item;
container.CostOfWaterSet.RemoveRange(CollCost);
container.CostOfWaterSet.Add(new CostOfWater()
{
Cost = Convert.ToDecimal(costOfWater)
});
var CollCottagers = from item in container.CottagerSet
select item;
container.CottagerSet.RemoveRange(CollCottagers);
foreach (var item in cottagers)
{
container.CottagerSet.Add(new Cottager()
{
Author = item.Author,
Square = item.Square
});
}
var CollBilling = from item in container.BillingSet
select item;
container.BillingSet.RemoveRange(CollBilling);
var CollMonthConsumption = from item in container.MonthConsumptionSet
select item;
container.MonthConsumptionSet.RemoveRange(CollMonthConsumption);
container.SaveChanges();
}
}
private void SetMonthBillingAsItemSource(MonthConsumption consumption, Billing billEx)
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
IQueryable <Billing> lst = null;
if (billEx == null)
{
lst = from bill in container.BillingSet
where bill.MonthConsumption.MonthBillingID == consumption.MonthBillingID
select bill;
}
else
{
lst = from bill in container.BillingSet
where bill.Date == billEx.Date
select bill;
}
List <Billing> bills = lst.ToList();
if (bills.Count > 0)
{
ViewDataGrid.ItemsSource = bills;
ViewDataGrid.Columns.RemoveAt(0);
ViewDataGrid.Columns.RemoveAt(1);
ViewDataGrid.Columns.RemoveAt(2);
ViewDataGrid.Columns.RemoveAt(2);
ViewDataGrid.Columns[0].Header = "ФИО дачника";
ViewDataGrid.Columns[1].Header = "Счёт за месяц";
int date = (billEx == null ? consumption.Date : billEx.MonthConsumption.Date);
currentViewTextBlock.Text = "Отчёт за период: " + (date / 100).ToString() + "/" + (date % 100 < 10 ? "0" + (date % 100).ToString() : (date % 100).ToString());
SortByFirstColumn();
}
else if (consumption != null)
{
MessageBox.Show("Отсутствуют дачники для выбранного периода");
}
}
private void FillDBForExampleBtn_Click(object sender, RoutedEventArgs e)
{
ModelSprintDBContainer container = new ModelSprintDBContainer(connString);
ClearDB();
//пример
CostOfWater costOfWater = new CostOfWater()
{
Cost = 1.57M
};
container.CostOfWaterSet.Add(costOfWater);
container.CottagerSet.Add(new Cottager()
{
Author = "Шубин Семён Николаевич",
Square = 12
});
container.CottagerSet.Add(new Cottager()
{
Author = "Иванов Пётр Михайлович",
Square = 15
});
container.CottagerSet.Add(new Cottager()
{
Author = "Сидоров Александр Анатольевич",
Square = 20
});
container.CottagerSet.Add(new Cottager()
{
Author = "Машинцев Илья Константинович",
Square = 9.5M
});
var cottagers = from item in container.CottagerSet.Local
select item;
MonthConsumption monthConsumption = new MonthConsumption()
{
Consumption = 300,
Date = 201804
};
decimal square = 0;
foreach (Cottager cottager in cottagers)
{
square += cottager.Square;
}
foreach (Cottager cottager in cottagers)
{
Billing bill = new Billing()
{
MonthConsumption = monthConsumption,
Cottager = cottager,
Author = cottager.Author,
Date = monthConsumption.Date,
Bill = Convert.ToDecimal((cottager.Square / square) * monthConsumption.Consumption * costOfWater.Cost),
};
container.BillingSet.Add(bill);
}
monthConsumption = new MonthConsumption()
{
Consumption = 470.5M,
Date = 201803
};
foreach (Cottager cottager in cottagers)
{
Billing bill = new Billing()
{
MonthConsumption = monthConsumption,
Cottager = cottager,
Author = cottager.Author,
Date = monthConsumption.Date,
Bill = Convert.ToDecimal((cottager.Square / square) * monthConsumption.Consumption * costOfWater.Cost),
};
container.BillingSet.Add(bill);
}
container.SaveChanges();
SetCottagersAsItemsSource();
}
