private async Task ExecuteCallbackMessage(CallbackQuery callbackQuery, Telegram.Bot.TelegramBotClient botclient)
{
try
{
var call = callbackQuery.Data.Split('z', StringSplitOptions.RemoveEmptyEntries);
int stage = int.Parse(call[0]);
string callbackString = call[1];
InlineImageGallery gallery = (InlineImageGallery)DBHelper.GetQuestion(stage);
var command = new InlineImageGalleryCommand(gallery);
await command.ExecuteQuery(callbackQuery, botclient);
}
catch (Exception ex)
{
Bot.MyLogger(ex.Message);
Bot.MyLogger(ex.StackTrace);
}
}
public InlineImageGalleryCommand(InlineImageGallery inline)
{
inlineImageGallery = inline;
}
public static void ExcelToClass(string path)
{
FileInfo File = new FileInfo(path);
using (ExcelPackage pck = new ExcelPackage(File))
{
var format = new ExcelTextFormat();
format.Delimiter = '/';
int k = pck.Workbook.Worksheets.Count;
ExcelWorksheet ws = null;
ws = pck.Workbook.Worksheets[1];
bool flag = true;
int i = 10;
int j = 0;
while (flag)
{
string tmp = ws.Cells[i, 1].Value.ToString().Trim();
IMessage temp = null;
int l = i;
switch (ws.Cells[i, 2].Value.ToString().Trim())
{
case "0":
{
TextMessage text = new TextMessage();
text.Stage = int.Parse(ws.Cells[i, 1].Value.ToString().Trim());
text.Message = ws.Cells[i, 3].Value.ToString().Trim();
text.NextStage = int.Parse(ws.Cells[i, 5].Value.ToString().Trim());
temp = text;
i++;
break;
}
case "1":
{
Question text = new Question();
int p = i;
text.Stage = int.Parse(ws.Cells[i, 1].Value.ToString().Trim());
text.Message = ws.Cells[i, 3].Value.ToString().Trim();
while (ws.Cells[i, 1].Value.ToString().Trim() == tmp.Trim())
{
Answer ans = new Answer(ws.Cells[i, 4].Value.ToString().Trim(), int.Parse(ws.Cells[i, 5].Value.ToString().Trim()));
text.Answers.Add(ans);
i++;
if (ws.Cells[i, 1].Value == null)
{
break;
}
}
temp = text;
break;
}
case "2":
{
break;
}
case "3":
{
InlineImageGallery text = new InlineImageGallery();
int p = i;
text.Stage = int.Parse(ws.Cells[i, 1].Value.ToString().Trim());
text.Message = ws.Cells[i, 3].Value.ToString().Trim();
text.NextStage = int.Parse(ws.Cells[i, 5].Value.ToString().Trim());
while (ws.Cells[i, 1].Value.ToString().Trim() == tmp.Trim())
{
ImageGallery ans = new ImageGallery(text.Stage, "https://myvelde.com/data/bot/" + ws.Cells[i, 6].Value.ToString().Trim(), ws.Cells[i, 4].Value.ToString().Trim());
text.ImageGalleries.Add(ans);
i++;
if (ws.Cells[i, 1].Value == null)
{
break;
}
}
temp = text;
break;
}
case "4":
{
PhoneMessage text = new PhoneMessage();
text.Stage = int.Parse(ws.Cells[i, 1].Value.ToString().Trim());
text.Message = ws.Cells[i, 3].Value.ToString().Trim();
text.NextStage = int.Parse(ws.Cells[i, 5].Value.ToString().Trim());
temp = text;
i++;
break;
}
case "5":
{
QuestionKitchen text = new QuestionKitchen();
int p = i;
text.Stage = int.Parse(ws.Cells[i, 1].Value.ToString().Trim());
text.Message = ws.Cells[i, 3].Value.ToString().Trim();
while (ws.Cells[i, 1].Value.ToString().Trim() == tmp.Trim())
{
Answer ans = new Answer(ws.Cells[i, 4].Value.ToString().Trim(), int.Parse(ws.Cells[i, 5].Value.ToString().Trim()));
text.Answers.Add(ans);
i++;
if (ws.Cells[i, 1].Value == null)
{
break;
}
}
temp = text;
break;
}
}
if (flag != false)
{
messages.Add(temp);
// tmp = ws.Cells[i, 1].Value.ToString();
}
if (ws.Cells[i, 1].Value == null)
{
flag = false;
}
}
}
}
