protected void Page_Load(object sender, EventArgs e)
{
_inBloomApi = new inBloomApi();
_sqlHelper = new SqlHelper();
_user = (User) Session["UserDetail"];
try
{
_inBloomApi.AccessToken = Session[SessionEnum.AccessToken.ToString()].ToString();
}
catch (Exception ex)
{
Response.Redirect("Search.aspx");
}
if (!IsPostBack)
{
try
{
if (!IsPostBack)
{
if (Session[SessionEnum.SchoolId.ToString()] == null)
{
}
else
{
LoadFieldNames();
_schoolId = Session[SessionEnum.SchoolId.ToString()].ToString();
_courseId = Session[SessionEnum.CourseId.ToString()].ToString();
_sectionId = Session[SessionEnum.SectionId.ToString()].ToString();
_user = (User) Session["UserDetail"];
if (Session["FlagId"] == null || Session["FlagType"] == null)
{
// show result for school and courses only.
Response.Redirect("Search.aspx");
}
else
{
_flagId = Convert.ToInt16(Session["FlagId"].ToString());
_flagType = Session["FlagType"].ToString();
if (_flagType.Equals("Flag"))
{
// get all the values for flag
IList<Flag> _flag = _sqlHelper.GetFlag(_flagId);
lblFlagName.Text = _flag[0].FlagName;
lblFlagDescription.Text = _flag[0].FlagDescription;
if (_flag.Count > 0)
{
int DataElementId = _flag[0].DataElementId;
int ConditionId = _flag[0].ConditionId;
_value1 = _flag[0].ValueSet1;
_value2 = _flag[0].ValueSet2;
_flagUser = _flag[0].UserId;
_dataType = _sqlHelper.GetDataTypeByDataElementId(DataElementId);
_fieldName = _sqlHelper.GetFieldNameByDataElementId(DataElementId);
_entityName = _sqlHelper.GetEntityNameByDataElementId(DataElementId);
DataTable dt = _inBloomApi.RunFlag(_fieldName, _dataType, _responseType, _flagUser, _schoolId, _courseId, _sectionId, ConditionId, _value1, _value2, _entityName, _isPreview);
Session.Add("FieldName", _fieldName);
gvResult.DataSource = dt;
gvResult.DataBind();
//gvResult.HeaderRow.Cells[3].Text = _inBloomApi.GetWellFormattedString(FieldName);
for (int i = 0; i < gvResult.HeaderRow.Cells.Count; i++)
{
String HeaderText = gvResult.HeaderRow.Cells[i].Text;
if (HeaderText == "FieldName")
{
gvResult.HeaderRow.Cells[i].Text = _inBloomApi.GetWellFormattedString(char.ToUpper(_entityName[0]) + _entityName.Substring(1)) + "." + _inBloomApi.GetWellFormattedString(_fieldName);
break;
}
}
HideColumnInitial();
Session.Add("ResultGrid", dt);
if (_sqlHelper.IsFav(_flagId) || _sqlHelper.IsInPublicFavorite(_flagId, _user.ExternalId))
{
btnlnkfavorite.Text = "Remove Favorite";
btnlnkfavorite.CssClass = "";
}
else
{
btnlnkfavorite.Text = "Add to Favorite";
btnlnkfavorite.CssClass = "unfavorite_result";
}
}
}
else if (_flagType.Equals("AggregateFlag"))
{
try
{
IList<AggregateFlag> _aggregateFlag = _sqlHelper.GetAggregateFlag(_flagId);
lblFlagName.Text = _aggregateFlag[0].AggregateFlagName;
lblFlagDescription.Text = _aggregateFlag[0].AggregateFlagDescription;
int[] FlagArrayId = _sqlHelper.GetAllFlagIdOfAggregateFlagByAggregateFlagId(_flagId);
DataTable dt = _inBloomApi.RunAggregateFlag(FlagArrayId, _schoolId, _courseId, _sectionId);
GridViewAggregateFlag.DataSource = dt;
Session.Add("ResultGrid", dt);
GridViewAggregateFlag.DataBind();
for (int i = 0; i < GridViewAggregateFlag.HeaderRow.Cells.Count; i++)
{
//GridViewAggregateFlag.HeaderRow.Cells[i].Text = _inBloomApi.GetWellFormattedString(GridViewAggregateFlag.HeaderRow.Cells[i].Text);
}
HideColumnInitialForAggregate();
//GridViewAggregateFlag.HeaderRow.Cells[0].Visible = false;
if (_sqlHelper.IsAggregateIsFav(_flagId) || _sqlHelper.IsAggregateInPublicFavorite(_flagId, _user.ExternalId))
{
btnlnkfavorite.Text = "Remove Favorite";
btnlnkfavorite.CssClass = "";
btnlnkfavorite.Attributes.Add("onclick", "showunfavmsg();");
}
else
{
btnlnkfavorite.Text = "Add to Favorite";
btnlnkfavorite.CssClass = "unfavorite_result";
btnlnkfavorite.Attributes.Add("onclick", "showfavmsg();");
}
}
catch (Exception ex)
{
}
}
}
//LoadStudentGrid();
}
}
}
catch (Exception ex)
{
Response.Redirect("Search.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
_sqlHelper = new SqlHelper();
_inBloomApi = new inBloomApi(Session[SessionEnum.AccessToken.ToString()].ToString());
if (!IsPostBack)
{
_sqlHelper = new SqlHelper();
LoadDataDomainList();
LoadGridWithAttribute();
lstCondition.DataSource = _sDACEntities.Conditions;
lstCondition.DataBind();
_user = (User)Session["UserDetail"];
if (!_user.IsAdminUser)
PanelFlagType.Visible = false;
if (Session["EditFlag"] != null)
{
try
{
int FlagId = Convert.ToInt16(Session["EditFlag"]);
Session.Add("FlagIdForEditPage", FlagId);
_flagIdForPage = FlagId;
IList<Flag> _Flag = _sqlHelper.GetFlag(FlagId);
txtFlagName.Text = _Flag[0].FlagName;
txtDescription.Text = _Flag[0].FlagDescription;
txtFlag.Text = _Flag[0].Keyword;
String IsPublic = _Flag[0].IsPublic.ToString();
if (IsPublic == "True")
{
radioFlagType.SelectedIndex = 0;
}
else
{
radioFlagType.SelectedIndex = 1;
}
lstCondition.SelectedValue = _Flag[0].ConditionId.ToString();
if (_Flag[0].ConditionId.ToString() != null && _Flag[0].ConditionId.ToString() != "")
{
condition.Style.Add("display", "block");
condition.Text = lstCondition.SelectedItem.Text;
}
txtSetVal.Text = _Flag[0].ValueSet1;
txtSetVal2.Text = _Flag[0].ValueSet2;
if (_Flag[0].ValueSet1 != null && _Flag[0].ValueSet1 != "")
{
val1.Style.Add("display", "block");
val1.Text = _Flag[0].ValueSet1;
}
if (_Flag[0].ValueSet2 != null && _Flag[0].ValueSet2 != "")
{
val2.Style.Add("display", "block");
val2.Text = " & " + _Flag[0].ValueSet2;
}
_conditionId = _Flag[0].ConditionId;
if (condition.Text == "Is between" || condition.Text == "Is not between")
{
txtSetVal2.Style.Add("display", "block");
}
hdnDataElementId.Value = _Flag[0].DataElementId.ToString();
int DataElementId = _Flag[0].DataElementId;
hdnDataType.Value = _sqlHelper.GetDataTypeByDataElementId(DataElementId);
String EntityName = _sqlHelper.GetDataDomainNameByDataElementId(DataElementId);
// LoadEntityList();
LoadDataDomainList();
DropDownListEntity.SelectedItem.Text = EntityName;
LoadGridWithAttribute();
SelectRow(_Flag[0].DataElementId);
// process to call run flag
String Entity = _sqlHelper.GetEntityNameByDataElementId(DataElementId);
String FieldName = _sqlHelper.GetFieldNameByDataElementId(DataElementId);
String DataType = _sqlHelper.GetDataTypeByDataElementId(DataElementId);
bool ResponseType = false;
_user = (User)Session["UserDetail"];
String UserId = _user.ExternalId;
String SchoolId = Session[SessionEnum.SchoolId.ToString()].ToString();
String CourseId = Session[SessionEnum.CourseId.ToString()].ToString();
String SectionId = Session[SessionEnum.SectionId.ToString()].ToString();
String Value1 = txtSetVal.Text;
String Value2 = txtSetVal2.Text;
// String ExternalField = "";
bool IsPreview = true;
DataTable dt = _inBloomApi.RunFlag(FieldName, DataType, ResponseType, UserId, SchoolId, CourseId, SectionId, _conditionId, Value1, Value2, Entity, IsPreview);
gridDisplayResult.DataSource = dt;
gridDisplayResult.DataBind();
gridDisplayResult.HeaderRow.Cells[1].Text =_inBloomApi.GetWellFormattedString(char.ToUpper(Entity[0]) + Entity.Substring(1))+"."+_inBloomApi.GetWellFormattedString(FieldName);
entity.Text = _inBloomApi.GetWellFormattedString(char.ToUpper(Entity[0]) + Entity.Substring(1)) + "." + _inBloomApi.GetWellFormattedString(FieldName); ;
}
catch (Exception ex)
{
}
}
else
{
Response.Redirect("Search.aspx");
}
}
}
