public ActionResult Create([Bind(Include = "CourseID,Title,Credits,DepartmentID")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "Name", course.DepartmentID);
return(View(course));
}
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(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);
}
}
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);
}
}
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 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 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);
}
}
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 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);
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD md = new ModelBD())
{
var rol = md.Rolee.Where(p => p.RoleName.Equals(Rolee.SelectedItem)).FirstOrDefault();
Users users = new Users
{
FirstName = FirstNam.Text,
LastName = LastNam.Text,
Login = Log.Text,
Password = Pass.Password,
Services = double.Parse(Serv.Text),
RoleID = rol.RoleID,
Photo = "",
Gender = GendR.SelectedItem.ToString(),
DateOfBirth = DatOf.SelectedDate
};
md.Users.Add(users);
md.SaveChanges();
MessageBox.Show("!!");
MainWindow main = new MainWindow();
main.LOG.Text = Log.Text;
main.PASS.Text = Pass.Password;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
using (ModelBD md = new ModelBD())
{
try
{
var IdPat = md.Patients.Where(p => p.FIO.Equals(FIO.Text)).FirstOrDefault();
var SetServNam = md.SetServicee.Where(p => p.Name.Equals(NameServ.Text)).FirstOrDefault();
var dop = DopServ.SelectedItems;
double?sum = 0;
foreach (var item in dop)
{
var cost = md.LabServices.Where(p => p.Name.Equals(item.ToString())).FirstOrDefault();
sum += cost.Cost;
}
foreach (var item in dop)
{
var ServNam = md.LabServices.Where(p => p.Name.Equals(item.ToString())).FirstOrDefault();
orderr = new Orderr
{
IDPatient = IdPat.ID,
IDService = ServNam.ID,
Status = "OK"
};
md.Orderr.Add(orderr);
md.SaveChanges();
}
if (DopServ.Items != null)
{
foreach (var item in dop)
{
bioMaterial = new BioMaterial
{
IDSetService = SetServNam.ID,
BioCode = int.Parse(BioCodeA.Text),
BioName = item.ToString()
};
md.BioMaterial.Add(bioMaterial);
md.SaveChanges();
}
}
numAn = new NumberAnalyze
{
IDPatient = IdPat.ID,
IDService = SetServNam.ID,
};
md.NumberAnalyze.Add(numAn);
md.SaveChanges();
MessageBox.Show("Данные успешно созранены в БД");
DateTime dat = DateTime.Now;
Order order = Order.GetInst(DopServ, sum, IdPat.ID, long.Parse(Shtr.Text));
order.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}