protected void Page_Load(object sender, EventArgs e) { if (cmstrDefualts.CheckQueryString("sitelang", out myLang)) { if (Request.QueryString["country"] != null && int.TryParse(Request.QueryString["country"], out blogid)) { if (blogid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("NameMyTextBox")).Visible = true; } else { //((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("NameMyTextBox")).Visible = false; BlogTypeMyForm.DataKeyFieldValue = blogid; } ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("BlogTypeName")).DataFieldName = myLang.ToString(); BlogTypeMyForm.SaveButtonText = "Save"; BlogTypeMyForm.DataKeyField = "idtbllang"; BlogTypeMyForm.BackButtonText = "Back"; BlogTypeMyForm.SaveReturnText = "Save&Back"; BlogTypeMyForm.BackURL = "ManageLanguages.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } else { BlogTypeMyForm.Visible = false; } CatsTable.SqlFieldNames = String.Format("langname,`{0}`", myLang); CatsTable.EditUrl = "ManageLanguages.aspx?country={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; CatsTable.AddLink = "ManageLanguages.aspx?country=0&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } }
protected void Page_Load(object sender, EventArgs e) { if (siteDefaults.CheckQueryString("sitelang", out myLang)) { if (Request.QueryString["country"] != null && int.TryParse(Request.QueryString["country"], out blogid)) { using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr)) { string sql = String.Format("Select CountryNameeng From countries where countryid={0}", blogid); MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { BlogTypeMyForm.Header = string.Format("Country: {0}", dr["CountryNameeng"].ToString()); } } ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("BlogTypeName")).DataFieldName = myLang.ToString(); BlogTypeMyForm.DataKeyFieldValue = blogid; BlogTypeMyForm.SaveButtonText = "Save"; BlogTypeMyForm.DataKeyField = "countryid"; BlogTypeMyForm.BackButtonText = "Back"; BlogTypeMyForm.SaveReturnText = "Save&Back"; BlogTypeMyForm.BackURL = "ManageCountries.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } else { BlogTypeMyForm.Visible = false; } CatsTable.SqlFieldNames = String.Format("CountryNameeng,`{0}`", myLang); CatsTable.EditUrl = "ManageCountries.aspx?country={field}&id=" + Request.QueryString["id"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } }
protected void UpdateTags_Click(object sender, EventArgs e) { string myTagsVals = ((tableControl)BlogTypeMyForm.FindControl("TagsTable")).SelectedValsHidVal; string[] myTagsValsArray = { }; myTagsValsArray = myTagsVals.Split(','); using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr)) { conn.Open(); string sql = String.Format("Delete From tbltagsforMissions where missionID={0}", contatctid); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); foreach (string Tag in myTagsValsArray) { int TagNumber = 0; if (int.TryParse(Tag, out TagNumber)) { cmd.CommandText = String.Format("Insert Into tbltagsforMissions (TagID,MissionID) Values ({0},{1})", Tag, contatctid); cmd.ExecuteNonQuery(); } } conn.Close(); } }
// int siteLang = 0; protected void Page_Load(object sender, EventArgs e) { // CatsTable.SqlWhereQuery = String.Format("gamelang={0}", siteLang); if (Request.QueryString["contact"] != null && int.TryParse(Request.QueryString["contact"], out contatctid)) { BlogTypeMyForm.BackURL = "ManagePages.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (contatctid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("hid_Guid")).Value = Guid.NewGuid().ToString(); // ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("LangMyHiddenField")).Value = siteLang.ToString(); } else { using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr)) { string sql = String.Format("Select pagename From tblpages where idtblpages={0}", contatctid); MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { BlogTypeMyForm.Header = string.Format("עריכת דף: {0}", dr["pagename"].ToString()); } dr.Close(); sql = "select tagid from tbltagsforMissions where missionid=" + contatctid; myTagsArray = new List <string>(); cmd.CommandText = sql; dr = cmd.ExecuteReader(); while (dr.Read()) { myTagsArray.Add(dr["tagid"].ToString()); } if (!IsPostBack) { ((tableControl)BlogTypeMyForm.FindControl("TagsTable")).SelectedValsHidVal = String.Join(",", myTagsArray.ToArray()); } } BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Update; BlogTypeMyForm.DataKeyFieldValue = contatctid; } } else { BlogTypeMyForm.Visible = false; } CatsTable.AddLink = "ManagePages.aspx?sitelang=" + Request.QueryString["sitelang"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&contact=0"; CatsTable.EditUrl = "ManagePages.aspx?sitelang=" + Request.QueryString["sitelang"] + "&contact={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; CatsTable.CustomField = ",,,<a target=\"blank \"href=\"" + siteDefaults.SiteUrl + "/Mission.aspx?name={0}" + "\" ><img alt=\"view\" title=\"View\" src=\"images/preview.png\" /></a>,<textarea style=\"height:50px;width:400px;text-align:left;\" onmouseup=\"selectonfocus(this)\" >" + siteDefaults.SiteUrl + "/Mission.aspx?name={0}&mail=[[email]]</textarea>,<a href=\"MissionStats.aspx?MissionID={0}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "\"><img title=\"הצג סטטיסטיקות למשימה\" src=\"images/pie-3d.png\" style=\"width:20px; height:20px;\" /></a>"; // CatsTable.CustomField = ",,<a href=\"ManageHelpArticle.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&MyParent={0}\" >נהל</a>"; // CatsTable.SqlWhereQuery = "helpParent=0"; }
protected void btnPost_Click(object sender, EventArgs e) //מתודת שליחת פוסט לקיר של הדף בפייסבוק { FacebookPagePost _post = new FacebookPagePost(); string _postResponse = ""; _post.message = ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("txt_PostText")).Text; using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr)) { con.Open(); MySqlCommand _cmd = new MySqlCommand(); _cmd.Connection = con; _cmd.CommandText = "select * from facebookpages where FacebookPagesID = 1"; MySqlDataReader _dr = _cmd.ExecuteReader(); if (_dr.Read()) { _post.id = _dr["PageID"].ToString(); _post.access_token = _dr["AccessToken"].ToString(); } _dr.Close(); con.Close(); } _post.link = ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("Post_Link")).Text; if (_post.access_token != "" && _post.access_token != null) //בדיקה האם יש טוקן במערכת והאם יש קבוצה שניתן "לפרסם" בה { _postResponse = FacebookCode.PostOnFacebookPage(_post); //ביצוע פוסט + קבלת מספר פוסט בכתשובה if (_postResponse != "") //בדיקה האם חזר מספר פוסט כתשובה מפייסבוק { using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr)) { con.Open(); MySqlCommand _cmd = new MySqlCommand(); _cmd.Connection = con; _cmd.CommandText = "UPDATE tblpages set FB_PostID='" + _postResponse + "' where idtblpages =" + contatctid; _cmd.ExecuteNonQuery(); con.Close(); } ((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "פוסט נשלח בהצלחה!"; } else { ((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "הייתה בעיה בשליחת הפוסט"; } } else { ((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "לא בוצע התחברות לדף פייסבוק עדיין, אנא התחבר לדף"; } //((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "פוסט נשלח בהצלחה - אנא לחץ שמור לשמירת הנתונים!"; //((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = _postResponse; hid_PostID.Value = _postResponse; //((Button)BlogTypeMyForm.FindControl("btnSavePost")).Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (siteDefaults.CheckQueryString("sitelang", out myLang)) { } string sql = ""; if (Request.QueryString["id"] != null && int.TryParse(Request.QueryString["id"], out blogid)) { // check if edit article (else category) if (Request.QueryString["article"] != null && int.TryParse(Request.QueryString["article"], out articleid)) { CatsTable.Visible = false; if (articleid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; sql = String.Format("Select helpheader, 'New Article' as parentheder From tblevents Where idtblhelpcenter={0}", blogid); BlogTypeMyForm.OrderQuery = string.Format(" where helpParent={0} AND eventLang={1}", blogid, myLang); } else { BlogTypeMyForm.DataKeyFieldValue = articleid; sql = String.Format("Select event1.helpheader, (select helpheader From tblevents where idtblhelpcenter=event1.helpParent) as parentheder From tblevents as event1 Where event1.idtblhelpcenter={0}", articleid); } ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("ParentMyHiddenField")).Value = blogid.ToString(); ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("LangMyHiddenField")).Value = myLang.ToString(); BlogTypeMyForm.BackURL = "EditEventCenterCat.aspx?id=" + Request.QueryString["id"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } else { BlogTypeMyForm.DataKeyFieldValue = blogid; ((Panel)BlogTypeMyForm.FindControl("ArticleFields")).Visible = false; BlogTypeMyForm.BackURL = "ManageEventCenter.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; sql = String.Format("Select helpheader, (select helpheader From tblevents where idtblhelpcenter=helpParent) as parentheder From tblevents Where idtblhelpcenter={0}", blogid); } BlogTypeMyForm.SaveButtonText = "Save"; BlogTypeMyForm.DataKeyField = "idtblhelpcenter"; BlogTypeMyForm.BackButtonText = "Back"; BlogTypeMyForm.SaveReturnText = "Save&Back"; using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr)) { MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { TitleLabel.Text = String.Format("Blog: {1} - {0}", dr["helpheader"], dr["parentheder"]); } CatsTable.SqlWhereQuery = string.Format("helpParent={0} AND eventLang={1}", blogid, myLang); CatsTable.AddLink = "EditEventCenterCat.aspx?article=0&id=" + Request.QueryString["id"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; CatsTable.EditUrl = "EditEventCenterCat.aspx?article={field}&id=" + Request.QueryString["id"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } } }
protected void Unnamed_Click(object sender, EventArgs e) { using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr)) { con.Open(); MySqlCommand _cmd = new MySqlCommand(); _cmd.Connection = con; _cmd.CommandText = "UPDATE tblpages set FB_PostID='" + hid_PostID.Value + "' where idtblpages =" + contatctid; _cmd.ExecuteNonQuery(); con.Close(); ((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = ""; ((Button)sender).Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { LangTableControl.EditUrl = "ManageProgram.aspx?sitelang={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (siteDefaults.CheckQueryString("sitelang", out siteLang)) { LangTableControl.Visible = false; CatsTable.Visible = true; // CatsTable.SqlWhereQuery = String.Format("gamelang={0}", siteLang); if (Request.QueryString["contact"] != null && int.TryParse(Request.QueryString["contact"], out contatctid)) { BlogTypeMyForm.BackURL = "ManageProgram.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("SpecialMyTextBox")).DataFieldName = siteLang.ToString(); ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("CommentMyTextBox")).DataFieldName = "Comment" + siteLang; if (contatctid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; // ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("LangMyHiddenField")).Value = siteLang.ToString(); } else { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Update; BlogTypeMyForm.DataKeyFieldValue = contatctid; } } else { BlogTypeMyForm.Visible = false; } } else { LangTableControl.Visible = true; CatsTable.Visible = false; BlogTypeMyForm.Visible = false; } CatsTable.AddLink = "ManageProgram.aspx?sitelang=" + Request.QueryString["sitelang"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&contact=0"; CatsTable.EditUrl = "ManageProgram.aspx?sitelang=" + Request.QueryString["sitelang"] + "&contact={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; // CatsTable.CustomField = ",,<a href=\"ManageHelpArticle.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&MyParent={0}\" >נהל</a>"; // CatsTable.SqlWhereQuery = "helpParent=0"; }
protected void BlogTypeMyForm_ItemInserted(string NewUserID) { string myVals = ((tableControl)BlogTypeMyForm.FindControl("MissionTable")).SelectedValsHidVal; string[] myValsArray = myVals.Split(','); string myBadgesVals = ((tableControl)BlogTypeMyForm.FindControl("BadgeTable")).SelectedValsHidVal; string[] myBadgesValsArray = { }; myBadgesValsArray = myBadgesVals.Split(','); using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr)) { conn.Open(); string sql = String.Format("Delete From tblbadgemissions where badgeid={0}", NewUserID); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); foreach (string mission in myValsArray) { int missionNumber = 0; if (int.TryParse(mission, out missionNumber)) { cmd.CommandText = String.Format("Insert Into tblbadgemissions (badgeid,missionid) Values ({0},{1})", NewUserID, mission); cmd.ExecuteNonQuery(); } } sql = String.Format("Delete From tblcronicalbadges where badgeid={0}", NewUserID); cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); foreach (string badge in myBadgesValsArray) { int TagNumber = 0; if (int.TryParse(badge, out TagNumber)) { cmd.CommandText = String.Format("Insert Into tblcronicalbadges (badgeid,NeedBadgeID) Values ({0},{1})", NewUserID, badge); cmd.ExecuteNonQuery(); } } } Badge.ClearList(); }
protected void Page_Load(object sender, EventArgs e) { int mytpo = 1; if (cmstrDefualts.CheckQueryString("sitelang", out siteLang)) { // CatsTable.SqlWhereQuery = String.Format("gamelang={0}", siteLang); using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr)) { string sql = String.Format("Select toplinemsgid From toplinemsg where toplang={0}", siteLang); MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { int.TryParse(dr["toplinemsgid"].ToString(), out mytpo); } else { mytpo = 0;; } dr.Close(); } if (mytpo != 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Update; BlogTypeMyForm.DataKeyFieldValue = mytpo; ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("LangMyHiddenField")).Visible = false; } else { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("LangMyHiddenField")).Value = siteLang.ToString(); string muguid = Guid.NewGuid().ToString(); ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("MyHiddenField1")).Value = muguid; string muguid2 = Guid.NewGuid().ToString(); ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("MyHiddenField2")).Value = muguid2; } } }
protected void Page_Load(object sender, EventArgs e) { LangTableControl.EditUrl = "ManageUserFields.aspx?sitelang={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (cmstrDefualts.CheckQueryString("sitelang", out siteLang)) { LangTableControl.Visible = false; CatsTable.Visible = true; ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("ValueMyTextBox")).DataFieldName = siteLang.ToString(); CatsTable.SqlFieldNames = String.Format("fieldname,`{0}`", siteLang); CatsTable.AddLink = "ManageUserFields.aspx?sitelang=" + Request.QueryString["sitelang"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&contact=0"; CatsTable.EditUrl = "ManageUserFields.aspx?sitelang=" + Request.QueryString["sitelang"] + "&contact={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (Request.QueryString["contact"] != null && int.TryParse(Request.QueryString["contact"], out contatctid)) { BlogTypeMyForm.BackURL = "ManageUserFields.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (contatctid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; } else { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Update; BlogTypeMyForm.DataKeyFieldValue = contatctid; } } else { BlogTypeMyForm.Visible = false; } } else { LangTableControl.Visible = true; CatsTable.Visible = false; BlogTypeMyForm.Visible = false; } }
protected string BlogTypeMyForm_ItemInserting() { ((CMSTRHiddenField)BlogTypeMyForm.FindControl("MyDateMyHiddenField")).Value = DateTime.Now.ToString(); return("insert"); }
protected void Page_Load(object sender, EventArgs e) { using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr)) { conn.Open(); // Badge.AddBadge(BadgTypeEnum.Join, conn, 29); } //CMSTRDropDownControl myTagsDropDown = (CMSTRDropDownControl)BlogTypeMyForm.FindControl("BadgeTags"); CMSTRDropDownControl myTTypeDropDown = (CMSTRDropDownControl)BlogTypeMyForm.FindControl("BagTypeMyDropDown"); CMSTRDropDownControl myTagsDropDown2 = (CMSTRDropDownControl)BlogTypeMyForm.FindControl("ChooseTagMyDropDown"); List <Tags> MyList = Tags.GetList(); //myTagsDropDown.ListItems.Add(new ListItem("בחר", "0")); myTagsDropDown2.ListItems.Add(new ListItem("בחר", "0")); if (MyList.Count > 0) { for (int i = 0; i < MyList.Count; i++) { //myTagsDropDown.ListItems.Add(new ListItem(MyList[i].Name, MyList[i].ID.ToString())); myTagsDropDown2.ListItems.Add(new ListItem(MyList[i].Name, MyList[i].ID.ToString())); } } List <BadgeType> MyBagTypeList = BadgeType.GetList(); myTTypeDropDown.ListItems.Add(new ListItem("בחר", "0")); if (MyBagTypeList.Count > 0) { for (int i = 0; i < MyBagTypeList.Count; i++) { myTTypeDropDown.ListItems.Add(new ListItem(MyBagTypeList[i].Name, MyBagTypeList[i].ID.ToString())); } } if (cmstrDefualts.CheckQueryString("badge", out badgeid)) { if (badgeid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; //myTagsDropDown.ListItems[0].Selected = true; myTTypeDropDown.SelectedValue = "0"; myTagsDropDown2.SelectedValue = "0"; } else { if (!IsPostBack) { List <Badge> myBadge = Badge.GetBadgeList().Where(x => x.ID == badgeid).ToList(); Response.Write(myBadge[0].MissionList.Count); if (myBadge.Count > 0 && myBadge[0].MissionList.Count > 0) { string[] myArray = myBadge[0].MissionList.Select(x => x.ToString()).ToArray(); ((tableControl)BlogTypeMyForm.FindControl("MissionTable")).SelectedValsHidVal = String.Join(",", myArray); } if (myBadge.Count > 0 && myBadge[0].AssociatedBadgesList.Count > 0) { string[] myAssociatedBadgesArray = myBadge[0].AssociatedBadgesList.Select(x => x.ToString()).ToArray(); ((tableControl)BlogTypeMyForm.FindControl("BadgeTable")).SelectedValsHidVal = String.Join(",", myAssociatedBadgesArray); } } BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Update; BlogTypeMyForm.DataKeyFieldValue = badgeid; } BlogTypeMyForm.BackURL = "ManageBadges.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"]; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["drop"] != null && int.TryParse(Request.QueryString["drop"], out dropid)) { using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr)) { string sql = String.Format("Select * From mysitedropdown Where idmysitedropdown={0}", dropid); MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { CatsTable.TableTitle = "Manage " + dr["dropdownname"]; CatsTable.SqlWhereQuery = "listid=" + dropid; ((ASP.controls_cmstrhiddenfield_ascx)BlogTypeMyForm.FindControl("ListMyHiddenField")).Value = dropid.ToString(); ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("NameMyTextBox")).FieldName = dr["dropdownname"] + " General Name"; ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("BlogTypeName")).FieldName = dr["dropdownname"] + " Name"; } else { Response.Redirect("./"); } dr.Close(); //for (int i = 140; i < 220; i++) //{ // string sql2 = String.Format("Insert Into `mydropdownvalues` (dropfieldValue,showfield,`1`,`3`,listid) Values ('{0}',true,'{0}','{0}',5);", i); // cmd.CommandText = sql2; // cmd.ExecuteNonQuery(); //} conn.Close(); } } else { Response.Redirect("./"); } if (siteDefaults.CheckQueryString("sitelang", out myLang)) { if (Request.QueryString["country"] != null && int.TryParse(Request.QueryString["country"], out blogid)) { if (blogid == 0) { BlogTypeMyForm.FormStatus = CMSTRFormWebUserControl.Status.Insert; ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("NameMyTextBox")).Visible = true; } else { ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("NameMyTextBox")).Visible = false; BlogTypeMyForm.DataKeyFieldValue = blogid; } ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("BlogTypeName")).DataFieldName = myLang.ToString(); BlogTypeMyForm.SaveButtonText = "Save"; BlogTypeMyForm.DataKeyField = "idmydropdownvalues"; BlogTypeMyForm.BackButtonText = "Back"; BlogTypeMyForm.SaveReturnText = "Save&Back"; BlogTypeMyForm.BackURL = "ManageDropDown.aspx?cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"] + "&drop=" + Request.QueryString["drop"]; } else { BlogTypeMyForm.Visible = false; } // CatsTable.SqlFieldNames = String.Format("`{0}`", myLang); CatsTable.EditUrl = "ManageDropDown.aspx?country={field}&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"] + "&drop=" + Request.QueryString["drop"]; CatsTable.AddLink = "ManageDropDown.aspx?country=0&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&sitelang=" + Request.QueryString["sitelang"] + "&drop=" + Request.QueryString["drop"]; CatsTable.SqlFieldNames = "dropfieldValue,`" + myLang.ToString() + "`"; CatsTable.SortBy = "`" + myLang.ToString() + "`"; } }