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);
}
}
