public AddPatient(int id, string shtr)
{
InitializeComponent();
IDPAT = id;
PolName.Visibility = Visibility.Collapsed;
PolNameBox.Visibility = Visibility.Visible;
CompName.Visibility = Visibility.Collapsed;
CompNameBox.Visibility = Visibility.Visible;
save.Visibility = Visibility.Visible;
add.Visibility = Visibility.Collapsed;
using (ModelBD md = new ModelBD())
{
var patient = md.Patients.Where(p => p.ID.Equals(id)).FirstOrDefault();
pFIO.Text = patient.FIO;
DaT.SelectedDate = patient.DateOfBirth;
pEmail.Text = patient.Email;
pPassportData.Text = patient.PassportData;
pPhone.Text = patient.Phone.ToString();
pInsPolicy.Text = patient.InsurancePolicy.ToString();
PolNameBox.Text = patient.TypeOfPolicy;
CompNameBox.Text = patient.Company.Name;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (ModelBD md = new ModelBD())
{
try
{
pat = new Patients
{
FIO = pFIO.Text,
DateOfBirth = DaT.DisplayDate,
Email = pEmail.Text,
PassportData = pPassportData.Text,
Phone = int.Parse(pPhone.Text),
InsurancePolicy = int.Parse(pInsPolicy.Text),
TypeOfPolicy = PolName.SelectedItem.ToString(),
IDCompany = int.Parse(CompName.SelectedItem.ToString().Split('.')[0])
};
md.Patients.Add(pat);
md.SaveChanges();
ReceptionBioMaterialWindow rbmw = new ReceptionBioMaterialWindow();
rbmw.FIO.Text = pat.FIO;
MessageBox.Show("Данные успешно созранены в БД");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void Button_Click_6(object sender, RoutedEventArgs e)
{
using (ModelBD md = new ModelBD())
{
CheckBox check = new CheckBox();
var dop = DopServ.SelectedItems;
var cost = md.LabServices.ToList();
double?sum = 0;
foreach (var item in dop)
{
foreach (var item1 in cost)
{
if (item.ToString() == item1.Name)
{
sum += item1.Cost;
}
}
}
summ.Text = sum.ToString();
}
}
private void AddAgentIntoBD(object sender, RoutedEventArgs e)
{
try
{
string _fio = FIOText.Text;
int? _percent = int.Parse(PercentText.Text);
if (_fio == "" && _percent == null || _fio != "" && _percent == null || _fio == "" && _percent != null)
{
MessageBox.Show("Не все поля заполненны!");
}
else
{
using (ModelBD model = new ModelBD())
{
Realtors realtors = new Realtors
{
FIO = _fio,
Percent = _percent
};
model.Realtors.Add(realtors);
model.SaveChanges();
MessageBox.Show("Агент успешно добавлен");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//BioCode
private void BioCode_TextChanged(object sender, TextChangedEventArgs e)
{
using (ModelBD md = new ModelBD())
{
var BioCodeB = from b in md.BioMaterial
where b.BioCode.ToString().Contains(BioCodeA.Text)
select new
{
BioName = b.BioName,
BioCode = b.BioCode
};
spic.Items.Clear();
if (BioCodeA.Text == "")
{
GetVisibilityListBox(spic, Visibility.Hidden, BioCodeA, new Thickness(1, 1, 1, 1));
}
else if (BioCodeA.Text != "")
{
GetVisibilityListBox(spic, Visibility.Visible, BioCodeA, new Thickness(1, 1, 1, 0));
foreach (var item in BioCodeB)
{
spic.Items.Add(" " + item.BioCode + " - " + item.BioName);
}
}
if (BioCodeA.Text != "" && BioCodeA.Text.Length == 5)
{
GetVisibilityListBox(spic, Visibility.Hidden, BioCodeA, new Thickness(1, 1, 1, 1));
}
}
}
private void AddToCheck()
{
try
{
using (ModelBD model = new ModelBD())
{
var agents = from r in model.Realtors
select new
{
IDAgent = r.ID,
FIO = r.FIO
};
var apartaments = from a in model.Apartaments
select a;
foreach (var agent in agents)
{
AgentsCombo.Items.Add(agent.FIO + " - ID: " + agent.IDAgent);
}
foreach (var apartament in apartaments)
{
ApartamentsCombo.Items.Add(apartament.StreetName + " - " + apartament.Price);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD md = new ModelBD())
{
var compId = md.Company.Where(p => p.Name.Equals(CompNameBox.Text)).FirstOrDefault();
Patients patients = new Patients
{
ID = IDPAT,
FIO = pFIO.Text,
DateOfBirth = DaT.SelectedDate,
Email = pEmail.Text,
PassportData = pPassportData.Text,
Phone = long.Parse(pPhone.Text),
InsurancePolicy = long.Parse(pInsPolicy.Text),
TypeOfPolicy = PolNameBox.Text,
IDCompany = compId.ID
};
md.Entry(patients).State = System.Data.Entity.EntityState.Modified;
md.SaveChanges();
}
MessageBox.Show("Данные успешно созранены в БД");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SaveAP(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
apartament.StreetName = STNameText.Text;
apartament.HouseNumber = HouseNumText.Text;
apartament.ApartamentNumber = int.Parse(APNumText.Text);
apartament.SquareApartament = double.Parse(SquareText.Text);
apartament.AmountRoom = int.Parse(AmountRoomText.Text);
apartament.Price = decimal.Parse(PriceText.Text);
model.Entry(apartament).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
SetChangeComboBox(realtors, apartament);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SetComboBox()
{
try
{
using (ModelBD model = new ModelBD())
{
var agents = from ag in model.Realtors
select ag;
var apartaments = from ap in model.Apartaments
select ap;
foreach (var agent in agents)
{
FIOComb.Items.Add(agent.FIO + " - ID: " + agent.ID);
}
foreach (var apartament in apartaments)
{
APComb.Items.Add(apartament.StreetName + " - ID: " + apartament.ID);
}
}
}
catch (Exception ex)
{
}
}
private void DeleteAP(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartaments = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
model.Apartaments.Remove(apartaments);
model.SaveChanges();
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
int? idAPart = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAPart).FirstOrDefault();
SetChangeComboBox(realtors, apartament);
ClearTextBoxAP();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void APComb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (APComb.SelectedItem != null && FIOComb.SelectedItem != null)
{
using (ModelBD model = new ModelBD())
{
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
STNameText.Text = apartament.StreetName;
HouseNumText.Text = apartament.HouseNumber;
APNumText.Text = apartament.ApartamentNumber.ToString();
SquareText.Text = apartament.SquareApartament.ToString();
AmountRoomText.Text = apartament.AmountRoom.ToString();
PriceText.Text = apartament.Price.ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddPatient(string shtrih)
{
InitializeComponent();
Shtrih.Text = shtrih;
using (ModelBD md = new ModelBD())
{
var comp = from c in md.Company
select new
{
NameComp = c.Name,
IdComp = c.ID
};
foreach (var item in comp)
{
CompName.Items.Add(item.IdComp + ". " + item.NameComp);
}
var pol = (from p in md.Patients select p.TypeOfPolicy).Distinct();
foreach (var item in pol)
{
PolName.Items.Add(item.ToString());
}
}
}
private void SaveAgent(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
realtors.FIO = FIOText.Text;
realtors.Percent = int.Parse(PercentText.Text);
model.Entry(realtors).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
SetChangeComboBox(realtors, apartament);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
Apartaments apartaments = new Apartaments
{
StreetName = STNameText.Text,
HouseNumber = HousNumText.Text,
ApartamentNumber = int.Parse(APNumText.Text),
SquareApartament = double.Parse(SquareText.Text),
AmountRoom = int.Parse(AmountRoomText.Text),
Price = decimal.Parse(PriceText.Text)
};
model.Apartaments.Add(apartaments);
model.SaveChanges();
MessageBox.Show("Квартира успешно добавлена");
ClearTextBox();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public AddStuf()
{
InitializeComponent();
using (ModelBD md = new ModelBD())
{
var Gend = from g in md.Users
select new
{
gender = g.Gender
};
var Rol = from r in md.Rolee
select new
{
role = r.RoleName
};
foreach (var item in Gend.Distinct())
{
GendR.Items.Add(item.gender);
}
foreach (var item in Rol)
{
Rolee.Items.Add(item.role);
}
}
}
public int GetAPID()
{
using (ModelBD model = new ModelBD())
{
int idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
return(model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault().ID);
}
}
public int GetAgentID()
{
using (ModelBD model = new ModelBD())
{
int idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
return(model.Realtors.Where(p => p.ID == idComb).FirstOrDefault().ID);
}
}
//
//FIO
private void FIO_TextChanged(object sender, TextChangedEventArgs e)
{
try
{
using (ModelBD md = new ModelBD())
{
FioSpic.Items.Clear();
var fioPat = from p in md.Patients select p;
if (filt.IsChecked == true)
{
GetIfChange(FIO, FioSpic);
foreach (var items in fioPat)
{
if (FIO.Text != "" && FIO.Text.Equals(items.FIO.ToString()))
{
GetVisibilityListBox(FioSpic, Visibility.Hidden, FIO, new Thickness(1, 1, 1, 1));
}
FioSpic.Items.Add(items.FIO);
}
}
else
{
GetIfChange(FIO, FioSpic);
foreach (var item in fioPat)
{
if (FIO.Text == "")
{
break;
}
else
{
if (LevenshteinDistance(item.FIO.Split(' ')[0], FIO.Text) <= 3)
{
FioSpic.Items.Add(item.FIO);
}
}
}
foreach (var items in fioPat)
{
if (FIO.Text != "" && FIO.Text.Equals(items.FIO.ToString()))
{
GetVisibilityListBox(FioSpic, Visibility.Hidden, FIO, new Thickness(1, 1, 1, 1));
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (ModelBD md = new ModelBD())
{
var pat = md.Patients.Where(p => p.FIO.Equals(FIO.Text)).FirstOrDefault();
AddPatient addPatient = new AddPatient(pat.ID, Shtr.Text);
addPatient.Show();
}
}
public string GetNamPat(ModelBD md, int i)
{
int OID = GetServices[i].id;
var idOrd = md.Orderr.Where(p => p.ID.Equals(OID)).FirstOrDefault();
int OID1 = int.Parse(idOrd.IDPatient.ToString());
var NamPat = md.Patients.Where(p => p.ID.Equals(OID1)).FirstOrDefault();
return(NamPat.FIO);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
try
{
string STName = ApartamentsCombo.SelectedItem.ToString().Split('-')[0].TrimEnd(' ');
decimal?price = decimal.Parse(ApartamentsCombo.SelectedItem.ToString().Split('-')[1]);
int? IDAgent = int.Parse(AgentsCombo.SelectedItem.ToString().Split(':')[1].TrimStart(' '));
if (STName == "" || IDAgent == null)
{
MessageBox.Show("Не все поля заполненны!");
}
else
{
using (ModelBD model = new ModelBD())
{
var aquareAP = from a in model.Apartaments
where a.StreetName == STName
select new
{
IDAP = a.ID
};
int id_ap = 0;
foreach (var sq in aquareAP)
{
id_ap = sq.IDAP;
}
Dealings dealing = new Dealings();
dealing.IDApartamemt = id_ap;
dealing.IDRealtor = IDAgent;
//model.Entry(dealing).State = System.Data.Entity.EntityState.Modified;
model.Dealings.Add(dealing);
model.SaveChanges();
MessageBox.Show("Сделка успешно добавлена");
}
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Order(ListBox serv, double?cost, int idpat)
{
InitializeComponent();
using (ModelBD md = new ModelBD())
{
var Ord = from p in md.Patients
join o in md.Orderr on p.ID equals o.IDPatient
join s in md.LabServices on o.IDService equals s.ID
join set in md.SetServicee on s.IDSetService equals set.ID
join b in md.BioMaterial on set.ID equals b.IDSetService
select new
{
IDpat = p.ID,
IDOrd = o.ID,
IDBio = b.IDBio,
PolNum = p.InsurancePolicy,
FIO = p.FIO,
DateOF = p.DateOfBirth
};
foreach (var item in Ord)
{
if (item.IDpat.Equals(idpat))
{
DateTime dat = DateTime.Now;
OrderDateOne.Text = DateTime.Now.ToString();
OrderNum.Text = item.IDOrd.ToString();
NumProb.Text = item.IDBio.ToString();
PoliceNum.Text = item.PolNum.ToString();
FIO.Text = item.FIO;
DateOfBirthP.Text = item.DateOF.ToString();
ServCount.Items.Clear();
link = "";
foreach (var item1 in serv.SelectedItems)
{
ServCount.Items.Add(item1);
services += item1.ToString() + ", ";
}
CostServ.Text = cost.ToString();
}
}
}
link = $"https://wsrussia.ru/?data=base64({OrderDateOne.Text}&{OrderNum.Text}&{NumProb.Text}&{PoliceNum.Text}&{FIO.Text}&{DateOfBirthP.Text}&{services}&{cost}";
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (FIO.Text != "")
{
using (ModelBD md = new ModelBD())
{
var pat = md.Patients.Where(p => p.FIO.Equals(FIO.Text)).FirstOrDefault();
AddPatient addPatient = AddPatient.getInst(pat.ID, Shtr.Text);
addPatient.Show();
}
}
else
{
MessageBox.Show("Введите имя пользователя!");
}
}
public StrahSch(ArrayList list)
{
InitializeComponent();
using (ModelBD md = new ModelBD())
{
var comp = from c in md.Company
select new
{
compName = c.Name
};
foreach (var item in comp)
{
ListComp.Items.Add(item.compName);
}
}
}
private void GetData(string crit = "")
{
GridAppr.ItemsSource = null;
predlist.Clear();
using (ModelBD model = new ModelBD())
{
if (crit != "")
{
var queryAppr = from p in model.Предметы
where p.Наименование_предмета.Contains(crit)
select p;
foreach (var item in queryAppr)
{
Предметы pred = new Предметы()
{
Наименование_предмета = item.Наименование_предмета,
Описание_предмета = item.Описание_предмета
};
predlist.Add(pred);
}
}
else
{
var queryAppr = from p in model.Предметы
select p;
foreach (var item in queryAppr)
{
Предметы pred = new Предметы()
{
Наименование_предмета = item.Наименование_предмета,
Описание_предмета = item.Описание_предмета
};
predlist.Add(pred);
}
}
GridAppr.ItemsSource = predlist;
}
}
private void SetChangeComboBox(Realtors realtors, Apartaments apartament)
{
try
{
APComb.Items.Clear();
FIOComb.Items.Clear();
SetComboBox();
using (ModelBD model = new ModelBD())
{
FIOComb.SelectedItem = realtors.FIO + " - ID: " + realtors.ID;
APComb.SelectedItem = apartament.StreetName + " - ID: " + apartament.ID;
}
}
catch (Exception ex)
{
}
}
private void GetData(string crit = "")
{
GridAppr.ItemsSource = null;
speclist.Clear();
using (ModelBD model = new ModelBD())
{
if (crit != "")
{
var queryAppr = from p in model.Специальности
where p.C_Наименование_специальности.Contains(crit)
select p;
foreach (var item in queryAppr)
{
Специальности spec = new Специальности()
{
C_Наименование_специальности = item.C_Наименование_специальности,
C_Описание_специальности = item.C_Описание_специальности
};
speclist.Add(spec);
}
}
else
{
var queryAppr = from p in model.Специальности
select p;
foreach (var item in queryAppr)
{
Специальности spec = new Специальности()
{
C_Наименование_специальности = item.C_Наименование_специальности,
C_Описание_специальности = item.C_Описание_специальности
};
speclist.Add(spec);
}
}
GridAppr.ItemsSource = speclist;
}
}
public void GetId(string[] masJson, int num, int num_2)
{
using (ModelBD md = new ModelBD())
{
int msPatId = int.Parse(masJson[0].Split(':')[1]);
int msLsServId = int.Parse(masJson[1].Split(':')[2].Substring(0, 1));
int msSetServId = int.Parse(masJson[num].Split(':')[num_2].Substring(0, 1));
var labserv = md.LabServices.Where(p => p.ID.Equals(msLsServId)).FirstOrDefault();
var patient = md.Patients.Where(p => p.ID.Equals(msPatId)).FirstOrDefault();
var setserv = md.SetServicee.Where(p => p.ID.Equals(msSetServId)).FirstOrDefault();
if (num == 2)
{
MessageBox.Show($"FIO: {patient.FIO}, IDSetServ: {setserv.ID}, IDLabServ: {labserv.ID}");
}
else
{
MessageBox.Show($"FIO: {patient.FIO}, IDSetServ: {setserv.ID}");
}
try
{
int idpat = msPatId;
var order = md.Orderr.Where(p => p.IDPatient.Equals(idpat)).FirstOrDefault();
Orderr orderr = new Orderr
{
IDPatient = order.IDPatient,
IDService = order.IDService,
Status = "IN PROGRESS"
};
md.Entry(orderr).State = System.Data.Entity.EntityState.Modified;
md.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Clipboard.SetText(ex.Message);
}
}
}
public AddPatient(int id, string shtr)
{
InitializeComponent();
using (ModelBD md = new ModelBD())
{
var patient = md.Patients.Where(p => p.ID.Equals(id)).FirstOrDefault();
pFIO.Text = patient.FIO;
DaT.SelectedDate = patient.DateOfBirth;
pEmail.Text = patient.Email;
pPassportData.Text = patient.PassportData;
pPhone.Text = patient.Phone.ToString();
pInsPolicy.Text = patient.InsurancePolicy.ToString();
PolName.SelectedItem = patient.TypeOfPolicy;
CompName.SelectedItem = patient.Company;
Shtrih.Text = shtr;
}
}
private void FIOComb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (APComb.SelectedItem != null && FIOComb.SelectedItem != null)
{
using (ModelBD model = new ModelBD())
{
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
FIOText.Text = realtors.FIO;
PercentText.Text = realtors.Percent.ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
