public RESTStatus PushSTDIOData(SQLLib sql, Push_Stdio_StdIn stdin, NetworkConnectionInfo ni, string MachineID)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
if (stdin == null)
{
ni.Error = "Missing data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
string sess = "stdio-" + stdin.SessionID;
PushData p = new PushData();
p.Action = "stdin";
p.ReplyID = sess;
p.AdditionalData1 = JsonConvert.SerializeObject(stdin);
PushServiceHelper.SendPushService(MachineID, p, 0);
return(RESTStatus.Success);
}
public RESTStatus DeleteUser(SQLLib sql, NetString User, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Fail);
}
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM Users WHERE Username=@u",
new SQLParam("@u", User.Data))) == 0)
{
ni.Error = "Invalid User";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.Fail);
}
if (User.Data.ToLower().Trim() == "root")
{
ni.Error = "Invalid User";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.Fail);
}
sql.ExecSQL("DELETE FROM Users WHERE Username=@u",
new SQLParam("@u", User.Data));
return(RESTStatus.Success);
}
public RESTStatus GetFileList(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
Int64List = new NetInt64ListSigned();
Int64List.data = new NetInt64List2();
Int64List.data.data = new List <long>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT ID FROM FileTransfers WHERE MachineID=@mid AND ((Size=ProgressSize AND Direction=0) OR (Direction=1)) ORDER BY RequestOnly ASC, ID ASC",
new SQLParam("@mid", ni.Username));
while (dr.Read())
{
Int64List.data.data.Add(Convert.ToInt64(dr["ID"]));
}
dr.Close();
}
if (Certificates.Sign(Int64List, SettingsManager.Settings.UseCertificate) == false)
{
FoxEventLog.WriteEventLog("Cannot sign policy with Certificate " + SettingsManager.Settings.UseCertificate, System.Diagnostics.EventLogEntryType.Warning);
ni.Error = "Cannot sign policy with Certificate " + SettingsManager.Settings.UseCertificate;
ni.ErrorID = ErrorFlags.CannotSign;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}
public RESTStatus AddUser(SQLLib sql, NetString User, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(User.Data) == true)
{
ni.Error = "Missing username";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.Fail);
}
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM Users WHERE Username=@u",
new SQLParam("@u", User.Data.Trim()))) != 0)
{
ni.Error = "User already exists";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.Fail);
}
sql.InsertMultiData("Users",
new SQLData("Username", User.Data.Trim()),
new SQLData("Name", "new user"),
new SQLData("Permissions", 0),
new SQLData("Password", ""));
return(RESTStatus.Success);
}
public RESTStatus ListUsers(SQLLib sql, object Dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Fail);
}
UserLists = new UserDetailsList();
UserLists.List = new List <UserDetails>();
SqlDataReader dr = sql.ExecSQLReader("SELECT * FROM Users ORDER BY Username");
while (dr.Read())
{
UserDetails d = new UserDetails();
d.EMail = Convert.ToString(dr["EMail"]);
d.LDAPUsername = Convert.ToString(dr["LDAPUsername"]);
d.MustChangePassword = Convert.ToBoolean(dr["MustChangePassword"]);
d.Name = Convert.ToString(dr["Name"]);
d.Permissions = Convert.ToInt64(dr["Permissions"]);
d.UseLDAP = Convert.ToBoolean(dr["UseLDAP"]);
d.Username = Convert.ToString(dr["Username"]);
UserLists.List.Add(d);
}
dr.Close();
return(RESTStatus.Success);
}
public RESTStatus GetLastError(SQLLib sql, object foo, NetworkConnectionInfo ni)
{
Err = new ErrorInfo();
Err.Error = ni.Error;
Err.ErrorID = (int)ni.ErrorID;
return(RESTStatus.Success);
}
public RESTStatus RestartClientForced(SQLLib sql, object dummy, NetworkConnectionInfo ni, string MachineID)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
string guid = Guid.NewGuid().ToString();
PushData p = new PushData();
p.Action = "restartsystemforced";
p.ReplyID = guid;
PushServiceHelper.SendPushService(MachineID, p, 0);
PushDataResponse resp = PushServiceHelper.PopResponse(MachineID, 0, guid);
if (resp == null)
{
ni.Error = "No response";
ni.ErrorID = ErrorFlags.NoData;
return(RESTStatus.NoContent);
}
Dummy = new NetString();
Dummy.Data = "OK";
return(RESTStatus.Success);
}
public RESTStatus GetPendingChatMessages(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
string MachineID = ni.Username;
ChatList2 = new PushChatMessageList();
ChatList2.List = new List <PushChatMessage>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("select * from Chats where [Read]=0 AND MachineID=@m AND ToClient=1 ORDER BY DT ASC",
new SQLParam("@m", MachineID));
while (dr.Read())
{
PushChatMessage pch = new PushChatMessage();
pch.ID = Convert.ToInt64(dr["ID"]);
pch.DT = SQLLib.GetDTUTC(dr["DT"]);
pch.Name = Convert.ToString(dr["Name"]);
pch.Text = Convert.ToString(dr["Text"]);
ChatList2.List.Add(pch);
}
dr.Close();
}
return(RESTStatus.Success);
}
public static byte[] RenderMachineReport(SQLLib sql, List <string> MachineIDs, DateTime?From, DateTime?To, ReportingFlagsPaper ReportingPaper, string Output = "PDF")
{
byte[] ReportFile = GetReportPaperData(sql, "COMPUTERREPORT", Resources.Computer_Report);
ReportBook RepBook = new ReportBook();
foreach (string MachineID in MachineIDs)
{
Dictionary <string, object> Params = new Dictionary <string, object>();
Params.Add("MachineID", MachineID);
Params.Add("From", From);
Params.Add("To", To);
Params.Add("ReportingPaper", (int)ReportingPaper);
RepBook.ReportSources.Add(RenderReportData(ReportFile, Params));
}
InstanceReportSource instance = new InstanceReportSource();
instance.ReportDocument = RepBook;
ReportProcessor reportprocessor = new ReportProcessor();
RenderingResult result = reportprocessor.RenderReport(Output, instance, null);
return(result.DocumentBytes);
}
public RESTStatus Push10(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
PushData data = PushServiceHelper.WaitForPush(ni, 10);
if (data == null)
{
ni.Error = "Push Service Error";
ni.ErrorID = ErrorFlags.SystemError;
return(RESTStatus.ServerError);
}
ReturnData = new PushDataRoot();
ReturnData.Data = data;
if (Certificates.Sign(ReturnData, SettingsManager.Settings.UseCertificate) == false)
{
ni.Error = "Push Service Signing Error";
ni.ErrorID = ErrorFlags.SystemError;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}
public RESTStatus PushResponseB(SQLLib sql, PushDataResponse pdr, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
if (pdr == null)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
if (ni.PushChannel == null)
{
ni.Error = "Too early";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
if (PushServiceHelper.PushResponse(ni.Username, pdr, ni.PushChannel.Value, true) == false)
{
ni.Error = "Cannot push";
ni.ErrorID = ErrorFlags.SystemError;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}
public RESTStatus GetFileDataMgmt(SQLLib sql, object dummy, NetworkConnectionInfo ni, Int64 ID)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT COUNT(*) FROM FileTransfers WHERE ID=@id",
new SQLParam("@id", ID));
if (dr.HasRows == false)
{
ni.Error = "Not found";
ni.ErrorID = ErrorFlags.InvalidID;
dr.Close();
return(RESTStatus.NotFound);
}
dr.Read();
UploadedData2 = FillUploadData(dr);
dr.Close();
}
return(RESTStatus.Success);
}
public RESTStatus GetUser(SQLLib sql, object Dummy, NetworkConnectionInfo ni)
{
CurrentUser = new UserInfo();
CurrentUser.Username = ni.Username;
CurrentUser.Name = ni.Name;
return(RESTStatus.Success);
}
public RESTStatus GetWebsocketURL(SQLLib sql, object foo, NetworkConnectionInfo ni)
{
WSURL = new NetString()
{
Data = Settings.Default.WSPublishURL
};
return(RESTStatus.Success);
}
public RESTStatus ReportUsersList(SQLLib sql, UsersList users, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
if (users == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
users.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", users.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.NotFound);
}
}
lock (ni.sqllock)
{
sql.ExecSQL("DELETE FROM UsersList WHERE MachineID=@id", new SQLParam("@id", users.MachineID));
}
if (users.Users == null)
{
users.Users = new Dictionary <string, string>();
}
foreach (KeyValuePair <string, string> kvp in users.Users)
{
if (string.IsNullOrWhiteSpace(kvp.Key) == true || string.IsNullOrWhiteSpace(kvp.Value) == true)
{
continue;
}
lock (ni.sqllock)
{
sql.InsertMultiData("UsersList",
new SQLData("MachineID", users.MachineID),
new SQLData("SID", kvp.Key),
new SQLData("Username", kvp.Value));
}
}
return(RESTStatus.Success);
}
static bool FileExistsCompleted(SQLLib sql, Int64 id)
{
if (Convert.ToInt32(sql.ExecSQLScalar("Select count(*) FROM FileTransfers WHERE ID=@id AND Size=ProgressSize",
new SQLParam("@id", id))) == 0)
{
return(false);
}
return(true);
}
public RESTStatus TestFn(SQLLib sql, HttpListenerRequest request, HttpListenerResponse response, object dummy, NetworkConnectionInfo ni)
{
TestTxt = "Beim nächsten Toun ass et " + DateTime.Now.ToString("HH:mm") + " - Biip";
byte[] buffer = Encoding.UTF8.GetBytes(TestTxt);
response.AddHeader("Content-Type", "text/plain; charset=UTF-8");
response.OutputStream.Write(buffer, 0, buffer.Length);
return(RESTStatus.Success);
}
//Telerik Supported output formats: https://docs.telerik.com/reporting/configuring-rendering-extensions
public static byte[] GetReportPaperData(SQLLib sql, string Paper, byte[] Default)
{
object d = sql.ExecSQLScalar("select [data] from ReportPapers where [ID]=@ID",
new SQLParam("@id", Paper));
if (d is DBNull || d is null)
{
return(Default);
}
return((byte[])d);
}
public RESTStatus GetSettings(SQLLib sql, object foo, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
Settingss = SettingsManager.Settings;
return(RESTStatus.Success);
}
void InsertSupplData(SQLLib sql, string MachineID, int IfIndex, int Type, List <string> lst)
{
for (int i = 0; i < lst.Count; i++)
{
sql.InsertMultiData("NetworkConfigSuppl",
new SQLData("MachineID", MachineID),
new SQLData("InterfaceIndex", IfIndex),
new SQLData("Type", Type),
new SQLData("Order", i),
new SQLData("Data", lst[i] == null ? "" : lst[i].Trim()));
}
}
public RESTStatus GetContractInfos(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
CI = new ContractInfosList();
CI.Items = new List <ContractInfos>();
if (Settings.Default.UseContract == false)
{
return(RESTStatus.Success);
}
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("select * from contracts order by ContractID");
while (dr.Read())
{
ContractInfos i = new ContractInfos();
i.IncludedComputers = new List <ComputerData>();
sql.LoadIntoClass(dr, i);
CI.Items.Add(i);
}
dr.Close();
}
foreach (ContractInfos i in CI.Items)
{
List <string> Machines = new List <string>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("select MachineID from ComputerAccounts where ContractID=@c",
new SQLParam("@c", i.ContractID));
while (dr.Read())
{
Machines.Add(Convert.ToString(dr["MachineID"]));
}
dr.Close();
}
foreach (string M in Machines)
{
ComputerData c = Computers.GetComputerDetail(sql, M);
i.IncludedComputers.Add(c);
}
}
return(RESTStatus.Success);
}
public static byte[] RenderMachineReport(SQLLib sql, string MachineID, DateTime?From, DateTime?To, ReportingFlagsPaper ReportingPaper, string Output = "PDF")
{
byte[] ReportFile = GetReportPaperData(sql, "COMPUTERREPORT", Resources.Computer_Report);
Dictionary <string, object> Params = new Dictionary <string, object>();
Params.Add("MachineID", MachineID);
Params.Add("From", From);
Params.Add("To", To);
Params.Add("ReportingPaper", (int)ReportingPaper);
return(RenderReportData(ReportFile, Params, Output));
}
public RESTStatus GetClientSettings(SQLLib sql, object foo, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
ClientSettings = new ClientSettings();
ClientSettings.AdministratorName = SettingsManager.Settings.AdministratorName;
ClientSettings.MessageDisclaimer = SettingsManager.Settings.MessageDisclaimer;
return(RESTStatus.Success);
}
public RESTStatus GetPaperList(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
RetListPaper = new NetStringList();
RetListPaper.Items = SupportedNames;
return(RESTStatus.Success);
}
public RESTStatus GetPaperTemplate(SQLLib sql, object dummy, NetworkConnectionInfo ni, string Paper)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
if (string.IsNullOrWhiteSpace(Paper) == true)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
Paper = Paper.ToUpper().Trim();
if (SupportedNames.Contains(Paper) == false)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
RetPaper = new NetByte();
RetPaper.Data = null;
lock (ni.sqllock)
{
object o = sql.ExecSQLScalar("SELECT [data] from ReportPapers WHERE ID=@id",
new SQLParam("@id", Paper));
if (o is DBNull || o is null)
{
switch (Paper)
{
case "COMPUTERREPORT":
RetPaper.Data = Resources.Computer_Report;
break;
}
}
else
{
RetPaper.Data = (byte[])o;
}
}
return(RESTStatus.Success);
}
public RESTStatus CancelUploadAgentToServer(SQLLib sql, object dummy, NetworkConnectionInfo ni, Int64 ID)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM FileTransfers WHERE ID=@id AND MachineID=@mid AND Direction in (0,1)",
new SQLParam("@mid", ni.Username),
new SQLParam("@id", ID))) == 0)
{
ni.Error = "Invalid ID";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
}
string Filename = null;
lock (ni.sqllock)
{
Filename = Settings.Default.DataPath + Convert.ToString(sql.ExecSQLScalar("SELECT ServerFile FROM FileTransfers WHERE ID=@id AND MachineID=@mid",
new SQLParam("@mid", ni.Username),
new SQLParam("@id", ID)));
}
if (File.Exists(Filename) == true)
{
try
{
CommonUtilities.SpecialDeleteFile(Filename);
}
catch
{ }
}
lock (ni.sqllock)
{
sql.ExecSQLScalar("DELETE FROM FileTransfers WHERE ID=@id AND MachineID=@mid",
new SQLParam("@mid", ni.Username),
new SQLParam("@id", ID));
}
return(RESTStatus.Success);
}
public RESTStatus CloseWSServerMappingPort(SQLLib sql, NetString GUID, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
RemoteNetworkConnectionWSCrosser.CloseSession(ni.Username, GUID.Data);
Res = new PushConnectNetworkResult();
Res.Result = 0;
return(RESTStatus.Success);
}
public RESTStatus PopSTDIOData(SQLLib sql, NetString StdIOSession, NetworkConnectionInfo ni, string MachineID)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
if (StdIOSession == null)
{
ni.Error = "Missing Session Data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(StdIOSession.Data) == true)
{
ni.Error = "Missing Session Data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
string sess = "stdio-" + StdIOSession.Data;
PushDataResponse resp = PushServiceHelper.PopResponse(MachineID, 0, sess, true);
if (resp == null)
{
res = new Push_Stdio_StdOut();
res.SessionID = StdIOSession.Data;
res.State = PushStdoutState.Timeout;
return(RESTStatus.NoContent);
}
try
{
res = JsonConvert.DeserializeObject <Push_Stdio_StdOut>(resp.Data.ToString());
}
catch
{
res = new Push_Stdio_StdOut();
res.SessionID = StdIOSession.Data;
res.State = PushStdoutState.InternalError;
return(RESTStatus.NoContent);
}
return(RESTStatus.Success);
}
public RESTStatus ChangeUser(SQLLib sql, UserDetailsPassword User, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Fail);
}
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM Users WHERE Username=@u",
new SQLParam("@u", User.Username))) == 0)
{
ni.Error = "Invalid User";
ni.ErrorID = ErrorFlags.InvalidID;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(User.NewPassword) == false)
{
if (MeetPasswordPolicy(User.NewPassword) == false)
{
ni.Error = "Password policy not met";
ni.ErrorID = ErrorFlags.PWPolicyNotMet;
return(RESTStatus.Fail);
}
string PWMD5REQ = Convert.ToBase64String(Encoding.Unicode.GetBytes(User.NewPassword));
sql.ExecSQL("UPDATE Users SET Password=@p WHERE Username=@u",
new SQLParam("@u", User.Username),
new SQLParam("@p", PWMD5REQ));
}
if (User.Username.ToLower().Trim() == "root")
{
User.Permissions = SQLTest.AllPermissions;
}
sql.ExecSQL("UPDATE Users SET Name=@n, Permissions=@p, MustChangePassword=@mchg,EMail=@email,UseLDAP=@UseLDAP,LDAPUsername=@LDAPUsername WHERE Username=@u",
new SQLParam("@u", User.Username),
new SQLParam("@n", User.Name),
new SQLParam("@p", User.Permissions),
new SQLParam("@mchg", User.MustChangePassword),
new SQLParam("@email", User.EMail),
new SQLParam("@useldap", User.UseLDAP),
new SQLParam("@LDAPUsername", User.LDAPUsername));
return(RESTStatus.Success);
}
public RESTStatus PushNetworkDataCreateConnection(SQLLib sql, PushConnectNetwork data, NetworkConnectionInfo ni, string MachineID)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
string SessionConnectionGUID = RemoteNetworkConnectionWSCrosser.CreateSession(ni.Username, MachineID);
data.SessionID = SessionConnectionGUID;
string sess = Guid.NewGuid().ToString();
PushData p = new PushData();
p.Action = "netcreatedata2";
p.ReplyID = sess;
p.AdditionalData1 = JsonConvert.SerializeObject(data);
PushServiceHelper.SendPushService(MachineID, p, 1);
PushDataResponse resp = PushServiceHelper.PopResponse(MachineID, 1, sess);
if (resp == null)
{
ni.Error = "No response";
ni.ErrorID = ErrorFlags.NoData;
RemoteNetworkConnectionWSCrosser.CloseSession(SessionConnectionGUID);
return(RESTStatus.NoContent);
}
try
{
res1 = JsonConvert.DeserializeObject <PushConnectNetworkResult>(resp.Data.ToString());
}
catch
{
ni.Error = "Faulty data";
ni.ErrorID = ErrorFlags.NoData;
RemoteNetworkConnectionWSCrosser.CloseSession(SessionConnectionGUID);
return(RESTStatus.NoContent);
}
return(RESTStatus.Success);
}
private void button3_Click( object sender, EventArgs e )
{
try
{
SqlLib.SQLLib sql = new SQLLib();
////read in customer
//System.Data.DataSet dscust = new DataSet();
//if (sql.ExecRsNB ("Select * from Customer",CommandType.Text ,ref dscust,null,"dbMSSql",false) == false)
// {
// int asdf = 0;
// }
////write customer to mysql
//try
// {
// StringBuilder ssql = new StringBuilder();
// ssql.Append( "Insert into Customer (eSubmitId,CustName,CustAddress,CustCity,CustState,CustZip) Values " );
// for (int rec = 0; rec < dscust.Tables[0].Rows.Count; rec++)
// {
// if (rec > 0) { ssql.Append( "," ); } //add comma between multiple insert row
// ssql.Append( "(" ); // + dscust.Tables[0].Rows[rec]["CustomerId"] + "," );
// ssql.Append("'"+ dscust.Tables[0].Rows[rec]["CertnaId"] + "'," );
// ssql.Append( "'" + dscust.Tables[0].Rows[rec]["CustName"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'"+dscust.Tables[0].Rows[rec]["CustAddress"].ToString().Replace("'","") + "'," );
// ssql.Append( "'"+dscust.Tables[0].Rows[rec]["CustCity"] + "'," );
// ssql.Append("'"+ dscust.Tables[0].Rows[rec]["CustState"] + "'," );
// ssql.Append("'"+ dscust.Tables[0].Rows[rec]["CustZip"] +"'");
// // ssql.Append( dscust.Tables[0].Rows[rec]["BillingCode"] + "," );
// // ssql.Append( dscust.Tables[0].Rows[rec]["SecondaryValue"] );
// ssql.Append( ")" );
// }
// string sinsert = ssql.ToString();
// string ready = "";
// sql.ExecA( ssql.ToString(), CommandType.Text, "dbMySql", false );
// }
//catch (Exception ex)
// {
// int zz = 0;
// }
//read in recorder fee
//insert into mysql recorder fee
//System.Data.DataSet dsfees = new DataSet();
//if (sql.ExecRsNB( "Select * from RecordingFees", CommandType.Text, ref dsfees, null, "dbMSSql", false ) == false)
// {
// int asdf = 0;
// }
////write customer to mysql
//try
// {
// StringBuilder ssql = new StringBuilder();
// ssql.Append( "Insert into RecordingFees (DocRecId,UniqueOrderId,FeeDescription,FeeAmount) Values " );
// for (int rec = 0; rec < dsfees.Tables[0].Rows.Count; rec++)
// {
// if (rec > 0) { ssql.Append( "," ); } //add comma between multiple insert row
// ssql.Append( "(" ); // + dscust.Tables[0].Rows[rec]["CustomerId"] + "," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["DocRecId"] + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["UniqueOrderId"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["FeeDescription"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( dsfees.Tables[0].Rows[rec]["FeeAmount"] );
// ssql.Append( ")" );
// }
// string sinsert = ssql.ToString();
// string ready = "";
// sql.ExecA( ssql.ToString(), CommandType.Text, "dbMySql", false );
// }
//catch (Exception ex)
// {
// int zz = 0;
// }
//read in rejected codes
// insert in rejected codes
//System.Data.DataSet dsfees = new DataSet();
//if (sql.ExecRsNB( "Select * from RejectedErrors", CommandType.Text, ref dsfees, null, "dbMSSql", false ) == false)
// {
// int asdf = 0;
// }
////write customer to mysql
//try
// {
// StringBuilder ssql = new StringBuilder();
// ssql.Append( "Insert into RejectedErrors (DocRecId,UniqueOrderId,ErrorDescription) Values " );
// for (int rec = 0; rec < dsfees.Tables[0].Rows.Count; rec++)
// {
// if (rec > 0) { ssql.Append( "," ); } //add comma between multiple insert row
// ssql.Append( "(" ); // + dscust.Tables[0].Rows[rec]["CustomerId"] + "," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["DocRecId"] + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["UniqueOrderId"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["ErrorDescription"].ToString().Replace( "'", "" ) + "'" );
// ssql.Append( ")" );
// }
// string sinsert = ssql.ToString();
// string ready = "";
// sql.ExecA( ssql.ToString(), CommandType.Text, "dbMySql", false );
// }
//catch (Exception ex)
// {
// int zz = 0;
// }
//read fips_codes
////insert fips_codes
//System.Data.DataSet dsfees = new DataSet();
//if (sql.ExecRsNB( "Select * from Fips_codes", CommandType.Text, ref dsfees, null, "dbMSSql", false ) == false)
// {
// int asdf = 0;
// }
////write customer to mysql
//try
// {
// StringBuilder ssql = new StringBuilder();
// ssql.Append( "Insert into FIPS_CODES (St_abbr,St_name,St_fips,County_name,County_FIPS) Values " );
// for (int rec = 0; rec < dsfees.Tables[0].Rows.Count; rec++)
// {
// if (rec > 0) { ssql.Append( "," ); } //add comma between multiple insert row
// ssql.Append( "(" ); // + dscust.Tables[0].Rows[rec]["CustomerId"] + "," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["ST_ABBR"] + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["State_name"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["State_FIPS"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["County_name"].ToString().Replace( "'", "" ) + "'," );
// ssql.Append( "'" + dsfees.Tables[0].Rows[rec]["County_FIPS"].ToString().Replace( "'", "" ) + "'" );
// ssql.Append( ")" );
// }
// string sinsert = ssql.ToString();
// string ready = "";
// sql.ExecA( ssql.ToString(), CommandType.Text, "dbMySql", false );
// }
//catch (Exception ex)
// {
// int zz = 0;
// }
}
catch (Exception ex)
{
int xx = 0;
}
}
