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