private void LoadData() { masterView.Rows.Clear(); detailsTabs.Items.Clear(); detailsTabs.SelectedItem = null; Hashtable hAttributes = new Hashtable(); try { omQuery = (OMQuery) Helper.OMResultedQuery[ClassName]; if (omQuery != null) { hAttributes = omQuery.AttributeList; } PagingData pagingData = new PagingData(m_pagingStartIndex); if (objectid != null) { lstObjIdLong = new List<long>(objectid); pagingData.ObjectId = lstObjIdLong; const int pageNumber = m_pagingStartIndex + 1; lblPageCount.Text = pagingData.GetPageCount().ToString(); txtCurrentPage.Text = pageNumber.ToString(); labelNoOfObjects.Text = pagingData.ObjectId.Count.ToString(); if (lstObjIdLong.Count > 0) { List<Hashtable> hashListResult = AssemblyInspectorObject.DataPopulation.ReturnQueryResults(pagingData, true, omQuery.BaseClass, omQuery. AttributeList); masterView.SetDataGridColumnHeader(hashListResult, ClassName, omQuery.AttributeList); masterView.SetDatagridRows(hashListResult, ClassName, hAttributes, 1); ListofModifiedObjects.AddDatagrid(ClassName, masterView); } if (pagingData.ObjectId.Count <= PagingData.PAGE_SIZE) { btnPrevious.Enabled = false; btnFirst.Enabled = false; btnNext.Enabled = false; btnLast.Enabled = false; } else { btnPrevious.Enabled = false; btnFirst.Enabled = false; btnNext.Enabled = true; btnLast.Enabled = true; } } ApplyReadonlyCondition(OMEInteraction.GetCurrentConnParams().ConnectionReadOnly); } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
public static List<Hashtable> ReturnResults(PagingData pgData, bool refresh,string baseclass,Hashtable AttributeList) { try { if (pgData.ObjectId.Count <= 0) return null; IObjectsetConverter objSetConvertor = new IObjectsetConverter(baseclass, refresh); return objSetConvertor.ObjectIDToUIObjects(pgData, AttributeList); } catch (Exception oEx) { LoggingHelper.HandleException(oEx); return null; } }
private void buttonSaveResult_Click(object sender, EventArgs e) { try { OMETrace.WriteFunctionStart(); SaveDetailsViewChangedObjects(detailsTabs); int startindex = (int) masterView.Rows[masterView.Rows.Count - 1].Cells[1].Value; int endindex = startindex + PagingData.PAGE_SIZE; if (endindex > lstObjIdLong.Count && startindex < lstObjIdLong.Count) { endindex = lstObjIdLong.Count; } PagingData pagingData = new PagingData(startindex, endindex); pagingData.ObjectId = lstObjIdLong; dbInteraction.ReturnQueryResults(pagingData, false, omQuery.BaseClass, omQuery.AttributeList); btnSave.Enabled = false; buttonSaveResult.Enabled = false; OMETrace.WriteFunctionEnd(); } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
private void btnSave_Click(object sender, EventArgs e) { try { OMETrace.WriteFunctionStart(); foreach (DataGridViewRow row in masterView.Rows) { if (IsObjectInMasterViewEdited(row)) { UpdateMasterViewObjectEditedStatus(row, false); dbInteraction.SaveObjects(row.Tag); } } int startindex = (int) masterView.Rows[masterView.Rows.Count - 1].Cells[1].Value; int endindex = startindex + PagingData.PAGE_SIZE; if (endindex > lstObjIdLong.Count && startindex < lstObjIdLong.Count) { endindex = lstObjIdLong.Count; } PagingData pagingData = new PagingData(startindex, endindex); pagingData.ObjectId = lstObjIdLong; dbInteraction.ReturnQueryResults(pagingData, true, omQuery.BaseClass, omQuery.AttributeList); MakeAllElementsInGridBlack(masterView); btnSave.Enabled = false; buttonSaveResult.Enabled = false; OMETrace.WriteFunctionEnd(); } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
private void treeview_OnContextMenuItemClicked(object sender, ContextItemClickedEventArg e) { try { TreeGridView treeview = (TreeGridView) e.Data; if (treeview.SelectedRows.Count <= 0) return; treeview.ContextMenuStrip.Dispose(); DialogResult dialogRes = MessageBox.Show("This will set the value to null in the database. Do you want to continue?", Helper.GetResourceString(Constants.PRODUCT_CAPTION), MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogRes != DialogResult.Yes) return; TreeGridNode node = (TreeGridNode) treeview.SelectedCells[0].OwningRow; long id = dbInteraction.GetLocalID(treeview.Nodes[0].Tag); dbInteraction.SetFieldToNull( ParentObjectFor(node), CommonValues.UndecorateFieldName(node.Cells[0].Value.ToString())); object obj = null; if (id != 0) { obj = dbInteraction.GetObjById(id); } else { MessageBox.Show("This object is already Null.", Helper.GetResourceString(Constants.PRODUCT_CAPTION), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (obj != null) { dbInteraction.RefreshObject(obj, DepthFor(node)); UpdateResultTable(treeview.SelectedCells[0].OwningRow.Cells[0], "null", (TreeGridNode) treeview.SelectedCells[0].OwningRow.Cells[0].OwningRow, (OMETabStripItem) treeview.Parent, true); treeview = dbInteraction.GetObjectHierarchy(obj, FieldTypeNameFor(treeview.Nodes[0])); detailsTabs.SelectedItem.Controls.Clear(); detailsTabs.SelectedItem.Controls.Add(treeview); RegisterTreeviewEvents(treeview); } else //delete tab as teh obj is deleted and delete it from db grid view { int index = OffsetInCurrentPageFor(ObjectIndexInMasterViewFor((OMETabStripItem) treeview.Parent)); detailsTabs.RemoveTab(detailsTabs.SelectedItem); masterView.Rows.RemoveAt(index - 1); if( detailsTabs.SelectedItem !=null ) detailsTabs.SelectedItem .Controls.Clear(); lstObjIdLong.Remove(id); int m_pageCount = CurrentPageNumber(); int startIndex = (CurrentPageNumber()*PagingData.PAGE_SIZE) - PagingData.PAGE_SIZE; int endIndex = startIndex + PagingData.PAGE_SIZE; labelNoOfObjects.Text = lstObjIdLong.Count.ToString(); PagingData pgData = new PagingData(startIndex, endIndex); pgData.ObjectId = lstObjIdLong; if (lstObjIdLong.Count > 0) { List<Hashtable> hashListResult = dbInteraction.ReturnQueryResults(pgData, false, omQuery.BaseClass, omQuery.AttributeList); Hashtable hAttributes = null; if (omQuery != null) { hAttributes = omQuery.AttributeList; } masterView.SetDatagridRows(hashListResult, ClassName, hAttributes, 1); } treeview = dbInteraction.GetObjectHierarchy(ReferencedObjectFor(detailsTabs.SelectedItem), ClassName); if (detailsTabs.SelectedItem != null) detailsTabs.SelectedItem.Controls.Add(treeview); RegisterTreeviewEvents(treeview); int delIndex = ObjectIndexInMasterViewFor(detailsTabs.SelectedItem); UpdateObjectDetailTablCaptions(delIndex); } } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
public static List<Hashtable> ReturnQueryResults(PagingData pagData, bool Refresh, string baseclass, Hashtable attributeList) { return RunQuery.ReturnResults(pagData, Refresh, baseclass, attributeList); }
public static List<Hashtable> ExecuteQueryResults(OMQuery omQuery, PagingData pgData, bool refresh, Hashtable attributeList) { RunQuery.ExecuteQuery(omQuery); return ReturnQueryResults(pgData, refresh, omQuery.BaseClass, attributeList); }
public List<Hashtable> ObjectIDToUIObjects(PagingData pgdata, Hashtable attribList) { try { Hashtable hashFieldValue; object rowObj=null ; if (pgdata.ObjectId.Count < pgdata.EndIndex ) { pgdata.EndIndex = pgdata.ObjectId.Count; } if (attribList.Count == 0) { IReflectClass rClass = DataLayerCommon.ReflectClassForName(m_classname); if (rClass != null) { IReflectField[] reff = DataLayerCommon.GetDeclaredFieldsInHeirarchy(rClass); if (reff == null) return m_lstRowContent; for (int i = pgdata.StartIndex; i < pgdata.EndIndex ; i++) { if (pgdata.ObjectId[i] == 0) continue; rowObj = objectContainer.Ext().GetByID(pgdata.ObjectId[i]); if (rowObj != null) { if (m_refresh) { objectContainer.Ext().Refresh(rowObj, 1); } else { objectContainer.Ext().Activate(rowObj, 1); } } if (rowObj != null) { hashFieldValue = checkforprimitives(reff, rowObj); m_lstRowContent.Add(hashFieldValue); } } } } else { int length = 0; foreach (string str in attribList.Keys) { string[] splitstring = str.Split('.'); if (splitstring.Length > length) { length = splitstring.Length-1; } } for (int i = pgdata.StartIndex; i < pgdata.EndIndex; i++) { hashFieldValue = new Hashtable(); m_hashRowContent = new Hashtable(); foreach (string attribute in attribList.Keys) { if (pgdata.ObjectId[i] != 0) { rowObj = objectContainer.Ext().GetByID(pgdata.ObjectId[i]); if (rowObj != null) { if (m_refresh) { objectContainer.Ext().Refresh(rowObj, length); } else { objectContainer.Ext().Activate(rowObj, length); } hashFieldValue = UpdateResults(rowObj, attribute); } } } if (hashFieldValue.Count != 0) { if (!hashFieldValue.ContainsKey(BusinessConstants.DB4OBJECTS_REF)) { hashFieldValue.Add(BusinessConstants.DB4OBJECTS_REF, rowObj); } m_lstRowContent.Add(hashFieldValue); } } } return m_lstRowContent; } catch (Exception oEx) { LoggingHelper.HandleException(oEx); return new List<Hashtable>( ); } }
public static List <Hashtable> ReturnQueryResults(PagingData pagData, bool Refresh, string baseclass, Hashtable attributeList) { return(RunQuery.ReturnResults(pagData, Refresh, baseclass, attributeList)); }
public static List <Hashtable> ExecuteQueryResults(OMQuery omQuery, PagingData pgData, bool refresh, Hashtable attributeList) { RunQuery.ExecuteQuery(omQuery); return(ReturnQueryResults(pgData, refresh, omQuery.BaseClass, attributeList)); }