// добавление новой заявки public void AddElement(Request model) { using (var transaction = context.Database.BeginTransaction()) { try { Request element = new Request { Id = model.Id, Date = model.Date, Address = model.Address, ReceiptMark = false, DateReception = null, Prioritet = model.Prioritet, UserId = AuthController.authId }; context.Requests.Add(element); context.SaveChanges(); transaction.Commit(); string address = findEmail(AuthController.authId); email.SendEmail(address, "Оформление заказа", "Ваш заказ на " + model.Date.ToString() + " принят в обработку"); } catch (Exception) { transaction.Rollback(); throw; } } }
public IActionResult Remove(int id) { var deleteMe = _dbContext.Students.Single(x => x.Id == id); _dbContext.Students.Remove(deleteMe); _dbContext.SaveChanges(); return(RedirectToAction("Index", "Message", MessageVm.Create( urlService: Url, message: "Student is removed.", returnAction: "Index", returnController: "Student" ) )); }
//регистрация нового пользователя public void AddElement(User model) { using (var transaction = context.Database.BeginTransaction()) { try { User element = context.Users.FirstOrDefault(rec => rec.Login == model.Login); if (element != null) { throw new Exception("Уже есть пользователь с таким логином"); } string encryptedPass = service.Encrypt("Login", model.Password); element = new User { FIO = model.FIO, CompanyName = model.CompanyName, Login = model.Login, Password = encryptedPass, Email = model.Email, PhoneNumber = model.PhoneNumber, Role = model.Role }; context.Users.Add(element); context.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw; } } }
public void rateProvider(int providerId, decimal rate) { Provider element = getById(providerId); element.Rating = (element.Rating + rate) / 2; context.SaveChanges(); }
private void AddNewTraffic() { if (cbxFrom.SelectedItem == cbxTo.SelectedItem) { MessageBox.Show("Операция Отклонена! Указанные города должны быть разными."); return; } if (idCargoesToList.Count == 0) { MessageBox.Show("Добавьте груз"); return; } Traffic traffic = new Traffic { IdAirplane = (cbxAirplanes.Items[cbxAirplanes.SelectedIndex] as Airplane).Id, IdAirportFrom = (cbxFrom.Items[cbxFrom.SelectedIndex] as Airport).Id, IdAirportTo = (cbxTo.Items[cbxTo.SelectedIndex] as Airport).Id }; var cargos = db.Cargoes .Where(c => idCargoesToList.Contains(c.Id)) .ToList(); cargos.ForEach(c => traffic.Cargos.Add(c)); //db.Entry(traffic).State = EntityState.Modified; db.Traffics.Add(traffic); db.SaveChanges(); this.Close(); }
public ActionResult AddStudent(int courseId, int studentId) { var course = _dbContext.Courses.Single(x => x.Id == courseId); var student = _dbContext.Students.Single(x => x.Id == studentId); course.Students.Add(student); _dbContext.SaveChanges(); return(RedirectToAction("Index", "Message", MessageVm.Create( urlService: Url, message: "Student was sucessfully enrolled in course.", returnAction: "Index", returnController: "Enrollment", routeValues: new { CourseId = courseId } ) )); }
private void ChangeAirplaneData() { try { if (string.IsNullOrEmpty(textBoxNameAir.Text) && string.IsNullOrEmpty(textBoxMaxDistance.Text) && string.IsNullOrEmpty(textBoxCarrying.Text)) { return; } var airplane = GetSelectedAirplane(); if (airplane == null) { return; } var newAirplane = new Airplane(); if (!string.IsNullOrEmpty(textBoxNameAir.Text)) { newAirplane.Name = textBoxNameAir.Text; } else { newAirplane.Name = airplane.Name; } if (!string.IsNullOrEmpty(textBoxMaxDistance.Text)) { newAirplane.MaxDistance = Int32.Parse(textBoxMaxDistance.Text); } else { newAirplane.MaxDistance = airplane.MaxDistance; } if (!string.IsNullOrEmpty(textBoxCarrying.Text)) { newAirplane.Carrying = Int32.Parse(textBoxCarrying.Text); } else { newAirplane.Carrying = airplane.Carrying; } if (airplane.Equals(newAirplane)) { return; } airplane.Name = newAirplane.Name; airplane.MaxDistance = newAirplane.MaxDistance; airplane.Carrying = newAirplane.Carrying; ClearFieldsInput(); db.Entry(airplane).State = EntityState.Modified; db.SaveChanges(); dataGridAirplanes.Refresh(); ShowInfo("Объект изменен!"); } catch (Exception ex) { MainFormService.ShowError(ex.Message); } }