/// <summary> /// ادد و نمایش برنامه /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Form1_Load(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); //Person person = new Person("mohammad", "saeid", "nazari"); //dataBaseContext.People.Add(person); dataBaseContext.SaveChanges(); dataBaseContext.People.Load(); lstPeople.ValueMember = "ID"; lstPeople.DisplayMember = "DisplayFullName"; lstPeople.DataSource = dataBaseContext.People.Local; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
protected override void DisposeCore() { if (dbContext != null) { dbContext.Dispose(); } }
private void Button_Add_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); Country country = new Country() { Name = "iran" }; dataBaseContext.Countries.Add(country); dataBaseContext.SaveChanges(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
public async Task Execute(IJobExecutionContext context) { DataBaseContext BaseContext = new DataBaseContext(); foreach (Purpose reminder in BaseContext._Purposes.Include("user")) { EventTime eventTime = BaseContext._EventTimes.Where(p => p.purpose == reminder).FirstOrDefault(); if (eventTime != null) { if (eventTime.dateTime != null) { if (eventTime.dateTime.Date == System.DateTime.Today && eventTime.dateTime.Hour == System.DateTime.Now.Hour && eventTime.dateTime.Minute == System.DateTime.Now.Minute) { if (reminder.user.SendMessageTelegram == true) { TelegramBotClient BotClient = new TelegramBotClient("779815529:AAEQVsHABl-V1rNhxX3vDnCo_r1xQjYczNU"); System.String name = "Название: " + reminder.Name + "\n"; name += "Описание: " + reminder.Note + "\n"; name += "Продолжительность: " + reminder.Duration; await BotClient.SendTextMessageAsync(reminder.user.ID, name); } } } } } BaseContext.Dispose(); }
private void btn4_Click(object sender, EventArgs e) { DataBaseContext oDataBaseContext = null; try { oDataBaseContext = new DataBaseContext(); Country oCountry = new Country(); string a = txt2.Text; oDataBaseContext.Countries.Where(c => c.Name == a).Load(); oDataBaseContext.Countries.Local.Clear(); oDataBaseContext.SaveChanges(); Display(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (oDataBaseContext != null) { oDataBaseContext.Dispose(); oDataBaseContext = null; } EmptyTXT(); } }
private void Form1_Load(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); Person person = null; person = new Person() { Name = "ایران", Population = "زیاد" }; dataBaseContext.Persons.Add(person); person = new Person { Name = "جیبوتی", Population = "کم" }; dataBaseContext.Persons.Add(person); dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
private void Form1_Load(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); Person person = new Person(); person.GetFullName = new FullName("mohammad", "hajian"); Address address = new Address("iran"); address.City = "esfahan"; person.GetAddress = address; dataBaseContext.People.Add(person); dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
/// <summary> /// در این کلاس چند یوزر به طول مشترک در یک گروه میروند /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnUsersToGroup_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); ///نکته : برای یافتن یک داده از دیتابیس و بیرون اوردن آن لازم نیس آن را نیو کنیم ///ابتدا گروهی که یوزر ها میخاهند در ان بروند را بیرون میاوریم Group groupCommom = dataBaseContext.Groups.Where(c => c.Name == "group 2").FirstOrDefault(); ///سپس یوزر هایی که در ان گروه میروند را بیرون میاوریم User user1 = dataBaseContext.Users.Where(c => c.Name == "user 2").FirstOrDefault(); User user2 = dataBaseContext.Users.Where(c => c.Name == "user 4").FirstOrDefault(); User user3 = dataBaseContext.Users.Where(c => c.Name == "user 6").FirstOrDefault(); ///سپس نام آن گروهی که گروهه بیرون آمده در ان است را به پراپرتی یوزر ان اضافه میکنیم groupCommom.Users.Add(user1); groupCommom.Users.Add(user2); groupCommom.Users.Add(user3); ///سیو دیتابیس dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
public async Task GetByIdAsyncWithEventsShouldReturnTheCurrentStateOfTheAggregate() { //Arrange #region mock of DataBaseContext , mock of IDomainEventRebuilder and mock of moqInvoker var aggregateId = Guid.NewGuid(); var optionsBuilder = new DbContextOptionsBuilder <DataBaseContext>(); optionsBuilder.UseInMemoryDatabase("FakeInMemoryData"); var moqContext = new DataBaseContext(optionsBuilder.Options); moqContext.Database.EnsureCreated(); var obj = new EventOject(aggregateId, "Dupont", "45 av charles degaulle paris, france"); var type = obj.GetType().AssemblyQualifiedName; var json = @" { 'FullName':'Dupont', 'Adresse':'45 av charles degaulle paris, france' }"; moqContext.EventStore.Add(new EventStore(aggregateId, 1, "2@735f8407-16be-44b5-be96-2bab582b5298", type, DateTime.Now, json)); moqContext.SaveChanges(); Mock <IDomainEventRebuilder> moqDomainEventRebuilder = new Mock <IDomainEventRebuilder>(); moqDomainEventRebuilder.Setup(m => m.RebuildDomainEvents(It.IsAny <IEnumerable <EventStore> >())) .Returns(new List <Event> { obj }); var aggregate = (StubAggregate)typeof(StubAggregate) .GetConstructor(BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[0], new ParameterModifier[0]) ?.Invoke(new object[0]); var moqInvoker = new Mock <IInvoker <StubAggregate> >(); moqInvoker.Setup(i => i.CreateInstanceOfAggregateRoot <StubAggregate>()).Returns(aggregate); #endregion mock of DataBaseContext , mock of IDomainEventRebuilder and mock of moqInvoker var sut = new EventStoreRepository <StubAggregate>(moqContext, moqInvoker.Object, moqDomainEventRebuilder.Object); //Act var result = await sut.GetByIdAsync <StubAggregate>(aggregateId); moqContext.Dispose(); //Assert Assert.NotNull(aggregate); Assert.Equal(aggregate, result); Assert.Equal(aggregateId, aggregate.Id); Assert.Equal(obj.FullName, aggregate.FullName); Assert.Equal(obj.Adresse, aggregate.Adresse); }
/// <summary> /// همانند بالا /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnGroupsToUser_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); User userActive = dataBaseContext.Users.Where(c => c.Name == "user 1").FirstOrDefault(); Group group1 = dataBaseContext.Groups.Where(c => c.Name == "group 1").FirstOrDefault(); Group group2 = dataBaseContext.Groups.Where(c => c.Name == "group 2").FirstOrDefault(); Group group3 = dataBaseContext.Groups.Where(c => c.Name == "group 3").FirstOrDefault(); userActive.Groups.Add(group1); userActive.Groups.Add(group2); userActive.Groups.Add(group3); dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
public async Task Execute(IJobExecutionContext context) { DataBaseContext BaseContext = new DataBaseContext(); foreach (Event reminder in BaseContext._Events.Include("user")) { EventTime eventTime = BaseContext._EventTimes.Where(p => p._event == reminder).FirstOrDefault(); if (eventTime != null) { if (eventTime.dateTime != null) { if (eventTime.dateTime.Date == System.DateTime.Today && eventTime.dateTime.Hour == System.DateTime.Now.Hour && eventTime.dateTime.Minute == System.DateTime.Now.Minute) { if (reminder.user.SendMessageE_Mail == true && reminder.user.EmailAdress != null) { // отправитель - устанавливаем адрес и отображаемое в письме имя MailAddress from = new MailAddress("*****@*****.**", "CalendarBot"); // кому отправляем MailAddress to = new MailAddress(reminder.user.EmailAdress); // создаем объект сообщения MailMessage m = new MailMessage(from, to); // тема письма m.Subject = "Мероприятие"; // текст письма System.String busy = ""; if (reminder.Busy == true) { busy = "Занят"; } else { busy = "Не занят"; } m.Body = "<h2>" + "Название: " + reminder.Name + "<br>"; m.Body += "Описание: " + reminder.Note + "<br>"; m.Body += "Локация: " + reminder.Location + "<br>"; m.Body += "Занятость: " + busy + "<br>"; m.Body += "</h2>"; // письмо представляет код html m.IsBodyHtml = true; //m.Attachments.Add(@"Путь к файлу!"); // адрес smtp-сервера и порт, с которого будем отправлять письмо SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587); // логин и пароль smtp.Credentials = new NetworkCredential("*****@*****.**", "123456qweASD123456"); smtp.EnableSsl = true; await smtp.SendMailAsync(m); System.Console.WriteLine("Сообщение отправлено!"); } } } } } BaseContext.Dispose(); }
public void MonthlyFinancialList() { Models.DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); List <MonthlyFinancial> monthlyFinancials = dataBaseContext.MonthlyFinancials .OrderBy(current => current.Register_Date) .ToList(); monthlyFinancialListDataGridView.DataSource = monthlyFinancials; } catch (System.Exception ex) { Infrastructure.Utility.ExceptionShow(ex); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
private void button_Add_Groups_Click(object sender, EventArgs e) { databasecontext = new DataBaseContext(); try { var Group1 = databasecontext.Groups.Where(c => c.Name == "Group1").FirstOrDefault(); var Group2 = databasecontext.Groups.Where(c => c.Name == "Group2").FirstOrDefault(); var User1 = databasecontext.Users.Where(c => c.Name == "User1").FirstOrDefault(); User1.Groups = new List <Group>(); User1.Groups.Add(Group1); User1.Groups.Add(Group2); //databasecontext.Users.Add(User1); اگر اینکار رو بکنیم یه یوزر دیگه ساخته میشه databasecontext.SaveChanges(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { if (databasecontext != null) { databasecontext.Dispose(); databasecontext = null; } } }
public void Dispose() { if (_context != null) { _context.Dispose(); } }
public void Dispose() { if (_Context != null) { _Context.Dispose(); } GC.SuppressFinalize(this); }
/// <summary> /// Executa a confirmação de mudancas. /// </summary> public void CommitChanges() { // Realizando o commit da transação if (StaticDataContext == null) { return; } if (StaticDataContext.Database.CurrentTransaction != null) { StaticDataContext.Database.CurrentTransaction.Commit(); } StaticDataContext.PerformingTransaction = false; StaticDataContext.Dispose(); StaticDataContext = null; }
private void Casting_FormClosed(object sender, FormClosedEventArgs e) { if (databasecontext != null) { databasecontext.Dispose(); databasecontext = null; } }
private void Form1_FormClosing(object sender, FormClosingEventArgs e) { if (GetDataBaseContext != null) { GetDataBaseContext.Dispose(); GetDataBaseContext = null; } }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
public virtual void Dispose(bool disposing) { if (!disposed) { db.Dispose(); } disposed = true; }
/// <summary> /// توضیحات با دقت خوانده شود /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnDoSomthing_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { ///ابتدا یک دیتابیس کانتکس نیو میکنیم dataBaseContext = new DataBaseContext(); ///سپس یک کانتری میسازیم و کشوری که ایدی اش یک باشد را تویش میریزیم Country country = dataBaseContext.Countries.Where(c => c.ID == 1).FirstOrDefault(); ///اگر همچین کانتری وجود نداشت از برنامه خارج میشود if (country == null) { return; } State state = null; ///شهر اصفهان را به کشوری که جست و جو شده نسبت میدهد ///ایدی کشوری که جست و جو شده را به ایدی شهر اصفهان میدهد state = new State { Name = "اصفهان", CountryId = country.ID }; dataBaseContext.States.Add(state); ///کل کشوری که جست و جو شده را به قسمت کشوره استان اضافه میکند state = new State { Name = "تهران", Country = country }; dataBaseContext.States.Add(state); ///در کلاس کانتری یک لیست استان داشتیم ///در ان لیست این شهر شیراز را ادد میکند state = new State { Name = "شیراز" }; country.States.Add(state); ///در اخر سیو میکنیم dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
public void Dispose() { if (_dataBaseContext != null) { _dataBaseContext.Rollback(); } _dataBaseContext.Dispose(); }
private void BtnAddNewPeople_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); Person person = null; ///ابتدا یک شخص را میسازیم و نامش را میگذاریم person = new Person { FullName = "Mahdi Hajian" }; ///سپس ان را ادد میکنیم dataBaseContext.Persons.Add(person); ///این دفعه شخص دیگری را میسازیم ولی ادرس هم بهش میدهیم person = new Person { FullName = "ali ramazani" }; Addess addess = null; addess = new Addess { City = "shiraz", State = "fars", Country = "iran" }; person.Addess = addess; dataBaseContext.Persons.Add(person); /// /// مثال پایین اشتباه است /// نمیشود مستقیم به ادرس اضافه کرد /// //person = new Person(); //person.FullName = "saeid nazari"; //person.Addess.City = "اصفهان"; //person.Addess.State = "استان اصفهان"; //person.Addess.Country = "ایران"; //dataBaseContext.Persons.Add(person); dataBaseContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }
protected virtual void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { entities.Dispose(); } } this.disposed = true; }
protected void Dispose(bool disposing) { if (disposing) { if (_dbContext != null) { _dbContext.Dispose(); _dbContext = null; } } }
private void Dispose(bool disposing) { if (!_disposed) { if (disposing) { _dataBaseContext.Dispose(); } } _disposed = true; }
public virtual void Dispose(bool disposing) { if (!_disposed) { if (disposing) { Db.Dispose(); } } _disposed = true; }
protected virtual void Dispose(bool disposing) { if (!_disposed) { if (disposing) { _context.Dispose(); } } _disposed = true; }
public virtual void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { db.Dispose(); } this.disposed = true; } }
private void Button_Do_Click(object sender, EventArgs e) { DataBaseContext dataBaseContext = null; try { dataBaseContext = new DataBaseContext(); var country = dataBaseContext.Countries.FirstOrDefault(c => c.ID == 1); if (country == null) { return; } State state = null; state = new State(); state.Name = "isfahan"; country.States = new List <State> { state }; //dataBaseContext.Countries.Add(country); اگر اینکار رو بکنیم یه کانتری دیگه ساخته میشه state = new State { Name = "shiraz", CountryID = country.ID }; dataBaseContext.States.Add(state); state = new State { Name = "tehran", Country = country }; dataBaseContext.States.Add(state); dataBaseContext.SaveChanges(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }