public string Transform(ModelMap mapToProcess, ModelProcess actionProcess, string input) { string result = string.Empty; try { CsvFileDescription outputFileDescription = new CsvFileDescription { SeparatorChar = ',', // tab delimited FirstLineHasColumnNames = false, // no column names in first record FileCultureName = "en-GB" // use formats used in The Netherlands }; CsvContext csvContext = new CsvContext(); string fileLocation = Path.Combine( new FileInfo(System.Reflection.Assembly.GetEntryAssembly().Location).Directory.FullName, actionProcess.Where); var theList = csvContext.Read<Data.DataRow>(fileLocation, outputFileDescription); var thePairs = theList.ToDictionary( d=>d[0].Value.ToString(), d =>d[1].Value.ToString()); if (thePairs.ContainsKey(input)) result = input != null ? thePairs[input] : "No Code Found"; } catch (Exception ex) { LoggerSingleton.Instance.LogMessage(ex); } return result; }
public string Transform(ModelMap mapToProcess, ModelProcess action, string input) { if (input == string.Empty) input = DateTime.Now.ToShortDateString(); string result = string.Empty; try { DateTime date = DateTime.Parse(input); int quarter = ((((date.Month - 1) / 3) + 3) % 4) + 1; switch (quarter) { case 2: result = string.Format("01/04/{0}", date.Year); break; case 3: result = string.Format("01/07/{0}", date.Year); break; case 4: result = string.Format("01/10/{0}", date.Year - 1); break; case 1: result = string.Format("01/01/{0}", date.Year); break; } } catch (Exception ex) { LoggerSingleton.Instance.LogMessage(ex); } return result; }
public string Transform(ModelMap mapToProcess, ModelProcess action, string input) { return string.Empty; }
public string Transform(ModelMap mapToProcess, ModelProcess action, string input) { return input.Replace(" ", ""); }
public string Transform(ModelMap mapToProcess, ModelProcess action, string input) { var regex = new Regex(action.Where); return regex.IsMatch(input) ? action.Make : input; }