public static void GetAllUsers(TelegramBotClient botClient, CallbackQuery _message, User user)
{
DataBase db = Singleton.GetInstance().Context;
//создание файла
String files = AppDomain.CurrentDomain.BaseDirectory + "\\newdoc.xls";
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Пользователи");
worksheet.Cells[0, 0] = new Cell("ФИО");
worksheet.Cells[0, 1] = new Cell("Username");
worksheet.Cells[0, 2] = new Cell("Номер");
worksheet.Cells[0, 3] = new Cell("Дата регистрации");
User[] Users = db.GetUsers();
IQueryable <User> temp = Users.OrderByDescending(p => p.DateRegister).AsQueryable();
Int32 count = 1;
foreach (User ThisUser in temp)
{
worksheet.Cells[count + 1, 0] = new Cell(ThisUser.FIO);
worksheet.Cells[count + 1, 1] = new Cell(ThisUser.Username);
worksheet.Cells[count + 1, 2] = new Cell(ThisUser.Number);
worksheet.Cells[count + 1, 3] = new Cell(ThisUser.DateRegister.Date.ToString("dd/MM/yyyy"));
count++;
}
workbook.Worksheets.Add(worksheet);
workbook.Save(files);
SendMessage(botClient, _message, user, "Пользователи");
}
private async Task <Boolean> SendNotificationAllUsers(TelegramBotClient botClient)
{
User[] users = db.GetUsers();
InlineButton inlineButton = new InlineButton();
var temp = inlineButton.PublishNotification(CollectionNotification);
var picture = db.GetListCollectionPictureNotification(TextAndButton);
/*List<IAlbumInputMedia> pictureList = new List<IAlbumInputMedia>();
* if (picture.Count > 1)
* {
* pictureList.Add(new InputMediaPhoto() { Media = picture[0].Picture});
* }*/
foreach (var ThisUser in users)
{
if (ThisUser.ID == user.ID)
{
if (picture == null)
{
await botClient.SendTextMessageAsync(ThisUser.ID, TextAndButton.Text.Text, replyMarkup : temp);
}
else
{
await botClient.SendPhotoAsync(ThisUser.ID, picture[0].Picture, TextAndButton.Text.Text,
replyMarkup : temp);
}
}
}
var tempList = db.GetListCollectionButtonNotification();
foreach (CollectionButtonNotification collectionButtonNotification in tempList)
{
db.Remove(collectionButtonNotification);
}
foreach (CollectionPictureNotification collectionPictureNotification in picture)
{
db.Remove(collectionPictureNotification);
}
var TextTemp = db.GetTextNotification(TextAndButton.Text);
db.Remove(TextAndButton);
db.Remove(TextTemp);
db.Save();
return(true);
}
public async Task Execute(IJobExecutionContext context)
{
DataBase db = Singleton.GetInstance().Context;
User[] users = db.GetUsers();
foreach (User user in users)
{
if (user.DateRegister.Month + 1 == System.DateTime.Today.Month)
{
user.CountReviews = 3;
user.DateRegister = System.DateTime.Today;
}
}
db.Save();
}
