public async Task <IActionResult> Delete(int id, int page)
{
CarMark carMark = await db.CarMarks.FindAsync(id);
if (carMark == null)
{
return(NotFound());
}
bool deleteFlag = false;
string message = "Do you want to delete this entity";
if (db.CarModels.Any(s => s.CarMarkId == carMark.CarMarkId))
{
message = "This entity has entities, which dependents from this. Do you want to delete this entity and other, which dependents from this?";
}
CarMarkViewModel model = new CarMarkViewModel();
model.Entity = carMark;
model.PageViewModel = new PageViewModel {
CurrentPage = page
};
model.DeleteViewModel = new DeleteViewModel {
Message = message, IsDeleted = deleteFlag
};
return(View(model));
}
private void Clicked_NewCategory(object sender, RoutedEventArgs e)
{
this._ModeEnabled_workWithCarModelCategories = true;
this._Mode_workWithCategory = WorkWithEntityMode.Adding;
this._carMarkForWork = new CarMark();
this._Flyout_ForCarModelCategories.DataContext = this._carMarkForWork;
}
public ActionResult CreateMark([Bind("ID,MarkName")] CarMark carMark)
{
if (ModelState.IsValid)
{
_context.Add(carMark);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(carMark));
}
public IActionResult Update(CarMark carMark)
{
if (!ModelState.IsValid)
{
return(View(carMark));
}
_carMarkRepository.Update(carMark);
return(RedirectToAction("List"));
}
public CarMark SaveCarMark(CarMark c)
{
CarDbContext db = new CarDbContext();
var list = db.CarMarks.ToList();
if (list.Contains(list.Find(x => x.Name == c.Name)))
{
return(c);
}
db.CarMarks.Add(c);
db.SaveChanges();
return(c);
}
public ActionResult CreateCarMark(EditModel e)
{
if (!ModelState.IsValid)
{
return(View("Index", e));
}
var c = new CarMark()
{
Name = e.CarMark.Name
};
SaveCarMark(c);
return(RedirectToAction("Index"));
}
private void Clicked_ChangeCategory(object sender, RoutedEventArgs e)
{
if (this._SelectedCarMark != null)
{
this._ModeEnabled_workWithCarModelCategories = true;
this._Mode_workWithCategory = WorkWithEntityMode.Change;
this._carMarkForWork = _SelectedCarMark;
this._Flyout_ForCarModelCategories.DataContext = this._carMarkForWork;
}
else
{
MessageBox.Show("Выберите категорию");
}
}
public CarMark getMark(int id)
{
var connection = DbConnection.openConection();
var cmd = new MySqlCommand("SELECT * FROM car_marks WHERE car_mark_id = " + id, connection);
var reader = cmd.ExecuteReader();
var mark = new CarMark();
while (reader.Read())
{
mark.id = Int32.Parse(reader["car_mark_id"].ToString());
mark.name = reader["car_mark_name"].ToString();
}
connection.Close();
return(mark);
}
public async Task <IActionResult> RateCar(CarMark carModel)
{
int mark = carModel.mark;
string userId = User.Claims.ElementAt(0).Value;
var carID = carModel.CarId;
var car = _context.Cars.Include(x => x.Marks).Where(x => x.Id == carID).ToList().First();
var user = _context.Users.Include(x => x.CarMarks).Where(x => x.Id == userId).ToList().First();
if (car != null)
{
CarMark carMark = new CarMark();
carMark.mark = mark;
car.Marks.Add(carMark);
user.CarMarks.Add(carMark);
var carReservation = _context.CarReservations.Where(x => x.UserId == user.Id && x.CarId == car.Id).ToList().First();
carReservation.Mark = mark;
var carCompany = _context.RentCarCompanies.Include(x => x.Cars).Where(x => x.Id == car.RentCarCompanyId).ToList().First();
int sum = 0;
int cnt = 0;
foreach (var car1 in carCompany.Cars)
{
if (car1.Marks != null)
{
foreach (var mark1 in car1.Marks)
{
sum += mark1.mark;
cnt++;
}
}
}
if (cnt > 0)
{
sum = sum / cnt;
carCompany.Mark = sum;
}
_context.Entry(carCompany).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.Entry(carReservation).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.Entry(car).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var result = await _context.SaveChangesAsync();
return(Ok(new { result }));
}
return(BadRequest());
}
public async Task <IActionResult> Edit(int id, int page)
{
CarMark carMark = await db.CarMarks.FindAsync(id);
if (carMark != null)
{
CarMarkViewModel model = new CarMarkViewModel();
model.PageViewModel = new PageViewModel {
CurrentPage = page
};
model.Entity = carMark;
return(View(model));
}
return(NotFound());
}
public List <CarMark> getMarks()
{
var connection = DbConnection.openConection();
var marks = new List <CarMark>();
var cmd = new MySqlCommand("SELECT * FROM car_marks", connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var mark = new CarMark();
mark.id = Int32.Parse(reader["car_mark_id"].ToString());
mark.name = reader["car_mark_name"].ToString();
marks.Add(mark);
}
connection.Close();
return(marks);
}
public async Task <IActionResult> Delete(CarMarkViewModel model)
{
CarMark carMark = await db.CarMarks.FindAsync(model.Entity.CarMarkId);
if (carMark == null)
{
return(NotFound());
}
db.CarMarks.Remove(carMark);
await db.SaveChangesAsync();
cache.Clean();
model.DeleteViewModel = new DeleteViewModel {
Message = "The entity was successfully deleted.", IsDeleted = true
};
return(View(model));
}
private bool CheckUniqueValues(CarMark carMark)
{
bool firstFlag = true;
CarMark tempCarMark = db.CarMarks.FirstOrDefault(g => g.Name == carMark.Name);
if (tempCarMark != null)
{
if (tempCarMark.CarMarkId != carMark.CarMarkId)
{
ModelState.AddModelError(string.Empty, "Another entity have this name. Please replace this to another.");
firstFlag = false;
}
}
if (firstFlag)
{
return(true);
}
else
{
return(false);
}
}
public async Task <IActionResult> Edit(CarMarkViewModel model)
{
if (ModelState.IsValid & CheckUniqueValues(model.Entity))
{
CarMark carMark = db.CarMarks.Find(model.Entity.CarMarkId);
if (carMark != null)
{
carMark.Name = model.Entity.Name;
db.CarMarks.Update(carMark);
await db.SaveChangesAsync();
cache.Clean();
return(RedirectToAction("Index", "CarMarks", new { page = model.PageViewModel.CurrentPage }));
}
else
{
return(NotFound());
}
}
return(View(model));
}
