internal void Initialize(KeyValues props) { foreach (var pair in props) { if (_properties.ContainsKey(pair.Key)) { _properties[pair.Key] = pair.Value; } else { _properties.Add(pair.Key, pair.Value); } } if (!_sPropertyActions.TryGetValue(GetType(), out var actions)) { return; } foreach (var pair in props) { if (actions.TryGetValue(pair.Key, out var action)) { action(this, pair.Value); } } }
/// <summary> /// Asserts the validation. /// </summary> /// <param name="keys">The keys.</param> public void AssertValidation(params string[] keys) { var sb = new StringBuilder(); foreach (var item in keys) { if (!KeyValues.ContainsKey(item)) { sb.AppendFormat("{0}, ", item); } else { if (string.IsNullOrEmpty(KeyValues[item])) { sb.AppendFormat("No value for '{0}', which is required. ", item); } } var result = sb.ToString(); if (result.Length > 0) { throw new InvalidDataException("Can't submit to Gateway - missing these input fields: " + result.Trim().TrimEnd(',')); } } }
public static string[] GetSteamLibraryDirectories() { var dir = GetSteamDirectory(); if (dir != null) { var libraryfolders = Path.Combine(dir, "steamapps", "libraryfolders.vdf"); if (File.Exists(libraryfolders)) { KeyValues kv = KVFile.ImportKeyValue(File.ReadAllText(libraryfolders), false); int i = 1; object obj; var list = new List <string>(); list.Add(Path.GetFullPath(Path.Combine(dir, "steamapps"))); while ((obj = kv.Root.GetValue(i++.ToString())) != null) { list.Add(Path.GetFullPath(Path.Combine((string)obj, "steamapps"))); } if (list.Count > 0) { return(list.ToArray()); } } } return(null); }
public override void Parse() { base.Parse(); if (KeyValues.ContainsKey("pid") && KeyValues.ContainsKey("resp")) { //we parse profileid here int profileID; if (!int.TryParse(KeyValues["pid"], out profileID)) { throw new GSException("pid format is incorrect."); } ProfileId = profileID; RequestType = AuthMethod.ProfileIDAuth; } else if (KeyValues.ContainsKey("authtoken") && KeyValues.ContainsKey("response")) { AuthToken = KeyValues["authtoken"]; Response = KeyValues["response"]; RequestType = AuthMethod.PartnerIDAuth; } else if (KeyValues.ContainsKey("keyhash") && KeyValues.ContainsKey("nick")) { RequestType = AuthMethod.CDkeyAuth; KeyHash = KeyValues["keyhash"]; Nick = KeyValues["nick"]; } else { throw new GSException("Unknown authp request method."); } }
/// <summary> /// 获取场景进入条件码 /// </summary> /// <param name="scene"></param> /// <returns></returns> public int GetSceneEntranceCondition(string scene) { scene = scene.Split('&')[0]; //处理一些特殊格式的 var gamemap = ConfigTable.Get <GameMap>(scene); if (gamemap != null) { //大地图 if (gamemap.Tags == "WORLDMAP") { return(0); } //已经有地图打开的纪录 string key = "SceneEntraceCondition_" + gamemap.Jyx2MapId; if (KeyValues.ContainsKey(key)) { return(int.Parse(GetKeyValues(key))); } //否则取配置表初始值 var map = ConfigTable.Get <Jyx2Map>(gamemap.Jyx2MapId); if (map != null) { return(map.EnterCondition); } } return(-1); }
private void DemoKeyValueStore() { var newPerson = new Person(1, "First", "Person"); "Saving new person: {0} - {1} {2}".ToInfo <RiakService>(newPerson.Id, newPerson.FirstName, newPerson.LastName); KeyValues.Persist(newPerson.Id.ToString(), newPerson); "Retrieving new person".ToInfo <RiakService>(); var retrieved = KeyValues.Get <Person>("1"); "Retrieved: {0} - {1} {2}".ToInfo <RiakService>(retrieved.Id, retrieved.FirstName, retrieved.LastName); var additional = new Person(2, "Second", "Person"); "Adding another person: {0} - {1} {2}".ToInfo <RiakService>(additional.Id, additional.FirstName, additional.LastName); "Retrieving all people".ToInfo <RiakService>(); var people = KeyValues.GetAll <Person>(); "Retrieved {0} people.".ToInfo <RiakService>(people.Count()); "Deleting people".ToInfo <RiakService>(); KeyValues.Delete <Person>("1"); KeyValues.Delete <Person>("2"); }
public void AddChannel(MergedChannel mergedChannel, bool includeEncrypted) { foreach (TuningInfo tuningInfo in mergedChannel.TuningInfos) { // make sure it is DVBS if (!(tuningInfo is DvbTuningInfo dvbTuningInfo) || !dvbTuningInfo.TuningSpace.Equals("DVB-S")) { continue; } var locator = dvbTuningInfo.TuneRequest.Locator as DVBSLocator; // filter on options if ((dvbTuningInfo.IsEncrypted || dvbTuningInfo.IsSuggestedBlocked) && !includeEncrypted) { continue; } // determine satellite, transponder, and service for channel var satellite = GetOrCreateSatellite(locator.OrbitalPosition); var transponder = satellite.GetOrCreateTransponder(dvbTuningInfo.Frequency / 1000, (int)locator.SignalPolarisation - 1, locator.SymbolRate / 1000, dvbTuningInfo.Onid, dvbTuningInfo.Tsid); var service = transponder.GetOrCreateService(mergedChannel.CallSign, dvbTuningInfo.Sid, mergedChannel.Service.ServiceType == 2 ? 1 : mergedChannel.Service.ServiceType == 3 ? 2 : 0, dvbTuningInfo.IsEncrypted || dvbTuningInfo.IsSuggestedBlocked); // add channel with callsign and channel number var keyValues = new KeyValues(WmcStore.WmcObjectStore); var region = GetOrCreateRegion(keyValues.Single(arg => arg.Key == "ClientCountryCode").Value); var footprint = region.GetOrCreateFootprint(satellite); var headend = footprint.GetOrCreateHeadend(satellite.PositionEast); headend.AddChannel(service, int.Parse(mergedChannel.ChannelNumber.ToString())); AddReferenceHeadend(headend); } }
public bool Create(KeyValuesViewModel data, out string errMsg) { KeyValuesDAO keyValuesDAO = new KeyValuesDAO(); errMsg = ""; try { KeyValues modelData = new KeyValues(); modelData.KeyValueName = data.KeyValueName; modelData.Text = data.Text; modelData.Value = data.Value; modelData.Sort = data.Sort; modelData.EnterPriseId = data.EnterPriseId; keyValuesDAO.Insert(modelData); keyValuesDAO.SaveChange(); } catch (Exception ex) { errMsg = ex.Message; return(false); } return(true); }
/// <summary> /// Generates the commands that correspond to this operation. /// </summary> /// <returns> The commands that correspond to this operation. </returns> public virtual IEnumerable <ModificationCommand> GenerateModificationCommands() { Debug.Assert(KeyColumns.Length == KeyValues.GetLength(1), $"The number of key values doesn't match the number of keys (${KeyColumns.Length})"); Debug.Assert(Columns.Length == Values.GetLength(1), $"The number of values doesn't match the number of keys (${Columns.Length})"); Debug.Assert(KeyValues.GetLength(0) == Values.GetLength(0), $"The number of key values doesn't match the number of values (${KeyValues.GetLength(0)})"); for (var i = 0; i < KeyValues.GetLength(0); i++) { var keys = new ColumnModification[KeyColumns.Length]; for (var j = 0; j < KeyColumns.Length; j++) { keys[j] = new ColumnModification( KeyColumns[j], originalValue: null, value: KeyValues[i, j], isRead: false, isWrite: false, isKey: true, isCondition: true); } var modifications = new ColumnModification[Columns.Length]; for (var j = 0; j < Columns.Length; j++) { modifications[j] = new ColumnModification( Columns[j], originalValue: null, value: Values[i, j], isRead: false, isWrite: true, isKey: true, isCondition: false); } yield return(new ModificationCommand(Table, Schema, keys.Concat(modifications).ToArray())); } }
/// <summary> /// 将为指定的 Key 清除。 /// </summary> /// <param name="key">指定项的 Key。</param> protected override async Task RemoveValueCoreAsync(string key) { await LoadFromFileTask.ConfigureAwait(false); CT.Debug($"{key} = null", "Set"); KeyValues.TryRemove(key, out _); }
async Task LoadOrders(string value) { LoadingManager.OnLoading(); Status _statusvalue = (Status)Enum.Parse(typeof(Status), value); var orderData = await orderDataStore.GetOrdersOfUserWithSpecificStatus(App.LogUser.UserId, _statusvalue, App.TokenDto.Token); KeyValues.Clear(); KeyValues.Add("orderAdded", orderData); UserOrders.Clear(); foreach (var item in orderData) { item.StoreOrder = await StoreDataStore.GetItemAsync(item.StoreId.ToString()); var presenter = new OrderPresenter(item); UserOrders.Add(presenter); } LoadingManager.OffLoading(); }
public override void Parse() { base.Parse(); if (!KeyValues.ContainsKey("sesskey")) { throw new GSException("sesskey is missing."); } int sessKey; if (!int.TryParse(KeyValues["sesskey"], out sessKey)) { throw new GSException("sesskey is not a valid int."); } SessionKey = sessKey; if (!KeyValues.ContainsKey("connid")) { throw new GSException("connid is missing."); } int connectionID; if (!int.TryParse(KeyValues["connid"], out connectionID)) { throw new GSException("connid format is incorrect."); } ConnectionID = connectionID; if (KeyValues.ContainsKey("challenge")) { IsClientLocalStorageAvailable = true; Challenge = KeyValues["challenge"]; } }
private void SetPrettyName(KeyValues kv) { if (kv.Key == "Type") { kv.Name = "Typ"; } else if (kv.Key == "ProviderName") { kv.Name = "Leverantörsnamn"; } else if (kv.Key == "pType") { kv.Name = "P-Typ"; } else if (kv.Key == "DeliveryLibrary") { kv.Name = "Ägandebibliotek"; } else if (kv.Key == "HomeLibrary") { kv.Name = "Hembibliotek"; } else if (kv.Key == "CancellationReason") { kv.Name = "Annulleringsorsak"; } else if (kv.Key == "PurchasedMaterial") { kv.Name = "Inköpt Material"; } else { kv.Name = kv.Key; } }
public VMTFile(Stream stream, String FileName = "") { this.FileName = FileName; if (stream == null) { MakeDefaultMaterial(); return; } KeyValues = KeyValues.FromStream(stream); if (KeyValues.Keys.Count() > 0 && KeyValues != null) { ShaderType = KeyValues.Keys.First(); //If shader is null, return if (string.IsNullOrEmpty(ShaderType)) { throw new FileLoadException(String.Format("Shader type is missing in material, skip parse", FileName)); } } else { throw new FileLoadException(String.Format("is missing any KeyValues data, skip parse", FileName)); } }
public async Task <bool> CheckUpdate(Server server) { if (!server.Game.SteamID.HasValue) { throw new Exception("Server game with SteamCMD Handler has no SteamID assigned!"); } uint appID = server.Game.SteamID.GetValueOrDefault(); string appManifestFile = Path.Combine(server.Path, "SteamApps", string.Format(CultureInfo.InvariantCulture, "appmanifest_{0}.acf", appID)); if (File.Exists(appManifestFile)) { KeyValues manifestKv; using (Stream s = File.OpenRead(appManifestFile)) { manifestKv = new KeyValues(s); } Dictionary <string, object> appState = (Dictionary <string, object>)manifestKv.Items["AppState"]; var serverData = await _steamAPIService.GetAppInfo(appID); if (appState["buildid"] != serverData.KeyValues["depots"]["branches"][server.Branch]["buildid"]) { return(true); } } return(false); }
public override void Parse() { base.Parse(); if (!KeyValues.ContainsKey("gamename")) { throw new GSException("gamename is missing."); } if (!KeyValues.ContainsKey("response")) { throw new GSException("response is missing."); } if (KeyValues.ContainsKey("port")) { int port; if (!int.TryParse(KeyValues["port"], out port)) { throw new GSException("port format is incorrect."); } Port = port; } GameName = KeyValues["gamename"]; }
/// <summary> /// Accept message from client. /// </summary> /// <param name="message">Request message.</param> public override void AcceptMessage(StreamMessage message) { base.AcceptMessage(message); if (XmlParseResult != ErrorCodes.ER_00_NO_ERROR) { return; } _dataLength = Convert.ToInt32(KeyValues.Item("Length"), 16); try { if (message.CharsLeft < _dataLength) { XmlParseResult = ErrorCodes.ER_80_DATA_LENGTH_ERROR; } else if (message.CharsLeft > _dataLength) { XmlParseResult = ErrorCodes.ER_15_INVALID_INPUT_DATA; } else { _data = message.Substring(_dataLength); } } catch (Exception) { XmlParseResult = ErrorCodes.ER_80_DATA_LENGTH_ERROR; } }
public ActionResult GetAvailableValues(KeyValueRequest req) { var res = new KeyValueResult(); res.KeyValues = new List <KeyValues>(); try { var searcher = ExamineManager.Instance.SearchProviderCollection["ChalmersILLOrderItemsSearcher"]; var searchCriteria = searcher.CreateSearchCriteria(Examine.SearchCriteria.BooleanOperation.Or); var allOrders = searcher.Search(searchCriteria.RawQuery("nodeTypeAlias:ChalmersILLOrderItem")); foreach (var k in req.Keys) { var keyValues = new KeyValues(); keyValues.Key = k; SetPrettyName(keyValues); keyValues.AvailableValues = allOrders.Where(x => x.Fields.ContainsKey(k)).Select(x => x.Fields[k]).Distinct().OrderBy(x => x).ToList(); res.KeyValues.Add(keyValues); } res.Success = true; res.Message = "Successfully fetched available values for keys."; } catch (Exception e) { res.Success = false; res.Message = "Failed to fetch available values for keys: " + e.Message; } return(Json(res, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Generates the commands that correspond to this operation. /// </summary> /// <returns> The commands that correspond to this operation. </returns> public virtual IEnumerable <ModificationCommand> GenerateModificationCommands([CanBeNull] IModel model) { Debug.Assert(KeyColumns.Length == KeyValues.GetLength(1), $"The number of key values doesn't match the number of keys (${KeyColumns.Length})"); Debug.Assert(Columns.Length == Values.GetLength(1), $"The number of values doesn't match the number of keys (${Columns.Length})"); Debug.Assert(KeyValues.GetLength(0) == Values.GetLength(0), $"The number of key values doesn't match the number of values (${KeyValues.GetLength(0)})"); var properties = model != null ? TableMapping.GetTableMapping(model, Table, Schema)?.GetPropertyMap() : null; for (var i = 0; i < KeyValues.GetLength(0); i++) { var keys = new ColumnModification[KeyColumns.Length]; for (var j = 0; j < KeyColumns.Length; j++) { keys[j] = new ColumnModification( KeyColumns[j], originalValue: null, value: KeyValues[i, j], property: properties?.Find(KeyColumns[j]), isRead: false, isWrite: false, isKey: true, isCondition: true); } var modifications = new ColumnModification[Columns.Length]; for (var j = 0; j < Columns.Length; j++) { modifications[j] = new ColumnModification( Columns[j], originalValue: null, value: Values[i, j], property: properties?.Find(Columns[j]), isRead: false, isWrite: true, isKey: true, isCondition: false); } yield return(new ModificationCommand(Table, Schema, keys.Concat(modifications).ToArray())); } }
void LoadManifest() { var configPath = InstallBase.GetChildDirectoryWithName("SteamApps").GetChildFileWithName("appmanifest_" + AppId + ".acf"); AppManifest = new KeyValues(Tools.FileUtil.Ops.ReadTextFileWithRetry(configPath)); }
public JsonNode ToJson() { var jps = KeyValues.LookupToJsonValues(); var jpAccs = Accounts.LookupToJson(); jps.KeyValues["accounts"] = jpAccs; return(jps); }
public SteamHelper(KeyValues steamConfig, IAbsoluteDirectoryPath steamPath, bool cache = true) { _cache = cache; _appCache = new Dictionary<int, SteamApp>(); KeyValues = steamConfig; _steamPath = steamPath; SteamFound = KeyValues != null || (_steamPath != null && _steamPath.Exists); _baseInstallPaths = GetBaseInstallFolderPaths(); }
public TblAudit ToAudit() { var audit = new TblAudit { TableName = TableName, DateTime = DateTime.UtcNow, Action = Action, UserId = UserId, KeyValues = KeyValues.First().Value.ToString(), OldValues = OldValues.Count == 0 ? null : JsonConvert.SerializeObject(OldValues), NewValues = NewValues.Count == 0 ? null : JsonConvert.SerializeObject(NewValues), }; List <AuditDelta> DeltaList = new List <AuditDelta>(); JObject sourceJObject = JsonConvert.DeserializeObject <JObject>(audit.OldValues); if (audit.Action == "Modified") { JObject targetJObject = JsonConvert.DeserializeObject <JObject>(audit.NewValues); foreach (KeyValuePair <string, JToken> sourceProperty in sourceJObject) { JProperty targetProp = targetJObject.Property(sourceProperty.Key); if (!JToken.DeepEquals(sourceProperty.Value, targetProp.Value)) { AuditDelta delta = new AuditDelta { FieldName = sourceProperty.Key, ValueBefore = Convert.ToString(sourceProperty.Value), ValueAfter = Convert.ToString(targetProp.Value) }; DeltaList.Add(delta); } } } else { foreach (KeyValuePair <string, JToken> sourceProperty in sourceJObject) { AuditDelta delta = new AuditDelta { FieldName = sourceProperty.Key, ValueBefore = Convert.ToString(sourceProperty.Value), ValueAfter = string.Empty }; DeltaList.Add(delta); } } audit.Changes = JsonConvert.SerializeObject(DeltaList); return(audit); }
public override void Parse() { base.Parse(); if (KeyValues.ContainsKey("pid")) { int profileID; if (!int.TryParse(KeyValues["pid"], out profileID)) { throw new GSException("pid format is incorrect."); } ProfileId = profileID; } if (KeyValues.ContainsKey("ptype")) { PersistStorageType storageType; if (!Enum.TryParse(KeyValues["ptype"], out storageType)) { throw new GSException("ptype format is incorrect."); } StorageType = storageType; } if (KeyValues.ContainsKey("dindex")) { int dataIndex; if (!int.TryParse(KeyValues["dindex"], out dataIndex)) { throw new GSException("dindex format is incorrect."); } DataIndex = dataIndex; } if (!KeyValues.ContainsKey("keys")) { throw new GSException("keys is missing."); } string keys = KeyValues["keys"]; if (keys == "") { GetAllDataFlag = true; } else { string[] keyArray = keys.Split('\x1'); foreach (var key in keyArray) { Keys.Add(key); } GetAllDataFlag = false; } }
void ReadSteamConfig() { var steamPath = GetSteamPath(); if (steamPath == null || !steamPath.Exists) return; var steamConfigPath = steamPath.GetChildDirectoryWithName("config").GetChildFileWithName("config.vdf"); if (steamConfigPath.Exists) SteamConfig = new KeyValues(Tools.FileUtil.Ops.ReadTextFileWithRetry(steamConfigPath)); }
public object GetOptional(string name) { if (!KeyValues.Contains(name)) { return(null); } return(Get(name)); }
public T GetOptional <T> (string name) { if (!KeyValues.Contains(name)) { return(default(T)); } return((T)Get(name)); }
/// <summary> /// 获取指定 Key 的值,如果不存在,需要返回 null。 /// </summary> /// <param name="key">指定项的 Key。</param> /// <returns> /// 执行项的 Key,如果不存在,则为 null / Task<string>.FromResult(null)"/>。 /// </returns> protected override async Task <string?> ReadValueCoreAsync(string key) { await LoadFromFileTask.ConfigureAwait(false); var value = KeyValues.TryGetValue(key, out var v) ? v : null; CT.Debug($"{key} = {value ?? "null"}", "Get"); return(value); }
public void SetValue(string key, string value) { if (KeyValues == null) { KeyValues = new KeyValuePair[0]; } KeyValues.Append(new KeyValuePair(key, value)); }
public SteamHelper(KeyValues steamConfig, IAbsoluteDirectoryPath steamPath, bool cache = true) { _cache = cache; _appCache = new Dictionary <int, SteamApp>(); KeyValues = steamConfig; _steamPath = steamPath; SteamFound = KeyValues != null || (_steamPath != null && _steamPath.Exists); _baseInstallPaths = GetBaseInstallFolderPaths(); }
public void MultiRoot2() { var keyVals = KeyValues.ParseList(Properties.Resources.entities); foreach (var keyVal in keyVals) { Console.WriteLine((string)keyVal["classname"]); } }
/// <summary> /// Accept message from client. /// </summary> /// <param name="message">Request message.</param> public override void AcceptMessage(StreamMessage message) { base.AcceptMessage(message); if (XmlParseResult == ErrorCodes.ER_00_NO_ERROR) { _delay = KeyValues.Item("Delay"); } }
private static string GetGameName(KeyValues.KeyValues kv) { while (true) { var kvp = kv.KeyNameValues.FirstOrDefault( k => k.Key.Equals("name", StringComparison.InvariantCultureIgnoreCase)); if (kvp != null) return kvp.Value; var userConfigKv = kv.KeyChilds.FirstOrDefault( c => c.Name.Equals("UserConfig", StringComparison.InvariantCultureIgnoreCase)); if (userConfigKv == null) return null; kv = userConfigKv; } }
public SteamApp(int appId, IAbsoluteDirectoryPath installBase, KeyValues appConfig) { AppId = appId; InstallBase = installBase; AppConfig = appConfig; if (installBase != null) LoadManifest(); SetAppPath(); }
/// <summary> /// Used to Export language xml files /// </summary> /// <param name="requestParam">source and target xml files name seperated with delemeter</param> /// <returns></returns> public string ExportLanguageXML(string requestParam) { string RetVal = string.Empty; string XMLFilesDir = string.Empty; string SrcLanguageName = string.Empty; string TrgLanguageName = string.Empty; string FileName = string.Empty; string SrcLngXML = string.Empty; string TrgLngXML = string.Empty; DataSet dsSrcLng = new DataSet(); DataSet dsTrgLng = new DataSet(); DataTable DtSrcLng = new DataTable(); DataTable DtTrgLng = new DataTable(); System.IO.FileStream SrcReadXml = null; System.IO.FileStream TrgReadXml = null; string OutputXmlFilePath = string.Empty; List<KeyValues> lstKeyValue = new List<KeyValues>(); KeyValues KeyVal = null; ArrayList ALTargetKeys = new ArrayList(); DataRow[] drArray; string[] Params; //Variables for creating XLS Logfile string XLSFileMsg = string.Empty; try { // Get Source Path of XML files XMLFilesDir = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, Constants.FolderName.MasterKeyVals); OutputXmlFilePath = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, Constants.FolderName.LanguageXMLFiles); Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter); // Get source and target language xml file names from input param SrcLanguageName = Params[0].ToString(); TrgLanguageName = Params[1].ToString(); // Get Complete path of source language XML file SrcLngXML = XMLFilesDir + SrcLanguageName + ".XML"; TrgLngXML = XMLFilesDir + TrgLanguageName + ".XML"; FileName = SrcLanguageName.Split(new string[] { "[" }, StringSplitOptions.None)[0].ToString() + "- " + TrgLanguageName.Split(new string[] { " [" }, StringSplitOptions.None)[0].ToString(); // Create new FileStream with which to read the schema. SrcReadXml = new FileStream(SrcLngXML, FileMode.Open); TrgReadXml = new FileStream(TrgLngXML, FileMode.Open); // Read language xml files as data set dsSrcLng.ReadXml(SrcReadXml); dsTrgLng.ReadXml(TrgReadXml); // Get data table from dataset DtSrcLng = dsSrcLng.Tables[0]; DtTrgLng = dsTrgLng.Tables[0]; foreach (DataRow row in DtSrcLng.Rows) { // List<KeyValues> listTest = new List<KeyValues>(); drArray = null; KeyVal = new KeyValues(); if (!ALTargetKeys.Contains(row["Key"].ToString().Trim())) { ALTargetKeys.Add(row["Key"].ToString().Trim()); KeyVal.Key = row["Key"].ToString(); KeyVal.ValueSource = row["Value"].ToString(); drArray = DtTrgLng.Select("Key = '" + row["Key"].ToString() + "'"); if (drArray.Length > 0) { KeyVal.ValueTarget = drArray[0]["Value"].ToString(); } lstKeyValue.Add(KeyVal); } } //foreach (DataRow row in DtTrgLng.Rows) //{ // if (!ALTargetKeys.Contains(row["Key"].ToString().ToUpper().Trim())) // { // KeyVal = new KeyValues(); // KeyVal.Key = row["Key"].ToString(); // KeyVal.ValueTarget = row["Value"].ToString(); // lstKeyValue.Add(KeyVal); // } //} IWorksheet ExcelSheet = (IWorksheet)Factory.GetWorkbook().Sheets[0]; //(IWorksheet)ExcelWorkbook.Sheets[0]; int RowIndex = 0; //Set the hidden fields for langaugue file names ExcelSheet.Cells[RowIndex, 1].Value = SrcLanguageName; ExcelSheet.Cells[RowIndex, 2].Value = TrgLanguageName; // hide first row as it consist of xml file names SpreadsheetGear.IRange Range = ExcelSheet.Range[0, 0, 0, 2]; Range.RowHeight = 0.0; //Create Header row for XLS file RowIndex++; CreateHeader(ref ExcelSheet, RowIndex, FileName); foreach (KeyValues KeyValues in lstKeyValue) { RowIndex++; ExcelSheet.Cells[RowIndex, 0].Value = KeyValues.Key; ExcelSheet.Cells[RowIndex, 1].Value = KeyValues.ValueSource; ExcelSheet.Cells[RowIndex, 2].Value = KeyValues.ValueTarget; ExcelSheet.Cells[RowIndex, 0].Borders.Color = System.Drawing.Color.Black; ExcelSheet.Cells[RowIndex, 1].Borders.Color = System.Drawing.Color.Black; ExcelSheet.Cells[RowIndex, 2].Borders.Color = System.Drawing.Color.Black; if (KeyValues.Key.ToString() == "FILE_VERSION") { SpreadsheetGear.IRange RngFileVersion = ExcelSheet.Range[RowIndex, 0, RowIndex + 1, 2]; RngFileVersion.NumberFormat = "0.0"; } } // hide columns containing keys SpreadsheetGear.IRange Rng = ExcelSheet.Range[0, 0, RowIndex - 1, 0]; Rng.ColumnWidth = 0.0; // Increase width of rows containing data values SpreadsheetGear.IRange RangeData = ExcelSheet.Range[0, 1, RowIndex - 1, 2]; RangeData.ColumnWidth = 50.0; // hide first four rows SpreadsheetGear.IRange Rng1 = ExcelSheet.Range[2, 0, 6, 2]; Rng1.RowHeight = 0.0; ExcelSheet.Name = FileName; ExcelSheet.SaveAs(OutputXmlFilePath + FileName + ".xls", SpreadsheetGear.FileFormat.Excel8); SrcReadXml.Close(); TrgReadXml.Close(); RetVal = "true" + Constants.Delimiters.ParamDelimiter + FileName; #region "Call method to write log in XLS file" if (RetVal.Contains("true")) { XLSFileMsg = string.Format(Constants.CSVLogMessage.ExportLanguage, SrcLanguageName, TrgLanguageName); WriteLogInXLSFile(Constants.AdminModules.LanguageSettings.ToString(), XLSFileMsg); } #endregion } catch (Exception ex) { RetVal = "false"; Global.CreateExceptionString(ex, null); } finally { SrcReadXml.Dispose(); TrgReadXml.Dispose(); } return RetVal; }