protected void advancedToolBar_ButtonClicked(object sender, Infragistics.WebUI.UltraWebToolbar.ButtonEvent be) { advancedToolBar.ClientSideEvents.InitializeToolbar = ""; uwToolbar.Items.FromKeyButton("Export").Pressed(true); switch (be.Button.Key) { case "TotalExport": using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString)) { string code = DDL_TermTypeList.SelectedIndex > 0 ? DDL_TermTypeList.SelectedValue.ToString() : string.Empty; using (DataSet ds = dbObj.RunSPReturnDataSet("_Term_Export", new System.Data.SqlClient.SqlParameter("@TermTypeCode", code))) { code = code == string.Empty ? " " : code; // assigning the code to have empty space if it is empty using (TermType tt = TermType.GetByKey(Convert.ToChar(code))) // If the code value is " ", then tt would be null { code = code != " " ? tt.Name : "All terms"; } HyperCatalog.UI.Tools.Export.ExportTermReport(ds, code, this.Page); } } break; case "RunValidationReport": using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString)) { Infragistics.WebUI.WebSchedule.WebDateChooser startDate = (Infragistics.WebUI.WebSchedule.WebDateChooser)advancedToolBar.Items.FromKeyCustom("startDate").FindControl("startDate"); if (startDate != null) { using (DataSet ds = dbObj.RunSPReturnDataSet("_Term_GetChoicesValidationReport", new System.Data.SqlClient.SqlParameter("@DayNew", startDate.Value))) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { HyperCatalog.UI.Tools.Export.ExportTermValidationReport(ds, (DateTime)startDate.Value, Page); } else { errorMsg.Text = "No activity since this date."; errorMsg.Visible = true; } } } } break; default: Response.Write("coucou"); break; } }
protected void Page_Load(object sender, System.EventArgs e) { #region Check Capabilities if ((SessionState.User.IsReadOnly) || (!SessionState.User.HasCapability(CapabilitiesEnum.MANAGE_TERM_BASE))) { uwToolbar.Items.FromKeyButton("Add").Enabled = false; uwToolbar.Items.FromKeyButton("Settings").Enabled = false; } #endregion errorMsg.Visible = false; if (Request["filter"] != null) { SessionState.tFilterTerm = txtFilter.Text = Request["filter"].ToString(); } if (!Page.IsPostBack) { #region Load TermType list using (TermTypeList termTypes = TermType.GetAll()) { DDL_TermTypeList.Items.Clear(); DDL_TermTypeList.Items.Add("All"); foreach (TermType t in termTypes) { DDL_TermTypeList.Items.Add(new ListItem(t.Name, t.Code.ToString())); } } #endregion #region TermType session if (SessionState.tTermType != string.Empty) { DDL_TermTypeList.SelectedValue = SessionState.tTermType; } #endregion #region FilterTerm session if (SessionState.tFilterTerm != string.Empty) { txtFilter.Text = SessionState.tFilterTerm; } #endregion #region Letter session if (SessionState.tLetter == string.Empty) { SessionState.tLetter = "A"; } uwToolbar.Items.FromKeyButton(SessionState.tLetter).Pressed(true); #endregion #region Validation report date chooser Infragistics.WebUI.WebSchedule.WebDateChooser startDate = (Infragistics.WebUI.WebSchedule.WebDateChooser)advancedToolBar.Items.FromKeyCustom("startDate").FindControl("startDate"); if (startDate != null) { System.Globalization.CultureInfo ci = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); ci.DateTimeFormat.ShortDatePattern = SessionState.User.FormatDate; ci.DateTimeFormat.LongDatePattern = SessionState.User.FormatDate; startDate.CalendarLayout.Culture = ci; startDate.Value = DateTime.Today.AddDays(-5); } #endregion ShowTermBase(); } else { if (Request["redirectId"] != null && Request["redirectId"].ToString() != string.Empty) { UpdateDataEdit(Request["redirectId"].ToString()); } } }