private void InitializeDataBase()
{
using (var context = new DataBaseContext())
{
context.Database.Initialize(false);
context.Commit();
}
}
/// <summary>
/// Gets the context.
/// </summary>
/// <returns></returns>
public DataBaseContext GetContext()
{
lock (Locker)
{
return this.context ?? (this.context = new DataBaseContext());
}
}
static void Main(string[] args)
{
Database.SetInitializer(new DropCreateDatabaseIfModelChanges<DataBaseContext>());
var simpleUser = new User() { Name = "Name" };
using (var context = new DataBaseContext())
{
context.Users.Add(simpleUser);
context.SaveChanges();
context.Status.Add(new Status() { IdStatus = new Guid("00000000-0000-0000-0000-000000000001"), Name = "Stopped"});
context.Status.Add(new Status() { IdStatus = new Guid("00000000-0000-0000-0000-000000000002"), Name = "Executing" });
context.Status.Add(new Status() { IdStatus = new Guid("00000000-0000-0000-0000-000000000003"), Name = "Done" });
context.SaveChanges();
}
}
void backroungWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
Deployment.Current.Dispatcher.BeginInvoke(() =>
{
//On récupère les informations de la question
dbc = new DataBaseContext(DataBaseContext.DBConnectionString);
var explications = from explication in dbc.Explications
where explication.QuestionId == questionId
select explication;
exp = explications.First();
});
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButton.OK);
}
}
public DataBaseContext Init()
{
return(dbContext ?? (dbContext = new DataBaseContext()));
}
public ProjectRepository(DataBaseContext db)
: base(db)
{
}
public UserPermissionsController(DataBaseContext context)
{
_context = context;
}
// CONSTRUCTORS
public NotificationRepositoryTest()
{
testData = new NotificationTestDataInitializer();
testContext = new DataBaseContext(CreateNewContextOptions(), testData);
}
public ProdutoRepository(DataBaseContext context)
{
_context = context;
}
public InterestRepository(DataBaseContext context) : base(context) => _context = context;
public CommentsController(DataBaseContext context, IConfiguration configuration, IHostingEnvironment _env)
{
_context = context;
_configuration = configuration;
env = _env;
}
public AddNewLinkCommandHandler(DataBaseContext context)
{
this.context = context;
}
public CustomerBookingRepository(DataBaseContext dataBaseContext)
{
_dataBaseContext = dataBaseContext;
}
public VersaoProjetoRepository(DataBaseContext dataBaseContext)
{
_dataBaseContext = dataBaseContext;
_versaoProjetoCollection = _dataBaseContext.GetCollection <Versao>();
}
public ProffosersController(DataBaseContext context)
{
_context = context;
}
public GetFriendsToAddQueryHandler(DataBaseContext context)
{
this.context = context;
}
public EmployeeRepository(DataBaseContext context)
{
this.db = context;
}
public UnitOfWork(DataBaseContext dbContext)
{
_dbContext = dbContext;
StartTransaction();
}
public AdoptionsController()
{
context = new DataBaseContext();
}
public GroupRepository(DataBaseContext db)
: base(db)
{
}
public GenresRepository(DataBaseContext context)
{
this.context = context;
}
public AccountController(DataBaseContext context, PasswordHashManager getHash)
{
passwordHashManager = getHash;
dataBaseContext = context;
}
public GetGroupFunctionsByGroupIdQueryHandler(DataBaseContext context)
{
this._context = context;
}
public ClientRepository(DataBaseContext db)
{
this.db = db;
}
public UserRepository(DataBaseContext context) : base(context)
{
}
public RemoveExtraMessageCommandHandler(DataBaseContext context)
{
this.context = context;
}
public ProductsController(DataBaseContext context)
{
_context = context;
}
/// <summary>
/// Konstruktor
/// </summary>
/// <param name="context"></param>
public CustomersController(DataBaseContext context)
{
_context = context;
}
public async void ChangeSecond(TelegramBotClient BotClient, Message _message, InlineButton inlineButton, User users, DataBaseContext baseContext)
{
foreach (BDNews temp in baseContext._News.Include("user"))
{
if (temp.user.ID == _message.From.Id && temp.Work == true)
{
temp.link = _message.Text;
await BotClient.SendTextMessageAsync(_message.Chat.Id, "\nНовое содержание: " + temp.link, replyMarkup : inlineButton.News);
temp.user.Work = 1111;
temp.Work = false;
}
}
baseContext.SaveChanges();
}
public UserRepository(DataBaseContext db)
: base(db)
{
}
public async void ChouseItem(TelegramBotClient BotClient, System.Object message, InlineButton inlineButton, DataBaseContext baseContext)
{
CallbackQuery _message = message as CallbackQuery;
Name = _message.Data;
System.Console.WriteLine(Name);
System.String[] words = Name.Split(new System.Char[] { ' ' }, System.StringSplitOptions.RemoveEmptyEntries);
System.Int32 temp = System.Convert.ToInt32(words[0]);
BDNews news = baseContext._News.Where(p => p.ID == temp).FirstOrDefault();
news.Work = true;
baseContext.SaveChanges();
await BotClient.EditMessageTextAsync(_message.From.Id, _message.Message.MessageId, "Название: " + news.Name + "\nСодержание:\n" + news.link, replyMarkup : inlineButton.ControlItem);
}
public BaseRepository( DataBaseContext db)
{
_db = db;
}
public async void SetContent(TelegramBotClient BotClient, Message _message, InlineButton inlineButton, DataBaseContext baseContext)
{
foreach (BDNews temp in baseContext._News.Include("user"))
{
if (temp.user.ID == _message.From.Id && temp.Work == true)
{
temp.link = _message.Text;
temp.Work = false;
}
}
await BotClient.SendTextMessageAsync(_message.Chat.Id, "Запись добавлена!\n" + "Заголовок: " + Name + "\nСодержание: " + _message.Text, replyMarkup : inlineButton.ShowCategory);
baseContext.SaveChanges();
}
public CompanyRepository(DataBaseContext db)
: base(db)
{
}
public async void SetName(TelegramBotClient BotClient, Message _message, InlineButton inlineButton, User users, DataBaseContext baseContext)
{
users.Work = 2311;
baseContext._News.Add(new BDNews()
{
Name = Name, user = users, Work = true
});
await BotClient.SendTextMessageAsync(_message.Chat.Id, "Заголовок: " + Name + "\nВведите содержание: ", replyMarkup : inlineButton.ShowCategory);
baseContext.SaveChanges();
}
public DataBaseContext Get()
{
return _dataContext ?? (_dataContext = new DataBaseContext());
}
public async void ShowItem(TelegramBotClient BotClient, System.Object message, InlineButton inlineButton, DataBaseContext baseContext)
{
CallbackQuery _message = message as CallbackQuery;
Telegram.Bot.Types.ReplyMarkups.InlineKeyboardMarkup answer = inlineButton.NewsShow(message, baseContext);
await BotClient.EditMessageTextAsync(_message.From.Id, _message.Message.MessageId, "Выберете статью: ", replyMarkup : answer);
}
public BaseRepositoryTest()
{
Database.SetInitializer(new DropCreateDatabaseIfModelChanges<DataBaseContext>());
_db = new DataBaseContext(_connectionString);
}
public async void ChangeFirst(TelegramBotClient BotClient, Message _message, InlineButton inlineButton, User users, DataBaseContext baseContext)
{
foreach (BDNews temp in baseContext._News.Include("user"))
{
if (temp.user.ID == _message.From.Id && temp.Work == true)
{
temp.Name = _message.Text;
await BotClient.SendTextMessageAsync(_message.Chat.Id, "\nНовый заголовок: " + temp.Name, replyMarkup : inlineButton.News);
temp.user.Work = 1111;
temp.Work = false;
}
}
}
public UserRepository(DataBaseContext dataBaseContext)
{
this.dataBaseContext = dataBaseContext;
}
public CardboardsController(DataBaseContext context)
{
_context = context;
}
public StatusRepository(DataBaseContext context)
: base(context)
{
}
public UpdateRunnerActivityDateCommandHandler(DataBaseContext context)
{
this._context = context;
}
