void fillSQSummary() { if (SavedQueryState != null) { Sage.Platform.Data.IDataService serviceObj = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>(); string connString = serviceObj.GetConnectionString(); System.Data.OleDb.OleDbConnection olecon = new System.Data.OleDb.OleDbConnection(connString); olecon.Open(); System.Data.OleDb.OleDbCommand cmdgetSummaryData = new System.Data.OleDb.OleDbCommand(); cmdgetSummaryData.CommandText = SavedQueryState.GenerateServiceQueryForSummary(); cmdgetSummaryData.Connection = olecon; System.Data.DataSet dsgetSummaryData = new System.Data.DataSet(); System.Data.OleDb.OleDbDataAdapter adpgetSummaryData = new System.Data.OleDb.OleDbDataAdapter(cmdgetSummaryData); adpgetSummaryData.Fill(dsgetSummaryData); olecon.Close(); if (dsgetSummaryData != null) { if (dsgetSummaryData.Tables[0].Rows.Count > 0) { ServiceQueryState objServiceQueryState = new ServiceQueryState(); // NavBarGroupTemplateContainer aspxContainer = this.navBarFilters.FindControl("GCTC0") as NavBarGroupTemplateContainer; ASPxPageControl tabControls = navBarFilters.Groups[0].FindControl("tabFilters") as ASPxPageControl; (tabControls.TabPages[0].FindControl("txtActual") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumActual"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumActual"])); (tabControls.TabPages[0].FindControl("txtOverRide") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumOverride"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumOverride"])); (tabControls.TabPages[0].FindControl("txtNonBillable") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumNonBillable"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumNonBillable"])); (tabControls.TabPages[0].FindControl("txtAdjustment") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumAdjustment"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumAdjustment"])); (tabControls.TabPages[0].FindControl("txtBillable") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumBillable"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumBillable"])); (tabControls.TabPages[0].FindControl("txtValService") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumServices"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumServices"])); (tabControls.TabPages[0].FindControl("txtValCost") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumCost"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumCost"])); (tabControls.TabPages[0].FindControl("txtValProfit") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumProfit"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumProfit"])); (tabControls.TabPages[0].FindControl("txtValTravel") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["sumTravel"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["sumTravel"])); (tabControls.TabPages[0].FindControl("txtValMargin") as TextBox).Text = String.Format("{0:0.00}", string.IsNullOrEmpty(Convert.ToString(dsgetSummaryData.Tables[0].Rows[0]["avgMargin"])) ? 0 : Convert.ToDouble(dsgetSummaryData.Tables[0].Rows[0]["avgMargin"])); } } } }
private void CreateServiceQueryState() { ServiceQueryState objServiceQueryState = new ServiceQueryState(); NavBarGroupTemplateContainer aspxContainer = this.navBarFilters.FindControl("GCTC0") as NavBarGroupTemplateContainer; ASPxPageControl tabControlFilters = navBarFilters.Groups[0].FindControl("tabFilters") as ASPxPageControl; if (string.IsNullOrEmpty((tabControlFilters.TabPages[0].FindControl("dteFromRange") as DateTimePicker).Text)) { objServiceQueryState.fromRange = null; } else { objServiceQueryState.fromRange = (Convert.ToDateTime((tabControlFilters.TabPages[0].FindControl("dteFromRange") as DateTimePicker).Text)); } if (string.IsNullOrEmpty((tabControlFilters.TabPages[0].FindControl("dteToRange") as DateTimePicker).Text)) { objServiceQueryState.toRange = null; } else { objServiceQueryState.toRange = (Convert.ToDateTime((tabControlFilters.FindControl("dteToRange") as DateTimePicker).Text)); } if ((tabControlFilters.TabPages[0].FindControl("ctlSite") as LookupControl).LookupResultValue == null) { objServiceQueryState.site = ""; } else { objServiceQueryState.site = ((ITLXProjectAccount)(tabControlFilters.TabPages[0].FindControl("ctlSite") as LookupControl).LookupResultValue).Id.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlAccount") as LookupControl).LookupResultValue == null) { objServiceQueryState.accountId = ""; } else { objServiceQueryState.accountId = (String)((IAccount)(tabControlFilters.TabPages[0].FindControl("ctlAccount") as LookupControl).LookupResultValue).Id; } if ((tabControlFilters.TabPages[0].FindControl("ctlOpportunity") as LookupControl).LookupResultValue == null) { objServiceQueryState.opportunityId = ""; } else { objServiceQueryState.opportunityId = ((IOpportunity)(tabControlFilters.TabPages[0].FindControl("ctlOpportunity") as LookupControl).LookupResultValue).Id.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlProject") as LookupControl).LookupResultValue == null) { objServiceQueryState.projectId = ""; } else { objServiceQueryState.projectId = ((ITLXProject)(tabControlFilters.TabPages[0].FindControl("ctlProject") as LookupControl).LookupResultValue).Id.ToString(); } //objServiceQueryState.ticket = (tabControlFilters.TabPages[0].FindControl("ctlTicket") as TextBox).Text; if ((tabControlFilters.TabPages[0].FindControl("ctlTicket") as LookupControl).LookupResultValue == null) { objServiceQueryState.ticket = ""; } else { (tabControlFilters.TabPages[0].FindControl("ctlTicket") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.String; objServiceQueryState.ticket = Convert.ToString((tabControlFilters.TabPages[0].FindControl("ctlTicket") as LookupControl).LookupResultValue); (tabControlFilters.TabPages[0].FindControl("ctlTicket") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.Object; } if ((tabControlFilters.TabPages[0].FindControl("ctlWeekend") as ASPxComboBox).Value == null) { objServiceQueryState.weekend = ""; } else { objServiceQueryState.weekend = (tabControlFilters.TabPages[0].FindControl("ctlWeekend") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlConsultant") as LookupControl).LookupResultValue == null) { objServiceQueryState.consultant = ""; } else { objServiceQueryState.consultant = ((IUserInfo)(tabControlFilters.TabPages[0].FindControl("ctlConsultant") as LookupControl).LookupResultValue).Id.ToString(); } objServiceQueryState.invoiceNo = (tabControlFilters.TabPages[0].FindControl("ctlInvoiceNo") as TextBox).Text.ToString(); if ((tabControlFilters.TabPages[0].FindControl("ctlBatchNo") as Sage.SalesLogix.Web.Controls.Lookup.LookupControl).LookupResultValue == null) { objServiceQueryState.batchno = ""; } else { objServiceQueryState.batchno = ((tabControlFilters.TabPages[0].FindControl("ctlBatchNo") as Sage.SalesLogix.Web.Controls.Lookup.LookupControl).LookupResultValue).ToString(); } if (string.IsNullOrEmpty((tabControlFilters.TabPages[0].FindControl("dteClosePeriod") as DateTimePicker).Text)) { objServiceQueryState.closePeriod = null; } else { objServiceQueryState.closePeriod = (Convert.ToDateTime((tabControlFilters.TabPages[0].FindControl("dteClosePeriod") as DateTimePicker).Text)); } if ((tabControlFilters.TabPages[0].FindControl("chkNoClosePeriod") as CheckBox).Checked) { objServiceQueryState.blnNoClosePeriod = true; } else { objServiceQueryState.blnNoClosePeriod = false; } if ((tabControlFilters.TabPages[0].FindControl("ctlClosePeriod") as ASPxComboBox).Text == null) { objServiceQueryState.ClosePeriodOperator = ""; } else { objServiceQueryState.ClosePeriodOperator = ((tabControlFilters.TabPages[0].FindControl("ctlClosePeriod") as ASPxComboBox).Text).ToString(); } //objServiceQueryState.categoryId = (tabControlFilters.TabPages[1].FindControl("ctlCategory") as SimplePicklist).PickListValue; //Added code for Proj Category PickList - Ajay if ((tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue == null) { objServiceQueryState.categoryId = ""; } else { (tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue = hdnProjCat.Value; objServiceQueryState.categoryId = (tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue; } if ((tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue == null) { objServiceQueryState.categoryId = ""; } else { (tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue = hdnProjCat.Value; objServiceQueryState.categoryId = (tabControlFilters.TabPages[1].FindControl("ctlCategory") as Sage.SalesLogix.Web.Controls.PickList.PickListControl).PickListValue; } //objServiceQueryState.typeId = (tabControlFilters.TabPages[1].FindControl("ctlType") as SimplePicklist).PickListValue; // Code for Type picklist, start - Ajay //if (hdnProjType.Value == null) //{ // objServiceQueryState.typeId = ""; //} //else //{ // objServiceQueryState.typeId = hdnProjType.Value; //} // Code for Type picklist, end - Ajay if (hdnProjStatus.Value == null) { objServiceQueryState.statusId = ""; } else { objServiceQueryState.statusId = hdnProjStatus.Value; } if ((tabControlFilters.TabPages[1].FindControl("ctlSoldBy") as LookupControl).LookupResultValue == null) { objServiceQueryState.soldById = ""; } else { objServiceQueryState.soldById = ((IComponentReference)(tabControlFilters.TabPages[1].FindControl("ctlSoldBy") as LookupControl).LookupResultValue).Id.ToString(); } if ((tabControlFilters.TabPages[1].FindControl("ctlProjectMgr") as LookupControl).LookupResultValue == null) { objServiceQueryState.projectMrgId = ""; } else { objServiceQueryState.projectMrgId = ((IComponentReference)(tabControlFilters.TabPages[1].FindControl("ctlProjectMgr") as LookupControl).LookupResultValue).Id.ToString();//(tabControlFilters.TabPages[1].FindControl("ctlProjectMgr") as LookupControl).LookupResultValue).Id.ToString(); } // this is for approval tabs if ((tabControlFilters.TabPages[0].FindControl("chkNedMgr") as CheckBox).Checked) { objServiceQueryState.blnNedManager = true; } else { objServiceQueryState.blnNedManager = false; } if ((tabControlFilters.TabPages[0].FindControl("chkNedPrjMgr") as CheckBox).Checked) { objServiceQueryState.blnNedPrjMgr = true; } else { objServiceQueryState.blnNedPrjMgr = false; } if ((tabControlFilters.TabPages[0].FindControl("chkNedFinMgr") as CheckBox).Checked) { objServiceQueryState.blnNedFinMgr = true; } else { objServiceQueryState.blnNedFinMgr = false; } // if ((tabControlFilters.TabPages[0].FindControl("chkAprdMgr") as CheckBox).Checked) { objServiceQueryState.blnAprdManager = true; } else { objServiceQueryState.blnAprdManager = false; } if ((tabControlFilters.TabPages[0].FindControl("chkAprdPrjMgr") as CheckBox).Checked) { objServiceQueryState.blnAprdPrjMgr = true; } else { objServiceQueryState.blnAprdPrjMgr = false; } if ((tabControlFilters.TabPages[0].FindControl("chkAprdFinMgr") as CheckBox).Checked) { objServiceQueryState.blnAprdFinMgr = true; } else { objServiceQueryState.blnAprdFinMgr = false; } //if ((tabControlFilters.TabPages[1].FindControl("chkAttendance") as CheckBox).Checked) //{ // objServiceQueryState.blnAttendance = true; //} //else //{ // objServiceQueryState.blnAttendance = false; //} //if ((tabControlFilters.TabPages[1].FindControl("chkSubmitted") as CheckBox).Checked) //{ // objServiceQueryState.blnSubmitted = true; //} //else //{ // objServiceQueryState.blnSubmitted = false; //} objServiceQueryState.includeChildProjects = (tabControlFilters.TabPages[1].FindControl("chkIncludeChildProjects") as CheckBox).Checked; objServiceQueryState.excludeExternal = (tabControlFilters.TabPages[1].FindControl("chkExcludeExternal") as CheckBox).Checked; objServiceQueryState.internalOnly = (tabControlFilters.TabPages[1].FindControl("chkInternalOnly") as CheckBox).Checked; // objServiceQueryState.displayTicketInfo = (tabControlFilters.TabPages[1].FindControl("chkDisplayTicketInfo") as CheckBox).Checked; objServiceQueryState.project = (tabControlFilters.TabPages[1].FindControl("chkProject") as CheckBox).Checked; objServiceQueryState.task = (tabControlFilters.TabPages[1].FindControl("chkTask") as CheckBox).Checked; objServiceQueryState.account = (tabControlFilters.TabPages[1].FindControl("chkAccount") as CheckBox).Checked; objServiceQueryState.blnConsultant = (tabControlFilters.TabPages[1].FindControl("chkConsultant") as CheckBox).Checked; objServiceQueryState.blnFixed = (tabControlFilters.TabPages[1].FindControl("chkFixed") as CheckBox).Checked; //objServiceQueryState.milestoneId = (tabControlFilters.TabPages[2].FindControl("ctlMilestone") as SimplePicklist).PickListValue; if ((tabControlFilters.TabPages[2].FindControl("ctlMilestone") as LookupControl).LookupResultValue == null) { objServiceQueryState.milestoneId = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlMilestone") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.String; objServiceQueryState.milestoneId = (tabControlFilters.TabPages[2].FindControl("ctlMilestone") as LookupControl).LookupResultValue.ToString(); (tabControlFilters.TabPages[2].FindControl("ctlMilestone") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.Object; } if ((tabControlFilters.TabPages[2].FindControl("ctlProjectTask") as LookupControl).LookupResultValue == null) { objServiceQueryState.projectTaskId = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlProjectTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.String; objServiceQueryState.projectTaskId = (tabControlFilters.TabPages[2].FindControl("ctlProjectTask") as LookupControl).LookupResultValue.ToString(); (tabControlFilters.TabPages[2].FindControl("ctlProjectTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.Object; } objServiceQueryState.taskText = (tabControlFilters.TabPages[2].FindControl("ctlTaskText") as TextBox).Text.ToString(); // Code for Task Category PickList - Ajay if ((tabControlFilters.TabPages[2].FindControl("ctlTaskCategory") as SimplePicklist).PickListValue == null) { objServiceQueryState.taskCategoryId = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlTaskCategory") as SimplePicklist).PickListValue = hdnTaskCategory.Value; objServiceQueryState.taskCategoryId = (tabControlFilters.TabPages[2].FindControl("ctlTaskCategory") as SimplePicklist).PickListValue; } if ((tabControlFilters.TabPages[2].FindControl("ctlTaskDepartment") as SimplePicklist).PickListValue == null) { objServiceQueryState.taskDepartment = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlTaskDepartment") as SimplePicklist).PickListValue = hdnTaskDepartment.Value; objServiceQueryState.taskDepartment = (tabControlFilters.TabPages[2].FindControl("ctlTaskDepartment") as SimplePicklist).PickListValue; } if ((tabControlFilters.TabPages[3].FindControl("ctlUserDepartment") as SimplePicklist).PickListValue == null) { objServiceQueryState.userDepartment = ""; } else { (tabControlFilters.TabPages[3].FindControl("ctlUserDepartment") as SimplePicklist).PickListValue = hdnUserDepartment.Value; objServiceQueryState.userDepartment = (tabControlFilters.TabPages[2].FindControl("ctlUserDepartment") as SimplePicklist).PickListValue; } if ((tabControlFilters.TabPages[2].FindControl("ctlParentTask") as LookupControl).LookupResultValue == null) { objServiceQueryState.parentTaskId = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlParentTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.String; objServiceQueryState.parentTaskId = (tabControlFilters.TabPages[2].FindControl("ctlParentTask") as LookupControl).LookupResultValue.ToString(); (tabControlFilters.TabPages[2].FindControl("ctlParentTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.Object; } if ((tabControlFilters.TabPages[2].FindControl("ctlMasterTask") as LookupControl).LookupResultValue == null) { objServiceQueryState.masterTaskId = ""; } else { (tabControlFilters.TabPages[2].FindControl("ctlMasterTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.String; objServiceQueryState.masterTaskId = (tabControlFilters.TabPages[2].FindControl("ctlMasterTask") as LookupControl).LookupResultValue.ToString(); (tabControlFilters.TabPages[2].FindControl("ctlMasterTask") as LookupControl).LookupBindingMode = Sage.Platform.Controls.LookupBindingModeEnum.Object; } if ((tabControlFilters.TabPages[0].FindControl("ctlTravelTask") as ASPxComboBox).Value == null) { objServiceQueryState.travelTask = ""; } else { objServiceQueryState.travelTask = (tabControlFilters.TabPages[0].FindControl("ctlTravelTask") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlInvoiced") as ASPxComboBox).Value == null) { objServiceQueryState.invoiced = ""; } else { objServiceQueryState.invoiced = (tabControlFilters.TabPages[0].FindControl("ctlInvoiced") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlRetainer") as ASPxComboBox).Value == null) { objServiceQueryState.retainer = ""; } else { objServiceQueryState.retainer = (tabControlFilters.TabPages[0].FindControl("ctlRetainer") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlOutOfScope") as ASPxComboBox).Value == null) { objServiceQueryState.outOfScope = ""; } else { objServiceQueryState.outOfScope = (tabControlFilters.TabPages[0].FindControl("ctlOutOfScope") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlBillable") as ASPxComboBox).Value == null) { objServiceQueryState.billable = ""; } else { objServiceQueryState.billable = (tabControlFilters.TabPages[0].FindControl("ctlBillable") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlHoldBilling") as ASPxComboBox).Value == null) { objServiceQueryState.holdBilling = ""; } else { objServiceQueryState.holdBilling = (tabControlFilters.TabPages[0].FindControl("ctlHoldBilling") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlAttendance") as ASPxComboBox).Value == null) { objServiceQueryState.blnAttendance = ""; } else { objServiceQueryState.blnAttendance = (tabControlFilters.TabPages[0].FindControl("ctlAttendance") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[0].FindControl("ctlSubmitted") as ASPxComboBox).Value == null) { objServiceQueryState.blnSubmitted = ""; } else { objServiceQueryState.blnSubmitted = (tabControlFilters.TabPages[0].FindControl("ctlSubmitted") as ASPxComboBox).Value.ToString(); } if ((tabControlFilters.TabPages[3].FindControl("ctlServiceCat") as SimplePicklist).PickListValue == null) { objServiceQueryState.serviceCatId = ""; } else { (tabControlFilters.TabPages[3].FindControl("ctlServiceCat") as SimplePicklist).PickListValue = hdnServCat.Value; objServiceQueryState.serviceCatId = (tabControlFilters.TabPages[3].FindControl("ctlServiceCat") as SimplePicklist).PickListValue; } if ((tabControlFilters.TabPages[3].FindControl("ctlLocation") as SimplePicklist).PickListValue == null) { objServiceQueryState.locationId = ""; } else { (tabControlFilters.TabPages[3].FindControl("ctlLocation") as SimplePicklist).PickListValue = hdnLocation.Value; objServiceQueryState.locationId = (tabControlFilters.TabPages[3].FindControl("ctlLocation") as SimplePicklist).PickListValue; } objServiceQueryState.margin = (tabControlFilters.TabPages[3].FindControl("ctlMargin") as ASPxComboBox).Value.ToString(); objServiceQueryState.marginText = (tabControlFilters.TabPages[3].FindControl("ctlMarginText") as TextBox).Text.ToString(); //objServiceQueryState.expenseTypeId = (tabControlFilters.TabPages[3].FindControl("ctlExpenseType") as SimplePicklist).PickListValue; if ((tabControlFilters.TabPages[3].FindControl("ctlExpenseType") as SimplePicklist).PickListValue == null) { objServiceQueryState.expenseTypeId = ""; } else { (tabControlFilters.TabPages[3].FindControl("ctlExpenseType") as SimplePicklist).PickListValue = hdnExpensType.Value; objServiceQueryState.expenseTypeId = (tabControlFilters.TabPages[3].FindControl("ctlExpenseType") as SimplePicklist).PickListValue; } objServiceQueryState.cmbreimbursed = (tabControlFilters.TabPages[3].FindControl("cmbReimbursed") as ASPxComboBox).Value.ToString(); if ((tabControlFilters.TabPages[0].FindControl("cmbReimbursed") as ASPxComboBox).Value == null) { objServiceQueryState.cmbreimbursed = ""; } else { objServiceQueryState.cmbreimbursed = (tabControlFilters.TabPages[0].FindControl("cmbReimbursed") as ASPxComboBox).Value.ToString(); } SavedQueryState = objServiceQueryState; //throw new Sage.Platform.Application.ValidationException(SavedQueryState.GenerateServiceQuery()); }