public async Task <ObjectResult> Post([FromBody] BotDomain botDomain) { GenericResult rs = new GenericResult(); try { string command = $"dbo.BOT_DOMAIN_Ins @p_DOMAIN = '{botDomain.DOMAIN}',@p_RECORD_STATUS =1, @p_USERNAME='******'"; var result = await _context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None); //return result; if (result != -1) { rs.Message = "Thêm domain thành công"; rs.Succeeded = true; } else { rs.Message = "Có lỗi xảy ra trong quá trình thêm!"; rs.Succeeded = false; } ObjectResult objRes = new ObjectResult(rs); //context.Dispose(); return(objRes); } catch (Exception ex) { rs.Message = "Lỗi " + ex.Message; rs.Succeeded = false; ObjectResult objRes = new ObjectResult(rs); //context.Dispose(); return(objRes); } }
public static void Main(string[] args) { const string connectionString = "Server=ProductiveDeveloperCode.database.windows.net;Database=TelegramDB;User Id=ProductiveDeveloper;Password=fDx-Vbt-Lvr-7Vg;"; SqlStorage sqlStorage = new SqlStorage(connectionString); InMemoryStorage inMemoryStorage = new InMemoryStorage(); TelegramReceiver reciver = new TelegramReceiver("984957183:AAECP59aHpYez0iBzmw_QBMb-sxMRgO5vpM"); TelegramSender telegramSender = new TelegramSender(reciver.botClient); Reminder reminder = new Reminder(telegramSender); BotDomain botDomain = new BotDomain(telegramSender, reciver, sqlStorage, inMemoryStorage, reminder); Console.WriteLine(reciver.GetHelloFromBot()); reciver.Run(); while (true) { Thread.Sleep(1800000); reminder.RemindersUpdate(); } }
//[Authorize(Roles ="UpdatePlugin")] public async Task <ObjectResult> Put(int id, [FromBody] BotDomain botDomain) { GenericResult rs = new GenericResult(); //DEFACEWEBSITEContext context = new DEFACEWEBSITEContext(); try { string command = $"dbo.BOT_DOMAIN_Upd @p_DOMAIN_ID={id}, @p_DOMAIN='{botDomain.DOMAIN}',@p_USERNAME='******',@p_RECORD_STATUS = {botDomain.RECORD_STATUS}"; var result = await _context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None); if (result > 0) { rs.Succeeded = true; rs.Message = "Cập nhật domain thành công"; } else { rs.Succeeded = false; rs.Message = "Đã có lỗi xảy ra"; } ObjectResult objRes = new ObjectResult(rs); //context.Dispose(); return(objRes); } catch (Exception ex) { rs.Succeeded = false; rs.Message = ex.Message; ObjectResult objRes = new ObjectResult(rs); //context.Dispose(); return(objRes); } }