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); } } }