private void sendFile(GroupInfoModel group, PackageInfoModel package) { FileController fileController = new FileController(); string filePath = fileController.getPathFromFile(group.Name, package.Name); if (!File.Exists(filePath)) { return; } byte[] fileName = Encoding.ASCII.GetBytes(package.Name); byte[] fileData = File.ReadAllBytes(filePath); byte[] fileNameLen = BitConverter.GetBytes(fileName.Length); byte[] file = new byte[4 + fileName.Length + fileData.Length]; fileNameLen.CopyTo(file, 0); fileName.CopyTo(file, 4); fileData.CopyTo(file, 4 + fileName.Length); try { tcpConnection.Client.Send(file); Console.WriteLine("File: {0} has been sent.", fileName); } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, EventLogEntryType.Error, 3003); } stopConnection(); }
public GroupInfoModel gbAddGroup(GroupInfoModel oGroup) { try { string sQry; GroupInfoModel oResult = new GroupInfoModel(); SqlCeCommand sqlCmd = new SqlCeCommand(); if (oGroup.ID == -1) { sQry = "INSERT INTO Gruppe(Gruppe_Name)" + "VALUES ('" + oGroup.Name + "')"; } else { sQry = "UPDATE Gruppe SET Gruppe_Name = '" + oGroup.Name + "'"; } sqlCmd.CommandText = sQry; sqlCmd.Connection = Connection; openConnection(); sqlCmd.ExecuteNonQuery(); closeConnection(); // Bearbeiteten Datensatz ermitteln und im objekt speichern sQry = "SELECT * FROM Gruppe WHERE Gruppe_Name = '" + oGroup.Name.ToString() + "'"; DataTable oData = new DataTable(); SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { if (oData.Rows.Count == 1) { oResult.ID = Convert.ToInt32(oRow["Gruppe_ID"]); oResult.Name = oRow["Gruppe_Name"].ToString(); } } return oResult; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3103); return null; } }
public bool gbDeleteGroup(GroupInfoModel oGroup) { try { SqlCeCommand sqlCmd = new SqlCeCommand(); string sQry; if (mbDataExists("Gruppe", "Gruppe_ID = " + oGroup.ID)) { // Vorher alle Clients der Gruppe ermitteln und in Standard packen DataTable oData = new DataTable(); sQry = "SELECT * FROM Client WHERE Client_Gruppe = " + oGroup.ID; SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { ClientInfoModel clientingroup = new ClientInfoModel(); clientingroup.ID = Convert.ToInt32(oRow["Client_ID"]); gbDeleteClient(clientingroup); } // Gruppe löschen sQry = "DELETE FROM Gruppe WHERE Gruppe_ID = " + oGroup.ID; sqlCmd = new SqlCeCommand(sQry, Connection); openConnection(); sqlCmd.ExecuteNonQuery(); } if (mbDataExists("Gruppe_Softwarepaket", "Gruppe_ID = " + oGroup.ID)) { // Software-Einträge löschen, die mit der Gruppe verknüpft sind sQry = "DELETE FROM Gruppe_Softwarepaket WHERE Gruppe_ID = " + oGroup.ID; sqlCmd = new SqlCeCommand(sQry, Connection); openConnection(); sqlCmd.ExecuteNonQuery(); } closeConnection(); return true; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3107); return false; } }
public List<PackageInfoModel> GetGroupPackages(GroupInfoModel oGroup) { try { List<PackageInfoModel> oResult = new List<PackageInfoModel>(); DataTable oData = new DataTable(); string sQry; sQry = " SELECT S.Softwarepaket_ID, S.Softwarepaket_Name " + " , S.Softwarepaket_Groesse, S.Softwarepaket_Arc " + " , S.Softwarepaket_ShowName " + " FROM Softwarepaket AS S" + " LEFT JOIN Gruppe_Softwarepakete AS GS ON S.Softwarepaket_ID = GS.Softwarepaket_ID " + " WHERE GS.Gruppe_ID = " + oGroup.ID; SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { PackageInfoModel package = new PackageInfoModel(); package.ID = Convert.ToInt32(oRow["Softwarepaket_ID"]); package.Name = oRow["Softwarepaket_Name"].ToString(); package.size = Convert.ToInt32(oRow["Softwarepaket_Groesse"]); package.arc = oRow["Softwarepaket_Arc"].ToString(); package.showName = oRow["Softwarepaket_ShowName"].ToString(); oResult.Add(package); } return oResult; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3015); return null; } }
public List<GroupInfoModel> GetGroupInfoModels() { try { List<GroupInfoModel> oResult = new List<GroupInfoModel>(); DataTable oData = new DataTable(); SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter("SELECT * FROM Gruppe", Connection); oDataAdapter.Fill(oData); if (oData.Rows.Count > 0) { foreach (DataRow oRow in oData.Rows) { GroupInfoModel oGroup = new GroupInfoModel(); oGroup.ID = Convert.ToInt32(oRow["Gruppe_ID"]); oGroup.Name = oRow["Gruppe_Name"].ToString(); oResult.Add(oGroup); } } return oResult; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3012); return null; } }
public List<ClientInfoModel> GetGroupClients(GroupInfoModel oGroup) { try { List<ClientInfoModel> oResult = new List<ClientInfoModel>(); DataTable oData = new DataTable(); string sQry; sQry = "SELECT * FROM Client WHERE Client_Gruppe = " + oGroup.ID; SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { if (!Convert.ToBoolean(oRow["Client_Administrator"])) { ClientInfoModel client = new ClientInfoModel(); client.ID = Convert.ToInt32(oRow["Client_ID"]); client.macAddress = oRow["Client_MacAdresse"].ToString(); client.group = Convert.ToInt32(oRow["Client_Gruppe"]); client.arc = oRow["Client_Arc"].ToString(); client.admin = Convert.ToBoolean(oRow["Client_Administrator"]); client.pcName = oRow["Client_PCName"].ToString(); oResult.Add(client); } } return oResult; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3014); return null; } }
public GroupInfoModel GetGroupByPackage(PackageInfoModel oPackage) { GroupInfoModel oResult = new GroupInfoModel(); string sQry; DataTable oData = new DataTable(); sQry = "SELECT G.Gruppe_ID, G.Gruppe_Name FROM Gruppe_Softwarepakete AS GS LEFT JOIN Gruppe AS G ON G.Gruppe_ID = GS.Gruppe_ID WHERE GS.Softwarepaket_ID = " + oPackage.ID; SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { oResult.ID = Convert.ToInt32(oRow["Gruppe_ID"]); oResult.Name = oRow["Gruppe_Name"].ToString(); } return oResult; }
public GroupInfoModel GetGroupByClient(ClientInfoModel oClient) { try { GroupInfoModel oResult = new GroupInfoModel(); DataTable oData = new DataTable(); string sQry; sQry = "SELECT * FROM Gruppe WHERE Gruppe_ID = " + oClient.group.ToString(); SqlCeDataAdapter oDataAdapter = new SqlCeDataAdapter(sQry, Connection); oDataAdapter.Fill(oData); foreach (DataRow oRow in oData.Rows) { if (oData.Rows.Count == 1) { oResult.ID = Convert.ToInt32(oRow["Gruppe_ID"]); oResult.Name = oRow["Gruppe_Name"].ToString(); } } return oResult; } catch (Exception ex) { Diagnostics.WriteToEventLog(ex.Message, System.Diagnostics.EventLogEntryType.Error, 3017); return null; } }