private void GetSumPregledi()
{
//SUM PLATENI
double payed = 0;
double notPayed = 0;
using (var db = new DatabaseContext())
{
foreach (var listItem in lbPregledivoFirma.Items)
{
var ReviewID = int.Parse((listItem as ListBoxItem).Tag.ToString());
var query = from b in db.Reviews
where b.ReviewID == ReviewID
select b;
foreach (var item in query)
{
if (item.ReviewIsPayed)
{
payed += item.ReviewPrice;
}
else
{
notPayed += item.ReviewPrice;
}
}
db.SaveChanges();
dolziinfo.Text = String.Format("Должи: {0:0.00} МКД",notPayed);
platenoinfo.Text = String.Format("Платено: {0:0.00} МКД", payed);
}
}
//using (SQLiteConnection con = new SQLiteConnection(ConfigurationManager.ConnectionStrings["Database"].ToString()))
//{
// con.Open();
// string command = "SELECT SUM(pregled.cena) AS cena, plateno FROM pregled,vraboten WHERE vraboten.naziv_firma = "
// + '"' + nazivFirma + '"' + " AND vraboten.id = pregled.id_vraboten GROUP BY plateno ORDER BY pregled.datum DESC;";
// using (SQLiteCommand cmd = new SQLiteCommand(command, con))
// {
// using (SQLiteDataReader reader = cmd.ExecuteReader())
// {
// var plateno = "0";
// var dolzi = "0";
// while (reader.Read())
// {
// if (reader["plateno"].ToString().Equals("True"))
// {
// plateno = reader["cena"].ToString();
// }
// else
// {
// dolzi = reader["cena"].ToString();
// }
// }
// dolziinfo.Text = "Должи: " + dolzi + ",00 MKD";
// platenoinfo.Text = "Платено: " + plateno + ",00 MKD";
// }
// }
// con.Close();
//}
}
private void FillLboxPregledi(int EmployeeID)
{
lboxPregledi.Items.Clear();
Console.WriteLine(EmployeeID);
using (var db = new DatabaseContext())
{
var query = from b in db.Reviews
where b.EmployeeID == EmployeeID
select b;
foreach (var item in query)
{
Console.WriteLine(item.EmployeeID);
string tip = "1";
switch (item.ReviewType)
{
case "1":
tip = "Систематски";
break;
case "2":
tip = "Периодичен дополнителен";
break;
case "3":
tip = "Периодичен проширен";
break;
case "4":
tip = "Периодичен специфичен";
break;
case "5":
tip = "Насочен";
break;
}
ListBoxItem reviewItem = new ListBoxItem();
StackPanel sp = new StackPanel();
sp.Orientation = Orientation.Horizontal;
Label lb = new Label();
lb.Content = tip;
lb.Width = lboxPregledi.Width/4 * 3;
sp.Children.Add(lb);
Label ld = new Label();
ld.Content = item.ReviewDate.ToShortDateString();
lb.HorizontalAlignment = System.Windows.HorizontalAlignment.Right;
sp.Children.Add(ld);
reviewItem.Tag = item.ReviewID;
reviewItem.Content = sp;
reviewItem.Background = (item.ReviewIsPayed ? Brushes.LightGreen : Brushes.Tomato);
lboxPregledi.Items.Add(reviewItem);
}
if (lboxPregledi.Items.Count == 0)
{
ListBoxItem item = new ListBoxItem();
//TODO смисли подобра фраза
item.Content = "Нема прегледи";
item.IsEnabled = false;
lboxPregledi.Items.Add(item);
}
}
}
private void FillLboxPreglediFirma(int BusinessID)
{
using (var db = new DatabaseContext())
{
//var query = from b in db.Employees
// orderby b.Employees
// select b;
var query = from employee in db.Employees
join review in db.Reviews
on employee.EmployeeID equals review.EmployeeID
where employee.BusinessID == BusinessID
select new {employee,review};
Console.WriteLine("All firmi in the database:");
foreach (var item in query)
{
ListBoxItem litem = new ListBoxItem();
StackPanel sp = new StackPanel();
sp.Orientation = Orientation.Horizontal;
Label lb = new Label();
lb.Content = item.review.ReviewDate.ToShortDateString();
lb.Width = 100;
sp.Children.Add(lb);
Label ld = new Label();
ld.Content = item.employee.EmployeeNameSurname;
ld.Width = 250;
lb.HorizontalAlignment = System.Windows.HorizontalAlignment.Right;
sp.Children.Add(ld);
var tip = "";
switch (item.review.ReviewType)
{
case "1":
tip = "Систематски";
break;
case "2":
tip = "Дополнителен";
break;
case "3":
tip = "Проширен";
break;
case "4":
tip = "Специфичен";
break;
case "5":
tip = "Насочен";
break;
}
Label td = new Label();
td.Content = tip;
td.Width = 100;
td.HorizontalAlignment = System.Windows.HorizontalAlignment.Right;
sp.Children.Add(td);
Label cd = new Label();
cd.Content = String.Format("{0:#.00} МКД",item.review.ReviewPrice);
cd.HorizontalAlignment = System.Windows.HorizontalAlignment.Right;
sp.Children.Add(cd);
litem.Content = sp;
litem.Background = (item.review.ReviewIsPayed ? Brushes.LightGreen : Brushes.Tomato);
litem.Tag = item.review.ReviewID;
lbPregledivoFirma.Items.Add(litem);
}
}
}
private void FillgboxVraboten(int id)
{
ToggleReadOnlyGboxVraboten(true);
ClearGboxVraboteni();
toggleCustomDatePicker(false);
btnVnesiVraboten.IsEnabled = false;
gbVraboten.IsEnabled = true;
gbPregledi.IsEnabled = true;
using (var db = new DatabaseContext())
{
var query = from b in db.Employees
where b.EmployeeID == id
select b;
foreach (var item in query)
{
tbImeVraboten.Text = item.EmployeeNameSurname;
tbMestoRagjanje.Text = item.EmployeeAddress;
tbProfesija.Text = item.EmployeeProffesion;
tbRabotnoMesto.Text = item.EmployeeWorks;
//Console.WriteLine(date[0]+" "+date[1]+" "+date[2]);
string dtm = Convert.ToDateTime(item.EmployeeBirthDate).ToString("dd/MM/yyyy");
SetCustomDate(dtm);
}
db.SaveChanges();
}
}
private void FillLboxFirmi()
{
lboxFirmi.Items.Clear();
using (var db = new DatabaseContext())
{
var query = from b in db.Businesss
orderby b.BusinessName
select b;
Console.WriteLine("All firmi in the database:");
foreach (var item in query)
{
if (item.BusinessID != null)
{
ListBoxItem b = new ListBoxItem();
b.Content = item.BusinessName;
b.Tag = item.BusinessID;
lboxFirmi.Items.Add(b);
}
}
if (lboxFirmi.Items.Count == 0)
{
ListBoxItem item = new ListBoxItem();
//TODO смисли подобра фраза
item.Content = "Нема фирми";
item.IsEnabled = false;
lboxFirmi.Items.Add(item);
}
}
}
private void FillEmployees(int BussinessID)
{
lboxVraboteni.Items.Clear();
using (var db = new DatabaseContext())
{
var query = from b in db.Employees
where b.BusinessID == BussinessID
select b;
Console.WriteLine("All firmi in the database:");
foreach (var item in query)
{
ListBoxItem b = new ListBoxItem();
b.Content = item.EmployeeNameSurname;
b.Tag = item.EmployeeID;
lboxVraboteni.Items.Add(b);
}
if (lboxVraboteni.Items.Count == 0)
{
ListBoxItem item = new ListBoxItem();
item.Content = "Нема вработени";
item.IsEnabled = false;
item.Tag = "-1";
lboxVraboteni.Items.Add(item);
}
}
}
private void FillFirmaInfo(int id)
{
using (var db = new DatabaseContext())
{
var query = from b in db.Businesss
where b.BusinessID == id
select b;
Console.WriteLine("All firmi in the database:");
foreach (var item in query)
{
imefirmainfo.Text = "Име на фирма: " + item.BusinessName;
adresafirmainfo.Text = "Адреса: " + item.BusinessAddress;
edbfirmainfo.Text = "ЕДБ: " + item.BusinessEdb;
}
db.SaveChanges();
}
}
private void btnNaplati_Click(object sender, RoutedEventArgs e)
{
if (lboxFirmi.SelectedIndex != -1)
{
using (var db = new DatabaseContext())
{
foreach (var listItem in lbPregledivoFirma.Items)
{
var ReviewID = int.Parse((listItem as ListBoxItem).Tag.ToString());
var query = from b in db.Reviews
where b.ReviewID == ReviewID
select b;
foreach (var item in query)
{
item.ReviewIsPayed = true;
}
db.SaveChanges();
}
}
RefreshLists();
}
}
private void FillCboxFirmi()
{
cboxFirmi.Items.Clear();
ComboBoxItem temporary = new ComboBoxItem();
temporary.Content = "Избери фирма (Задолжително)";
temporary.IsEnabled = false;
cboxFirmi.Items.Add(temporary);
cboxFirmi.SelectedIndex = 0;
using (var db = new DatabaseContext())
{
var query = from b in db.Businesss
orderby b.BusinessName
select b;
foreach (var item in query)
{
if (item.BusinessID != null)
{
ComboBoxItem b = new ComboBoxItem();
b.Content = item.BusinessName;
b.Tag = item.BusinessID;
cboxFirmi.Items.Add(b);
}
}
}
//using (SQLiteConnection con = new SQLiteConnection(ConfigurationManager.ConnectionStrings["Database"].ToString()))
//{
// con.Open();
// string stm = "SELECT naziv FROM firmi";
// using (SQLiteCommand cmd = new SQLiteCommand(stm, con))
// {
// using (SQLiteDataReader rdr = cmd.ExecuteReader())
// {
// while (rdr.Read())
// {
// ComboBoxItem item = new ComboBoxItem();
// item.Content = rdr["naziv"].ToString();
// cboxFirmi.Items.Add(item);
// }
// }
// }
// con.Close();
//}
}
private static void EmptyTables()
{
using (var db = new DatabaseContext())
{
var rows = from o in db.Employees
select o;
foreach (var row in rows)
{
db.Employees.Remove(row);
}
db.SaveChanges();
}
using (var db = new DatabaseContext())
{
var rows = from o in db.Reviews
select o;
foreach (var row in rows)
{
db.Reviews.Remove(row);
}
db.SaveChanges();
}
using (var db = new DatabaseContext())
{
var rows = from o in db.Businesss
select o;
foreach (var row in rows)
{
db.Businesss.Remove(row);
}
db.SaveChanges();
}
}
protected void KreirajDir(object sender, EventArgs e)
{
TextBox TextBox1 = (TextBox)vnesinaziv;
String str = TextBox1.Text;
if (str.Equals("")) { MessageBox.Show("Називот на фирмата не смее да биде празен!", "Грешка"); return; }
System.IO.Directory.CreateDirectory("Правни лица/" + str);
String path = "Правни лица/" + str + "/Инфо.txt";
File.Create(path).Dispose();
MessageBox.Show("Успешно е креиран директориум за фирма со назив '" + str + "'.", "Внесување фирма");
String[] linii = new String[] { vnesinaziv.Text, vnesiadresa.Text, vnesiedb.Text, vnesiemb.Text, vnesizabeleska.Text };
File.WriteAllLines(path, linii);
using (var db = new DatabaseContext())
{
var business = new Business { BusinessName = vnesinaziv.Text.ToString(), BusinessAddress = vnesiadresa.Text.ToString(), BusinessEdb = vnesiedb.Text.ToString(), BusinessEmb = vnesiemb.Text.ToString(), BusinessRemark = vnesizabeleska.Text.ToString() };
db.Businesss.Add(business);
db.SaveChanges();
}
//vnesuvanje vo baza
vnesinaziv.Clear();
vnesiadresa.Clear();
vnesiedb.Clear();
vnesiemb.Clear();
vnesizabeleska.Clear();
FillLboxFirmi();
FillCboxFirmi();
}
protected void addPregled(object sender, EventArgs e)
{
if (rbSistematski.IsChecked == false && rbDopolnitelen.IsChecked == false &&
rbSpecifichen.IsChecked == false && rbNasochen.IsChecked == false && rbProshiren.IsChecked == false)
{
string pom1 = rbSistematski.IsChecked.ToString();
MessageBox.Show("Мора да изберете тип на преглед за пациентот " + pom1, "Грешка!");
return;
}
if (lboxVraboteni.SelectedIndex < 0)
{
return;
}
ListBoxItem employeeItem = lboxVraboteni.SelectedItem as ListBoxItem;
var EmployeeID = int.Parse(employeeItem.Tag.ToString());
using (var db = new DatabaseContext())
{
var review = new Review();
int tip = 0;
int cena = 0;
if (rbSistematski.IsChecked == true) { tip = 1; cena = 800; }
else if (rbDopolnitelen.IsChecked == true) { tip = 2; cena = 1000; }
else if (rbProshiren.IsChecked == true) { tip = 3; cena = 1200; }
else if (rbSpecifichen.IsChecked == true) { tip = 4; cena = 1500; }
else if (rbNasochen.IsChecked == true) { tip = 5; cena = 1000; }
review.ReviewPrice = cena;
review.ReviewType = String.Format("{0}",tip);
review.ReviewIsPayed = false;
//TODO CHECK STRING FORMAT BEFORE PARSING !
try
{
var shortDate = dpDatumPregled.Text.ToString().Split(' ')[0].Split('.');
var year = int.Parse(shortDate[2]);
var month = int.Parse(shortDate[1]);
var day = int.Parse(shortDate[0]);
review.ReviewDate = new DateTime(year, month, day);
}
catch (Exception err)
{
MessageBox.Show("Погрешен формат за датум (dd.mm.yyyy)", "Грешка!");
}
review.ReviewDate = DateTime.Now;
review.EmployeeID = EmployeeID;
db.Reviews.Add(review);
creator.Review = review;
db.SaveChanges();
var BusinessID = -1;
var eQuery = from employee in db.Employees
where employee.EmployeeID == EmployeeID
select employee;
foreach (var eItem in eQuery)
{
creator.Employee = eItem;
BusinessID = eItem.BusinessID;
}
var bQuery = from business in db.Businesss
where business.BusinessID == BusinessID
select business;
foreach (var bItem in bQuery)
{
creator.Business = bItem;
}
}
FillLboxPregledi(EmployeeID);
//creator.ime_vraboten = tbImeVraboten.Text.ToString();
//creator.mesto_ragjanje = tbMestoRagjanje.Text.ToString();
//creator.vrab_profesija = tbProfesija.Text.ToString();
//creator.vrab_rabmesto = tbRabotnoMesto.Text.ToString();
//creator.datum_rag = cboxDay.SelectedValue.ToString() + "." + cboxMonth.SelectedValue.ToString() +
// "." + cboxYear.SelectedValue.ToString();
//var cbxit = cboxFirmi.SelectedItem as ComboBoxItem;
//creator.naziv_firma = cbxit.Content.ToString();
//creator.id_pregled = pregledID;
//string[] str5 = dpDatumPregled.Text.ToString().Split(' ')[0].Split('-');
//creator.datum_pregled = str5[2] + "." + str5[1] + "." + str5[0];
creator.GenerateDocs();
}
protected void addEmployee(object sender, EventArgs e)
{
if (tbImeVraboten.Equals("")) { MessageBox.Show("Полето за име на вработениот не смее да биде празно", "Грешка!"); return; }
//TODO check DATE VALUES and tb fields
ComboBoxItem b = cboxFirmi.SelectedItem as ComboBoxItem;
int BusinessID = int.Parse(b.Tag.ToString());
using (var db = new DatabaseContext())
{
var employee = new Employee();
employee.EmployeeNameSurname = tbImeVraboten.Text.ToString();
employee.EmployeeWorks = tbRabotnoMesto.Text.ToString();
employee.EmployeeProffesion = tbProfesija.Text.ToString();
employee.EmployeeAddress = tbMestoRagjanje.Text.ToString();
int year = Int32.Parse(cboxYear.SelectedItem.ToString());
int month = Int32.Parse(cboxMonth.SelectedItem.ToString());
int day = Int32.Parse(cboxDay.SelectedItem.ToString());
DateTime dateTime = new DateTime(year,month,day);
employee.EmployeeBirthDate = dateTime;
employee.BusinessID = BusinessID;
db.Employees.Add(employee);
db.SaveChanges();
}
MessageBox.Show(tbImeVraboten.Text + " e внесен во базата.", "Успешно е внесен нов вработен во фирмата " + cboxFirmi.SelectedValue.ToString());
lboxVraboteni.SelectedIndex = lboxVraboteni.Items.Count;
FillEmployees(BusinessID);
RefreshLists();
}
public MainWindow()
{
InitializeComponent();
using (var db = new DatabaseContext())
{
db.Database.EnsureCreated();
}
InitializeCustomeDatePicker();
FillLboxFirmi();
//FillCboxFirmi();
dpDatumPregled.Text = DateTime.Now.ToShortDateString();
//EmptyTables();
}
