//This method is used to find ticker
protected void btnFind_Click(object sender, EventArgs e)
{
DataOperation operation = new DataOperation();
DataTable table = operation.FindByTicker(tbFind.Text);
gvMain.DataSource = table;
gvMain.DataBind();
}
//Button to load data from Web, parse it to db and show it in GridView
protected void btnFill_Click(object sender, EventArgs e)
{
DataOperation operation = new DataOperation();
operation.ParseData();
FillFilters();
gvMain.DataSource = operation.ReadData();
gvMain.DataBind();
}
//This method is used to handle all DropDownList and Calendar events
protected void ControlsEvent_Click(object sender, EventArgs e)
{
DataOperation operation = new DataOperation();
DropDownList[] ddlArray = { ddlCountry, ddlIndustry, ddlSector, ddlMarketCap, ddlDividentYeild,
ddlFilter52WeekHigh, ddlFilter52WeekLow, ddlFilterBeta, ddlPerformanceWeek,
ddlPerformanceMonth, ddlPerformanceYear, ddlFilterAverageTrueRange, ddlFilterChange,
ddlFilterVolume, ddlFilterPrice };
for (int i = 0; i < AMOUNT_OF_FILTERS; i++)
{
if ((string)Session[i.ToString()] != ddlArray[i].Text)
{
Session[i.ToString()] = ddlArray[i].Text;
}
}
List<string> list = new List<string>();
for (int i = 0; i < AMOUNT_OF_FILTERS; i++)
{
list.Add((string)Session[i.ToString()]);
}
DateTime dateSelected = cldrDate.SelectedDate;
string chosenDate = dateSelected.Day.ToString() + DOT + dateSelected.Month.ToString() + DOT + dateSelected.Year.ToString();
bool flag = true;
for (int i = 0; i < chosenDate.Length; i++)
{
if (((string)Session[CALENDAR])[i] != chosenDate[i])
{
flag = false;
break;
}
}
if (!flag)
{
Session[CALENDAR] = chosenDate;
}
list.Add((string)Session[CALENDAR]);
DataTable table = operation.Filter(list);
gvMain.DataSource = table;
gvMain.DataBind();
}
private void FillFilters()
{
DataOperation operation = new DataOperation();
DropDownList[] ddlArray = { ddlCountry, ddlIndustry, ddlSector, ddlMarketCap, ddlDividentYeild,
ddlFilter52WeekHigh, ddlFilter52WeekLow, ddlFilterBeta, ddlPerformanceWeek,
ddlPerformanceMonth, ddlPerformanceYear, ddlFilterAverageTrueRange, ddlFilterChange,
ddlFilterVolume, ddlFilterPrice };
string[,] filtersDataArray = operation.LoadFiltersData();
for (int j = 0; j < AMOUNT_OF_FILTERS; j++)
{
for (int i = 0; i < filtersDataArray.GetLength(0); i++)
{
if (filtersDataArray[i, j] == NULL)
{
break;
}
ddlArray[j].Items.Add(filtersDataArray[i, j]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Writing filters default value "Any" to session
for (int i = 0; i < AMOUNT_OF_FILTERS; i++)
{
Session[i.ToString()] = "Any";
}
//Writing calendar value to session
DateTime dateToday = DateTime.Today;
Session[CALENDAR] = dateToday.Day + DOT + dateToday.Month + DOT + dateToday.Year;
FillFilters();
}
//Filling GridView
DataOperation operation = new DataOperation();
gvMain.DataSource = operation.ReadData();
gvMain.DataBind();
}
//This method is used for display GridView in multipage mode
protected void gvMain_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
DataOperation table = new DataOperation();
gvMain.DataSource = table.ReadData();
gvMain.PageIndex = e.NewPageIndex;
gvMain.DataBind();
}
//This method is used to sort GridView
protected void gvMain_OnSorting(object sender, GridViewSortEventArgs e)
{
DataOperation table = new DataOperation();
DataTable dataTable = table.ReadData();
DataView dataView = new DataView(dataTable);
dataView.Sort = e.SortExpression;
gvMain.DataSource = dataView;
gvMain.DataBind();
}
