/// <summary> /// /// </summary> /// <returns></returns> public List <string> GetLogging() { listOfConditionOfLog = new List <string>(); StringStream stringStream = new StringStream(pipeClient); string protocol = "GetLogSettings"; stringStream.WriteStringToService(protocol); string readFromService = stringStream.ReadStringFromService(); string condition = ""; if (readFromService.Contains("Success")) { for (int i = 0; i < 12; i++) { condition = stringStream.ReadStringFromService(); listOfConditionOfLog.Add(condition); } } else { condition = "Error"; listOfConditionOfLog.Add(condition); } return(listOfConditionOfLog); }
/// <summary> /// /// </summary> /// <returns></returns> public string AskForConnStr() { connectionStringList.Clear(); StringStream stringStream = new StringStream(pipeClient); string sendRequest = "GetConnectionStrings"; stringStream.WriteStringToService(sendRequest); string amountOfStringsOrError = stringStream.ReadStringFromService(); List <string> connectionList = new List <string>(); if (amountOfStringsOrError.Contains("Error")) { return(amountOfStringsOrError); } else { int amount = int.Parse(amountOfStringsOrError); for (int i = 0; i < amount; i++) { connectionList.Add(stringStream.ReadStringFromService()); } foreach (string str in connectionList) { connectionStringList.Add(new Model.ServerClass(str.Split('=', ';')[1], new Model.ConnectionString(str.Split('=', ';')[3], str.Split('=', ';')[5], str.Split('=', ';')[7]))); } return("True"); } }
/// <summary> /// /// </summary> /// <returns></returns> public string DisconnectFromDatabase() { try { StringStream stringStream = new StringStream(pipeClient); string sendProtocol = "DisconnectFromDatabase"; stringStream.WriteStringToService(sendProtocol); messageFromService = stringStream.ReadStringFromService(); } catch (Exception exceptionInDisconnectFromDB) { messageFromService = exceptionInDisconnectFromDB.Message; } return(messageFromService); }
/// <summary> /// /// </summary> /// <param name="connectionstring"></param> /// <returns></returns> public string DeleteConStr(string connectionstring) { string doWhat = "DeleteConnectionString"; string result = ""; try { StringStream stringStream = new StringStream(pipeClient); stringStream.WriteStringToService(doWhat); stringStream.WriteStringToService(connectionstring); result = stringStream.ReadStringFromService(); } catch (Exception e) { return(e.ToString()); } return(result); }
public string SetLogFiles(List <string> selectedCheckBoxes) { try { StringStream stringStream = new StringStream(pipeClient); string protocol = "EditLogSettings"; stringStream.WriteStringToService(protocol); foreach (var item in selectedCheckBoxes) { stringStream.WriteStringToService(item); } LogStatus = stringStream.ReadStringFromService(); } catch (Exception exceptionInSetLog) { LogStatus = exceptionInSetLog.Message; } return(LogStatus); }
/// <summary> /// The method which connects to the pipe /// </summary> public void ConnectToService() { try { pipeClient.Connect(); StringStream stringStream = new StringStream(pipeClient); if (stringStream.ReadStringFromService() == "I am the one true server!") { } else { Console.WriteLine("Server could not be verified."); } } catch (Exception ex) { string gi = ex.Message; throw; } }
/// <summary> /// /// </summary> /// <param name="con"></param> /// <returns></returns> public string ConnectToDatabase(string ServerName, string DbName, string UsrName, string Password) { try { StringStream stringStream = new StringStream(pipeClient); string sendProtocol = "ConnectToDatabase"; stringStream.WriteStringToService(sendProtocol); stringStream.WriteStringToService(ServerName); stringStream.WriteStringToService(DbName); stringStream.WriteStringToService(UsrName); stringStream.WriteStringToService(Password); messageFromService = stringStream.ReadStringFromService(); } catch (Exception exceptionInConnectToDB) { messageFromService = exceptionInConnectToDB.Message; } return(messageFromService); }
/// <summary> /// /// </summary> /// <param name="serverName"></param> /// <param name="dbName"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <returns></returns> public string SendConStrToService(string serverName, string dbName, string userName, string password) { string configeDB = "SetNewConnectionString"; string result = ""; try { StringStream stringStream = new StringStream(pipeClient); stringStream.WriteStringToService(configeDB); stringStream.WriteStringToService(serverName); stringStream.WriteStringToService(dbName); stringStream.WriteStringToService(userName); stringStream.WriteStringToService(password); result = stringStream.ReadStringFromService(); } catch (Exception e) { result = e.Message.ToString(); } return(result); }
/// <summary> /// /// </summary> /// <param name="serverName"></param> /// <param name="dbName"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <param name="oldstring"></param> /// <returns></returns> public string SendEditConStrToService(string serverName, string dbName, string userName, string password, string oldstring) { string doWhat = "EditConnectionString"; string result = ""; try { StringStream stringStream = new StringStream(pipeClient); stringStream.WriteStringToService(doWhat); stringStream.WriteStringToService(serverName); stringStream.WriteStringToService(dbName); stringStream.WriteStringToService(userName); stringStream.WriteStringToService(password); stringStream.WriteStringToService(oldstring); result = stringStream.ReadStringFromService(); } catch (Exception e) { return(e.Message.ToString()); } return(result); }
/// <summary> /// /// </summary> /// <returns></returns> public string SendDataToService() { try { StringStream stringStream = new StringStream(pipeClient); //Change the protocol to insert data to SQL string sendProtocol = "UploadData"; stringStream.WriteStringToService(sendProtocol); foreach (var item in ProduceFakeData()) { stringStream.WriteStringToService(item.SG10IG001IN0001); stringStream.WriteStringToService(item.SG10IG001IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG001IN0003.ToString()); stringStream.WriteStringToService(item.SG10IG002IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG002IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG002IN0006.ToString()); stringStream.WriteStringToService(item.SG10IG002IN0007.ToString()); stringStream.WriteStringToService(item.SG10IG003IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG003IN0003.ToString()); stringStream.WriteStringToService(item.SG10IG005IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG005IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG005IN0003.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0003.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0004.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0005.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0006.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0007.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0012.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0013.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0015.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0016.ToString()); stringStream.WriteStringToService(item.SG10IG010IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG050IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG050IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG050IN0009.ToString()); stringStream.WriteStringToService(item.SG10IG050IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0012.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0013.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0015.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0016.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG051IN0018.ToString()); stringStream.WriteStringToService(item.SG10IG052IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG052IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG052IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG052IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG053IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG053IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG053IN0015.ToString()); stringStream.WriteStringToService(item.SG10IG053IN0016.ToString()); stringStream.WriteStringToService(item.SG10IG054IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG054IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG054IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0016.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG055IN0018.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0013.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG056IN0018.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0020.ToString()); stringStream.WriteStringToService(item.SG10IG057IN0021.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0020.ToString()); stringStream.WriteStringToService(item.SG10IG058IN0021.ToString()); stringStream.WriteStringToService(item.SG10IG059IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG059IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG059IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG059IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG060IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG060IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG060IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0016.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG061IN0018.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0013.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0017.ToString()); stringStream.WriteStringToService(item.SG10IG062IN0018.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0020.ToString()); stringStream.WriteStringToService(item.SG10IG063IN0021.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0010.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0011.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0014.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0020.ToString()); stringStream.WriteStringToService(item.SG10IG064IN0021.ToString()); stringStream.WriteStringToService(item.SG10IG065IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG065IN0002.ToString()); stringStream.WriteStringToService(item.SG10IG066IN0001.ToString()); stringStream.WriteStringToService(item.SG10IG066IN0002.ToString()); } statusMessageForInsert = stringStream.ReadStringFromService(); } catch (Exception exceptionInSendGeneratedDataToService) { statusMessageForInsert = exceptionInSendGeneratedDataToService.Message; } return(statusMessageForInsert); }
/// <summary> /// /// </summary> /// <returns></returns> public DBReturnValues AddToListOfReceptValuesFromService(string SPName, string materialNo) { StringStream stringStream = new StringStream(pipeClient); string sendProtocol = "ReceiveData"; stringStream.WriteStringToService(sendProtocol); stringStream.WriteStringToService(SPName); stringStream.WriteStringToService(materialNo); string knownColumn = "false"; StoredColumn myColumn = new StoredColumn(); DBReturnValues newValues = new DBReturnValues(); try { foreach (StoredColumn item in Columns) { if (item.Name == SPName) { knownColumn = "true"; myColumn = item; } } stringStream.WriteStringToService(knownColumn); string amountOfRowsOrError = stringStream.ReadStringFromService(); if (amountOfRowsOrError.Contains("Error")) { //allRows.Add(new List<DynamicClass>().Add(new DynamicClass(receivedFromService, null, null))); newValues.Result = amountOfRowsOrError; return(newValues); } else { int amountOfRows = int.Parse(amountOfRowsOrError); if (knownColumn == "true") { for (int i = 0; i < amountOfRows; i++) { List <string> oneRow = new List <string>(); for (int j = 0; j < myColumn.ColumnNames.Count; j++) { oneRow.Add(stringStream.ReadStringFromService()); } newValues.Rows.Add(oneRow); } // only addded the values from the service //adding the columns and the types from the saved list newValues.Result = "True"; newValues.ColumnNames = myColumn.ColumnNames; newValues.Types = myColumn.ColumnTypes; } else { //return everything from the service and save the column names and //the types into the list of known columns int amountOfColumns = int.Parse(stringStream.ReadStringFromService()); for (int i = 0; i < amountOfColumns; i++) { string type = stringStream.ReadStringFromService(); string columnName = stringStream.ReadStringFromService(); newValues.ColumnNames.Add(columnName); newValues.Types.Add(type); } //loaded column names and types //save this into the list of known columns StoredColumn newStoredColumn = new StoredColumn(); newStoredColumn.Name = SPName; newStoredColumn.ColumnNames = newValues.ColumnNames; newStoredColumn.ColumnTypes = newValues.Types; Columns.Add(newStoredColumn); newValues.Result = "True"; for (int i = 0; i < amountOfRows; i++) { List <string> oneRow = new List <string>(); for (int j = 0; j < newValues.ColumnNames.Count; j++) { oneRow.Add(stringStream.ReadStringFromService()); } newValues.Rows.Add(oneRow); } } } } catch (Exception) { throw; } return(newValues); }