public TableAdjustment EditTrains(LatticeData <Train, Train> latticeData, Train trainRow)
{
Train train = _context.Trains
.FirstOrDefault(x => x.TrainId == trainRow.TrainId);
if (train == null)
{
train = new Train()
{
TrainId = trainRow.TrainId
};
_context.Trains.Add(train);
}
try
{
_context.SaveChanges();
}
catch (Exception e)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", $"Save exception: {e.Message}"))
));
}
trainRow.TrainId = train.TrainId;
return(latticeData.Adjust(x => x
.UpdateRow(trainRow)
.Message(LatticeMessage.User("success", "Editing", "Train saved"))
));
}
public TableAdjustment EditStaton(LatticeData <Station, Station> latticeData, Station stationRow)
{
Station station = _context.Stations
.FirstOrDefault(x => x.StationId == stationRow.StationId);
if (station == null)
{
station = new Station()
{
StationId = stationRow.StationId
};
_context.Stations.Add(station);
}
try
{
station.StationName = stationRow.StationName;
_context.SaveChanges();
}
catch (Exception e)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", $"Save exception: {e.Message}"))
));
}
stationRow.StationId = station.StationId;
return(latticeData.Adjust(x => x
.UpdateRow(stationRow)
.Message(LatticeMessage.User("success", "Editing", "Station saved"))
));
}
private TableAdjustment EditOrCreate(LatticeData <TodoListEntry, TodoListEntry> latticeData)
{
var data = GetData();
var confirmation = latticeData.CommandConfirmation <TodoListEntryCreateEditViewModel>();
TodoListEntry entry = null;
if (confirmation.Id == null)
{
entry = new TodoListEntry()
{
Date = DateTime.Now,
Icon = confirmation.Icon,
Id = Guid.NewGuid(),
Text = confirmation.Text
};
data.Add(entry);
return(latticeData.Adjust(x => x
.UpdateSource(entry)
.Message(LatticeMessage.User("success", "Created", "New ToDo entry created"))));
}
entry = data.FirstOrDefault(c => c.Id == confirmation.Id);
entry.Date = DateTime.Now;
entry.Text = confirmation.Text;
entry.Icon = confirmation.Icon;
return(latticeData.Adjust(x => x
.UpdateSource(entry)
.Message(LatticeMessage.User("success", "Updated", "ToDo entry updated"))));
}
public TableAdjustment EditRoute(LatticeData <Route, Route> latticeData, Route routeRow)
{
Route route = _context.Routes.FirstOrDefault(x => x.RouteId == routeRow.RouteId);
if (route == null)
{
route = new Route()
{
RouteId = routeRow.RouteId
};
_context.Routes.Add(route);
}
else
{
route = _context.Routes
.FirstOrDefault(x => x.RouteId == routeRow.RouteId);
}
try
{
route.RouteName = routeRow.RouteName;
_context.SaveChanges();
}
catch (Exception e)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", $"Save exception: {e.Message}"))
));
}
routeRow.RouteId = route.RouteId;
return(latticeData.Adjust(x => x
.UpdateRow(routeRow)
.Message(LatticeMessage.User("success", "Editing", "Route saved"))
));
}
public TableAdjustment EditTrainsStaffMember(LatticeData <Employee, EmployeeRow> latticeData,
EmployeeRow employeeRow)
{
if (string.IsNullOrEmpty(employeeRow.UserId))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", "Can not create create new employee from here"))
));
}
Employee employee = _context.Employees
.FirstOrDefault(x => x.UserId == employeeRow.UserId);
if (employee == null)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", "Can not find employee"))
));
}
employee.TrainId = employeeRow.TrainId;
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Update(employeeRow)
.Message(LatticeMessage.User("success", "Editing", "Employee saved"))
));
}
public TableAdjustment EditRoutePoint(LatticeData <RoutePoint, RoutePointRow> latticeData,
RoutePointRow routePointRow, int routeId)
{
RoutePoint routePoint;
if (routePointRow.RouteId == 0)
{
routePoint = new RoutePoint
{
RouteId = routeId,
StationOrder = _context.RoutePoints.Where(x => x.RouteId == routeId)
.Select(x => x.StationOrder)
.DefaultIfEmpty(0)
.Max() + 1
};
_context.RoutePoints.Add(routePoint);
}
else
{
routePoint = _context.RoutePoints
.FirstOrDefault(x => x.RouteId == routePointRow.RouteId &&
x.StationOrder == routePointRow.StationOrder);
}
Station station = _context.Stations.FirstOrDefault(x => x.StationName == routePointRow.StationName);
if (station == null)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"There is no station with name {routePointRow.StationName}"))
));
}
if (_context.RoutePoints.Any(x => x.RouteId == routeId &&
x.StationOrder != routePoint.StationOrder &&
x.Station.StationId == station.StationId))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"The route already has station {station.StationName}"))
));
}
routePoint.Station = station;
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Update(routePoint)
.Message(LatticeMessage.User("success", "Editing", "Route saved"))
));
}
public TableAdjustment EditQueue(LatticeData <PhoneInstallationQueue, PhoneInstallationQueueRow> latticeData, PhoneInstallationQueueRow queueRow)
{
PhoneInstallationQueue currentQueue = null;
if (queueRow.Id == 0)
{
currentQueue = new PhoneInstallationQueue();
_context.PhoneInstallationQueues.Add(currentQueue);
}
else
{
currentQueue = _context.PhoneInstallationQueues.FirstOrDefault(x => x.Id == queueRow.Id);
}
currentQueue.AtsUserId = queueRow.UserId;
_context.SaveChanges();
queueRow.Id = currentQueue.Id;
queueRow.UserName = _context.AtsUsers
.Where(user => user.Id == queueRow.UserId)
.Select(user => user.Person.Name)
.FirstOrDefault();
queueRow.UserSurname = _context.AtsUsers
.Where(user => user.Id == queueRow.UserId)
.Select(user => user.Person.Surname)
.FirstOrDefault();
return(latticeData.Adjust(x => x
.Update(queueRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
public TableAdjustment EditAddress(LatticeData <Address, AddressRow> latticeData, AddressRow addressRow)
{
Address currentAddress = null;
if (addressRow.Id == 0)
{
currentAddress = new Address();
_context.Addresses.Add(currentAddress);
}
else
{
currentAddress = _context.Addresses.FirstOrDefault(address => address.Id == addressRow.Id);
}
currentAddress.FlatNumber = addressRow.FlatNumber;
currentAddress.HouseNumber = addressRow.HouseNumber;
currentAddress.Index = addressRow.Index;
currentAddress.Locality = addressRow.Locality;
currentAddress.Street = addressRow.Street;
_context.SaveChanges();
addressRow.Id = currentAddress.Id;
return(latticeData.Adjust(wrapper => wrapper
.Update(addressRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
// public TableAdjustment UpdateRow(LatticeData<Person, PersonRow> latticeData)
// {
// return latticeData.Adjust(x => x.Build());
// }
public TableAdjustment EditPerson(LatticeData <Person, PersonRow> latticeData, PersonRow personRow)
{
Person currentPerson = null;
if (personRow.Id == 0)
{
currentPerson = new Person();
_context.Persons.Add(currentPerson);
}
else
{
currentPerson = _context.Persons.FirstOrDefault(x => x.Id == personRow.Id);
}
currentPerson.Age = personRow.Age;
currentPerson.Gender = personRow.Gender;
currentPerson.Name = personRow.Name;
currentPerson.Surname = personRow.Surname;
currentPerson.Middlename = personRow.Middlename;
_context.SaveChanges();
personRow.Id = currentPerson.Id;
return(latticeData.Adjust(x => x
.Update(personRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
public TableAdjustment EditPhoneCall(LatticeData <PhoneHistory, PhoneHistoryRow> latticeData, PhoneHistoryRow phoneCallRow)
{
PhoneHistory phoneCall = null;
if (phoneCallRow.Id == 0)
{
phoneCall = new PhoneHistory();
_context.PhoneHistories.Add(phoneCall);
}
else
{
phoneCall = _context.PhoneHistories.FirstOrDefault(history => history.Id == phoneCallRow.Id);
}
phoneCall.PhoneNumberId = phoneCallRow.PhoneNumberId;
phoneCall.PhoneDate = phoneCallRow.PhoneDate;
phoneCall.Duration = phoneCallRow.Duration;
phoneCall.Caller = phoneCallRow.Caller;
phoneCall.CallerCity = phoneCallRow.CallerCity;
phoneCall.Callee = phoneCallRow.Callee;
phoneCall.CalleeCity = phoneCallRow.CalleeCity;
_context.SaveChanges();
phoneCallRow.Id = phoneCall.Id;
phoneCallRow.PhoneNumber = _context.PhoneNumbers
.Where(number => number.Id == phoneCallRow.PhoneNumberId).Select(number => number.Number)
.FirstOrDefault();
return(latticeData.Adjust(wrapper => wrapper
.Update(phoneCallRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
public TableAdjustment EditPerson(LatticeData <UserAccounting, UserAccountingRow> latticeData, UserAccountingRow userBillRow)
{
UserAccounting currentUserBill = null;
if (userBillRow.Id == 0)
{
currentUserBill = new UserAccounting();
_context.UserAccountings.Add(currentUserBill);
}
else
{
currentUserBill = _context.UserAccountings.FirstOrDefault(x => x.Id == userBillRow.Id);
}
currentUserBill.AtsUserId = userBillRow.UserId;
currentUserBill.Total = userBillRow.Total;
_context.SaveChanges();
userBillRow.Id = currentUserBill.Id;
userBillRow.UserName = _context.AtsUsers
.Where(user => user.Id == userBillRow.UserId)
.Select(user => user.Person.Name)
.FirstOrDefault();
userBillRow.UserSurname = _context.AtsUsers
.Where(user => user.Id == userBillRow.UserId)
.Select(user => user.Person.Surname)
.FirstOrDefault();
return(latticeData.Adjust(x => x
.Update(userBillRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
public TableAdjustment EditAts(LatticeData <Ats, AtsRow> latticeData, AtsRow atsRow)
{
Ats currentATS = null;
if (atsRow.Id == 0)
{
currentATS = new Ats();
_context.AtsStations.Add(currentATS);
}
else
{
currentATS = _context.AtsStations.FirstOrDefault(ats => ats.Id == atsRow.Id);
}
currentATS.CityAtsAttributesId = atsRow.CityAtsAttributesId;
currentATS.DepartmentalAtsAttributesId = atsRow.DepartmentalAtsAttributesId;
currentATS.InstitutionalAtsAttributesId = atsRow.InstitutionalAtsAttributesId;
currentATS.AtsType = atsRow.AtsType;
_context.SaveChanges();
atsRow.Id = currentATS.Id;
return(latticeData.Adjust(wrapper => wrapper
.Update(atsRow)
// .Message(LatticeMessage.AtsUser("success", "Editing", "Person saved!"))
));
}
public TableAdjustment EditTrip(LatticeData <Trip, TripRow> latticeData, TripRow tripRow)
{
Trip trip;
if (tripRow.TripId == 0)
{
trip = new Trip();
_context.Trips.Add(trip);
}
else
{
trip = _context.Trips
.FirstOrDefault(x => x.TripId == tripRow.TripId);
}
//на всякий случай(по идее, если сделано через форму то никогда не сработает)
if (!_context.Routes.Any(x => x.RouteId == tripRow.RouteId))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"There is no route with id {tripRow.RouteId}"))
));
}
if (!_context.Trains.Any(x => x.TrainId == tripRow.TrainId))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"There is no train with id {tripRow.TrainId}"))
));
}
trip.RouteId = tripRow.RouteId;
trip.TrainId = tripRow.TrainId;
_context.SaveChanges();
var mpd = latticeData.Configuration.MapRange(latticeData.Source.Where(t => t.TripId == trip.TripId));
return(latticeData.Adjust(x => x
.Update(mpd)
.Message(LatticeMessage.User("success", "Editing", "Trip saved"))
));
}
private TableAdjustment Complete(LatticeData <TodoListEntry, TodoListEntry> latticeData)
{
try
{
var data = GetData();
var subj = latticeData.CommandSubject();
var entry = data.FirstOrDefault(c => c.Id == subj.Id);
data.Remove(entry);
var msg = string.Format("'{0}' task successfulyl completed", entry.Text);
return(latticeData.Adjust(x => x.RemoveExact(entry)
.Message(LatticeMessage.User("success", "Completed", msg))));
}
catch (Exception e)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("error", "Error", e.Message))));
}
}
public TableAdjustment RemoveRole(LatticeData <Employee, EmployeeRow> latticeData)
{
var comandModel = latticeData.CommandConfirmation <TargetRoleCommandViewModel>();
var subj = latticeData.CommandSubject();
var employee = _context.Employees.FirstOrDefault(x => x.UserId == subj.UserId);
_userManager.RemoveFromRole(employee.UserId, comandModel.TargetRole);
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("success", "Remove", "Role was removed"))
));
}
public TableAdjustment EditRoutePoint(LatticeData <RoutePoint, RoutePoint> latticeData,
RoutePoint routePointRow)
{
RoutePoint routePoint = _context.RoutePoints
.FirstOrDefault(x => x.RouteId == routePointRow.RouteId &&
x.StationOrder == routePointRow.StationOrder);
if (routePoint == null)
{
routePoint = new RoutePoint
{
RouteId = routePointRow.RouteId,
StationOrder = routePointRow.StationOrder
};
_context.RoutePoints.Add(routePoint);
}
else
{
routePoint = _context.RoutePoints
.FirstOrDefault(x =>
x.RouteId == routePointRow.RouteId && x.StationOrder == routePointRow.StationOrder);
}
try
{
routePoint.StationId = routePointRow.StationId;
_context.SaveChanges();
}
catch (Exception e)
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing", $"Save exception: {e.Message}"))
));
}
return(latticeData.Adjust(x => x
.UpdateRow(routePointRow)
.Message(LatticeMessage.User("success", "Editing", "RoutePoint saved"))
));
}
public TableAdjustment RemoveTripPoint(LatticeData <TripPoint, TripPointForRow> latticeData)
{
var subj = latticeData.CommandSubject();
if (_context.TripPoints.Any(x => x.TripId == subj.TripId && x.StationOrder == subj.StationOrder + 1))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Remove", "Can not delete point from the middle of route"))
));
}
var tripPoint = _context.TripPoints
.FirstOrDefault(x => x.TripId == subj.TripId && x.StationOrder == subj.StationOrder);
_context.TripPoints.Remove(tripPoint);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
.Message(LatticeMessage.User("success", "Remove", "RoutePoint removed"))
));
}
public TableAdjustment RemoveTrip(LatticeData <Trip, TripRow> latticeData)
{
var subj = latticeData.CommandSubject();
var trip = _context.Trips.FirstOrDefault(x => x.TripId == subj.TripId);
_context.Trips.Remove(trip);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
.Message(LatticeMessage.User("success", "Remove", "Trip removed"))
));
}
public TableAdjustment RemoveRoute(LatticeData <Route, RouteRow> latticeData)
{
var subj = latticeData.CommandSubject();
var route = _context.Routes.FirstOrDefault(x => x.RouteId == subj.RouteId);
_context.Routes.Remove(route);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
.Message(LatticeMessage.User("success", "Remove", "Route removed"))
));
}
public TableAdjustment RemoveStation(LatticeData <Station, Station> latticeData)
{
var subj = latticeData.CommandSubject();
var station = _context.Stations.FirstOrDefault(x => x.StationId == subj.StationId);
_context.Stations.Remove(station);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.RemoveExact(subj)
.Message(LatticeMessage.User("success", "Remove", "Station removed"))
));
}
public TableAdjustment EditTrip(LatticeData <Trip, Trip> latticeData, Trip tripRow)
{
Trip trip;
if (tripRow.TripId == 0)
{
trip = new Trip();
_context.Trips.Add(trip);
}
else
{
trip = _context.Trips.FirstOrDefault(x => x.TripId == tripRow.TripId);
}
if (!(_context.Routes.Any(x => x.RouteId == tripRow.RouteId)))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"There is no route with id {tripRow.RouteId}"))
));
}
if (!(_context.Trains.Any(x => x.TrainId == tripRow.TrainId)))
{
return(latticeData.Adjust(x => x
.Message(LatticeMessage.User("failure", "Editing",
$"There is no train with id {tripRow.TrainId}"))
));
}
trip.RouteId = trip.RouteId;
trip.TrainId = tripRow.TrainId;
_context.SaveChanges();
tripRow.TripId = trip.TripId;
return(latticeData.Adjust(x => x
.UpdateRow(tripRow)
.Message(LatticeMessage.User("success", "Editing", "Trip saved"))
));
}
public TableAdjustment RemoveEmployee(LatticeData <Employee, EmployeeRow> latticeData)
{
var subj = latticeData.CommandSubject();
var employee = _context.Employees.FirstOrDefault(x => x.UserId == subj.UserId);
_userManager.Delete(employee.ApplicationUser);
//_context.Employees.Remove(employee); удаляеться из за зависимости от usera
// _context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
.Message(LatticeMessage.User("success", "Remove", "Employee removed"))
));
}
public TableAdjustment RemoveTripPoint(LatticeData <TripPoint, TripPoint> latticeData)
{
var subj = latticeData.CommandSubject();
var tripPoint = _context.TripPoints
.FirstOrDefault(x => x.TripId == subj.TripId && x.StationOrder == subj.StationOrder);
_context.TripPoints.Remove(tripPoint);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.RemoveExact(subj)
.Message(LatticeMessage.User("success", "Remove", "RoutePoint removed"))
));
}
public TableAdjustment RemoveSelected(LatticeData <CityAtsAttributes, CityATSAttributesRow> latticeData)
{
var selectedRows = latticeData.Selection().ToArray();
var selectedAttributesIds = selectedRows.Select(x => x.Id);
var ids = string.Join(",", selectedAttributesIds);
_context.Database.ExecuteSqlCommand($"DELETE FROM CityAtsAttributes WHERE Id IN ({ids})");
return(latticeData.Adjust(x => x
.Remove(selectedRows)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"{selectedRows.Length} orders removed!"))
));
}
public TableAdjustment RemoveSelected(LatticeData <Address, AddressRow> latticeData)
{
var selectedRows = latticeData.Selection().ToArray();
var selectedAddressIds = selectedRows.Select(row => row.Id);
var ids = string.Join(",", selectedAddressIds);
_context.Database.ExecuteSqlCommand($"DELETE FROM Addresses WHERE Id IN ({ids})");
return(latticeData.Adjust(wrapper => wrapper
.Remove(selectedRows)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"{selectedRows.Length} orders removed!"))
));
}
public TableAdjustment Remove(LatticeData <UserAccounting, UserAccountingRow> latticeData)
{
var confirmationData = latticeData.CommandConfirmation <RemovalConfirmationViewModel>();
var subj = latticeData.CommandSubject();
var userBill = _context.UserAccountings.FirstOrDefault(x => x.Id == subj.Id);
_context.UserAccountings.Remove(userBill);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"Order removed because of {confirmationData.Cause}"))
));
}
public TableAdjustment Remove(LatticeData <CityAtsAttributes, CityATSAttributesRow> latticeData)
{
var confirmationData = latticeData.CommandConfirmation <RemovalConfirmationViewModel>();
var subj = latticeData.CommandSubject();
var cityATSAttributes = _context.CityAtsAttributes.FirstOrDefault(x => x.Id == subj.Id);
_context.CityAtsAttributes.Remove(cityATSAttributes);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"Order removed because of {confirmationData.Cause}"))
));
}
public TableAdjustment Remove(LatticeData <Address, AddressRow> latticeData)
{
var confirmationData = latticeData.CommandConfirmation <RemovalConfirmationViewModel>();
var subject = latticeData.CommandSubject();
var address = _context.Addresses.FirstOrDefault(address1 => address1.Id == subject.Id);
_context.Addresses.Remove(address);
_context.SaveChanges();
return(latticeData.Adjust(wrapper => wrapper
.Remove(subject)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"Order removed because of {confirmationData.Cause}"))
));
}
public TableAdjustment Remove(LatticeData <PhoneInstallationQueue, PhoneInstallationQueueRow> latticeData)
{
var confirmationData = latticeData.CommandConfirmation <RemovalConfirmationViewModel>();
var subj = latticeData.CommandSubject();
var queue = _context.PhoneInstallationQueues.FirstOrDefault(x => x.Id == subj.Id);
_context.PhoneInstallationQueues.Remove(queue);
_context.SaveChanges();
return(latticeData.Adjust(x => x
.Remove(subj)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"Order removed because of {confirmationData.Cause}"))
));
}
public TableAdjustment Remove(LatticeData <PhoneNumber, PhoneNumberRow> latticeData)
{
var confirmationData = latticeData.CommandConfirmation <RemovalConfirmationViewModel>();
var subject = latticeData.CommandSubject();
var phoneNumber = _context.PhoneNumbers.FirstOrDefault(number => number.Id == subject.Id);
_context.PhoneNumbers.Remove(phoneNumber);
_context.SaveChanges();
return(latticeData.Adjust(wrapper => wrapper
.Remove(subject)
// .Message(LatticeMessage.AtsUser("success", "Remove", $"Order removed because of {confirmationData.Cause}"))
));
}
