public File Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.Files.Include(m => m.Asset).Include(m => m.ContentFile).FirstOrDefault(x => x.Id == id));
}
}
public IQueryable <AuditLog> GetLogs(string TypeFullName, object entityId)
{
using (var ctx = new CADBContext())
{
return(ctx.GetLogs(TypeFullName, entityId));
}
}
public bool Update(Asset t)
{
using (var ctx = new CADBContext())
{
var cryptoSave = new Crypto();
t.Password = cryptoSave.Encrypt(t.Password);
t.CustomerId = t.Customer.Id;
t.TypeId = t.Type.Id;
ctx.Assets.Attach(t);
ctx.Entry(t).State = EntityState.Modified;
try
{
ctx.SaveChanges(t.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!AssetExists(t.Id, ctx))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
}
public AutoMappingConfig(CADBContext context)
{
this._context = context;
CreateMap <Contact, ContactDTO>() // means you want to map from Contact to ContactDTO
.ForMember(dest =>
dest.Address,
opt => opt.MapFrom(src => new AddressDTO
{
City = src.Address.City,
StateCode = src.Address.State,
State = this._context.State.FirstOrDefault(s => s.Code == src.Address.State).StateName,
Street = src.Address.Street,
Zip = src.Address.Zip
}));
CreateMap <ContactDTO, Contact>() // means you want to map from ContactDTO to Contact
.ForMember(dest =>
dest.Address,
opt => opt.MapFrom(src => new Address
{
ContactId = this.TryToConvertToInt(src.Id),
City = src.Address.City,
State = src.Address.StateCode,
Street = src.Address.Street,
Zip = src.Address.Zip
}));
}
public Asset Create(Asset t)
{
using (var ctx = new CADBContext())
{
var cryptoSave = new Crypto();
t.Password = cryptoSave.Encrypt(t.Password);
t.CustomerId = t.Customer.Id;
t.TypeId = t.Type.Id;
if (t.Manufacturer != null)
{
t.ManufacturerId = t.Manufacturer.Id;
ctx.Entry(t.Manufacturer).State = EntityState.Unchanged;
}
ctx.Entry(t.Customer).State = EntityState.Unchanged;
ctx.Entry(t.Type).State = EntityState.Unchanged;
Asset a = ctx.Assets.Add(t);
ctx.SaveChanges();
return(a);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, CADBContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseCors(MyAllowSpecificOrigins);
CADBContext.AddTestData(context);
app.UseRouting();
app.UseSpaStaticFiles();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
app.UseSpa(spa =>
{
if (env.IsDevelopment())
{
spa.Options.SourcePath = "ClientApp";
}
else
{
spa.Options.SourcePath = "dist";
}
if (env.IsDevelopment())
{
spa.UseVueCli(npmScript: "serve");
}
});
}
public Manufacturer Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.Manufacturers.FirstOrDefault(x => x.Id == id));
}
}
public AssetType Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.AssetTypes.FirstOrDefault(x => x.Id == id));
}
}
public Firewall Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.Firewalls.Include(m => m.Customer).FirstOrDefault(x => x.Id == id));
}
}
public Switch Create(Switch t)
{
using (var ctx = new CADBContext())
{
ctx.Database.Connection.Open();
t.CustomerId = t.Customer.Id;
t.AssetId = t.Asset.Id;
ctx.Entry(t.Customer).State = EntityState.Unchanged;
ctx.Entry(t.Asset).State = EntityState.Unchanged;
Switch a = ctx.Switches.Add(t);
if (t.Ports != null)
{
foreach (var p in t.Ports)
{
p.SwitchId = a.Id;
}
ctx.Ports.AddRange(t.Ports);
}
// ctx.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT [CustomerAccountingDB].[dbo].[Switches] ON");
ctx.SaveChanges();
// ctx.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT [CustomerAccountingDB].[dbo].[Switches] OFF");
return(a);
}
}
public bool Update(User t)
{
using (var ctx = new CADBContext())
{
var cryptoSave = new Crypto();
t.Password = cryptoSave.Encrypt(t.Password);
ctx.Entry(t).State = EntityState.Modified;
try
{
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(t.Id, ctx))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
}
public Changelog Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.Changelogs.Include(y => y.User).Include(x => x.Asset).Include(x => x.Asset.Customer).FirstOrDefault(x => x.Id == id));
}
}
public static void Start()
{
IEnumerable <Type> ruleTypes = AppDomain.CurrentDomain.GetAssemblies()
.SelectMany(x => x.GetTypes())
.Where(x => typeof(IValidationRule).IsAssignableFrom(x) && !x.IsInterface && !x.IsAbstract);
var db = new CADBContext();
foreach (var type in ruleTypes)
{
var rule = Activator.CreateInstance(type) as IValidationRule;
var ruleModel = new ValidatorModel(rule);
//Debug.WriteLine($"[ValidationRuleConfig.Start] Found {ruleModel}");
ValidatorModel _ruleModel = db.ValidatorModels.SingleOrDefault(x => x.FullName == ruleModel.FullName);
if (_ruleModel == null)
{
Debug.WriteLine($"[ValidationRuleConfig.Start] Adding {ruleModel}");
db.ValidatorModels.Add(ruleModel);
db.SaveChanges();
}
}
db.Dispose();
}
public CustomerFile Read(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.CustomerFiles.Include(m => m.CustomerContentType).Include(c => c.Customer).FirstOrDefault(x => x.Id == id));
}
}
public bool Update(Changelog t)
{
using (var ctx = new CADBContext())
{
ctx.Entry(t.User).State = EntityState.Unchanged;
ctx.Entry(t.Asset).State = EntityState.Unchanged;
ctx.Entry(t).State = EntityState.Modified;
try
{
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ChangelogExists(t.Id, ctx))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
}
public List <Changelog> ReadAllWithFk(int id)
{
using (var ctx = new CADBContext())
{
return(ctx.Changelogs.Include(y => y.User).Include(x => x.Asset).Where(x => x.Asset.Id == id).ToList());
}
}
public List <Changelog> ReadAll()
{
using (var ctx = new CADBContext())
{
return(ctx.Changelogs.Include(y => y.User).Include(x => x.Asset).ToList());
}
}
public bool Update(Switch t)
{
using (var ctx = new CADBContext())
{
t.CustomerId = t.Customer.Id;
ctx.Switches.Attach(t);
ctx.Entry(t).State = EntityState.Modified;
ctx.Entry(t.Customer).State = EntityState.Unchanged;
try
{
ctx.SaveChanges(t.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!SwitchExists(t.Id, ctx))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
}
public bool Update(Port t)
{
using (var ctx = new CADBContext())
{
if (PortExists(t.Id, ctx))
{
ctx.Ports.Attach(t);
ctx.Entry(t).State = EntityState.Modified;
}
try
{
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PortExists(t.Id, ctx))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
}
public List <CustomerFile> ReadAll()
{
using (var ctx = new CADBContext())
{
var c = ctx.CustomerFiles.Include(m => m.Customer).ToList();
return(c);
}
}
private bool ChangelogExists(int tId, CADBContext ctx)
{
if (ctx.Changelogs.Count(a => a.Id == tId) > 0)
{
return(true);
}
return(false);
}
public List <Port> ReadAll()
{
using (var ctx = new CADBContext())
{
var a = ctx.Ports.Include(x => x.Switch).ToList();
return(a);
}
}
private bool FileExists(int tId, CADBContext ctx)
{
if (ctx.CustomerFiles.Count(a => a.Id == tId) > 0)
{
return(true);
}
return(false);
}
private bool UserExists(int id, CADBContext ctx)
{
if (ctx.Users.Count(a => a.Id == id) > 0)
{
return(true);
}
return(false);
}
private bool FirewallExists(int tId, CADBContext ctx)
{
if (ctx.Firewalls.Count(a => a.Id == tId) > 0)
{
return(true);
}
return(false);
}
public List <Firewall> ReadAll()
{
using (var ctx = new CADBContext())
{
var c = ctx.Firewalls.Include(m => m.Customer).ToList();
return(c);
}
}
public List <Port> ReadAllWithFk(int id)
{
using (var ctx = new CADBContext())
{
var afk = ctx.Ports.Include(x => x.Switch).Where(c => c.SwitchId == id).ToList();
return(afk);
}
}
bool PortExists(int id, CADBContext ctx)
{
if (ctx.Ports.Count(a => a.Id == id) > 0)
{
return(true);
}
return(false);
}
public List <CustomerFile> ReadAllWithFk(int id)
{
using (var ctx = new CADBContext())
{
var c = ctx.CustomerFiles.Include(m => m.Customer).Where(x => x.Customer.Id == id).ToList();
return(c);
}
}
public Port Read(int id)
{
using (var ctx = new CADBContext())
{
var a = ctx.Ports.Include(x => x.Switch).FirstOrDefault(x => x.Id == id);
return(a);
}
}
