public void AddCarOwner(CarOwner carOwner)
{
bool isAlreadyInThere = false;
using (var db = new AppDbContext())
{
foreach (var lokaleCarOwner in db.CarOwners)
{
if (lokaleCarOwner.KontactInfo == carOwner.KontactInfo)
{
isAlreadyInThere = true;
lokaleCarOwner.Name = carOwner.Name;
lokaleCarOwner.DrivingLicenceNumber = carOwner.DrivingLicenceNumber;
lokaleCarOwner.CarRegistrationNumber = carOwner.CarRegistrationNumber;
lokaleCarOwner.Cars = carOwner.Cars;
lokaleCarOwner.CarOwnerMessages = carOwner.CarOwnerMessages;
break;
}
}
if (!isAlreadyInThere)
{
db.CarOwners.AddAsync(carOwner);
}
db.SaveChangesAsync();
}
}
public void Update(int ownerId, int carId)
{
var owner = db.Owners.Include(x => x.CarOwners).Where(x => x.Id == ownerId).FirstOrDefault();
foreach (var car in owner.CarOwners)
{
if (car.CarId == carId)
{
return;
}
}
//if(owner.CarOwners.)
var carOwner = new CarOwner()
{
Car = db.Cars.Find(carId),
Owner = db.Owners.Find(ownerId),
CarId = carId,
OwnerId = ownerId
};
owner.CarOwners.Add(carOwner);
this.Update(owner);
db.SaveChanges();
}
protected CarOwnerDetailViewModel ConvertCarOwnerToCarOwnerDetailViewModel(CarOwner carOwner)
{
return(new CarOwnerDetailViewModel()
{
FullName = carOwner.FullName
});
}
public async Task <IActionResult> Edit(CarOwnerUpdateDTO carOwnerUpdateDTO)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CarOwner carOwner = new CarOwner
{
Id = carOwnerUpdateDTO.Id,
CarId = carOwnerUpdateDTO.CarId,
OwnerId = carOwnerUpdateDTO.OwnerId
};
var result = await _carOwnerService.UpdateAsync(carOwner);
if (result == -1)
{
return(BadRequest("Error update"));
}
return(Ok(carOwner));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
static void Main(string[] args)
{
using (GIBDDContext db = new GIBDDContext())
{
// создаем два объекта User
Color user1 = new Color {
Name = "Синий"
};
Color user2 = new Color {
Name = "Чёрный"
};
CarOwner user3 = new CarOwner {
FIO = "Чёрный", PassportData = 123
};
//добавляем их в бд
db.Colors.Add(user1);
db.Colors.Add(user2);
db.CarOwners.Add(user3);
db.SaveChanges();
Console.WriteLine("Объекты успешно сохранены");
// получаем объекты из бд и выводим на консоль
var users = db.CarOwners;
Console.WriteLine("Список объектов:");
foreach (CarOwner c in users)
{
Console.WriteLine("{0}.{1}", c.Id, c.FIO);
}
}
Console.Read();
}
/// <summary>
/// 注册
/// </summary>
/// <param name="db"></param>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="registTime">内部测试使用的时间</param>
/// <returns>如果用户名已存在，返回null，否则返回注册后的用户对象</returns>
public async static Task <LoginOrRegisterResult> RegisterAsync(ParkContext db, string username, string password, DateTime registTime)
{
if (await db.CarOwners.AnyAsync(p => p.Username == username))
{
return(new LoginOrRegisterResult()
{
Type = LoginOrRegisterResultType.Existed
});
}
CarOwner carOwner = new CarOwner()
{
RegistTime = registTime,
LastLoginTime = registTime,
Username = username,
Password = CreateMD5(username + password),
Enabled = true,
};
db.Add(carOwner);
await db.SaveChangesAsync();
return(new LoginOrRegisterResult()
{
CarOwner = carOwner
});
}
private void BtnUpdateOwner_Click(object sender, RoutedEventArgs e)
{
if (!IsFieldValid())
{
return;
}
CarOwner ownerToUpdate = (CarOwner)lvGridCarOwner.SelectedItem;
try
{
ownerToUpdate.Name = txtName.Text;
ownerToUpdate.Photo = currOwnerImage;
/*Global.ctx.carOwners.Add(ownerToUpdate);
* Global.ctx.Entry(ownerToUpdate).State = System.Data.Entity.EntityState.Modified;*/
Global.ctx.SaveChanges();
// if updated information need to be displayed after clicking update button, then don't clear the form, just reset view.
ResetForm();
}
catch (SystemException exc)
{
MessageBox.Show(exc.Message, "Database operation failed", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public async Task <IActionResult> Edit(CarOwnerUpdateDTO carOwnerUpdateDTO)
{
try
{
if (ModelState.IsValid)
{
CarOwner carOwner = new CarOwner
{
Id = carOwnerUpdateDTO.Id,
CarId = carOwnerUpdateDTO.CarId,
OwnerId = carOwnerUpdateDTO.OwnerId
};
var result = await _carOwnerService.UpdateAsync(carOwner);
if (result == -1)
{
await GetSelected();
ModelState.AddModelError("", "Error update");
return(View(carOwnerUpdateDTO));
}
return(RedirectToAction("Index"));
}
await GetSelected();
return(View(carOwnerUpdateDTO));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="db"></param>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public async static Task <LoginOrRegisterResult> Login(ParkContext db, string username, string password)
{
//判断参数是否为空
if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password))
{
return(new LoginOrRegisterResult()
{
Type = LoginOrRegisterResultType.Empty
});
}
//寻找用户名与密码都匹配的用户
CarOwner carOwner = await db.CarOwners
.FirstOrDefaultAsync(p => p.Username == username && p.Password == CreateMD5(password));
if (carOwner == null)
{
//返回用户名或密码错误
return(new LoginOrRegisterResult()
{
Type = LoginOrRegisterResultType.Wrong
});
}
carOwner.LastLoginTime = DateTime.Now;
db.Entry(carOwner).State = EntityState.Modified;
//修改并保存用户信息
await db.SaveChangesAsync();
return(new LoginOrRegisterResult()
{
CarOwner = carOwner
});
}
public CarOwner AddCarOwner(string name, [ScopedService] ApplicationDbContext dbContext)
{
var carOwner = new CarOwner(name);
dbContext.CarOwners.Add(carOwner);
dbContext.SaveChanges();
return(carOwner);
}
public void Delete(int id)
{
CarOwner entry = _db.CarOwners.Find(id);
if (entry != null)
{
_db.CarOwners.Remove(entry);
}
}
private async void CreateCarOwner(object sender, EventArgs e)
{
var carOwner = new CarOwner();
var carOwnerDetailsPage = new CarOwnerDetailsPage
{
BindingContext = carOwner
};
await Navigation.PushAsync(carOwnerDetailsPage);
}
public void DeleteOwnerForCar(int carId, int ownerId)
{
CarOwner entry = _db.CarOwners.Where(x => x.CarId == carId && x.OwnerId == ownerId).FirstOrDefault();
if (entry != null)
{
_db.CarOwners.Remove(entry);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string name = ownerName.Text;
string surname = ownerLastName.Text;
string location = ownerLocation.Text;
string imageLink = ownerImage.Text;
CarOwner ownerToCheck = new CarOwner {
FirstName = name, LastName = surname, Location = location, Image = imageLink
};
if (ownerToCheck.CheckCredentials())
{
owner = new CarOwner {
FirstName = name, LastName = surname, Location = location, Image = imageLink
};
Close();
}
else
{
if (string.IsNullOrEmpty(ownerName.Text) || string.IsNullOrWhiteSpace(ownerName.Text))
{
ownerName.Background = Brushes.Red;
}
else
{
ownerName.Background = Brushes.White;
}
if (string.IsNullOrEmpty(ownerLastName.Text) || string.IsNullOrWhiteSpace(ownerLastName.Text))
{
ownerLastName.Background = Brushes.Red;
}
else
{
ownerLastName.Background = Brushes.White;
}
if (string.IsNullOrEmpty(ownerImage.Text) || string.IsNullOrWhiteSpace(ownerImage.Text) || !ownerImage.Text.StartsWith("http"))
{
ownerImage.Background = Brushes.Red;
}
else
{
ownerImage.Background = Brushes.White;
}
if (string.IsNullOrEmpty(ownerLocation.Text) || string.IsNullOrWhiteSpace(ownerLocation.Text))
{
ownerLocation.Background = Brushes.Red;
}
else
{
ownerLocation.Background = Brushes.White;
}
}
}
public async Task <ActionResult <CarOwner> > PostCarOwner(CarOwner carOwner)
{
_context.Update(carOwner);
await _context.SaveChangesAsync();
//_context.CarOwners.Update(carOwner);
//await _context.SaveChangesAsync();
return(CreatedAtAction("GetCarOwner", new { id = carOwner.Id }, carOwner));
}
public ActionResult Delete(int id)
{
CarOwner carOwner = db.CarOwner.Find(id);
if (carOwner == null)
{
return(HttpNotFound());
}
return(View(carOwner));
}
public void AddCar(Car car, CarOwner carOwner)
{
bool isAlreadyInThere = false;
using (var db = new AppDbContext())
{
foreach (var lokaleCarOwner in db.CarOwners)
{
if (lokaleCarOwner.KontactInfo == carOwner.KontactInfo)
{
isAlreadyInThere = true;
lokaleCarOwner.Name = carOwner.Name;
lokaleCarOwner.DrivingLicenceNumber = carOwner.DrivingLicenceNumber;
lokaleCarOwner.CarRegistrationNumber = carOwner.CarRegistrationNumber;
lokaleCarOwner.Cars = carOwner.Cars;
lokaleCarOwner.CarOwnerMessages = carOwner.CarOwnerMessages;
break;
}
}
if (!isAlreadyInThere)
{
db.CarOwners.AddAsync(carOwner);
}
isAlreadyInThere = false;
foreach (var lokaleCar in db.Cars)
{
if (lokaleCar.LicenceplateNumber == car.LicenceplateNumber)
{
isAlreadyInThere = true;
lokaleCar.Picture = car.Picture;
lokaleCar.HaveTowbar = car.HaveTowbar;
lokaleCar.Condition = car.Condition;
lokaleCar.IsReserved = car.IsReserved;
lokaleCar.Weight = car.Weight;
lokaleCar.Hight = car.Hight;
lokaleCar.Width = car.Width;
lokaleCar.Type = car.Type;
lokaleCar.Area = car.Area;
lokaleCar.PossibleToRentDays = car.PossibleToRentDays;
lokaleCar.DaysThatIsRented = car.DaysThatIsRented;
lokaleCar.CarRenter = car.CarRenter;
lokaleCar.CarOwner = car.CarOwner;
break;
}
}
if (!isAlreadyInThere)
{
db.CarOwners.AddAsync(carOwner);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
CarOwner carOwner = db.CarOwner.Find(id);
if (carOwner == null)
{
return(HttpNotFound());
}
db.CarOwner.Remove(carOwner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CreateCarForOwner(int ownerId, int CarId)
{
CarOwner item = new CarOwner
{
OwnerId = ownerId,
CarId = CarId
};
_carOwnerRepository.Create(item);
_carOwnerRepository.Save();
return(RedirectToAction("Cars", new { ownerId = ownerId }));
}
public async Task <IActionResult> Edit(CarOwner carOwner)
{
await GetSelected();
var model = new CarOwnerUpdateDTO
{
Id = carOwner.Id,
CarId = carOwner.CarId,
OwnerId = carOwner.OwnerId
};
return(View(model));
}
public ActionResult CreateOwnerForCar(int OwnerId, int carId)
{
CarOwner item = new CarOwner
{
OwnerId = OwnerId,
CarId = carId
};
_carOwnerRepository.Create(item);
_carOwnerRepository.Save();
return(RedirectToAction("Owners", new { id = carId }));
}
public CarsDialog(CarOwner carOwner)
{
InitializeComponent();
// load the car list from database
currentOwner = carOwner;
// carlist = (from c in Global.ctx.cars where c.Id == carOwner.Id select c).ToList<Car>();
lvGridCar.ItemsSource = currentOwner.CarsInGarage.ToList();
if (carOwner != null)
{
lblOwnerNameResult.Content = carOwner.Name;
txtMakeModel.Text = "";
}
}
public OwnerView(int?carOwnerID)
{
this.carOwnerID = carOwnerID;
InitializeComponent();
context = new DatabaseModel();
GetOwnerCars(context);
//Load info about owner
CarOwner carOwner = context.CarOwners.Find(carOwnerID);
ownerNameTitle.Content = $"{carOwner.FirstName} {carOwner.LastName}";
ownerLocation.Content = carOwner.Location;
ownerPhoto.Source = new BitmapImage(new Uri(carOwner.Image));
}
public ActionResult Create(CarOwner carOwner)
{
try
{
// TODO: Add insert logic here
db.CarOwners.Add(carOwner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task <ExtendCarOwner> Apply(CarOwner owner, ParkContext db)
{
ID = owner.ID;
Enabled = owner.Enabled;
Password = owner.Password;
Username = owner.Username;
IsFree = owner.IsFree;
Cars = owner.Cars;
TransactionRecords = owner.TransactionRecords;
Balance = await TransactionService.GetBalanceAsync(db, owner.ID);
RegistTime = owner.RegistTime;
LastLoginTime = owner.LastLoginTime;
return(this);
}
public ActionResult Delete(int id, CarOwner carOwner)
{
try
{
// TODO: Add delete logic here
carOwner = db.CarOwners.Where(c => c.ID == Id).FirstOrDefault();
db.CarOwners.Remove(carOwner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(Id));
}
}
public void AddCarOwnerMessage(CarOwnerMessage carOwnerMessage, CarOwner carOwner)
{
bool isAlreadyInThere = false;
using (var db = new AppDbContext())
{
foreach (var lokaleCarOwner in db.CarOwners)
{
if (lokaleCarOwner.KontactInfo == carOwner.KontactInfo)
{
isAlreadyInThere = true;
lokaleCarOwner.Name = carOwner.Name;
lokaleCarOwner.DrivingLicenceNumber = carOwner.DrivingLicenceNumber;
lokaleCarOwner.CarRegistrationNumber = carOwner.CarRegistrationNumber;
lokaleCarOwner.Cars = carOwner.Cars;
lokaleCarOwner.CarOwnerMessages = carOwner.CarOwnerMessages;
break;
}
}
if (!isAlreadyInThere)
{
db.CarOwners.AddAsync(carOwner);
}
isAlreadyInThere = false;
foreach (var localCarOwnerMessage in db.CarOwnerMessages)
{
if (localCarOwnerMessage.CarOwnerMessageid == carOwnerMessage.CarOwnerMessageid)
{
isAlreadyInThere = true;
localCarOwnerMessage.HaveBeenRejected = carOwnerMessage.HaveBeenRejected;
localCarOwnerMessage.HaveBeenSeen = carOwnerMessage.HaveBeenSeen;
localCarOwnerMessage.Commentary = carOwnerMessage.Commentary;
localCarOwnerMessage.Car = carOwnerMessage.Car;
localCarOwnerMessage.RentedFromTo = carOwnerMessage.RentedFromTo;
localCarOwnerMessage.CarOwner = carOwnerMessage.CarOwner;
break;
}
}
if (!isAlreadyInThere)
{
db.CarOwnerMessages.AddAsync(carOwnerMessage);
}
}
}
public ActionResult CreateOwner([FromBody] NewCarOwner ownerRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest("Model state not valid"));
}
var model = new CarOwner
{
CarId = ownerRequest.CarId,
Period = ownerRequest.Period,
Owner = ownerRequest.Owner,
OwnerContent = ownerRequest.OwnerContent,
};
_carService.AddCarOwner(model);
return(Ok($"Car owner created: {model.Owner}"));
}
private void BtnManage_Click(object sender, RoutedEventArgs e)
{
if (lvGridCarOwner.SelectedIndex == -1)
{
MessageBox.Show("Please choose an owner.");
return;
}
CarOwner coToManage = (CarOwner)lvGridCarOwner.SelectedItem;
CarsDialog cd = new CarsDialog(coToManage);
cd.Owner = this;
bool?result = cd.ShowDialog();
if (result == true)
{
lvGridCarOwner.Items.Refresh();
}
}
public void AddCarOwner(CarOwner carOwner)
{
if (CarOwners.Any(p => p.ID == carOwner.ID))
{
var co = CarOwners.First(p => p.ID == carOwner.ID);
co.Name = carOwner.Name;
co.Surname = carOwner.Surname;
co.SecondName = carOwner.SecondName;
co.Phone = carOwner.Phone;
co.Birthday = carOwner.Birthday;
}
else
{
iCarOwners++;
carOwner.ID = iCarOwners;
CarOwners.Add(carOwner);
}
fileDataAccess.SetModel(this);
}
public static void BindOwner(ComboBox cb, bool search)
{
cb.DropDownStyle = ComboBoxStyle.DropDownList;
ArrayList lists = FT.DAL.Orm.SimpleOrmOperator.QueryListAll(typeof(CarOwner));
if (search)
{
CarOwner owner = new CarOwner();
owner.Name = "--��ѡ��--";
owner.Id = -1;
lists.Add(owner);
}
if (lists.Count > 0)
{
//this.cbGroup
cb.DataSource = lists;
cb.DisplayMember = "����";
cb.ValueMember = "���";
cb.SelectedIndex = 0;
}
}
