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 async Task <int> SavePowerPC(Device device, List <PowerPC> powerpcs)
{
connectionString = Utils.InitSqlPath(connectionString);
int result = 0;
Dictionary <string, object> dic = new Dictionary <string, object>();
MyCom = new MLDBUtils.SQLCom(connectionString, "");
int count = 0;
int newrecords = 0;
try
{
string guidnew = string.Empty;
foreach (var ppc in powerpcs)
{
MyCom.clearParams();
MyCom.setCommand("sSetpowerTime");
MyCom.AddParam(device.AndroidIDmacHash);
MyCom.AddParam(device.TypeDeviceID);
MyCom.AddParam(ppc.GUID);
MyCom.AddParam(ppc.dateTimeOnPC);
MyCom.AddParam(ppc.dateTimeOffPC);
dic = MyCom.GetResultD();
if (dic == null || dic.Count == 0)
{
result = 0;
break;
}
int.TryParse(dic["c"].ToString(), out count);
int.TryParse(dic["n"].ToString(), out newrecords);
if (newrecords == 1)
{
guidnew = ppc.GUID;
}
if (count == NOT_FOUND_DEVICEID || count == NotActive)
{
result = count;
break;
}
else
{
result += count;
}
}
if (newrecords == 1 && !string.IsNullOrEmpty(guidnew))
{
SendAutoInfoToMaster(guidnew, device.AndroidIDmacHash);
}
}
catch (Exception ex)
{
var err = ex.Message;
result = SQL_ERROR;
}
return(result);
}
