public void get_grids_local(PlaceHolder PlaceHolder1)
{
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
for (int i = 0; i < cp; i++)
{
paramArray[i] = new SqlParameter(parameters[i], values[i]);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("nipm_dump_viewer", paramArray, "dataset") as DataSet;
//int[] StaticGridViews = new int[5];
//StaticGridViews[0] = 0;
//StaticGridViews[1] = 1;
//StaticGridViews[2] = 2;
//StaticGridViews[3] = 3;
//StaticGridViews[4] = 4;
control_utils gu = new control_utils();
MasterPage MasterPage1 = Page.Master;
gu.get_grids(ds, PlaceHolder1, null, MasterPage1, false);
}
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
lMenuPath.Text = e.Item.ValuePath;
//cmdStr = "empty";
bool made = false;
//cmdStr = "EXEC exports_control_panel ";
//Ratings
if (e.Item.ValuePath == "Ratings/Look")
{
made = true; //cmdStr += "@IO=1,@SubIO=1,@ServerID=" + Session["ServerID"] + ",@DatabaseID=" + Session["DatabaseID"] + ",@ListOfRatings='" + tbListOfRatings.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "1");
paramArray[cp++] = new SqlParameter("@SubIO", "1");
//paramArray[cp++] = new SqlParameter("@ServerID",Session["ServerID"]);
//paramArray[cp++] = new SqlParameter("@ServerID",Session["DatabaseID"]);
paramArray[cp++] = new SqlParameter("@ListOfRatings", tbListOfRatings.Text);
}
//Servers.ServerID.Text
//DWS
if (e.Item.ValuePath == "DWS/Ratings/Look Exported")
{
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "1");
paramArray[cp++] = new SqlParameter("@ListOfRatings", tbListOfRatings.Text);
}
if (e.Item.ValuePath == "DWS/Ratings/Add as Excluded")
{
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "2");
paramArray[cp++] = new SqlParameter("@ListOfRatings", tbListOfRatings.Text);
}
if (e.Item.ValuePath == "DWS/Ratings/Registaration Delete")
{
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "3");
paramArray[cp++] = new SqlParameter("@ListOfRatings", tbListOfRatings.Text);
}
//if (cp>0) get_grids(cmdStr, SUPPORT_SupportDB);
if (cp > 0)
{
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("exports_control_panel", paramArray, "DataSet") as DataSet;
control_utils gu = new control_utils();
//MasterPage MasterPage1 = Page.Master; //придержать
gu.get_grids(ds, PlaceHolder1, null, Page.Master, false);
}
}
public void getGrids(bool OneLine)
{
if (cp > 0)
{
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("InstDB_manual_dividends", paramArray, "DataSet") as DataSet;
control_utils gu = new control_utils();
//MasterPage MasterPage1 = Page.Master; //придержать
//gu.get_grids(ds, PlaceHolder1, null, Page.Master);
gu.get_grids(ds, PlaceHolder1, OneLine);
}
}
public void get_OldGrids()
{
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
for (int i = 0; i < cp; i++)
{
paramArray[i] = new SqlParameter(parameters[i], values[i]);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("nipm_load_ratings_ftp_feed_1_2", paramArray, "DataSet") as DataSet;
//int[] StaticGridViews = new int[5];
//StaticGridViews[0] = 0;
//StaticGridViews[1] = 1;
//StaticGridViews[2] = 2;
//StaticGridViews[3] = 3;
//StaticGridViews[4] = 4;
control_utils gu = new control_utils();
gu.get_grids(ds, PlaceHolder1, null, Page.Master, false);
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
if (sender.Equals(LinkButton1))
{
parameters[cp] = "@IO"; values[cp++] = "1";
if (TaskID != "")
{
parameters[cp] = "@TaskID"; values[cp++] = TaskID;
}
else
if (tbTaskID.Text != "")
{
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
}
}
if (sender.Equals(LinkButton2))
{
parameters[cp] = "@IO"; values[cp++] = "2";
if (GroupID != "")
{
parameters[cp] = "@GroupID"; values[cp++] = GroupID;
}
else
if (tbGroupID.Text != "")
{
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
}
}
if (sender.Equals(LinkButton3))
{
parameters[cp] = "@IO"; values[cp++] = "3";
if (AddressID != "")
{
parameters[cp] = "@AddressID"; values[cp++] = AddressID;
}
else
if (tbAddressID.Text != "")
{
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
}
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
for (int i = 0; i < cp; i++)
{
paramArray[i] = new SqlParameter(parameters[i], values[i]);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("admin_emails", paramArray, "DataSet") as DataSet;
int[] StaticGridViews = new int[5];
StaticGridViews[0] = 0;
StaticGridViews[1] = 1;
StaticGridViews[2] = 2;
StaticGridViews[3] = 3;
StaticGridViews[4] = 4;
control_utils gu = new control_utils();
MasterPage MasterPage1 = Page.Master;
gu.get_grids(ds, PlaceHolder1, StaticGridViews, MasterPage1, false);
}
TaskID = ""; GroupID = ""; AddressID = "";
}
protected void Menu1_MenuItemClick1(object sender, MenuEventArgs e)
{
lMenuPath.Text = e.Item.ValuePath;
//Tasks
if (e.Item.ValuePath == "Tasks|All")
{
parameters[cp] = "@IO"; values[cp++] = "1";
}
if (e.Item.ValuePath == "Tasks|Find")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "0";
if (tbFieldContent1.Text != "")
{
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
if (tbFieldContent2.Text != "")
{
parameters[cp] = "@FieldContent2"; values[cp++] = tbFieldContent2.Text;
}
tbFieldContent1.Text = "";
}
if (e.Item.ValuePath == "Tasks|New One")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "1";
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
tbFieldContent1.Text = "";
}
if (e.Item.ValuePath == "Tasks|Disable")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "4";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
}
if (e.Item.ValuePath == "Tasks|Enable")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "5";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
}
if ((e.Item.ValuePath == "Tasks|Bind With Groups")
||
(e.Item.ValuePath == "Tasks|With Groups|Bind"))
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "8";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
}
if (e.Item.ValuePath == "Tasks|With Groups|UnBind ALL")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "14";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
}
if (e.Item.ValuePath == "Tasks|With Addresses|Exclude")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "12";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Tasks|With Addresses|Include")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "13";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Tasks|Update|Description")
{
parameters[cp] = "@IO"; values[cp++] = "1";
parameters[cp] = "@SubIO"; values[cp++] = "2";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
//Groups
if (e.Item.ValuePath == "Groups|All")
{
cmdStr += "@IO=2";
}
if ((e.Item.ValuePath == "Groups|Bind With Tasks")
||
(e.Item.ValuePath == "Groups|With Tasks|Bind"))
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "8";
parameters[cp] = "@ListOfTaskID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
}
if (e.Item.ValuePath == "Groups|Disable")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "4";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
}
if (e.Item.ValuePath == "Groups|Enable")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "5";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
}
if ((e.Item.ValuePath == "Groups|Bind With Addresses")
||
(e.Item.ValuePath == "Groups|With Addresses|Bind"))
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "9";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Groups|With Addresses|Enable")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "233";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Groups|With Addresses|Disable")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "234";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Groups|Find")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "0";
if (tbFieldContent1.Text != "")
{
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
if (tbFieldContent2.Text != "")
{
parameters[cp] = "@FieldContent2"; values[cp++] = tbFieldContent2.Text;
}
tbFieldContent1.Text = "";
}
if (e.Item.ValuePath == "Groups|New One")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "1";
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
tbFieldContent1.Text = "";
}
if (e.Item.ValuePath == "Groups|Update|Description")
{
parameters[cp] = "@IO"; values[cp++] = "2";
parameters[cp] = "@SubIO"; values[cp++] = "2";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbTaskID.Text;
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
//Addresses
if (e.Item.ValuePath == "Addresses|Addresses|All")
{
cmdStr += "@IO=3";
}
if (e.Item.ValuePath == "Addresses|Find")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "0";
if (tbFieldContent1.Text != "")
{
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
if (tbFieldContent2.Text != "")
{
parameters[cp] = "@FieldContent2"; values[cp++] = tbFieldContent2.Text;
}
tbFieldContent1.Text = ""; tbFieldContent2.Text = "";
}
if (e.Item.ValuePath == "Addresses|New One")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "1";
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
parameters[cp] = "@FieldContent2"; values[cp++] = tbFieldContent2.Text;
tbFieldContent1.Text = "";
tbFieldContent2.Text = "";
}
if (e.Item.ValuePath == "Addresses|Update|ContactPerson")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "2";
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
parameters[cp] = "@FieldContent1"; values[cp++] = tbFieldContent1.Text;
}
if (e.Item.ValuePath == "Addresses|Update|Address")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "2";
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
parameters[cp] = "@FieldContent2"; values[cp++] = tbFieldContent2.Text;
}
if (e.Item.ValuePath == "Addresses|Disable")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "4";
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Addresses|Enable")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "5";
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Addresses|InActive From")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "6";
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (e.Item.ValuePath == "Addresses|InActive To")
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "7";
parameters[cp] = "@Date"; values[cp++] = tbDate.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if ((e.Item.ValuePath == "Addresses|Bind With Groups")
||
(e.Item.ValuePath == "Addresses|With Groups|Bind"))
{
parameters[cp] = "@IO"; values[cp++] = "3";
parameters[cp] = "@SubIO"; values[cp++] = "8";
parameters[cp] = "@ListOfGroupID"; values[cp++] = tbGroupID.Text;
parameters[cp] = "@ListOfAddressID"; values[cp++] = tbAddressID.Text;
}
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
for (int i = 0; i < cp; i++)
{
paramArray[i] = new SqlParameter(parameters[i], values[i]);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("admin_emails", paramArray, "DataSet") as DataSet;
int[] StaticGridViews = new int[5];
StaticGridViews[0] = 0;
StaticGridViews[1] = 1;
StaticGridViews[2] = 2;
StaticGridViews[3] = 3;
StaticGridViews[4] = 4;
control_utils gu = new control_utils();
gu.get_grids(ds, PlaceHolder1, StaticGridViews, Page.Master, false);
}
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
lMenuPath.Text = e.Item.ValuePath;
//Ratings
//cmdStr = e.Item.ValuePath.IndexOf("Ratings/Processed").ToString();
//cmdStr = e.Item.ValuePath.IndexOf("f").ToString();
//cmdStr = "EXEC ipm_load_ratings_control_panel";
//Find
if (e.Item.ValuePath == "Find/by Symbol")
{
//made = true; cmdStr += "@IO=1,@SubIO=1,@FieldContent='" + tbFieldContent.Text + "',@SiteID='" + tbSiteID.Text + "',@AnalystID='" + tbAnalystID.Text + "',@TeamID='" + tbTeamID.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "1");
paramArray[cp++] = new SqlParameter("@SubIO", "1");
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
paramArray[cp++] = new SqlParameter("@SiteID", tbSiteID.Text);
paramArray[cp++] = new SqlParameter("@AnalystID", tbAnalystID.Text);
paramArray[cp++] = new SqlParameter("@TeamID", tbTeamID.Text);
}
if (e.Item.ValuePath == "Find/by Sedol")
{
//made = true; cmdStr += "@IO=1,@SubIO=2,@FieldContent='" + tbFieldContent.Text + "',@SiteID='" + tbSiteID.Text + "',@AnalystID='" + tbAnalystID.Text + "',@TeamID='" + tbTeamID.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "1");
paramArray[cp++] = new SqlParameter("@SubIO", "2");
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
paramArray[cp++] = new SqlParameter("@SiteID", tbSiteID.Text);
paramArray[cp++] = new SqlParameter("@AnalystID", tbAnalystID.Text);
paramArray[cp++] = new SqlParameter("@TeamID", tbTeamID.Text);
}
if (e.Item.ValuePath == "Find/by Analyst Name")
{
//made = true; cmdStr += "@IO=1,@SubIO=3,@FieldContent='" + tbFieldContent.Text + "',@SiteID='" + tbSiteID.Text + "',@AnalystID='" + tbAnalystID.Text + "',@TeamID='" + tbTeamID.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "1");
paramArray[cp++] = new SqlParameter("@SubIO", "3");
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
paramArray[cp++] = new SqlParameter("@SiteID", tbSiteID.Text);
paramArray[cp++] = new SqlParameter("@AnalystID", tbAnalystID.Text);
paramArray[cp++] = new SqlParameter("@TeamID", tbTeamID.Text);
}
//Ratings
if (e.Item.ValuePath.IndexOf("Ratings/Processed") > -1)
{
//made = true; cmdStr += "@IO=2,@SubIO=1";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "1");
//if (e.Item.Value == "NULL") cmdStr += ",@Flag=NULL";
if (e.Item.Value == "NULL")
{
paramArray[cp++] = new SqlParameter("@Flag", null);
}
//if (e.Item.Value == "No") cmdStr += ",@Flag='N'";
if (e.Item.Value == "No")
{
paramArray[cp++] = new SqlParameter("@Flag", "N");
}
//if (e.Item.Value == "Wait") cmdStr += ",@Flag='W'";
if (e.Item.Value == "Wait")
{
paramArray[cp++] = new SqlParameter("@Flag", "W");
}
//cmdStr += ",@HorizontalDump='" + tbHorizontalDump.Text + "'";
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
}
if (e.Item.ValuePath == "Ratings/StockID/Clear")
{
//made = true; cmdStr += "@IO=2,@SubIO=2"; cmdStr += ",@HorizontalDump='" + tbHorizontalDump.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "2");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
}
if (e.Item.ValuePath == "Ratings/StockID/Add")
{
//made = true; cmdStr += "@IO=2,@SubIO=4"; cmdStr += ",@HorizontalDump='" + tbHorizontalDump.Text + "',@FieldContent=" + tbFieldContent.Text;
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "4");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
if (e.Item.ValuePath == "Ratings/Look")
{
//made = true; cmdStr += "@IO=2,@SubIO=3"; cmdStr += ",@HorizontalDump='" + tbHorizontalDump.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "3");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
}
if (e.Item.ValuePath == "Ratings/PersonID/Clear")
{
//made = true; cmdStr += "@IO=2,@SubIO=5"; cmdStr += ",@HorizontalDump='" + tbHorizontalDump.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "5");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
}
//Ratings
if (e.Item.ValuePath == "Ratings/UPDATE/Index")
{
//made = true; cmdStr += "@IO=2,@SubIO=6"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "',@FieldContent='" + tbFieldContent.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "6");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
if (e.Item.ValuePath == "Ratings/UPDATE/Sedol")
{
//made = true; cmdStr += "@IO=2,@SubIO=7"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "',@FieldContent='" + tbFieldContent.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "7");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
if (e.Item.ValuePath == "Ratings/UPDATE/CUSIP")
{
//made = true; cmdStr += "@IO=2,@SubIO=7"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "',@FieldContent='" + tbFieldContent.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "11");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
if (e.Item.ValuePath == "Ratings/UPDATE/Region")
{
//made = true; cmdStr += "@IO=2,@SubIO=8"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "',@FieldContent='" + tbFieldContent.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "8");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
if (e.Item.ValuePath == "Ratings/UPDATE/Without Stock History")
{
//made = true; cmdStr += "@IO=2,@SubIO=9"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "9");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
}
if (e.Item.ValuePath == "Ratings/UPDATE/NewAnalystName")
{
//made = true; cmdStr += "@IO=2,@SubIO=10"; cmdStr += ",@RatingsID='" + tbRatingsID.Text + "',@FieldContent='" + tbFieldContent.Text + "'";
paramArray[cp++] = new SqlParameter("@IO", "2");
paramArray[cp++] = new SqlParameter("@SubIO", "10");
paramArray[cp++] = new SqlParameter("@RatingsID", tbRatingsID.Text);
paramArray[cp++] = new SqlParameter("@FieldContent", tbFieldContent.Text);
}
//if (tbHorizontalDump.Text == "") made = false;
//execute
//lCMD.Text = cmdStr;
//if (made) get_grids(cmdStr, SUPPORT_SupportDB);
if (cp > 0)
{
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("ipm_load_ratings_control_panel", paramArray, "DataSet") as DataSet;
control_utils gu = new control_utils();
//MasterPage MasterPage1 = Page.Master; //придержать
gu.get_grids(ds, PlaceHolder1, null, Page.Master, false);
}
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
int cp = 0;
string p0 = "", v0 = "";
string p1 = "", v1 = "";
string p2 = "", v2 = "";
string p3 = "", v3 = "";
string p4 = "", v4 = "";
lMenuPath.Text = e.Item.ValuePath;
//Stocks
if (e.Item.ValuePath == "Stocks|Look")
{
cp += 3; p0 = "@IO"; v0 = "1"; p1 = "@SubIO"; v1 = "1"; p2 = "@StocksID"; v2 = tbStocksID.Text;
}
if (e.Item.ValuePath == "Stocks|UPDATE|RIC")
{
cp += 4; p0 = "@IO"; v0 = "1"; p1 = "@SubIO"; v1 = "2"; p2 = "@StocksID"; v2 = tbStocksID.Text; p3 = "@RIC"; v3 = tbFieldContent1.Text;
}
if (e.Item.ValuePath == "Stocks|UPDATE|InstDBStockID")
{
cp += 4; p0 = "@IO"; v0 = "1"; p1 = "@SubIO"; v1 = "4"; p2 = "@StocksID"; v2 = tbStocksID.Text; p3 = "@FieldContent1"; v3 = tbFieldContent1.Text;
}
if (e.Item.ValuePath == "Stocks|History|Delete/On 1 Date")
{
cp += 4; p0 = "@IO"; v0 = "1"; p1 = "@SubIO"; v1 = "3"; p2 = "@StocksID"; v2 = tbStocksID.Text; p3 = "@Date"; v3 = tbFieldContent1.Text;
}
//InstDB
if (e.Item.ValuePath == "InstDB|Keep Pair Symbol & RIC|Look")
{
cp += 3; p0 = "@IO"; v0 = "2"; p1 = "@SubIO"; v1 = "1"; p2 = "@StocksID"; v2 = tbStocksID.Text;
}
if ((e.Item.ValuePath == "InstDB|Keep Pair Symbol & RIC|From Stocks") || (e.Item.ValuePath == "Keep from Stocks"))
{
cp += 3; p0 = "@IO"; v0 = "2"; p1 = "@SubIO"; v1 = "2"; p2 = "@StocksID"; v2 = tbStocksID.Text;
}
if (e.Item.ValuePath == "InstDB|Keep Pair Symbol & RIC|Delete")
{
cp += 3; p0 = "@IO"; v0 = "2"; p1 = "@SubIO"; v1 = "4"; p2 = "@StocksID"; v2 = tbStocksID.Text;
}
//lCMD.Text = strCMD;
//if (Made) { SqlDataSource1.SelectCommand = strCMD; }
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
if (p0 != "")
{
paramArray[0] = new SqlParameter(p0, v0);
}
if (p1 != "")
{
paramArray[1] = new SqlParameter(p1, v1);
}
if (p2 != "")
{
paramArray[2] = new SqlParameter(p2, v2);
}
if (p3 != "")
{
paramArray[3] = new SqlParameter(p3, v3);
}
if (p4 != "")
{
paramArray[4] = new SqlParameter(p4, v4);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("quotes_editor", paramArray, "DataSet") as DataSet;
int[] StaticGridViews = new int[3];
control_utils gu = new control_utils();
MasterPage MasterPage1 = Page.Master;
//gu.get_grids(ds, PlaceHolder1, StaticGridViews, MasterPage1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
control_utils tt = new control_utils();
tt.setMenuStyle(ref Menu1, 1);
}
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
int cp = 0;
string p0 = "", v0 = "";
string p1 = "", v1 = "";
string p2 = "", v2 = "";
string p3 = "", v3 = "";
string p4 = "", v4 = "";
lMenuPath.Text = e.Item.ValuePath;
//Find By
if (e.Item.ValuePath == "Find By|Emails")
{
cp += 3;
p0 = "@IO"; v0 = "1";
p1 = "@SubIO"; v1 = "1";
p2 = "@FieldContent1"; v2 = tbFieldContent1.Text;
}
if (e.Item.ValuePath == "Find By|Contact Person")
{
cp += 3;
p0 = "@IO"; v0 = "1";
p1 = "@SubIO"; v1 = "2";
p2 = "@FieldContent1"; v2 = tbFieldContent1.Text;
}
if (e.Item.ValuePath == "Find By|By AnalystID")
{
cp += 3;
p0 = "@IO"; v0 = "2";
p1 = "@SubIO"; v1 = "1";
p2 = "@FieldContent1"; v2 = tbFieldContent1.Text;
}
//Broker
if (e.Item.ValuePath == "Broker|Update|ExchangeISOID")
{
cp += 4;
p0 = "@IO"; v0 = "3";
p1 = "@SubIO"; v1 = "1";
p2 = "@ID"; v2 = tbID.Text;
p3 = "@ExchangeISOID"; v3 = tbExchangeISOID.Text;
}
if (e.Item.ValuePath == "Broker|Update|LastAlert Date")
{
cp += 4;
p0 = "@IO"; v0 = "3";
p1 = "@SubIO"; v1 = "2";
p2 = "@ID"; v2 = tbID.Text;
p3 = "@Date"; v3 = tbDate.Text;
}
if (e.Item.ValuePath == "Broker|Update|emailGroupID")
{
cp += 4;
p0 = "@IO"; v0 = "3";
p1 = "@SubIO"; v1 = "3";
p2 = "@ID"; v2 = tbID.Text;
p3 = "@FieldContent1"; v3 = tbFieldContent1.Text;
}
if ((e.Item.ValuePath == "Broker|Update|TypeOfDelay|Daily") ||
(e.Item.ValuePath == "Broker|Update|TypeOfDelay|Weekly") ||
(e.Item.ValuePath == "Broker|Update|TypeOfDelay|Monthly"))
{
cp += 4;
p0 = "@IO"; v0 = "3";
p1 = "@SubIO"; v1 = "4";
p2 = "@ID"; v2 = tbID.Text;
if (e.Item.ValuePath == "Broker|Update|TypeOfDelay|Daily")
{
p3 = "@FieldContent1"; v3 = "Daily";
}
if (e.Item.ValuePath == "Broker|Update|TypeOfDelay|Weekly")
{
p3 = "@FieldContent1"; v3 = "Weekly";
}
if (e.Item.ValuePath == "Broker|Update|TypeOfDelay|Monthly")
{
p3 = "@FieldContent1"; v3 = "Monthly";
}
}
if (cp > 0)
{
SqlParameter[] paramArray = new SqlParameter[cp];
if (p0 != "")
{
paramArray[0] = new SqlParameter(p0, v0);
}
if (p1 != "")
{
paramArray[1] = new SqlParameter(p1, v1);
}
if (p2 != "")
{
paramArray[2] = new SqlParameter(p2, v2);
}
if (p3 != "")
{
paramArray[3] = new SqlParameter(p3, v3);
}
if (p4 != "")
{
paramArray[4] = new SqlParameter(p4, v4);
}
db_utils du = new db_utils();
DataSet ds;
ds = du.get_db_Data("rdsftp_file_alerts", paramArray, "DataSet") as DataSet;
int[] StaticGridViews = new int[0];
control_utils gu = new control_utils();
MasterPage MasterPage1 = Page.Master;
gu.get_grids(ds, PlaceHolder1, StaticGridViews, MasterPage1, false);
}
}
