private void AddCategory_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (this.DialogResult == DialogResult.OK)
{
if (!String.IsNullOrEmpty(textBox_AddCategory.Text))
{
BillingDataSet.CategoriesRow row = _views.MainForm.datasetBilling.Categories.NewCategoriesRow();
row.Category = textBox_AddCategory.Text;
var categoryID = Convert.ToInt32(txtID.Text);
row.ID = categoryID;
_views.MainForm.datasetBilling.Categories.AddCategoriesRow(row);
_views.MainForm.adapterCategoriesBilling.Update(_views.MainForm.datasetBilling.Categories);
_views.MainForm.adapterCategoriesBilling.Fill(_views.MainForm.datasetBilling.Categories);
_selectedCategoryID = categoryID;
//if (cmbExcludeFromFilter.SelectedIndex > -1)
//{
// var selectedItem = (AddGroupComboboxItem)cmbExcludeFromFilter.SelectedItem;
// var filterId = (int)selectedItem.GroupID;
// var categoryType = selectedItem.
// var newRow = _views.MainForm.datasetBilling.CategoryToFilterExclusion.NewCategoryToFilterExclusionRow();
// newRow.CategoryID = categoryID;
// newRow.FilterID = filterId;
// newRow.Type = "";
// _views.MainForm.datasetBilling.CategoryToFilterExclusion.Rows.Add(newRow);
// _views.MainForm.datasetBilling.CategoryToFilterExclusion.AcceptChanges();
// _views.MainForm.adapterCategoryToFilterExclusionBilling.Insert(categoryID, filterId,"");
//}
}
else
{
MessageBox.Show("Category name cannot be empty");
e.Cancel = true;
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
e.Cancel = true;
}
}
protected int Property_Get_CategoryID()
{
int nResult = -1;
if (gridCategories.SelectedRows.Count == 1)
{
DataGridViewRow row = gridCategories.SelectedRows[0];
DataRowView rowview = (DataRowView)row.DataBoundItem;
BillingDataSet.CategoriesRow rowCategories = (BillingDataSet.CategoriesRow)rowview.Row;
nResult = rowCategories.ID;
}
return(nResult);
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
if (gridCategories.SelectedRows.Count == 1)
{
DialogResult dlgres = MessageBox.Show("Do you wish to delete category?", "Delete category", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (dlgres == DialogResult.Yes)
{
DataRowView rowview = (DataRowView)gridCategories.SelectedRows[0].DataBoundItem;
BillingDataSet.CategoriesRow rowCategories = (BillingDataSet.CategoriesRow)rowview.Row;
int nCategoryID = Convert.ToInt32(rowCategories["ID"]);
string idC = rowCategories[1].ToString();
string categoryName = rowCategories.Category;
rowCategories.Delete();
_views.MainForm.adapterCategoriesBilling.Update(_views.MainForm.datasetBilling.Categories);
_views.MainForm.adapterCategoriesBilling.Fill(_views.MainForm.datasetBilling.Categories);
//////////////////////////////////////////////////////////////////////////
foreach (BillingDataSet.DocumentsRow rowDocuments in _views.MainForm.datasetBilling.Documents)
{
if (!rowDocuments.IsCategoryNull() && rowDocuments.Category == nCategoryID)
{
rowDocuments.SetCategoryNull();
}
}
_views.MainForm.adapterDocumentsBilling.Update(_views.MainForm.datasetBilling.Documents);
_views.MainForm.adapterDocumentsBilling.Fill(_views.MainForm.datasetBilling.Documents);
//////////////////////////////////////////////////////////////////////////
_views.MainForm.sourceCategoriesBilling.ResetBindings(false);
////
//Remove from saved if it exists there
////
OleDbConnection conn = _views.MainForm.adapterDocumentsBilling.Connection;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM SavedCategories";
string positive = "";
string negative = "";
var reader = cmd.ExecuteReader();
while (reader.Read())
{
try
{
var type = reader["PosNeg"].ToString();
var ids = reader["categoryIDs"].ToString();
var idArray = ids.Split(',');
if (!String.IsNullOrEmpty(idArray[0]))
{
if (type == "Positive")
{
foreach (var id in idArray)
{
if (id != idC)
{
positive += id + ",";
}
}
}
else //Add to negative
{
foreach (var id in idArray)
{
if (id != idC)
{
negative += id + ",";
}
}
}
}
}
catch
{
}
}
if (positive.Length > 0)
{
positive = positive.Substring(0, positive.Length - 1);
}
if (negative.Length > 0)
{
negative = negative.Substring(0, negative.Length - 1);
}
OleDbCommand cmd1 = conn.CreateCommand();
//UPDATE SavedCategories SET categoryIDs=? WHERE PosNeg=?
cmd1.CommandText = "UPDATE SavedCategories SET categoryIDs=? WHERE PosNeg=?";
cmd1.Parameters.Add("categoryIDs", OleDbType.VarChar)
.Value = positive;
cmd1.Parameters.Add("PosNeg", OleDbType.VarChar)
.Value = "Positive";
cmd1.ExecuteNonQuery();
OleDbCommand cmd2 = conn.CreateCommand();
cmd2.CommandText = "UPDATE SavedCategories SET categoryIDs=? WHERE PosNeg=?";
cmd2.Parameters.Add("categoryIDs", OleDbType.VarChar)
.Value = negative;
cmd2.Parameters.Add("PosNeg", OleDbType.VarChar)
.Value = "Negative";
cmd2.ExecuteNonQuery();
try
{
OleDbCommand cmd3 = conn.CreateCommand();
cmd3.CommandText = "DELETE FROM CategoryToFilterExclusion WHERE CategoryID = " + nCategoryID;
cmd3.ExecuteNonQuery();
if (_views.MainForm.datasetMain.Categories.Count > 0)
{
_views.MainForm.datasetMain.Categories.First(x => x.ID == nCategoryID).Delete();
_views.MainForm.adapterCategories.Update(_views.MainForm.datasetMain.Categories);
_views.MainForm.adapterCategories.Fill(_views.MainForm.datasetMain.Categories);
}
_views.MainForm.adapterCategoriesBilling.Delete(nCategoryID, categoryName);
_views.MainForm.datasetBilling.Categories.First(x => x.ID == nCategoryID).Delete();
_views.MainForm.datasetBilling.Categories.AcceptChanges();
}
catch
{
}
conn.Close();
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
