public List <ActBase> GetActs(Token token, int count, int offset)
{
if (!Token.Exists(token))
{
return(null);
}
using (var db = new DzoContext())
{
//try
//{
// ActBase act;
// act = new PhotoTable { Id = 5 };
// db.Acts.Attach(act);
// db.Acts.Remove(act);
// db.SaveChanges();
//}
//catch (Exception e)
//{
//}
if (token.UserRegion == Region.All)
{
return(db.Acts.OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
return(db.Acts.Where(x => x.Region == token.UserRegion).OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
}
public bool AddUser(string adminPassword, User user)
{
try
{
using (var db = new DzoContext())
{
if (db.Users.First(x => x.Login == "admin").Password == adminPassword)
{
if (!db.Users.Any(x => x.Login == user.Login))
{
db.Users.Add(user);
db.SaveChanges();
return(true);
}
Console.WriteLine("This user already exists!");
}
else
{
Console.WriteLine("Password is incorrect!");
}
return(false);
}
}
catch (Exception)
{
Console.WriteLine("Something went wrong!");
return(false);
}
}
public Token Authenticate(string login, string password)
{
using (var db = new DzoContext())
{
var users = db.Users.Where(x => x.Login == login);
var authenticated = users.Count() == 1 && users.First().Password == password;
var token = authenticated ? new Token(users.First()) : null;
return(token);
}
}
public List <ActInpectationFl> GetActsInpectationFl(Token token, int count, int offset)
{
if (!Token.Exists(token))
{
return(null);
}
using (var db = new DzoContext())
{
if (token.UserRegion == Region.All)
{
return(db.ActsInspectionFl.OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
return(db.ActsInspectionFl.Where(x => x.Region == token.UserRegion).AsEnumerable().OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
}
public List <Regulation> GetRegulations(Token token, int count, int offset)
{
if (!Token.Exists(token))
{
return(null);
}
using (var db = new DzoContext())
{
if (token.UserRegion == Region.All)
{
return(db.Regulations.OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
return(db.Regulations.Where(x => x.Region == token.UserRegion).AsEnumerable().OrderBy(x => x.Id).Skip(offset).Take(count).ToList());
}
}
public Token Authenticate(string login, string password)
{
try
{
using (var db = new DzoContext())
{
var users = db.Users.Where(x => x.Login == login);
var authenticated = users.Count() == 1 && users.First().Password == password;
var token = authenticated ? new Token(users.First()) : null;
return(token);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(null);
}
}
public List <Photo> GetPhotoTablePhotos(Token token, PhotoTable photoTable)
{
if (!Token.Exists(token))
{
return(null);
}
try
{
using (var db = new DzoContext())
{
//return db.PhotoTables.Where(x=>x.Id == photoTable.Id)
return(null);
}
}
catch
{
return(null);
}
}
public bool DeleteActById(int id, Token token)
{
if (!Token.Exists(token))
{
return(false);
}
try
{
using (var db = new DzoContext())
{
var old = db.Acts.First(x => x.Id == id);
db.Acts.Remove(old);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool UpdateAct(ActBase act, Token token)
{
if (!Token.Exists(token))
{
return(false);
}
try
{
using (var db = new DzoContext())
{
var old = db.Acts.First(x => x.Id == act.Id);
db.Acts.Remove(old);
db.Acts.Add(act);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool AddAct(ActBase act, Token token)
{
if (!Token.Exists(token))
{
return(false);
}
act.Region = token.UserRegion;
var type = act.GetType();
try
{
using (var db = new DzoContext())
{
var ok = false;
if (type == typeof(ActBase))
{
ok = db.Acts.Add(act) != null;
}
if (type == typeof(ActCommon))
{
ok = db.CommonActs.Add(act as ActCommon ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(ActIndividual))
{
ok = db.IndividualActs.Add(act as ActIndividual ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(ActInpectationFl))
{
ok = db.ActsInspectionFl.Add(act as ActInpectationFl ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(ActInspectationUlIp))
{
ok = db.ActsInspectionUlIp.Add(act as ActInspectationUlIp ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(ActInspection))
{
ok = db.ActsInspection.Add(act as ActInspection ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(AgreementStatement))
{
ok = db.AgreementStatements.Add(act as AgreementStatement ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(AreaMeasurement))
{
ok = db.AreaMeasurements.Add(act as AreaMeasurement ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(CheckingJournal))
{
ok = db.CheckingJournals.Add(act as CheckingJournal ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(CitizensCheckPlan))
{
ok = db.CitizensCheckPlans.Add(act as CitizensCheckPlan ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(OrderInspectionUlIp))
{
ok = db.OrderInspectionsUlIp.Add(act as OrderInspectionUlIp ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(PhotoTable))
{
ok = db.PhotoTables.Add(act as PhotoTable ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(Protocol))
{
ok = db.Protocols.Add(act as Protocol ?? throw new InvalidOperationException()) != null;
}
if (type == typeof(Regulation))
{
ok = db.Regulations.Add(act as Regulation ?? throw new InvalidOperationException()) != null;
}
db.SaveChanges();
return(ok);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}