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