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);
}
