protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public void Dispose()
{
_context?.Dispose();
_roleStore?.Dispose();
_roleManager?.Dispose();
_userStore?.Dispose();
_userManager?.Dispose();
}
public static bool AddUser(User u)
{
MyDbContext context = new MyDbContext();
context.Users.Add(u);
context.SaveChanges();
context.Dispose();
return(true);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
_userManager.Dispose();
_db.Dispose();
}
base.Dispose(disposing);
}
private static void InsertRom(Game rom)
{
using (var iR = new MyDbContext())
{
iR.Game.Add(rom);
iR.SaveChanges();
iR.Dispose();
}
}
private static void UpdateRom(Game rom)
{
using (var uR = new MyDbContext())
{
uR.Game.Update(rom);
uR.SaveChanges();
uR.Dispose();
}
}
public void Dispose()
{
client?.Dispose();
client = null;
scope?.Dispose();
scope = null;
server?.Dispose();
server = null;
dbContext?.Dispose();
dbContext = null;
}
protected virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
_db.Dispose();
}
}
this.disposed = true;
}
public virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
_db.Dispose();
}
this.disposed = true;
}
}
protected virtual void Dispose(bool disposing)
{
if (!disposed)
{
if (disposing)
{
context.Dispose();
}
}
disposed = true;
}
public virtual void Dispose()
{
if (disposing)
{
return;
}
disposing = true;
if (context != null)
{
context.Dispose();
}
}
public ActionResult Delete(int id)
{
MyDbContext _db = new MyDbContext();
Application lm = _db.Applications.Find(id);
if (lm != null)
{
_db.Applications.Remove(lm);
_db.SaveChanges();
_db.Dispose();
}
return(RedirectToAction("Personal"));
}
protected virtual void Dispose(bool disposing)
{
if (!_disposed)
{
if (disposing)
{
if (dataContext != null)
{
dataContext.Dispose();
}
}
}
_disposed = true;
}
protected virtual void Dispose(bool disposing)
{
if (disposed)
{
return;
}
if (disposing)
{
_dbContext.Dispose();
}
disposed = true;
}
public async Task CreateWExistingItem_IIalreadyCreatedToday_OriginalIsIncemted()
{
try
{
//uut.CreateWNewItem(null, 1, ii, "Bearer " + jwt);
var ii = new SimpleInventoryItem()
{
Amount = 3,
ItemId = 2
};
var result = await uut.CreateWExistingItem(null, 3, ii, "Bearer " + jwt);
result = await uut.CreateWExistingItem(null, 3, ii, "Bearer " + jwt);
var result1 = await uut.Get(2, "Bearer " + jwt);
Assert.That(result1.Value.Count, Is.EqualTo(2));//Two II already exists with seed data
Assert.That(result1.Value[1].Amount, Is.EqualTo(10));
}
finally
{
dbc.Dispose();
}
}
private MyDbContext AddToContext(MyDbContext context, FileRow entity, int count, int commitCount)
{
context.FileRows.Add(entity);
if (count % commitCount == 0)
{
context.SaveChanges();
context.Dispose();
context = new MyDbContext();
context.Configuration.AutoDetectChangesEnabled = false;
}
return(context);
}
public Task UpdateItem(object updateItem)
{
return(Task.Run(() =>
{
using (myDbContext = new MyDbContext(sqlService.GetConnectionString()))
{
var item = updateItem as Gu12;
if (myDbContext.Gu12s.Select((select) => select.Id == item.Id).FirstOrDefault())
{
myDbContext.Gu12s.FirstOrDefault((select) => select.Id == item.Id);
myDbContext.SaveChanges();
myDbContext.Dispose();
}
}
}));
}
public static void CreateUserAdmin()
{
MyDbContext context = new MyDbContext();
if (context.Users.Count() == 0)
{
User u = new User();
u.CreateDateTime = System.DateTime.Now;
u.PIB = "Admin";
u.Login = "******";
u.Password = "******";
u.Role = "Admin";
u.Email = "*****@*****.**";
context.Users.Add(u);
context.SaveChanges();
context.Dispose();
}
}
public Task DeleteItem(object currentItem)
{
return(Task.Run(() =>
{
using (myDbContext = new MyDbContext(sqlService.GetConnectionString()))
{
var gu12 = currentItem as Gu12;
if (gu12 == null)
{
throw new System.Exception("Конкретная заявка не найдена");
}
if (myDbContext.Gu12s.Select((select) => select.Id == gu12.Id).FirstOrDefault())
{
myDbContext.Gu12s.Remove(gu12);
myDbContext.SaveChanges();
myDbContext.Dispose();
}
}
}));
}
public void Dispose()
{
_myDbContext.Dispose();
}
/// <inheritedoc /> public void Dispose() => _ctx?.Dispose();
public void Dispose()
{
_dbContext.Dispose();
}
protected override void Dispose(bool disposing)
{
context.Dispose();
base.Dispose(disposing);
}
public void Dispose()
{
Db?.Dispose();
}
protected virtual void Dispose(bool disposing)
{
if (disposing) GC.SuppressFinalize(this);
if (_ownContext) _ctx.Dispose();
}
public ActionResult Index(Application a)
{
ViewBag.Page = "Application";
int s = (int)TempData["Step"];
string buttonValue = Request["button"];
if (buttonValue == "Назад")
{
TempData["NewApplication"] = a;
return(RedirectToAction("Index"));
}
else
{
ViewBag.dicProducts = _db.Products.ToList();
ViewBag.dicSchems = MainHelp.dicSchems();
switch (s)
{
case 1:
{
if (MainHelp.IsValidEtap1(a).Count == 0)
{
TempData["Step"] = s + 1;
ModelState.Clear();
try
{
a.CreateDateTime = DateTime.Now;
if (User.Identity.IsAuthenticated)
{
a.CreateUserId = _db.Users.FirstOrDefault(x => x.Login == User.Identity.Name).UserId;
}
else
{
a.CreateUserId = -1;
}
_db.Applications.Add(a);
_db.SaveChanges();
_db.Dispose();
return(View(a));
}
catch (DbEntityValidationException ex)
{
TempData["Step"] = s;
ModelState.AddModelError("", ex.EntityValidationErrors.ToString());
return(View(a));
}
}
else
{
TempData["Step"] = s;
foreach (KeyValuePair <string, string> k in MainHelp.IsValidEtap1(a))
{
ModelState.AddModelError(k.Key, k.Value);
}
return(View(a));
}
}
case 2:
{
if (MainHelp.IsValidEtap2(a).Count == 0)
{
TempData["Step"] = s + 1;
a.Xml = MainHelp.CreateXML(a);
a.XmlData = System.Text.Encoding.Default.GetBytes(a.Xml);// MainHelp.CreateXML(lm)
_db.Entry(a).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
_db.Dispose();
SendMail.Send(a);
return(View(a));
}
else
{
TempData["Step"] = s;
foreach (KeyValuePair <string, string> k in MainHelp.IsValidEtap2(a))
{
ModelState.AddModelError(k.Key, k.Value);
}
return(View(a));
}
}
case 3:
{
TempData["Step"] = s + 1;
//_db.Entry(lm).State = System.Data.Entity.EntityState.Modified;
//_db.SaveChanges();
//_db.Dispose();
return(View());
//return View(lm);
}
default: return(View());
}
}
}
protected override void Dispose(bool disposing)
{
_context.Dispose();
}
private void Window_Closing(object sender, CancelEventArgs e)
{
myDbContext.Dispose();
}
private void App_Exit(object sender, ExitEventArgs e)
{
DbCtx.Dispose();
}
public void Dispose()
{
_context.Dispose();
}
