public void UpdateDocumentsRow(MainDataSet.DocumentsRow rowDocument)
{
OleDbConnection conn = _views.MainForm.adapterDocuments.Connection;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE Documents SET Category = @Category WHERE ED_ENC_NUM = @ED_ENC_NUM";
if (!rowDocument.IsCategoryNull())
{
cmd.Parameters.Add(new OleDbParameter("@Category", rowDocument.Category));
}
else
{
cmd.Parameters.Add(new OleDbParameter("@Category", DBNull.Value));
}
cmd.Parameters.Add(new OleDbParameter("@ED_ENC_NUM", rowDocument.ED_ENC_NUM));
cmd.ExecuteNonQuery();
rowDocument.AcceptChanges();
}
private void btnSelectCategory_Click(object sender, EventArgs e)
{
if (documentsDataGridView.SelectedRows.Count > 0)
{
var cell = documentsDataGridView.Rows[_currentMouseOverRow].Cells[columnCategory.Index];
FormSelectCategory formSelectCategory = new FormSelectCategory(_views, FormSelectCategory.DisplayMode.Default, cell, false);
//////////////////////////////////////////////////////////////////////////
if (formSelectCategory.ShowDialog() == DialogResult.OK)
{
foreach (DataGridViewRow row in documentsDataGridView.SelectedRows)
{
DataRowView rowview = (DataRowView)row.DataBoundItem;
MainDataSet.ReviewMLDocumentsRow rowReviewDocuments = (MainDataSet.ReviewMLDocumentsRow)rowview.Row;
MainDataSet.DocumentsRow rowDocuments = _views.MainForm.datasetMain.Documents.FindByPrimaryKey(rowReviewDocuments.ED_ENC_NUM);
if (formSelectCategory.CategoryID != -1)
{
rowDocuments.Category = formSelectCategory.CategoryID;
}
else
{
rowDocuments.SetCategoryNull();
}
UpdateDocumentsRow(rowDocuments);
}
}
}
}
protected bool InsertDocument(string strTableName, MainDataSet.DocumentsRow row, CategoryInfo ci)
{
bool bResult = false;
try
{
OleDbConnection connection = _views.MainForm.adapterDocuments.Connection;
if (connection != null)
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
OleDbCommand command;
try
{
string strCommand = "INSERT INTO " + strTableName + "(ED_ENC_NUM, NoteText, Score, Category, CategoryID) "
+ "VALUES (?, ?, ?, ?, ?)";
command = new OleDbCommand(strCommand, connection);
command.Parameters.Add("ED_ENC_NUM", OleDbType.Double)
.Value = row.ED_ENC_NUM;
command.Parameters.Add("NoteText", OleDbType.Char)
.Value = _views.DocumentsService.GetDocumentText(row.ED_ENC_NUM); // TODO
command.Parameters.Add("Score", OleDbType.Integer)
.Value = row.Score;
command.Parameters.Add("Category", OleDbType.Char)
.Value = ci.Category;
command.Parameters.Add("CategoryID", OleDbType.Char)
.Value = ci.ID;
int nCount = command.ExecuteNonQuery();
if (nCount > 0)
{
bResult = true;
}
}
catch
{
}
connection.Close();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, MainForm.AppName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
return(bResult);
}
protected bool Extract_WriteDateTimeValue(ColRegExpExtractProcessingResult extractResult, MainDataSet.DocumentsRow rowDocuments, string columnName, bool scriptExtract)
{
var result = false;
DateTime dt;
if (!scriptExtract)
{
var dateTimeFormat = extractResult.ExtractOptions.DateTimeFormat;
if (!String.IsNullOrEmpty(dateTimeFormat))
{
var formats = dateTimeFormat.Split(',')
.Select(x => x.Replace("\"", ""));
result = DateTime.TryParseExact(extractResult.Value, formats.ToArray(), _cultureInfo, DateTimeStyles.None, out dt);
}
else
{
result = DateTime.TryParse(extractResult.Value, out dt);
}
}
else
{
result = DateTime.TryParse(extractResult.Value, out dt);
}
///////////////////////////////////////////////////////////////////////////////
if (result)
{
rowDocuments[columnName] = dt;
}
return(result);
}
protected bool Extract_WriteNumericValue(ColRegExpExtractProcessingResult extractResult, MainDataSet.DocumentsRow rowDocuments, string columnName, bool scriptExtract)
{
decimal numericValue;
if (Decimal.TryParse(extractResult.Value, out numericValue))
{
rowDocuments[columnName] = numericValue;
return(true);
}
return(false);
}
protected bool PythonExtract_WriteFreeTextValue(RegExpPythonExtractSingleProcessingResult extractResult, MainDataSet.DocumentsRow rowDocument, string columnName)
{
string newValue;
newValue = JsonConvert.SerializeObject(new Tuple <object, string> (JsonConvert.DeserializeObject(extractResult.Result), extractResult.NoteTextColumnName));
///////////////////////////////////////////////////////////////////////////////
if (!columnName.StartsWith("NOTE_TEXT"))
{
rowDocument[columnName] = newValue;
}
return(true);
}
protected bool Extract_WriteFreeTextValue(ColRegExpExtractProcessingResult extractResult, MainDataSet.DocumentsRow rowDocument, string columnName, bool scriptExtract)
{
string newValue;
if (!scriptExtract)
{
List <string> currentValues = null;
if (extractResult.ExtractOptions.AddToPrevious.HasValue && extractResult.ExtractOptions.AddToPrevious.Value)
{
if (!rowDocument.IsNull(columnName))
{
var textValue = (string)rowDocument[columnName];
try
{
if (textValue.StartsWith("["))
{
currentValues = JsonConvert.DeserializeObject <List <string> >(textValue);
}
}
catch
{
}
if (currentValues == null)
{
currentValues = new List <string> {
textValue
}
}
;
}
}
///////////////////////////////////////////////////////////////////////////////
if (currentValues == null)
{
currentValues = new List <string>();
}
if (extractResult.Value.StartsWith("["))
{
try
{
var extractedValues = JsonConvert.DeserializeObject <string[]>(extractResult.Value);
currentValues.AddRange(extractedValues);
}
catch
{
currentValues.Add(extractResult.Value);
}
}
else
{
currentValues.Add(extractResult.Value);
}
newValue = currentValues.Count > 1
? JsonConvert.SerializeObject(currentValues)
: currentValues.First();
}
else
{
newValue = extractResult.Value;
}
///////////////////////////////////////////////////////////////////////////////
if (!columnName.StartsWith("NOTE_TEXT"))
{
rowDocument[columnName] = newValue;
}
return(true);
}
