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