public void SaveAttributeForObject(IMS_Object_Attributes selectedObj, string attrName, string value, bool editOrNotEdit)
{
SqlCommand save = new SqlCommand();
save.Connection = con;
save.CommandType = CommandType.StoredProcedure;
save.CommandText = "IMS_ADD_OBJECT_ATTRS";
if (editOrNotEdit == true)
{
save.Parameters.AddWithValue("inOBJECT_ID", selectedObj.OBJECT_ID);
}
else
{
save.Parameters.AddWithValue("inOBJECT_ID", lastObjectID);
}
save.Parameters.AddWithValue("inATTRIBUTE_ID", attributePropList.Where(x => x.NAME.Equals(attrName)).First().ATTRIBUTE_ID);
save.Parameters.AddWithValue("in_INLIST_ID", 0);
save.Parameters.AddWithValue("inSTRING_VALUE", value);
save.Connection.Open();
reader = save.ExecuteReader();
reader.Close();
save.Connection.Close();
}
private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
ContextMenu contextMenuForObjectsEditing = new ContextMenu();
MenuItem menuObjectUpdate = new MenuItem("Редактировать объект", new System.EventHandler(this.MenuObjectUpdate_Click));
MenuItem menuObjectDelete = new MenuItem("Удалить объект", new System.EventHandler(this.MenuObjectDelete_Click));
contextMenuForObjectsEditing.MenuItems.Add(menuObjectUpdate);
contextMenuForObjectsEditing.MenuItems.Add(menuObjectDelete);
contextMenuForObjectsEditing.Show(dataGridView1, e.Location);
}
else if (e.Button == MouseButtons.Left)
{
selectedObj = (IMS_Object_Attributes)dataGridView1.CurrentRow.DataBoundItem;
}
}
public void DeleteObject(IMS_Object_Attributes selectedObject)
{
SqlCommand delete = new SqlCommand();
delete.Connection = con;
delete.CommandType = CommandType.StoredProcedure;
delete.CommandText = "IMS_DELETE_OBJECT";
delete.Parameters.AddWithValue("inOBJECT_ID", selectedObject.OBJECT_ID);
delete.Connection.Open();
reader = delete.ExecuteReader();
reader.Close();
delete.Connection.Close();
}
public void ControlEdit(string objectTypeName, IMS_Object_Attributes selectedObject)
{
txtBoxName.Text = selectedObject.STRING_VALUE;
}
