static void Main(string[] args)
{
const string connectionString =
"Server=ProductiveDeveloperCode.database.windows.net;Database=TelegramDB;User Id=ProductiveDeveloper;Password=fDx-Vbt-Lvr-7Vg;";
Telegram.Bot.Storage.Sql.SqlStorage sqlStorage = new Telegram.Bot.Storage.Sql.SqlStorage(connectionString);
Telegram.Bot.Storage.InMemory.InMemoryStorage inMemoryStorage = new Telegram.Bot.Storage.InMemory.InMemoryStorage();
Telegram.Receiver.TelegramReceiver reciver = new Telegram.Receiver.TelegramReceiver("984957183:AAECP59aHpYez0iBzmw_QBMb-sxMRgO5vpM");
Telegram.Sender.TelegramSender telegramSender = new Telegram.Sender.TelegramSender(reciver.botClient);
Telegram.Domain.Reminders.Reminder reminder = new Telegram.Domain.Reminders.Reminder(telegramSender);
Telegram.Domain.BotDomain botDomain = new Telegram.Domain.BotDomain(telegramSender, reciver, sqlStorage, inMemoryStorage, reminder);
System.Console.WriteLine(reciver.GetHelloFromBot());
reciver.Run();
while (true)
{
System.Threading.Thread.Sleep(1800000);
reminder.RemindersUpdate();
}
}
public List <UserItem> GetUsers()
{
List <UserItem> result = new List <UserItem>();
using (SqlConnection connection = SqlStorage.GetOpenedSqlConnection())
{
var sqlCommand = connection.CreateCommand();
sqlCommand.CommandType = System.Data.CommandType.Text;
sqlCommand.CommandText = $"SELECT * FROM Users";
using (var reader = sqlCommand.ExecuteReader())
{
if (!reader.HasRows)
{
return(result);
}
int ChatIdColumnIndex = reader.GetOrdinal("ChatId");
int FirstNameColumnIndex = reader.GetOrdinal("FirstName");
int DateOfRegistration = reader.GetOrdinal("DateOfRegistration");
int Id = reader.GetOrdinal("Id");
int Status = reader.GetOrdinal("Status");
while (reader.Read())
{
var chatId = reader.GetInt32(ChatIdColumnIndex);
var firstName = reader.GetString(FirstNameColumnIndex);
var dateOfRegistration = reader.GetString(DateOfRegistration);
var id = reader.GetGuid(Id);
var status = reader.GetString(Status);
StatusEnum _status;
switch (status)
{
case "Admin":
_status = StatusEnum.Admin;
break;
case "Ban":
_status = StatusEnum.Ban;
break;
case "User":
_status = StatusEnum.User;
break;
default:
_status = StatusEnum.Null;
break;
}
result.Add(new UserItem()
{
ChatId = chatId,
FirstName = firstName,
Status = _status,
Message = "Null",
DateOfRegistration = DateTimeOffset.Parse(dateOfRegistration),
Id = id
});
}
}
return(result);
}
}
