private void frmDenominatorSetup_FormClosed(object sender, FormClosedEventArgs e) { frmIndicatorReportSetup frmIndicatorReportSetupCopy = new frmIndicatorReportSetup(); // // // try { frmIndicatorReportSetupCopy.refreshPage(); } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } }
private void lstUtilizationFields_ItemCheckedChanged(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { frmIndicatorReportSetup frmIndicatorReportSetupCopy = new frmIndicatorReportSetup(); int sid; int fid = 0; try { if (openning == 0) { sid = Support.GetItemData(frmIndicatorReportSetupCopy.lstHeading, frmIndicatorReportSetupCopy.lstHeading.SelectedIndex); fid = Support.GetItemData(lstUtilizationFields, lstUtilizationFields.SelectedIndex); //LDW if (lstUtilizationFields.GetItemChecked(eventArgs.Index) == true) if (Convert.ToBoolean(e.Item.CheckState) == true) { modGlobal.gv_sql = "INSERT into tbl_Setup_IndicatorReportDenominators (SubGroupID, tName, FieldID, OpChar)"; modGlobal.gv_sql = modGlobal.gv_sql + " values (" + sid + ",'Utilization'," + Support.GetItemData(lstUtilizationFields, lstUtilizationFields.SelectedIndex) + " , 1)"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } else { modGlobal.gv_sql = "delete from tbl_Setup_IndicatorReportDenominators "; modGlobal.gv_sql = string.Format("{0} where SubGroupID = {1} and tName = 'Utilization' and FieldID ={2}", modGlobal.gv_sql, sid, fid); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } } } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } }
public void RefreshSummaryFields() { frmIndicatorReportSetup frmIndicatorReportSetupCopy = new frmIndicatorReportSetup(); var LIndex = 0; var Table_ListIndex = 0; DataSet rsSelected = new DataSet(); List <Item> itemslstSummaryFields = new List <Item>(); try { /*LDW if (frmIndicatorReportSetup.lstHeading.SelectedIndex == -1) * { * goto DoneRefreshSummaryFields; * }*/ if (frmIndicatorReportSetupCopy.lstHeading.SelectedIndex != -1) { // //retrieve the list of Indicators // modGlobal.gv_sql = "Select * from vuSummaryFieldNames order by fieldname"; } //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "vuSummaryFieldNames"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); // // // modGlobal.gv_sql = "select * from vuDenominatorSummaryFields where SubGroupID = " + Support.GetItemData(frmIndicatorReportSetupCopy.lstHeading, frmIndicatorReportSetupCopy.lstHeading.SelectedIndex); //LDW rsSelected = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "vuDenominatorSummaryFields"; rsSelected = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, rsSelected); // //fill the list box // lstSummaryFields.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; itemslstSummaryFields.Add(new Item(myRow1.Field <int>("SubGroupID"), myRow1.Field <string>("FieldName") + " (" + myRow1.Field <int>("SubGroupID") + ")")); //lstSummaryFields.Items.Add(new ListBoxItem(myRow1.Field<string>("FieldName") + " (" + myRow1.Field<int>("SubGroupID") + ")", myRow1.Field<int>("SubGroupID"))); if (rsSelected.Tables[sqlTableName2].Rows.Count > 0) { //LDW rsSelected.MoveFirst(); //LDW while (!rsSelected.EOF) foreach (DataRow myRow2 in rsSelected.Tables[sqlTableName2].Rows) { if (Strings.Trim(myRow2.Field <string>("FieldName")) == Strings.Trim(myRow1.Field <string>("FieldName"))) { //LDW lstSummaryFields.SetItemChecked(lstSummaryFields.NewIndex, true); lstSummaryFields.SelectedIndex = lstSummaryFields.Items.Count - 1; lstSummaryFields.SelectedItem.Enabled = true; } //LDW rsSelected.MoveNext(); } } //LDW modGlobal.gv_rs.MoveNext(); } this.lstSummaryFields.DataSource = itemslstSummaryFields; this.lstSummaryFields.DisplayMember = "Description"; this.lstSummaryFields.ValueMember = "Id"; rsSelected.Dispose(); } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } // DoneRefreshSummaryFields: }
public void RefreshUtilizationFields() { frmIndicatorReportSetup frmIndicatorReportSetupCopy = new frmIndicatorReportSetup(); var LIndex = 0; var Table_ListIndex = 0; DataSet rsSelected = new DataSet(); try { // //retrieve the list of Indicators // modGlobal.gv_sql = "Select * from tbl_setup_DataDef where BaseTableID = 2 ORDER BY FieldName"; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_setup_DataDef"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); // // // modGlobal.gv_sql = "select * from vuDenominatorUtilizationStat where SubGroupID = " + Support.GetItemData(frmIndicatorReportSetupCopy.lstHeading, frmIndicatorReportSetupCopy.lstHeading.SelectedIndex) + " order by fieldName"; //LDW rsSelected = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "vuDenominatorUtilizationStat"; rsSelected = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, rsSelected); // //fill the list box // lstUtilizationFields.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; lstUtilizationFields.Items.Add(string.Format("{0} ({1})", myRow3.Field <string>("FieldName"), myRow3.Field <int>("DDID"))); Support.SetItemData(lstUtilizationFields, lstUtilizationFields.Items.Count - 1, myRow3.Field <int>("DDID")); if (rsSelected.Tables[sqlTableName4].Rows.Count > 0) { //LDW rsSelected.MoveFirst(); //LDW while (!rsSelected.EOF) foreach (DataRow myRow4 in rsSelected.Tables[sqlTableName4].Rows) { if (Strings.Trim(myRow4.Field <string>("FieldName")) == Strings.Trim(myRow3.Field <string>("FieldName"))) { //LDW lstUtilizationFields.SetItemChecked(lstUtilizationFields.NewIndex, true); lstUtilizationFields.SelectedIndex = lstSummaryFields.Items.Count - 1; lstUtilizationFields.SelectedItem.Enabled = true; } //LDW rsSelected.MoveNext(); } } //LDW modGlobal.gv_rs.MoveNext(); } rsSelected.Dispose(); } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } // RefreshUtilizationFieldsDone }