private async void SendAutoInfoToMaster(string guidnew, string androidIDmacHash)
{
int chatID = 0;//NEED GET FROM SQL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
DataTable table = new DataTable();
StringBuilder sb = new StringBuilder();
WebHookPwController whc = new WebHookPwController();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("bAutoSendPowerPCToMasterBot");
MyCom.AddParam(androidIDmacHash);
MyCom.AddParam((int)TypeDevicePW.TelegramBotMaster);
MyCom.AddParam(guidnew);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return;
}
//for all master paired with slave sending message with info powerON
foreach (DataRow row in table.Rows)
{
sb.Append(row["name"]);
sb.Append(" (");
sb.Append(row["type"]);
sb.Append(")");
sb.Append(Environment.NewLine);
sb.Append(Environment.NewLine);
sb.Append("power ON: ");
sb.Append(string.Format("{0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["on"])));
sb.Append(Environment.NewLine);
sb.Append("-----------------------------");
sb.Append(Environment.NewLine);
sb.Append(string.Format("sync: {0: hh:mm:ss tt (d MMM)} ", Convert.ToDateTime(row["sync"])));
sb.Append(Environment.NewLine);
sb.Append(Environment.NewLine);
sb.Append("/menu");
chatID = 0;
int.TryParse(row["chatID"].ToString(), out chatID);
if (chatID != 0 && sb.Length != 0)
{
MyCom.clearParams();
MyCom.setCommand("sCreateMessForSending");
MyCom.AddParam(chatID);
MyCom.AddParam(sb.ToString());
MyCom.ExecuteCommand();
}
sb.Clear();
}
//Send To Bot Command Sending Message from [bMessForSending] !!!!!!!!!!!!!!!
whc.Get(777);
}
catch (Exception ex)
{
whc.SaveErrorLog(chatID, "SendAutoInfoToMaster():" + ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
object cur = comboBox1.SelectedValue;
if ((int)comboBox1.SelectedValue == 0 & newMenuName.Text.Trim() == "")
{
MessageBox.Show("Не введено имя нового меню");
return;
}
string pString = string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9}",
dllName.Text,
className.Text,
methodName.Text,
methodTypes.Text,
checkBox1.Checked.ToString(),
constructorParam.Text,
docType.Text,
checkBox2.Checked.ToString(),
checkBox3.Checked.ToString(),
textBox2.Text
);
com.setCommand("mSaveContexMenu");
com.AddParam(comboBox1.SelectedValue);
com.AddParam(newMenuName.Text as object);
com.AddParam(pString as object);
com.AddParam(comboBox2.SelectedValue);
com.AddParam(comboBox3.SelectedValue);
com.AddParam(numericUpDown1.Value as object);
try
{
com.ExecuteCommand();
MessageBox.Show("Данные сохранены...");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
GetMenu();
comboBox1.SelectedValue = cur;
}
private string FinishAddHostDevice(List<string> data)
{
Dictionary<string, object> dic = new Dictionary<string, object>();
string result = String.Empty;
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("acheckABfinish");
long deviceID = 0;
if (!Int64.TryParse(data[DeviceIdIDX], out deviceID))
{
return String.Empty;
}
MyCom.AddParam(deviceID);
MyCom.AddParam(Convert.ToInt32(data[CodeAIDX]));
MyCom.AddParam(Convert.ToInt32(data[CodeBIDX]));
MyCom.AddParam(Utils.TruncateLongString(data[IpIDX], 50));
dic = MyCom.GetResultD();
if (dic == null || dic.Count == 0)
{
return "-1";
}
result = dic["DeviceID"].ToString();
}
catch (Exception ex)
{
return "-3";
}
try
{
//for send push after and active deviceID
long newDeviceId = 0;
if (Int64.TryParse(dic["DeviceID"].ToString(), out newDeviceId))
{
if (newDeviceId > 0)
{
if (dic["token"] != null)
{
string mess = newDeviceId.ToString();
string url = "http:\\tut.by";
string title = "title";
Utils.responseGCM responcegsm = Utils.SendGCM(mess, url, title, dic["token"].ToString());
string err = responcegsm.Warningmess;
if (String.IsNullOrEmpty(err))
{
err = "OK";
}
var responce = responcegsm.ResponseLine;
if (String.IsNullOrEmpty(responce))
{
responce = "EMPTY";
}
string request = String.Format("{0};{1};{2}", mess, url, title);
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("aGCMlog");
MyCom.AddParam(Utils.TruncateLongString(request, 50));
MyCom.AddParam(Utils.TruncateLongString(responce, 255));
MyCom.AddParam(newDeviceId);
MyCom.AddParam(Utils.TruncateLongString(err, 50));
MyCom.AddParam(Utils.TruncateLongString("ADDdevice", 20));
MyCom.ExecuteCommand();
}
}
}
}
catch (Exception ex)
{
return "-5|" + dic["DeviceID"].ToString();
}
return result;
}
