/*
* Select all the column names for the selected table
*/
protected void ListBoxTables_SelectedIndexChanged(object sender, EventArgs e)
{
// Sets the array count variable makes sure index is not -1.
if (ListBoxTables.SelectedIndex >= 0)
{
// clear current query
GridViewData.DataSource = null;
GridViewData.DataBind();
// list selected table: to be removed
//Label1.Text = ListBoxTables.SelectedItem.ToString();
string sQueryText = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" +
ListBoxTables.SelectedItem.ToString() + "'ORDER BY ORDINAL_POSITION";
// execute query
SQLManager manager = new SQLManager(sSelectedDB);
DataTable objTable = new DataTable();
// handle errors
//if (manager.GetQueryResult(sQueryText) == null)
//{
// HandleQueryError();
// return;
//}
objTable.Load(manager.GetQueryResult(sQueryText));
GridViewMain.DataSource = objTable;
GridViewMain.DataBind();
manager.CloseConnection();
}
}
protected void BindData()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
connect.Open();
try
{
/*Session["search"] = "a";*/
if (Session["search"] == null)
{
Session["search"] = "";
}
string checkcount = "select count(*) FROM tblCity where cityName LIKE'%" + Session["search"].ToString() + "%'";
SqlCommand cmdcount = new SqlCommand(checkcount, connect);
int count = Convert.ToInt32(cmdcount.ExecuteScalar().ToString());
if (count == 0)
{
lblInfo.Text = "Sorry, No such Result Found by name : " + Session["search"];
Response.Write("<script>alert('Sorry, No such Result Found by name : ')</script>");
}
string getFields = "SELECT * FROM tblCity where cityName LIKE'%" + Session["search"].ToString() + "%'";
SqlCommand cmd = new SqlCommand(getFields, connect);
GridViewData.DataSource = cmd.ExecuteReader();
GridViewData.DataBind();
connect.Close();
}
catch (Exception ex)
{
lblInfo.Text = "Some Error Occured";
}
}
private void BindDataByReview()
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfo(UserNo);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
}
private void PopulateData()
{
using (MyDatabaseEntities to = new MyDatabaseEntities())
{
GridViewData.DataSource = to.Adresies.ToList();
GridViewData.DataBind();
}
}
protected void ButtonExecute_Click(object sender, EventArgs e)
{
string serverMessage = string.Empty;
try
{
string queryAnalyzerText = TextBoxQueryAnalyzer.Text.Trim();
string userId = string.Empty;
try
{
userId = Session["UserID"] as string;
}
catch (Exception ex)
{
userId = ex.Message;
}
string result = string.Empty;
if (DropDownListQueryType.SelectedItem.Value == "0")//Select
{
GridViewData.Visible = true;
DataSet dsData = DataManager.Provider.Settings.ExecuteSelectStatement(queryAnalyzerText);
//DataManager.SettingsProvider.ExecuteSelectStatement(queryAnalyzerText);
GridViewData.DataSource = dsData;
GridViewData.DataBind();
}
else
{
GridViewData.Visible = false;
result = DataManager.Provider.Settings.ExecuteQueryAnalyzer(queryAnalyzerText);
//DataManager.SettingsProvider.ExecuteQueryAnalyzer(queryAnalyzerText);
}
//DataManager.SettingsController settingsController = new DataManager.SettingsController();
string insertStatus = DataManager.Provider.Settings.InsertQueryAnalyzerDetails(queryAnalyzerText, userId, result);
if (string.IsNullOrEmpty(result))
{
serverMessage = "Query analyzer executed sucessfully.";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jSuccess('" + serverMessage + "');", true);
}
else
{
{
serverMessage = "Failed to executed query analyzer.";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
}
}
}
catch
{
serverMessage = "Failed to executed query analyzer.";
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "jError('" + serverMessage + "');", true);
}
}
private void ExecuteOlapQuery()
{
OlapManager objOlapManager = new OlapManager();
CellSet objCellSet = objOlapManager.GetQueryResult(TextBoxQuery.Text);
AdomdDataAdapter objDataAdaptor = new AdomdDataAdapter(objOlapManager.ObjCommand);
AdomdDataReader objDataReader = objOlapManager.ObjCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataTable objTable = new DataTable();
DataColumn myColumn = new DataColumn();
DataRow myRow = null;
DataTable objSchemaTable = objDataReader.GetSchemaTable();
List <string> lMeta = new List <string>();
// init meta values
for (int i = 0; i < objSchemaTable.Rows.Count; i++)
{
lMeta.Add(objSchemaTable.Rows[i][0].ToString());
}
// add columns and column captions
for (int i = 0; i < objDataReader.FieldCount; i++)
{
myColumn = new DataColumn(lMeta[i]);
objTable.Columns.Add(myColumn);
}
// output the rows in the DataReader
while (objDataReader.Read())
{
// new row
myRow = objTable.NewRow();
// set the row values
for (int i = 0; i < objDataReader.FieldCount; i++)
{
myRow[i] = objDataReader[i];
}
// add row to the table
objTable.Rows.Add(myRow);
}
// close reader
objDataReader.Close();
GridViewData.DataSource = objTable;
GridViewData.DataBind();
// export TEST
//ExportDataTableToExcel(objTable);
objOlapManager.CloseConnection();
// load the main table data
this.ObjMainTable = objTable;
Session.Add("queryData", objMainTable);
}
protected void BindGrid(string ID)
{
DataTable dt = MasterData.GetData();
DataTable dtFilter = dt.Select("HNO='" + ID + "'").CopyToDataTable().DefaultView.ToTable(false, new String[] { "Address", "City", "Price", "Currency", "Description", "Deposit", "AgencyFee", "Link", "Facilities/kitchenware", "Facilities/toilet", "Facilities/living_room", "Facilities/bedroom", "Facilities/bathroom", "Facilities/parking", "Facilities/wheelchair_accessible", "Facilities/smoking_allowed", "Facilities/bed", "Facilities/dishwasher", "Facilities/washing_machine", "Facilities/internet", "Facilities/dryer", "Facilities/ac", "Facilities/wifi", "Facilities/lroom_furniture", "Facilities/desk", "Facilities/tv", "Facilities/closet", "Facilities/balcony" });
DataTable transposedTable = GenerateTransposedTable(dtFilter);
GridViewData.DataSource = transposedTable;
GridViewData.DataBind();
}
private void BindDataByReview(string myUserNo)
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(myUserNo, false);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
private void BindDataByReview()
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfo2(UserNo);//传申报人ID进去，返回对应的填写参赛信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
if (Convert.ToInt16(dt.Rows[0]["IsFirst"]) == 1)
{
this.showMyInfo.Style.Add("display", "block");
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (UploadRHFile.UploadedFiles.Count > 0)
{
string filename = "~/File/" + UploadRHFile.UploadedFiles[0].GetName();
if (UploadRHFile.UploadedFiles[0].GetExtension() == ".xls" || UploadRHFile.UploadedFiles[0].GetExtension() == ".xlsx")
{
if (UploadRHFile.UploadedFiles[0].GetName() != "")
{
string filePath = Server.MapPath(filename);
string ConnectionString = "";
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filePath + ";" +
"Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";
using (OleDbConnection cn = new OleDbConnection(ConnectionString))
{
cn.Close();
cn.Open();
DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dbSchema == null || dbSchema.Rows.Count < 1)
{
throw new Exception("Error: Could not determine the name of the first worksheet.");
}
string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT F1,F2,F3 FROM [" + WorkSheetName + "]", cn);
DataTable dtFromExcel = new DataTable(WorkSheetName);
da.Fill(dtFromExcel);
cn.Close();
GridViewData.DataSource = dtFromExcel;
GridViewData.DataBind();
}
}
else
{
lblMessage.Text = "Please select a file to upload.";
}
}
}
}
catch (Exception ex)
{
lblMessage.Text = "Error occured while uploading: " + ex.Message;
}
}
protected void fetchData()
{
DataTable dt = new DataTable();
var relativeRoute = HttpContext.Current.Server.MapPath(@"\BDcoches.db");
var connstring = "data source=" + relativeRoute;
using (var db = new SQLiteConnection(connstring))
{
db.Open();
SQLiteCommand cmd = new SQLiteCommand("SELECT[ID], [Cuenta], [Clave], [NombreCompleto], [DNI], [Tel], [Email], [Rol] FROM[Usuarios] ", db);
cmd.CommandType = CommandType.Text;
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
da.Fill(dt);
GridViewData.DataSource = dt;
GridViewData.DataBind();
}
}
protected void BindData()
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
try
{
string getFields = "SELECT * FROM tblRegistration";
SqlCommand cmd = new SqlCommand(getFields, connect);
connect.Open();
GridViewData.DataSource = cmd.ExecuteReader();
GridViewData.DataBind();
connect.Close();
}
catch (Exception ex)
{
//Response.Write("ERROR = " + ex.ToString());
}
}
protected void search(object sender, EventArgs e)
{
DataTable dt = new DataTable();
var relativeRoute = HttpContext.Current.Server.MapPath(@"\BDcoches.db");
var connstring = "data source=" + relativeRoute;
using (var db = new SQLiteConnection(connstring))
{
var searchText = searchWord.Value;
var cat = CategorySelectInput.Value;
db.Open();
SQLiteCommand cmd = new SQLiteCommand("SELECT[ID], [Cuenta], [Clave], [NombreCompleto], [DNI], [Tel], [Email], [Rol] FROM[Usuarios] WHERE [" + cat + "] LIKE \'%" + searchText + "%\'", db);
cmd.CommandType = CommandType.Text;
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
da.Fill(dt);
GridViewData.DataSource = dt;
GridViewData.DataBind();
}
}
protected void Btn_Select_Click(object sender, EventArgs e)
{
string sValue = inputtext.Value.ToString().Trim();
if (string.IsNullOrEmpty(sValue))
{
UrlHtmlUtil.ShowMess("请先输入搜索关键字！");
}
else
{
DataTable dt = UrlHtmlUtil.selectEnrolInfoByKeyword(sValue);
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FindTextRecord.AuditStatus = "";
FindTextRecord.District = "0";
FindTextRecord.School = "0";
FindTextRecord.SchoolGroup = "0";
FindTextRecord.Subject = "0";
if (UrlHtmlUtil.GetUserRole().Equals("评审人"))
{
UserNo = UrlHtmlUtil.GetUserNo();
adminRole(false);
BindDataToDropList_District(); //学区
BindDataToDropList_School(); //学校
BindDataToDropList_SchoolGroup(); //学段
BindDataToDropList_Subject(); //学科
BindDataByReview(UserNo);
}
else if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
adminRole(true);
UserNo = UrlHtmlUtil.GetUserNo();
BindDataToDropList_District(); //学区
BindDataToDropList_School(); //学校
BindDataToDropList_SchoolGroup(); //学段
BindDataToDropList_Subject(); //学科
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, true); //传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else
{
UrlHtmlUtil.MsgBox("您不具备评审人权限！");
}
}
}
/*
* Run selected query and populate the data grid
*/
private void ExecuteRelationalQuery(string sQuery)
{
SQLManager manager = new SQLManager(sSelectedDB);
DataTable objTable = new DataTable();
// handle errors
//if (manager.GetQueryResult(sQuery) == null)
//{
// HandleQueryError();
// return;
//}
objTable.Load(manager.GetQueryResult(sQuery));
GridViewData.DataSource = objTable;
GridViewData.DataBind();
manager.CloseConnection();
// store the data table and prepare the mining link
Session.Add("queryData", objTable);
Session.Add("queryTable", ListBoxTables.SelectedItem.ToString());
Session.Add("queryDB", DropDownListDatabases.SelectedItem.ToString());
}
public void ShowIndexGraph()
{
DataTable dailyData = null;
StockManager stockManager = new StockManager();
string fromDate = Master.textboxFromDate.Text;
string selectedindex = Master.ddlIndexList.SelectedValue;
string selectedindexname = Master.ddlIndexList.SelectedValue;
bool bIntraday = false;
try
{
DateTime dateFrom = System.Convert.ToDateTime(fromDate);
if (DateTime.Today.ToShortDateString().Equals(dateFrom.ToShortDateString()))
{
bIntraday = true;
//in case of today we will need to make sure we set time interval to min. If caller did not send interval in mins then we will default to 5min
//dailyData = stockManager.GetStockPriceData(selectedindex, time_interval: "5m", fromDate: fromDate);
//dailyData = stockManager.GetIntraWithPctChange(selectedindex, time_interval: "1min", outputsize: "compact");
dailyData = stockManager.GetStockPriceData(selectedindex, outputsize: "Compact", time_interval: "1m", fromDate: fromDate);
//Master.dropdownGraphList.Items[0].Enabled = true;
//Master.dropdownGraphList.Items[6].Enabled = false;
}
else
{
dailyData = stockManager.GetStockPriceData(selectedindex, fromDate: fromDate);
//Master.dropdownGraphList.Items[0].Enabled = false;
//Master.dropdownGraphList.Items[6].Enabled = true;
}
if (chartAdvGraph.Annotations.Count > 0)
{
chartAdvGraph.Annotations.Clear();
}
ViewState["MAIN_DATA"] = null;
if ((dailyData != null) && (dailyData.Rows.Count > 0))
{
GridViewData.DataSource = dailyData;
GridViewData.DataBind();
ViewState["MAIN_DATA"] = dailyData;
if (bIntraday)
{
chartAdvGraph.ChartAreas[0].AxisX2.LabelStyle.Format = "g";
chartAdvGraph.ChartAreas[1].AxisX2.LabelStyle.Format = "g";
chartAdvGraph.ChartAreas[2].AxisX.LabelStyle.Format = "g";
}
else
{
chartAdvGraph.ChartAreas[0].AxisX2.LabelStyle.Format = "dd-MM-yyyy";
chartAdvGraph.ChartAreas[1].AxisX2.LabelStyle.Format = "dd-MM-yyyy";
chartAdvGraph.ChartAreas[2].AxisX.LabelStyle.Format = "dd-MM-yyyy";
}
if (chartAdvGraph.Series.FindByName("Open") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("Open"));
}
chartAdvGraph.Series.Add("Open");
if (chartAdvGraph.Series.FindByName("High") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("High"));
}
chartAdvGraph.Series.Add("High");
if (chartAdvGraph.Series.FindByName("Low") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("Low"));
}
chartAdvGraph.Series.Add("Low");
if (chartAdvGraph.Series.FindByName("Close") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("Close"));
}
chartAdvGraph.Series.Add("Close");
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("OHLC"));
}
chartAdvGraph.Series.Add("OHLC");
if (chartAdvGraph.Series.FindByName("Volume") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("Volume"));
}
chartAdvGraph.Series.Add("Volume");
chartAdvGraph.Series["Open"].Enabled = false;
chartAdvGraph.Series["Open"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["Open"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["Open"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["Open"].ChartArea = "chartarea2";
chartAdvGraph.Series["Open"].Legend = "legendAdvGraph";
chartAdvGraph.Series["Open"].LegendText = "Open";
chartAdvGraph.Series["High"].Enabled = false;
chartAdvGraph.Series["High"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["High"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["High"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["High"].ChartArea = "chartarea2";
chartAdvGraph.Series["High"].Legend = "legendAdvGraph";
chartAdvGraph.Series["High"].LegendText = "High";
chartAdvGraph.Series["Low"].Enabled = false;
chartAdvGraph.Series["Low"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["Low"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["Low"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["Low"].ChartArea = "chartarea2";
chartAdvGraph.Series["Low"].Legend = "legendAdvGraph";
chartAdvGraph.Series["Low"].LegendText = "Low";
chartAdvGraph.Series["Close"].Enabled = false;
chartAdvGraph.Series["Close"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["Close"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["Close"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["Close"].ChartArea = "chartarea2";
chartAdvGraph.Series["Close"].Legend = "legendAdvGraph";
chartAdvGraph.Series["Close"].LegendText = "Close";
chartAdvGraph.Series["OHLC"].Enabled = true;
chartAdvGraph.Series["OHLC"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["OHLC"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["OHLC"].ChartType = SeriesChartType.Candlestick;
chartAdvGraph.Series["OHLC"].ChartArea = "chartarea2";
chartAdvGraph.Series["OHLC"].Legend = "legendAdvGraph";
chartAdvGraph.Series["OHLC"].LegendText = "Candlestick";
chartAdvGraph.Series["OHLC"].CustomProperties = "PriceDownColor=Blue, ShowOpenClose=Both, PriceUpColor=Red, OpenCloseStyle=Traingle";
chartAdvGraph.Series["Volume"].Enabled = true;
chartAdvGraph.Series["Volume"].XAxisType = AxisType.Primary;
chartAdvGraph.Series["Volume"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["Volume"].ChartType = SeriesChartType.Column;
chartAdvGraph.Series["Volume"].ChartArea = "chartarea3";
chartAdvGraph.Series["Volume"].Legend = "legendAdvGraph";
chartAdvGraph.Series["Volume"].LegendText = "Volume";
if (bIntraday)
{
chartAdvGraph.Series["Open"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["Open"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Open"].YValueMembers = "Open";
chartAdvGraph.Series["Open"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Open"].ToolTip = "Date:#VALX{g}; Open:#VALY";
chartAdvGraph.Series["Open"].PostBackValue = "Open," + selectedindexname + ",#VALX{g},#VALY";
chartAdvGraph.Series["High"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["High"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["High"].YValueMembers = "High";
chartAdvGraph.Series["High"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["High"].ToolTip = "Date:#VALX{g}; High:#VALY";
chartAdvGraph.Series["High"].PostBackValue = "High," + selectedindexname + ",#VALX{g},#VALY";
chartAdvGraph.Series["Low"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["Low"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Low"].YValueMembers = "Low";
chartAdvGraph.Series["Low"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Low"].ToolTip = "Date:#VALX{g}; Low:#VALY";
chartAdvGraph.Series["Low"].PostBackValue = "Low," + selectedindexname + ",#VALX{g},#VALY";
chartAdvGraph.Series["Close"].XValueMember = "TIMESTAMP"; // "latestDay";
chartAdvGraph.Series["Close"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Close"].YValueMembers = "CLOSE"; // "Price";
chartAdvGraph.Series["Close"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Close"].ToolTip = "Date:#VALX{g}; Close:#VALY";
chartAdvGraph.Series["Close"].PostBackValue = "Close," + selectedindexname + ",#VALX{g},#VALY";
chartAdvGraph.Series["OHLC"].XValueMember = "TIMESTAMP"; // "latestDay";
chartAdvGraph.Series["OHLC"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["OHLC"].YValueMembers = "High,Low,Open,Close"; // "High,Low,Open,Price";
chartAdvGraph.Series["OHLC"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["OHLC"].ToolTip = "Date:#VALX{g}; Open:#VALY3; High:#VALY1; Low:#VALY2; Close:#VALY4";
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + selectedindexname + ",#VALX{g},#VALY1,#VALY2,#VALY3,#VALY4";
chartAdvGraph.Series["Volume"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["Volume"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Volume"].YValueMembers = "Volume";
chartAdvGraph.Series["Volume"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Volume"].ToolTip = "Date:#VALX{g}; Volume:#VALY";
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + selectedindexname + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["Open"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["Open"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Open"].YValueMembers = "OPEN";
chartAdvGraph.Series["Open"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Open"].ToolTip = "Date:#VALX; Open:#VALY";
chartAdvGraph.Series["Open"].PostBackValue = "Open," + selectedindexname + ",#VALX,#VALY";
chartAdvGraph.Series["High"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["High"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["High"].YValueMembers = "HIGH";
chartAdvGraph.Series["High"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["High"].ToolTip = "Date:#VALX; High:#VALY";
chartAdvGraph.Series["High"].PostBackValue = "High," + selectedindexname + ",#VALX,#VALY";
chartAdvGraph.Series["Low"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["Low"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Low"].YValueMembers = "LOW";
chartAdvGraph.Series["Low"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Low"].ToolTip = "Date:#VALX; Low:#VALY";
chartAdvGraph.Series["Low"].PostBackValue = "Low," + selectedindexname + ",#VALX,#VALY";
chartAdvGraph.Series["Close"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["Close"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Close"].YValueMembers = "CLOSE";
chartAdvGraph.Series["Close"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Close"].ToolTip = "Date:#VALX; Close:#VALY";
chartAdvGraph.Series["Close"].PostBackValue = "Close," + selectedindexname + ",#VALX,#VALY";
chartAdvGraph.Series["OHLC"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["OHLC"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["OHLC"].YValueMembers = "HIGH,LOW,OPEN,CLOSE";
chartAdvGraph.Series["OHLC"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["OHLC"].ToolTip = "Date:#VALX; Open:#VALY3; High:#VALY1; Low:#VALY2; Close:#VALY4";
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + selectedindexname + ",#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
chartAdvGraph.Series["Volume"].XValueMember = "TIMESTAMP";
chartAdvGraph.Series["Volume"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Volume"].YValueMembers = "VOLUME";
chartAdvGraph.Series["Volume"].YValueType = ChartValueType.Double;
chartAdvGraph.Series["Volume"].ToolTip = "Date:#VALX; Volume:#VALY";
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + selectedindexname + ",#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("PctChange") != null)
{
chartAdvGraph.Series.Remove(chartAdvGraph.Series.FindByName("PctChange"));
}
//chartAdvGraph.ChartAreas[0].Visible = false;
chartAdvGraph.ChartAreas[0].Visible = true;
chartAdvGraph.Series.Add("PctChange");
if (bIntraday)
{
//chartAdvGraph.ChartAreas[0].Visible = true;
//chartAdvGraph.Series.Add("PctChange");
chartAdvGraph.Series["PctChange"].Enabled = true;
chartAdvGraph.Series["PctChange"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["PctChange"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["PctChange"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["PctChange"].ChartArea = "chartarea1";
chartAdvGraph.Series["PctChange"].Legend = "legendAdvGraph";
chartAdvGraph.Series["PctChange"].LegendText = "Change";
chartAdvGraph.Series.FindByName("PctChange").Enabled = true;
chartAdvGraph.Series["PctChange"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["PctChange"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["PctChange"].YValuesPerPoint = 3;
chartAdvGraph.Series["PctChange"].YValueMembers = "CHANGE_PCT,CHANGE,PREV_CLOSE"; // "changePercent";
chartAdvGraph.Series["PctChange"].YValueType = ChartValueType.Auto;
chartAdvGraph.Series["PctChange"].ToolTip = "Date:#VALX{g}; Prev Close:#VALY3, Change%:#VALY1, Change:#VALY2";
chartAdvGraph.Series["PctChange"].PostBackValue = "PctChange," + selectedindexname + ",#VALX{g},#VALY1,#VALY2,#VALY3";
chartAdvGraph.Series["Volume"].Enabled = false;
chartAdvGraph.ChartAreas[2].Visible = false;
}
else
{
chartAdvGraph.Series["PctChange"].Enabled = true;
chartAdvGraph.Series["PctChange"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["PctChange"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["PctChange"].ChartType = SeriesChartType.Line;
chartAdvGraph.Series["PctChange"].ChartArea = "chartarea1";
chartAdvGraph.Series["PctChange"].Legend = "legendAdvGraph";
chartAdvGraph.Series["PctChange"].LegendText = "Change";
chartAdvGraph.Series.FindByName("PctChange").Enabled = true;
chartAdvGraph.Series["PctChange"].XValueMember = "TIMESTAMP";// "latestDay";
chartAdvGraph.Series["PctChange"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["PctChange"].YValuesPerPoint = 3;
chartAdvGraph.Series["PctChange"].YValueMembers = "CHANGE_PCT,CHANGE,PREV_CLOSE"; // "changePercent";
chartAdvGraph.Series["PctChange"].YValueType = ChartValueType.Auto;
chartAdvGraph.Series["PctChange"].ToolTip = "Date:#VALX; Prev Close:#VALY3, Change%:#VALY1, Change:#VALY2";
chartAdvGraph.Series["PctChange"].PostBackValue = "PctChange," + selectedindexname + ",#VALX,#VALY1,#VALY2,#VALY3";
chartAdvGraph.Series["Volume"].Enabled = true;
chartAdvGraph.ChartAreas[2].Visible = true;
}
chartAdvGraph.DataSource = dailyData;
chartAdvGraph.DataBind();
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('" + ex.Message + "');", true);
}
}
protected void GridViewData_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewData.PageIndex = e.NewPageIndex;
GridViewData.DataSource = (DataTable)ViewState["MAIN_DATA"];
GridViewData.DataBind();
}
public void ShowGraph()
{
DataTable scriptData = null, valuationTable = null, sensexTable = null, niftyTable = null;
int portfolioTxnNumber = 1;
Series tempSeries = null;
string symbol = Request.QueryString["symbol"].ToString() + "." + Request.QueryString["exchange"].ToString();
try
{
FillData();
scriptData = (DataTable)ViewState["FetchedData"];
valuationTable = (DataTable)ViewState["VALUATION_TABLE"];
sensexTable = (DataTable)ViewState["SENSEX"];
niftyTable = (DataTable)ViewState["NIFTY50"];
GridViewData.DataSource = (DataTable)ViewState["FetchedData"];
GridViewData.DataBind();
if (scriptData != null)
{
chartAdvGraph.DataSource = scriptData;
chartAdvGraph.DataBind();
//The following example takes input from Series1's Y values for the daily high, low, and close prices (Series1:Y,Series1:Y2,Series1:Y4),
//and outputs %K on Series3 (Series3:Y) and %D on Series4 (Series4:Y). It uses a period of 15 days to calculate both %K and %D.
//Chart1.DataManipulator.FinancialFormula(FinancialFormula.StochasticIndicator, "15,15", "Series1:Y,Series1:Y2,Series1:Y4", "Series3:Y,Series4:Y")
chartAdvGraph.DataManipulator.FinancialFormula(FinancialFormula.StochasticIndicator,
textboxSTOCH_Fastkperiod.Text + "," + textboxSTOCH_Slowdperiod.Text, "OHLC:Y,OHLC:Y2,OHLC:Y4", "K-FastLine:Y,D-SlowLine:Y");
chartAdvGraph.DataManipulator.FinancialFormula(FinancialFormula.RelativeStrengthIndex,
textboxSTOCH_Fastkperiod.Text + "," + textboxPeriod.Text, "OHLC:Y4", "RSI:Y");
int pointstomove = Int32.Parse(textboxSTOCH_Fastkperiod.Text) + Int32.Parse(textboxSTOCH_Slowdperiod.Text) - 2;
AdjustSeriesPoints(pointstomove, chartAdvGraph);
chartAdvGraph.Series["RSI"].Points.RemoveAt(0);
if (chartAdvGraph.Series.FindByName("Open") != null)
{
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("High") != null)
{
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Low") != null)
{
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Close") != null)
{
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + "," + "#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
//if (chartAdvGraph.Series.FindByName("Volume") != null)
//{
// chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + symbol + "," + "#VALX,#VALY";
//}
if (chartAdvGraph.Series.FindByName("K-FastLine") != null)
{
chartAdvGraph.Series["K-FastLine"].PostBackValue = "K-FastLine:" + textboxSTOCH_Fastkperiod.Text + "," + symbol + "," + "#VALX,#VALY{0.##}";
}
if (chartAdvGraph.Series.FindByName("D-SlowLine") != null)
{
chartAdvGraph.Series["D-SlowLine"].PostBackValue = "D-SlowLine:" + textboxSTOCH_Slowdperiod.Text + "," + symbol + "," + "#VALX,#VALY{0.##}";
}
if (chartAdvGraph.Series.FindByName("RSI") != null)
{
chartAdvGraph.Series["RSI"].PostBackValue = "RSI:" + textboxPeriod.Text + "," + symbol + "," + "#VALX,#VALY{0.##}";
}
}
if ((valuationTable != null) && (valuationTable.Rows.Count > 0))
{
if (chartAdvGraph.Series.FindByName(symbol) == null)
{
chartAdvGraph.Series.Add(symbol);
chartAdvGraph.Series[symbol].Name = symbol;
(chartAdvGraph.Series[symbol]).ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Line;
(chartAdvGraph.Series[symbol]).ChartArea = chartAdvGraph.ChartAreas[0].Name;
chartAdvGraph.Series[symbol].Legend = chartAdvGraph.Legends[0].Name;
(chartAdvGraph.Series[symbol]).XAxisType = AxisType.Secondary;
(chartAdvGraph.Series[symbol]).YAxisType = AxisType.Primary;
(chartAdvGraph.Series[symbol]).XValueMember = "TIMESTAMP";
(chartAdvGraph.Series[symbol]).XValueType = ChartValueType.Date;
(chartAdvGraph.Series[symbol]).YValueMembers = "CLOSE";
(chartAdvGraph.Series[symbol]).YValueType = ChartValueType.Double;
chartAdvGraph.Series[symbol].LegendText = symbol;
chartAdvGraph.Series[symbol].LegendToolTip = symbol;
chartAdvGraph.Series[symbol].ToolTip = symbol + ": Date:#VALX; CLOSE:#VALY (Click to see details)";
chartAdvGraph.Series[symbol].PostBackValue = symbol + "," + "#VALX,#VALY";
}
(chartAdvGraph.Series[symbol]).Points.Clear();
for (int rownum = 0; rownum < valuationTable.Rows.Count; rownum++)
{
//(chartAdvGraph.Series[schemeCode]).Points.AddXY(valuationTable.Rows[rownum]["PurchaseDate"], valuationTable.Rows[rownum]["PurchaseNAV"]);
(chartAdvGraph.Series[symbol]).Points.AddXY(valuationTable.Rows[rownum]["TIMESTAMP"], valuationTable.Rows[rownum]["CLOSE"]);
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].PostBackValue =
"Portfolio," +
valuationTable.Rows[rownum]["SYMBOL"] + "," + valuationTable.Rows[rownum]["TIMESTAMP"] + "," +
valuationTable.Rows[rownum]["CLOSE"] + "," +
valuationTable.Rows[rownum]["PURCHASE_DATE"] + "," + valuationTable.Rows[rownum]["PURCHASE_PRICE"] + "," +
valuationTable.Rows[rownum]["PURCHASE_QTY"] + "," +
valuationTable.Rows[rownum]["INVESTMENT_COST"] + "," + valuationTable.Rows[rownum]["CumulativeQty"] + "," +
valuationTable.Rows[rownum]["CumulativeCost"] + "," + valuationTable.Rows[rownum]["CumulativeValue"];
//if (valuationTable.Rows[rownum]["PURCHASE_DATE"].ToString().Equals(valuationTable.Rows[rownum]["TIMESTAMP"].ToString())) // || ((rownum + 1) == valuationTable.Rows.Count))
if ((valuationTable.Rows[rownum]["PORTFOLIO_FLAG"].Equals("True")) || ((rownum + 1) == valuationTable.Rows.Count))
{
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerSize = 11;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerStyle = System.Web.UI.DataVisualization.Charting.MarkerStyle.Diamond;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerColor = Color.Black;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].ToolTip = "Transaction: " + portfolioTxnNumber++;
}
}
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerSize = 10;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerStyle = System.Web.UI.DataVisualization.Charting.MarkerStyle.Diamond;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].MarkerColor = Color.Black;
(chartAdvGraph.Series[symbol]).Points[(chartAdvGraph.Series[symbol]).Points.Count - 1].ToolTip = "Click to see latest valuation";
}
else
{
tempSeries = chartAdvGraph.Series.FindByName(symbol);
if (tempSeries != null)
{
chartAdvGraph.Series.Remove(tempSeries);
}
}
if ((sensexTable != null) && (sensexTable.Rows.Count > 0))
{
if (chartAdvGraph.Series.FindByName("^BSESN") == null)
{
chartAdvGraph.Series.Add("^BSESN");
chartAdvGraph.Series["^BSESN"].Name = "^BSESN";
(chartAdvGraph.Series["^BSESN"]).ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Line;
(chartAdvGraph.Series["^BSESN"]).ChartArea = chartAdvGraph.ChartAreas[0].Name;
chartAdvGraph.Series["^BSESN"].Legend = chartAdvGraph.Legends[0].Name;
chartAdvGraph.Series["^BSESN"].LegendText = "BSE SENSEX";
chartAdvGraph.Series["^BSESN"].LegendToolTip = "BSE SENSEX";
(chartAdvGraph.Series["^BSESN"]).YValuesPerPoint = 4;
chartAdvGraph.Series["^BSESN"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["^BSESN"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["^BSESN"].ToolTip = "^BSESN" + ": Date:#VALX; Close:#VALY1 (Click to see details)";
chartAdvGraph.Series["^BSESN"].PostBackValue = "^BSESN," + "SENSEX" + ",#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
chartAdvGraph.Series["^BSESN"].Points.Clear();
(chartAdvGraph.Series["^BSESN"]).Points.DataBindXY(sensexTable.Rows, "TIMESTAMP", sensexTable.Rows, "CLOSE,OPEN,HIGH,LOW");
}
else
{
tempSeries = chartAdvGraph.Series.FindByName("^BSESN");
if (tempSeries != null)
{
chartAdvGraph.Series.Remove(tempSeries);
}
}
if ((niftyTable != null) && (niftyTable.Rows.Count > 0))
{
if (chartAdvGraph.Series.FindByName("^NSEI") == null)
{
chartAdvGraph.Series.Add("^NSEI");
chartAdvGraph.Series["^NSEI"].Name = "^NSEI";
(chartAdvGraph.Series["^NSEI"]).ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Line;
(chartAdvGraph.Series["^NSEI"]).ChartArea = chartAdvGraph.ChartAreas[0].Name;
chartAdvGraph.Series["^NSEI"].Legend = chartAdvGraph.Legends[0].Name;
chartAdvGraph.Series["^NSEI"].LegendText = "NIFTY 50";
chartAdvGraph.Series["^NSEI"].LegendToolTip = "NIFTY 50";
(chartAdvGraph.Series["^NSEI"]).YValuesPerPoint = 4;
chartAdvGraph.Series["^NSEI"].XAxisType = AxisType.Secondary;
chartAdvGraph.Series["^NSEI"].YAxisType = AxisType.Primary;
chartAdvGraph.Series["^NSEI"].ToolTip = "^NSEI" + ": Date:#VALX; Close:#VALY1 (Click to see details)";
chartAdvGraph.Series["^NSEI"].PostBackValue = "^NSEI," + "NIFTY50" + ",#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
(chartAdvGraph.Series["^NSEI"]).Points.Clear();
(chartAdvGraph.Series["^NSEI"]).Points.DataBindXY(niftyTable.Rows, "TIMESTAMP", niftyTable.Rows, "CLOSE,OPEN,HIGH,LOW");
}
else
{
tempSeries = chartAdvGraph.Series.FindByName("^NSEI");
if (tempSeries != null)
{
chartAdvGraph.Series.Remove(tempSeries);
}
}
foreach (ListItem item in Master.checkboxlistLines.Items)
{
if (chartAdvGraph.Series.FindByName(item.Value) != null)
{
chartAdvGraph.Series[item.Value].Enabled = item.Selected;
if (item.Selected == false)
{
if (chartAdvGraph.Annotations.FindByName(item.Value) != null)
{
chartAdvGraph.Annotations.Clear();
}
}
}
}
}
catch (Exception ex)
{
//Response.Write("<script language=javascript>alert('Exception while generating graph: " + ex.Message + "')</script>");
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('Exception while generating graph:" + ex.Message + "');", true);
}
}
private void refresh()
{
GridViewData.DataSource = da.GetDataSet(qr, "ConnDB230");
GridViewData.DataBind();
}
private bool DropListFillData(DropDownList dp)
{
string sText = dp.Text;
string sName = dp.ID.ToString().Trim();
if ("DropList_District".Equals(sName))//学区
{
FindTextRecord.District = sText;
}
else if ("DropList_School".Equals(sName))//学校
{
FindTextRecord.School = sText;
}
else if ("DropList_SchoolGroup".Equals(sName))//学段
{
FindTextRecord.SchoolGroup = sText;
}
else if ("DropList_Subject".Equals(sName))//学科
{
FindTextRecord.Subject = sText;
}
else if ("DropList_AuditStatus".Equals(sName))//评审状态
{
if (sText.Equals("全部"))
{
sText = "";
}
FindTextRecord.AuditStatus = sText;
}
else
{
UrlHtmlUtil.ShowMess("请添加该控件的事件绑定！");
return(false);
}
if (UrlHtmlUtil.GetUserRole().Equals("评审人"))
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, false, FindTextRecord);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, true, FindTextRecord);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else
{
UrlHtmlUtil.ShowMess("您不具备该权限！");
}
return(true);
}
public void ShowDaily()
{
DataTable dailyData = null;
StockManager stockManager = new StockManager();
string fromDate = Master.textboxFromDate.Text;
string symbol = Master.textbox_SelectedSymbol.Text;
string exchange = Master.textbox_SelectedExchange.Text;
string seriestype = Master.dropdownSeries.SelectedValue;
string outputsize = Master.dropdownOutputSize.SelectedValue;
string interval = Master.dropdownInterval.SelectedValue;
string period = Master.textboxDMIDX_Period.Text;
try
{
dailyData = stockManager.getADX_DX_DM_DI_DataTableFromDaily(symbol, exchange, seriestype, outputsize, time_interval: interval,
fromDate: fromDate, period: period.ToString());
if (chartAdvGraph.Annotations.Count > 0)
{
chartAdvGraph.Annotations.Clear();
}
ViewState["MAIN_DATA"] = null;
if ((dailyData != null) && (dailyData.Rows.Count > 0))
{
GridViewData.DataSource = dailyData;
GridViewData.DataBind();
ViewState["MAIN_DATA"] = dailyData;
chartAdvGraph.DataSource = dailyData;
chartAdvGraph.DataBind();
if (chartAdvGraph.Series.FindByName("Open") != null)
{
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("High") != null)
{
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Low") != null)
{
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Close") != null)
{
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series.FindByName("OHLC").Enabled = true;
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + "," + "#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('" + ex.Message + "');", true);
}
}
public void ShowDaily()
{
DataTable dailyData = null;
StockManager stockManager = new StockManager();
string fromDate = Master.textboxFromDate.Text;
string symbol = Master.textbox_SelectedSymbol.Text;
string exchange = Master.textbox_SelectedExchange.Text;
string outputsize = Master.dropdownOutputSize.SelectedValue;
string interval = Master.dropdownInterval.SelectedValue;
try
{
dailyData = stockManager.getVWAPDataTableFromDaily(symbol, exchange, outputsize: outputsize, time_interval: interval,
fromDate: fromDate);
if (chartAdvGraph.Annotations.Count > 0)
{
chartAdvGraph.Annotations.Clear();
}
ViewState["MAIN_DATA"] = null;
if ((dailyData != null) && (dailyData.Rows.Count > 0))
{
dailyData.Rows.RemoveAt(0);
dailyData.Rows.RemoveAt(dailyData.Rows.Count - 1);
GridViewData.DataSource = dailyData;
GridViewData.DataBind();
ViewState["MAIN_DATA"] = dailyData;
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.ChartAreas[0].AxisX2.LabelStyle.Format = "g";
chartAdvGraph.ChartAreas[1].AxisX.LabelStyle.Format = "g";
}
else
{
chartAdvGraph.ChartAreas[0].AxisX2.LabelStyle.Format = "dd-MM-yyyy";
chartAdvGraph.ChartAreas[1].AxisX.LabelStyle.Format = "dd-MM-yyyy";
}
chartAdvGraph.DataSource = dailyData;
chartAdvGraph.DataBind();
if (chartAdvGraph.Series.FindByName("Open") != null)
{
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["Open"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Open"].ToolTip = "Date:#VALX{g}; Open:#VALY";
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["Open"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Open"].ToolTip = "Date:#VALX; Open:#VALY";
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + ",#VALX,#VALY";
}
}
if (chartAdvGraph.Series.FindByName("High") != null)
{
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["High"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["High"].ToolTip = "Date:#VALX{g}; High:#VALY";
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["High"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["High"].ToolTip = "Date:#VALX; High:#VALY";
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + ",#VALX,#VALY";
}
}
if (chartAdvGraph.Series.FindByName("Low") != null)
{
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["Low"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Low"].ToolTip = "Date:#VALX{g}; Low:#VALY";
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["Low"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Low"].ToolTip = "Date:#VALX; High:#VALY";
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + ",#VALX,#VALY";
}
}
if (chartAdvGraph.Series.FindByName("Close") != null)
{
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["Close"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Close"].ToolTip = "Date:#VALX{g}; Close:#VALY";
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["Close"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Close"].ToolTip = "Date:#VALX; Close:#VALY";
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + ",#VALX,#VALY";
}
}
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series.FindByName("OHLC").Enabled = true;
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["OHLC"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["OHLC"].ToolTip = "Date:#VALX{g}; OHLC:#VALY";
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + ",#VALX{g},#VALY1,#VALY2,#VALY3,#VALY4";
}
else
{
chartAdvGraph.Series["OHLC"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["OHLC"].ToolTip = "Date:#VALX; OHLC:#VALY";
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + ",#VALX,#VALY";
}
}
if (chartAdvGraph.Series.FindByName("Volume") != null)
{
chartAdvGraph.Series.FindByName("Volume").Enabled = true;
if (Master.dropdownInterval.SelectedValue.Contains("m"))
{
chartAdvGraph.Series["Volume"].XValueType = ChartValueType.DateTime;
chartAdvGraph.Series["Volume"].ToolTip = "Date:#VALX{g}; Volume:#VALY";
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + symbol + ",#VALX{g},#VALY";
}
else
{
chartAdvGraph.Series["Volume"].XValueType = ChartValueType.Date;
chartAdvGraph.Series["Volume"].ToolTip = "Date:#VALX; Volume:#VALY";
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + symbol + ",#VALX,#VALY";
}
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('" + ex.Message + "');", true);
}
}
public void ShowDaily()
{
DataTable dailyData = null;
StockManager stockManager = new StockManager();
string fromDate = Master.textboxFromDate.Text;
string symbol = Master.textbox_SelectedSymbol.Text;
string exchange = Master.textbox_SelectedExchange.Text;
string outputsize = Master.dropdownOutputSize.SelectedValue;
try
{
dailyData = stockManager.GetStockPriceData(symbol, exchange, outputsize: outputsize, fromDate: fromDate);
if (chartAdvGraph.Annotations.Count > 0)
{
chartAdvGraph.Annotations.Clear();
}
ViewState["MAIN_DATA"] = null;
if ((dailyData != null) && (dailyData.Rows.Count > 0))
{
GridViewData.DataSource = dailyData;
GridViewData.DataBind();
ViewState["MAIN_DATA"] = dailyData;
chartAdvGraph.DataSource = dailyData;
chartAdvGraph.DataBind();
if (chartAdvGraph.Series.FindByName("Open") != null)
{
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("High") != null)
{
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Low") != null)
{
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Close") != null)
{
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series.FindByName("OHLC").Enabled = true;
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + "," + "#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
if (chartAdvGraph.Series.FindByName("Volume") != null)
{
chartAdvGraph.Series.FindByName("Volume").Enabled = true;
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("PctChange") != null)
{
chartAdvGraph.Series.FindByName("PctChange").Enabled = true;
chartAdvGraph.Series["PctChange"].ToolTip = "Date:#VALX; Prev Close:#VALY3; Change%:#VALY1; Change:#VALY2";
chartAdvGraph.Series["PctChange"].PostBackValue = "PctChange," + symbol + ",#VALX,#VALY1,#VALY2,#VALY3";
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('" + ex.Message + "');", true);
}
}
public void ShowDaily()
{
DataTable dailyData = null;
StockManager stockManager = new StockManager();
string fromDate = Master.textboxFromDate.Text;
string symbol = Master.textbox_SelectedSymbol.Text;
string exchange = Master.textbox_SelectedExchange.Text;
string seriestype = Master.dropdownSeries.SelectedValue;
string outputsize = Master.dropdownOutputSize.SelectedValue;
string interval = Master.dropdownInterval.SelectedValue;
int fastperiod = Int32.Parse(Master.textboxMACDEMADaily_fastperiod.Text);
int slowperiod = Int32.Parse(Master.textboxMACDEMADaily_slowperiod.Text);
int signalperiod = Int32.Parse(Master.textboxMACDEMADaily_signalperiod.Text);
try
{
dailyData = stockManager.GetSMA_EMA_MACD_BBANDS_Table(symbol, exchange, seriestype, outputsize, time_interval: interval,
fromDate: fromDate,
small_fast_Period: fastperiod, long_slow_Period: slowperiod, emaRequired: true, macdRequired: true, signalperiod: signalperiod);
if (chartAdvGraph.Annotations.Count > 0)
{
chartAdvGraph.Annotations.Clear();
}
ViewState["MAIN_DATA"] = null;
if ((dailyData != null) && (dailyData.Rows.Count > 0))
{
GridViewData.DataSource = dailyData;
GridViewData.DataBind();
ViewState["MAIN_DATA"] = dailyData;
chartAdvGraph.DataSource = dailyData;
chartAdvGraph.DataBind();
if (chartAdvGraph.Series.FindByName("Open") != null)
{
chartAdvGraph.Series["Open"].PostBackValue = "Open," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("High") != null)
{
chartAdvGraph.Series["High"].PostBackValue = "High," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Low") != null)
{
chartAdvGraph.Series["Low"].PostBackValue = "Low," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("Close") != null)
{
chartAdvGraph.Series["Close"].PostBackValue = "Close," + symbol + "," + "#VALX,#VALY";
}
if (chartAdvGraph.Series.FindByName("OHLC") != null)
{
chartAdvGraph.Series.FindByName("OHLC").Enabled = true;
chartAdvGraph.Series["OHLC"].PostBackValue = "OHLC," + symbol + "," + "#VALX,#VALY1,#VALY2,#VALY3,#VALY4";
}
if (chartAdvGraph.Series.FindByName("Volume") != null)
{
chartAdvGraph.Series.FindByName("Volume").Enabled = true;
chartAdvGraph.Series["Volume"].PostBackValue = "Volume," + symbol + "," + "#VALX,#VALY";
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(GetType(), "myScript", "alert('" + ex.Message + "');", true);
}
}