private DataTable GetDetailDocuments(string tablename, string database) { try { ClientQueryService postgresHelper = new ClientQueryService(); var sql = @"SELECT * FROM " + tablename; var dbConnStr = postgresHelper.ConnString + database; var dataTable = new DataTable(); dataTable.Load(postgresHelper.ExecuteReader(dbConnStr, System.Data.CommandType.Text, sql)); return(dataTable); } catch (Exception e) { logger.Log(LogLevel.Error, "GetDetailDocuments:" + e.Message); return(null); } }
private void btnSaveDb_Click(object sender, EventArgs e) { JObject saveObj = null; try { saveObj = (JObject)JsonConvert.DeserializeObject(jsonTextBox.Text); } catch (Exception) { MessageBox.Show("json format error."); return; } ClientQueryService postgresHelper = new ClientQueryService(); int i = postgresHelper.UpdateInfoById(DbId, DataName, TableName, saveObj); if (i > 0) { pForm.refreshDataTable(); MessageBox.Show("Save data to database successfully."); } }
private void idButton_Click(object sender, EventArgs e) { try { //|| string.IsNullOrWhiteSpace(TableName) if (string.IsNullOrWhiteSpace(DataName)) { MessageBox.Show("Please select a DataBase", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (!string.IsNullOrWhiteSpace(txtKeyword.Text) && string.IsNullOrWhiteSpace(TableName)) { MessageBox.Show("Please select a Table", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (string.IsNullOrWhiteSpace(idTextBox.Text) && string.IsNullOrWhiteSpace(txtKeyword.Text)) { //MessageBox.Show("Please enter id or keyword", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); refreshDataTable(); } else if (!string.IsNullOrWhiteSpace(idTextBox.Text)) { ClientQueryService clientQueryService = new ClientQueryService(); var sqlTableName = TableName; if (string.IsNullOrEmpty(sqlTableName)) { var idValuesArray = idTextBox.Text.Split('/'); if (idValuesArray.Count() > 1) { var firstValueOfId = idValuesArray[0]; if (firstValueOfId.EndsWith("ies")) { sqlTableName = string.Format("mt_doc_{0}", idValuesArray[0].TrimEnd(new char[3] { 'i', 'e', 's' }) + "y"); } else { sqlTableName = string.Format("mt_doc_{0}", idValuesArray[0].TrimEnd('s')); } } else { MessageBox.Show("The given id cannot redirect to a table, Please Select a table", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } } try { var result = clientQueryService.GetInfoById(idTextBox.Text.Trim(), DataName, sqlTableName, CommandType.Text, null); if (result != null) { JObject jo = (JObject)JsonConvert.DeserializeObject(result.Data); ShowJsonForm(jo, result.Id); } else { MessageBox.Show("Please enter valid id", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(string.Format("Error {0} occured!", ex.Message), "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (!string.IsNullOrWhiteSpace(txtKeyword.Text)) { string keyword = txtKeyword.Text.Trim(); System.Data. DataTable dt1 = GetDetailDocuments(TableName, DataName); DataRow[] rows = dt1.Select(" data like '%" + keyword + "%'"); DataTable newdt = new DataTable(); newdt = dt1.Clone(); foreach (DataRow row in rows) { newdt.Rows.Add(row.ItemArray); } DetailDataTable = newdt; } } catch (Exception ex) { logger.Log(LogLevel.Error, "idSearchError:" + ex.Message); } }
public ClientQueryServiceTests() { _sut = new ClientQueryService(_clientRepository); }