public MLContextMenu(Dictionary <string, object> par)
{
InitializeComponent();
Menus = new DataTable();
conStr = par["conStr"].ToString();
com = new SQLCom(conStr, "mGetRepRarts");
DataTable t;
com.AddParam(14); com.AddParam(0);
try
{
t = com.GetResult();
comboBox2.DataSource = t;
com.setCommand("getAnalityc");
com.AddParam(26); com.AddParam(1);
comboBox3.DataSource = com.GetResult();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
GetMenu();
}
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 <string> GetStatusMessage(long queueCommandID)
{
DataTable table = new DataTable();
StringBuilder sb = new StringBuilder();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("bGetSlavePCStatus");
MyCom.AddParam(queueCommandID);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return("No Information");
}
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);
bool online = Convert.ToBoolean(row["online"]);
if (online)
{
sb.Append("Device is Online");
}
else
{
sb.Append("Device is Offline");
}
sb.Append(Environment.NewLine);
sb.Append("Last Power ON: ");
sb.Append(string.Format("{0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["on"])));
sb.Append(Environment.NewLine);
if (!online)
{
sb.Append("Last Power OFF: ");
sb.Append(string.Format("{0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["off"])));
sb.Append(Environment.NewLine);
}
sb.Append("-----------------------------");
sb.Append(Environment.NewLine);
}
sb.Append(Environment.NewLine);
sb.Append("/menu");
}
catch (Exception ex)
{
SaveErrorLog(queueCommandID, "GetStartUpTimeToday(queueCommandID): " + ex.Message);
}
return(await Complete(sb.ToString()));
}
private void GetMenu()
{
//DataTable t;
com.setCommand("mGetRepRarts");
com.AddParam(25); com.AddParam(0);
try
{
Menus.Reset();
Menus = com.GetResult();
comboBox1.DataSource = Menus;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
GetMenuParams(comboBox1.SelectedValue);
}
public List <Command> getCommand(string hash)
{
if (string.IsNullOrEmpty(hash))
{
return(null);
}
DataTable table = new DataTable();
string result = string.Empty;
var res = new List <Command>();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("sGetCommand");
MyCom.AddParam(hash);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
res.Add(new Command
{
commandID = Convert.ToInt32(row["commandID"]),
QueueCommandID = Convert.ToInt64(row["QueueCommandID"]),
dateCreate = Convert.ToDateTime(row["dataCreate"])
});
}
}
catch (Exception ex)
{
var err = ex.Message;
res.Add(new Command {
commandID = -1
});
return(res);
}
return(res);
}
private List <Master> getMasters(string hash)
{
DataTable table = new DataTable();
string result = string.Empty;
var res = new List <Master>();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("sGetMasters");
MyCom.AddParam(hash);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
res.Add(new Master {
MasterId = Convert.ToInt32(row["MasterID"]),
codeB = Convert.ToInt32(row["codeB"]),
Name = row["name"].ToString(),
TypeDeviceID = Convert.ToInt32(row["typedeviceID"]),
TypeName = row["typedevice"].ToString(),
IsActive = Convert.ToBoolean(row["isActive"])
});
}
}
catch (Exception ex)
{
var err = ex.Message;
res = new List <Master>();
res.Add(new Master {
codeB = 0, MasterId = 0, Name = err, TypeDeviceID = 0, TypeName = "ERROR SQL"
});
return(res);
}
return(res);
}
public List <ScreenShot> getScreenShotPC(string hash, string GUID)
{
DataTable table = new DataTable();
string result = string.Empty;
var res = new List <ScreenShot>();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("bGetScreenShotByDevice");
MyCom.AddParam(GUID);
MyCom.AddParam(hash);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
res.Add(new ScreenShot
{
GUID = row["GUID"].ToString(),
ImageScreen = (byte[])row["ImageScreen"], //Utils.ObjectToByteArray(row["ImageScreen"]),//Encoding.UTF8.GetBytes(row["ImageScreen"].ToString()),//Utils.ObjectToByteArray(row["ImageScreen"]),
dateCreate = Convert.ToDateTime(row["dateCreate"]),
synchronizeTime = Convert.ToDateTime(row["synchronizeTime"])
});
}
}
catch (Exception ex)
{
var err = ex.Message;
res.Add(new ScreenShot {
GUID = "SQL error " + err
});
return(res);
}
return(res);
}
private List <PowerPC> getPowerPC(string hash)
{
DataTable table = new DataTable();
string result = string.Empty;
var res = new List <PowerPC>();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
MyCom.setCommand("bGetPowerPCByDevice");
MyCom.AddParam(DateTime.Now.Date); //only for today power on
MyCom.AddParam(hash);
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
res.Add(new PowerPC
{
GUID = row["GUID"].ToString(),
dateTimeOnPC = Convert.ToDateTime(row["dateTimeOnPC"]),
dateTimeOffPC = Convert.ToDateTime(row["dateTimeOffPC"]),
synchronizeTime = Convert.ToDateTime(row["synchronizeTime"])
});
}
}
catch (Exception ex)
{
var err = ex.Message;
res.Add(new PowerPC {
GUID = "SQL error " + err
});
return(res);
}
return(res);
}
//get list startup - powertime from slave pc to master telegram bot
private async Task <string> GetStartUpTimeMessage(long queueCommandID, int days)
{
DataTable table = new DataTable();
StringBuilder sb = new StringBuilder();
try
{
MyCom = new MLDBUtils.SQLCom(connectionString, "");
if (days == 0)
{
MyCom.setCommand("bGetStartUpTimeToday");
}
else if (days == 3)
{
MyCom.setCommand("bGetStartUpTime");
}
MyCom.AddParam(queueCommandID);
if (days == 3)
{
MyCom.AddParam(DateTime.Now.Date.AddDays(-2));
MyCom.AddParam(DateTime.Now.Date);
}
table = MyCom.GetResult();
if (table == null || table.Rows.Count == 0)
{
return("Today is no information");
}
int r = 0;
string synctime = string.Empty;
foreach (DataRow row in table.Rows)
{
if (r == 0)
{
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);
if (r == (table.Rows.Count - 1)) //last row
{
synctime = string.Format("sync: {0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["sync"]));
if (IsDeviceOnline(queueCommandID))
{
sb.Append("Device Online");
}
else
{
sb.Append("power OFF: ");
sb.Append(string.Format("{0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["off"])));
}
}
else
{
sb.Append("power OFF: ");
sb.Append(string.Format("{0: hh:mm tt (d MMM)} ", Convert.ToDateTime(row["off"])));
}
sb.Append(Environment.NewLine);
sb.Append("-----------------------------");
sb.Append(Environment.NewLine);
r++;
}
sb.Append(synctime);
sb.Append(Environment.NewLine);
sb.Append(Environment.NewLine);
sb.Append("/menu");
}
catch (Exception ex)
{
SaveErrorLog(queueCommandID, "GetStartUpTimeToday(queueCommandID): " + ex.Message);
}
return(await Complete(sb.ToString()));
}
