public async Task <bool> UpdateDriver(DriverEntity driver)
{
var driverToUpdate = await _dbContext.Drivers.FirstOrDefaultAsync(v => v.Id == driver.Id);
_dbContext.Entry(driverToUpdate).CurrentValues.SetValues(driver);
return(true);
}
private void btnDeleteSelected_Click(object sender, EventArgs e)
{
List <DriverEntity> docsToDelete = new List <DriverEntity>();
foreach (DataGridViewRow row in dataGridDrivers.Rows)
{
DriverEntity doc = (DriverEntity)row.DataBoundItem;
if (Convert.ToBoolean(row.Cells[0].Value))
{
docsToDelete.Add(doc);
}
}
if (docsToDelete.Count() > 0)
{
if (MessageBox.Show("Are you sure you want to delete the " + docsToDelete.Count.ToString() + " selected driver(s)?", "Delete?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
BusyMessage.Show("Deleting...", this.FindForm());
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
uow.DriverRepository.BulkDelete(docsToDelete);
uow.SaveChanges();
}
BusyMessage.Close();
refresh();
}
}
else
{
MessageBox.Show("No records were selected to delete.");
}
}
public void CreateDriver(DriverEntity driverEntity)
{
if (driverEntity.Business != null)
{
_dbContext.Entry(driverEntity.Business).State = EntityState.Unchanged;
}
_dbContext.Drivers.Add(driverEntity);
}
public void Remove(DriverEntity entity)
{
DbConnection.ExecuteScalar($@"
DELETE FROM DriverEntitys
WHERE Id = {entity.Id}");
DbConnection.ExecuteScalar($@"
DELETE FROM LogEntitys
WHERE DriverId = {entity.Id}");
}
private static DriverDto ClientifyDriver(DriverEntity driver)
{
return(new DriverDto()
{
Id = driver.Id,
Name = driver.Name,
Address = driver.Address,
});
}
public DialogResult ShowEdit(DriverEntity doc)
{
driverObj = doc;
clearErrors();
tbFirstname.Text = doc.Firstname;
tbLastname.Text = doc.Lastname;
this.Text = "Update Driver";
return(this.ShowDialog());
}
private async void BtnAddDriver_Click(object sender, RoutedEventArgs e)
{
progressBar.Visibility = Visibility.Visible;
try
{
var selectedVehicle = comboVehicles.SelectedItem as VehicleEntity;
var driver = new DriverEntity
{
Firstname = txtFirstname.Text,
Address = txtAddress.Text,
DoB = GlobalHelpers.GetDate(txtDob.Text),
Lastname = txtLastname.Text,
UploadDate = DateTime.Now,
Phone = txtPhone.Text,
DriverStatus = Core.Enumerations.EnumStatus.Active,
VehicleId = selectedVehicle.Id
};
var userDriver = new UserEntity
{
Address = driver.Address,
DoB = driver.DoB,
UploadDate = driver.UploadDate,
Firstname = driver.Firstname,
Lastname = driver.Lastname,
Password = "******",
Role = Core.Enumerations.EnumRole.Driver,
Phone = driver.Phone
};
var response = await _httpClientService.PostAsync(userDriver, "Users/register");
if (response.IsSuccessStatusCode)
{
response = await _httpClientService.PostAsync(driver, "Drivers/add");
if (response.IsSuccessStatusCode)
{
MessageDialog messageDialog = new MessageDialog($"{driver.Firstname} {driver.Lastname} has been registered as driver");
await messageDialog.ShowAsync();
}
else
{
txtError.Text = await response.Content.ReadAsStringAsync();
}
}
else
{
txtError.Text = await response.Content.ReadAsStringAsync();
}
}
catch (Exception ex)
{
txtError.Text = ex.Message;
}
progressBar.Visibility = Visibility.Collapsed;
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
ResponderEntity.Configure(modelBuilder);
ResponderRouteEntity.Configure(modelBuilder);
RoutePointEntity.Configure(modelBuilder);
CityEntity.Configure(modelBuilder);
DriverEntity.Configure(modelBuilder);
VehicleEntity.Configure(modelBuilder);
ResponderRequestEntity.Configure(modelBuilder);
base.OnModelCreating(modelBuilder);
}
private LogEntity InsertLog(DriverEntity driver, string numberPlate, LogEntity enterLog, decimal?price, DateTime date)
{
var entity = new LogEntity()
{
DriverId = driver.Id,
ParentLogId = enterLog?.Id,
Price = price,
DateCreated = date
};
_logsDal.Insert(entity);
return(entity);
}
public async Task <DriverDto> CreateDriver(CreateDriverDto createDriverDto)
{
var toy = new DriverEntity()
{
Id = GetNewId(),
Name = createDriverDto.Name,
Address = createDriverDto.Address,
};
DriversTable.Rows.Add(toy);
await UpdateDatabase();
return(ClientifyDriver(toy));
}
public void Send(DriverEntity driver, LogEntity entry, LogEntity exit, decimal price)
{
MailMessage newMail = new MailMessage();
newMail.To.Add(driver.Email);
newMail.Subject = _mailSubject;
newMail.Body = string.Format(_mailBody, entry.DateCreated, exit.DateCreated, price.ToString("N2"));
newMail.From = new MailAddress(_emailAddress, _mailName);
newMail.IsBodyHtml = true;
SmtpClient smtpSender = new SmtpClient();
smtpSender.Credentials = new System.Net.NetworkCredential(_emailAddress, _emailPwd);
smtpSender.Port = _smtpPort;
smtpSender.Host = _smtpHost;
smtpSender.EnableSsl = true;
smtpSender.Send(newMail);
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
_userAuthDto = JsonConvert.DeserializeObject <UserAuthDto>(e.Parameter as string);
_userAuthDtoJson = JsonConvert.SerializeObject(_userAuthDto);
GlobalHelpers.HubConnection.On <RequestMatatuResponse>("RequestResponse", (requestReponse) =>
{
var res = requestReponse;
});
try
{
_httpClientService.SetAuthorizationHeaderToken(_httpClientService.HttpClient, _userAuthDto.Token);
_driverEntity = JsonConvert.DeserializeObject <DriverEntity>(await _httpClientService.GetAsync($"Drivers/getbyphone/{_userAuthDto.Phone}"));
}
catch (Exception ex)
{
MessageDialog messageDialog = new MessageDialog(ex.Message);
await messageDialog.ShowAsync();
}
}
private void btnEditSelected_Click(object sender, EventArgs e)
{
AddEditDriver dialog = new AddEditDriver();
DataGridViewRow row = null;
if (dataGridDrivers.SelectedRows.Count > 0)
{
row = dataGridDrivers.SelectedRows[0];
DriverEntity doc = (DriverEntity)row.DataBoundItem;
if (dialog.ShowEdit(doc) != DialogResult.Cancel)
{
refresh();
}
}
else
{
MessageBox.Show("Please select a row to edit.");
}
}
public async Task <DriverDto> UpdateDriver(UpdateDriverDto updateDriverDto)
{
var driverInd = GetDriverIndById(updateDriverDto.Id);
if (driverInd != -1)
{
var updatedDriver = new DriverEntity()
{
Id = updateDriverDto.Id,
Name = updateDriverDto.Name,
Address = updateDriverDto.Address,
};
DriversTable.Rows[driverInd] = updatedDriver;
await UpdateDatabase();
return(ClientifyDriver(updatedDriver));
}
else
{
throw new DatabaseException("Такой водитель не найден");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
DriverEntity existingDriver = null;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork()) {
if (driverObj == null)
{
existingDriver = new DriverEntity();
}
else
{
existingDriver = uow.DriverRepository.GetById(driverObj.Id);
}
existingDriver.Firstname = tbFirstname.Text.Trim();
existingDriver.Lastname = tbLastname.Text.Trim();
existingDriver.Name = string.Format("{0} {1}", existingDriver.Firstname, existingDriver.Lastname);
uow.DriverRepository.Save(existingDriver);
uow.SaveChanges();
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public void Insert(DriverEntity entity)
{
entity.DateCreated = DateTime.Now;
DbConnection.Insert(entity);
}
