public List <Document> GetDocuments(Document query)
{
var documents = new List <Document>();
using (var context = new KatDataContext())
{
List <CodeFirstModels.Document> result;
if (!string.IsNullOrEmpty(query.RegNumber))
{
result = context.Documents.Where(d => d.RegNumber.Contains(query.RegNumber)).ToList();
}
else if (query.Driver != null)
{
result = context.Documents.Where(d =>
(query.RegNumber == string.Empty || d.RegNumber.Contains(query.RegNumber)) &&
(query.Driver.FirstName == string.Empty || d.Driver.FirstName.Contains(query.Driver.FirstName)) &&
(query.Driver.SecondName == string.Empty || d.Driver.SecondName.Contains(query.Driver.SecondName)) &&
(query.Driver.LastName == string.Empty || d.Driver.SecondName.Contains(query.Driver.LastName))).ToList();
}
else
{
result = context.Documents.ToList();
}
if (result.Any())
{
result.ForEach(d => documents.Add(mapper.Map <Document>(d)));
}
return(documents);
}
}
public User Login(string username, string password)
{
CodeFirstModels.User user;
try
{
using (var db = new KatDataContext())
{
user = db.Users.FirstOrDefault(u => u.Username == username && u.Password == password);
}
}
catch (DataException datEx)
{
return(null);
}
if (user == null)
{
return(null);
}
return(new User
{
Username = user.Username,
IsAdmin = user.IsAdmin,
FullName = user.FullName
});
}
public List <Policeman> GetPolicemen()
{
var policemen = new List <Policeman>();
using (var context = new KatDataContext())
{
var result = context.Policemеn.ToList();
result.ForEach(r => policemen.Add(mapper.Map <Policeman>(r)));
return(policemen);
}
}
public List <Nomenclature> GetDocTypes()
{
var docTypes = new List <Nomenclature>();
using (var context = new KatDataContext())
{
var result = context.DocumentTypes.ToList();
result.ForEach(r => docTypes.Add(mapper.Map <Nomenclature>(r)));
return(docTypes);
}
}
public List <Camera> GetCameras()
{
var cameras = new List <Camera>();
using (var context = new KatDataContext())
{
var result = context.Cameras.ToList();
result.ForEach(r => cameras.Add(mapper.Map <Camera>(r)));
return(cameras);
}
}
public List <Nomenclature> GetRanks()
{
var ranks = new List <Nomenclature>();
using (var context = new KatDataContext())
{
var result = context.Ranks.ToList();
result.ForEach(r => ranks.Add(mapper.Map <Nomenclature>(r)));
return(ranks);
}
}
public List <Violation> GetViolations()
{
var violations = new List <Violation>();
using (var context = new KatDataContext())
{
var result = context.Violations.ToList();
result.ForEach(r => violations.Add(mapper.Map <Violation>(r)));
return(violations);
}
}
public bool DeleteDocument(long id)
{
using (var context = new KatDataContext())
{
var delete = context.Documents.FirstOrDefault(d => d.Id == id);
if (delete != null)
{
context.Documents.Remove(delete);
context.SaveChanges();
return(true);
}
return(false);
}
}
public List <Driver> GetAllDrivers()
{
try
{
var drivers = new List <Driver>();
using (var context = new KatDataContext())
{
var result = context.Drivers.ToList();
result.ForEach(r => drivers.Add(mapper.Map <Driver>(r)));
return(drivers);
}
}
catch (Exception e)
{
return(new List <Driver>());
}
}
public bool AddCamera(Camera camera)
{
try
{
var insertCamera = mapper.Map <CodeFirstModels.Nomenclatures.Camera>(camera);
using (var context = new KatDataContext())
{
context.Cameras.Add(insertCamera);
context.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public long AddDriver(Driver driver)
{
try
{
var dbDriver = Mapper.Map <CodeFirstModels.Driver>(driver);
using (var context = new KatDataContext())
{
context.Drivers.Add(dbDriver);
context.SaveChanges();
}
return(dbDriver.Id);
}
catch (Exception)
{
return(0);
}
}
public bool AddPoliceman(Policeman policeman)
{
try
{
var insertPoliceman = mapper.Map <CodeFirstModels.Policeman>(policeman);
using (var context = new KatDataContext())
{
context.Policemеn.Add(insertPoliceman);
context.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool DeleteCar(long id)
{
try
{
using (var context = new KatDataContext())
{
var removeCar = context.Cars.FirstOrDefault(c => c.Id == id);
context.Cars.Remove(removeCar);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool DeleteViolation(long id)
{
try
{
using (var context = new KatDataContext())
{
var removeViolation = context.Violations.FirstOrDefault(v => v.Id == id);
context.Violations.Remove(removeViolation);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public long AddCar(Car car)
{
try
{
var insertCar = Mapper.Map <CodeFirstModels.Car>(car);
using (var context = new KatDataContext())
{
context.Cars.Add(insertCar);
context.SaveChanges();
}
return(insertCar.Id);
}
catch (Exception)
{
return(0);
}
}
public bool AddViolation(Violation violation)
{
try
{
var insertViolation = mapper.Map <CodeFirstModels.Nomenclatures.Violation>(violation);
using (var context = new KatDataContext())
{
context.Violations.Add(insertViolation);
context.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool UpdateCar(Car car)
{
try
{
var updateCar = Mapper.Map <CodeFirstModels.Car>(car);
using (var context = new KatDataContext())
{
var dbRecord = context.Cars.FirstOrDefault(d => d.Id == car.Id);
PropertyCopy.Copy(updateCar, dbRecord);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateViolation(Violation violation)
{
try
{
var updateViolation = mapper.Map <CodeFirstModels.Nomenclatures.Violation>(violation);
using (var context = new KatDataContext())
{
var dbRecord = context.Violations.FirstOrDefault(v => v.Id == violation.Id);
PropertyCopy.Copy(updateViolation, dbRecord);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateCamera(Camera camera)
{
try
{
var updateCamera = mapper.Map <CodeFirstModels.Nomenclatures.Camera>(camera);
using (var context = new KatDataContext())
{
var dbRecord = context.Cameras.FirstOrDefault(v => v.Id == camera.Id);
PropertyCopy.Copy(updateCamera, dbRecord);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public List <Car> GetCars()
{
try
{
var cars = new List <Car>();
using (var context = new KatDataContext())
{
var result = context.Cars.ToList();
result.ForEach((r) =>
{
cars.Add((Mapper.Map <Car>(r)));
cars.Last().Brand = Mapper.Map <Nomenclature>(r.Model.Brand);
});
return(cars);
}
}
catch (Exception e)
{
return(new List <Car>());
}
}
public bool UpdatePoliceman(Policeman policeman)
{
try
{
var updatePoliceman = mapper.Map <CodeFirstModels.Policeman>(policeman);
using (var context = new KatDataContext())
{
//var dbRecord = context.Policemеn.FirstOrDefault(v => v.Id == policeman.Id);
//PropertyCopy.Copy(updatePoliceman, dbRecord);
var docInDb = context.Policemеn.Find(updatePoliceman.Id);
if (docInDb == null)
{
context.Policemеn.Add(updatePoliceman);
context.SaveChanges();
return(true);
}
if (updatePoliceman.Rank != null)
{
context.Ranks.Attach(updatePoliceman.Rank);
docInDb.Rank = updatePoliceman.Rank;
}
context.Entry(docInDb).CurrentValues.SetValues(updatePoliceman);
context.Entry(docInDb).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public long InsertDocument(Document document)
{
try
{
var insertDocument = mapper.Map <CodeFirstModels.Document>(document);
using (var context = new KatDataContext())
{
var newDoc = new CodeFirstModels.Document
{
Date = insertDocument.Date,
Picture = insertDocument.Picture,
RegNumber = insertDocument.RegNumber
};
context.Documents.Add(newDoc);
// Attach props:
if (insertDocument.Driver != null)
{
insertDocument.Driver.Cars = null;
context.Drivers.Attach(insertDocument.Driver);
newDoc.Driver = insertDocument.Driver;
}
if (insertDocument.Violations != null && insertDocument.Violations.Any())
{
insertDocument.Violations.ToList().ForEach(v => context.Violations.Attach(v));
newDoc.Violations = insertDocument.Violations;
}
if (insertDocument.Camera != null)
{
context.Cameras.Attach(insertDocument.Camera);
newDoc.Camera = insertDocument.Camera;
}
if (insertDocument.Policeman != null)
{
context.Policemеn.Attach(insertDocument.Policeman);
newDoc.Policeman = insertDocument.Policeman;
}
if (insertDocument.DocumentType != null)
{
context.DocumentTypes.Attach(insertDocument.DocumentType);
newDoc.DocumentType = insertDocument.DocumentType;
}
//var docInDb = context.Documents.Find(insertDocument.Id);
//if (docInDb == null)
//{
// insertDocument.Driver.Cars.ToList().ForEach(c => c.Driver = null);
// context.Documents.Add(insertDocument);
// context.SaveChanges();
// return insertDocument.Id;
//}
//context.Entry(docInDb).CurrentValues.SetValues(insertDocument);
//context.Entry(docInDb).State = EntityState.Modified;
context.SaveChanges();
return(newDoc.Id);
}
}
catch (Exception e)
{
return(0);
}
}
public bool UpdateDocument(Document document)
{
try
{
var updateDocument = mapper.Map <CodeFirstModels.Document>(document);
using (var context = new KatDataContext())
{
var result = context.Documents.Where(d => d.RegNumber == updateDocument.RegNumber).ToList();
if (result.Count != 1)
{
return(false);
}
var recordToUpdate = result.FirstOrDefault();
// Attach props:
if (updateDocument.Driver != null)
{
// context.Cars.ToList().FindAll(c => c.Driver.Id == updateDocument.Driver.Id).ToList()
updateDocument.Driver.Cars = null;
context.Drivers.Attach(updateDocument.Driver);
recordToUpdate.Driver = updateDocument.Driver;
}
if (updateDocument.Violations != null && updateDocument.Violations.Any())
{
updateDocument.Violations.ToList().ForEach(v => context.Violations.Attach(v));
recordToUpdate.Violations = new List <CodeFirstModels.Nomenclatures.Violation>();
updateDocument.Violations.ToList().ForEach(v => recordToUpdate.Violations.Add(v));
}
if (updateDocument.Camera != null)
{
context.Cameras.Attach(updateDocument.Camera);
recordToUpdate.Camera = updateDocument.Camera;
}
if (updateDocument.Policeman != null)
{
context.Policemеn.Attach(updateDocument.Policeman);
recordToUpdate.Policeman = updateDocument.Policeman;
}
if (updateDocument.DocumentType != null)
{
context.DocumentTypes.Attach(updateDocument.DocumentType);
recordToUpdate.DocumentType = updateDocument.DocumentType;
}
if (updateDocument.Picture != null)
{
recordToUpdate.Picture = updateDocument.Picture;
}
recordToUpdate.Id = updateDocument.Id;
recordToUpdate.RegNumber = updateDocument.RegNumber;
//var docInDb = context.Documents.Find(updateDocument.Id);
//// Activity does not exist in database and it's new one
//if (docInDb == null)
//{
// context.Documents.Add(updateDocument);
// context.SaveChanges();
// return true;
//}
//// Activity already exist in database and modify it
//context.Entry(docInDb).CurrentValues.SetValues(updateDocument);
//context.Entry(docInDb).State = EntityState.Modified;
context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
