private void btnSaveChanges_Click(object sender, RoutedEventArgs e) { DataTable_Processing dataTable_Processing = new DataTable_Processing(); DataTable dt = (DataTable)dgLoadMappingTable.DataContext; string mappingDataJsonString = dataTable_Processing.DataTableToJSONWithJSONNet(dt); string allInfo = (string)lblColumnName.Content; string folderName = allInfo.Split('|')[0] + datetimeString; string fileName = allInfo.Split('|')[1]; string mappingInfoFolder = ""; string dirPath = mappingInfoFolder != ""? mappingInfoFolder + "//" + folderName:folderName; if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } string filePath = dirPath != ""? dirPath + "//" + fileName : fileName; if (File.Exists(filePath + ".json")) { File.Delete(filePath + ".json"); } using (StreamWriter sw = new StreamWriter((filePath + ".json"))) { sw.Write(mappingDataJsonString); } }
private void btnSaveAllExpressions_Click(object sender, RoutedEventArgs e) { DataTable dt = DictToDT(); DataTable_Processing dataTable_Processing = new DataTable_Processing(); string jsonString = dataTable_Processing.DataTableToJSONWithJSONNet(dt); ChildWindow childWindow = new ChildWindow(); childWindow.saveFile(dataTable.TableName + ChildWindow.datetimeString, "ExpressionsList", "", jsonString); }
public Dictionary <string, string> ReadMappingFile(string filePath) { Dictionary <string, string> mappingDataDict = new Dictionary <string, string>(); string jsonData = ReadFileDataContent(filePath); if (jsonData != "") { DataTable_Processing dataTable_Processing = new DataTable_Processing(); mappingDataDict = dataTable_Processing.GetDictinaryFromJson(jsonData); } return(mappingDataDict); }
public void btnProcessMapping_Click(object sender, RoutedEventArgs e) { backupTable = dataTable.Copy(); foreach (string f in allfiles) { Dictionary <string, string> mappingDataDic = ReadMappingFile(f); if (mappingDataDic.Count > 0) { DataTable_Processing dataTable_Processing = new DataTable_Processing(); dataTable_Processing.MappingOnDataTableColumn(ref dataTable, System.IO.Path.GetFileNameWithoutExtension(f), mappingDataDic); } } }
public void MyButton_DoubleClick(object sender, RoutedEventArgs e) { Label l = (Label)sender; //MessageBox.Show(l.Content.ToString()); string jsonData = ReadFileDataContent(txtboxMappingFolderPath.Text + "//" + l.Content.ToString()); if (jsonData != "") { DataTable_Processing dataTable_Processing = new DataTable_Processing(); DataTable dt = dataTable_Processing.ConvertJsonStrToDT(jsonData); ChildWindow chldWindow = new ChildWindow(dt); chldWindow.Show(); } }
private void btnApplyExpression_Click(object sender, RoutedEventArgs e) { DataTable_Processing dataTable_Processing = new DataTable_Processing(); dt_backUpDataTable = dt_OriginalDataTable.Copy(); foreach (DataRow dr in dt_expsInfoTable.Rows) { if ((bool)dr["Status"]) { dataTable_Processing.AddNewColumn(ref dt_OriginalDataTable, dr[0].ToString(), dr[1].ToString()); } } MessageBox.Show("All Expression executed successfully", "Information", MessageBoxButton.OK, MessageBoxImage.Information); }
public ExpressionManager(DataTable dt, string jsonExpsData) { InitializeComponent(); dt_OriginalDataTable = dt; DataTable_Processing dataTable_Processing = new DataTable_Processing(); dt_expsInfoTable = dataTable_Processing.ConvertJsonStrToDT(jsonExpsData); if (dt_expsInfoTable.Rows.Count > 0) { DataColumn newColumn = new System.Data.DataColumn("Status", typeof(System.Boolean)); newColumn.DefaultValue = true; dt_expsInfoTable.Columns.Add(newColumn); dgLoadExpressionTable.DataContext = dt_expsInfoTable; } }
public void OpenColumnMapping(string seletedCol) { List <string> uniqueValue = new List <string>(); if (seletedCol != "") { DataTable_Processing dataTable_Processing = new DataTable_Processing(); uniqueValue = dataTable_Processing.GetColUniqueValues(currentProcessingTable, seletedCol); if (uniqueValue.Count > 0) { DataTable dt = CreateColumnMapperTable(uniqueValue, seletedCol); //ChildWindow chldWindow = new ChildWindow(dt); //chldWindow.Show(); ThreadStartingPoint(dt); mIemExecuteCurrentDir.IsEnabled = true; // return dt; } } //return new DataTable(""); }