public void populateServiceddl() { //GCommon<Service> obj = new DataManipulationClass().populateService(); List <Service> obj = new DataManipulationClass().populateService_list(); DataTable dt = GenericListToDataTable(obj); ViewState["dtdata1"] = dt; Session["list"] = obj; // this.gridTest.DataSource = dt; this.gridTest.DataSource = obj; this.gridTest.DataBind(); if (obj.Count > 0) { IEnumerator <Service> ie = obj.GetEnumerator(); ListItem li = new ListItem(); li.Value = "0"; li.Text = "Please Select"; ddlService.Items.Insert(0, li); while (ie.MoveNext()) { li = new ListItem(); li.Text = ie.Current.service_name.ToString(); li.Value = ie.Current.service_id.ToString(); ddlService.Items.Add(li); } } }
protected void Page_Load(object sender, EventArgs e) { // DataTable dt=new DataTable(); // dt.Columns.Add("recid", typeof(int)); // DataRowState dr=dt.new //dr["recid"]="1"; //Dictionary<int, string> dict = new Dictionary<int, string>(); //dict.Add("1", "Ram"); //dict.Add("2", "Sam"); //dict.Add("1", "Jadhu"); //try //{ // int x = 4; // int y = 0; // int res = x / y; //} //catch (Exception ex) //{ //} //finally //{ // Response.Redirect("http://www.rediffmail.com:"); //} //int x=fun(); //if (ValidateUrl("http://www.rediffmail.com:")) if (ValidateUrl("http://www.suvrojyotik.com")) { } DataManipulationClass objd = new DataManipulationClass(); objd.funOL(1); }
protected void ddlSite_SelectedIndexChanged(object sender, EventArgs e) { if (ddlSite.SelectedValue != "") { dvData.Visible = true; GridView1.Visible = false; lblMsg.Text = ""; lblSearch.Text = ""; string sql = "SELECT " + "LinkExchange.SubPage.ID, " + "LinkExchange.SubPage.LinkURL " + "FROM " + "LinkExchange.SubPage " + "WHERE LinkExchange.SubPage.Websiteid='" + ddlSite.SelectedValue + "'"; string strError = ""; string _schema = Convert.ToString(ConfigurationManager.AppSettings["SCHEMA"]); DataManipulationClass objdata = new DataManipulationClass(); objdata.DropDownFill(ddlSubPage, sql, "LinkURL", "ID", _schema, ref strError); } else { lblMsg.Text = "Please select a site"; ddlSite.Focus(); dvData.Visible = false; this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script>alert('Please select a site');</script>"); } }
protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { Login objlogin = new Login(); objlogin.Address1 = txtAddress1.Value.ToString().Replace("'", "''"); objlogin.username = txtUserName.Value; DataManipulationClass objdata = new DataManipulationClass(); string strError = ""; objdata.AddExpert(objlogin, ref strError); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Upd") { TextBox txtpageid = (TextBox)GridView1.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("txtpageid"); Label lblid = (Label)GridView1.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("lblid"); //Button btnUpdate = (Button)GridView1.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("btnUpdate"); LinkButton btnUpdate = (LinkButton)GridView1.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("btnUpdate"); btnUpdate.Attributes.Add("onclick", "javascript:return ValidateText('" + txtpageid.ClientID + "');"); //btnGo.Attributes.Add("onclick", "javascript:ValidateText(" + btnGo.ID + ")"); //ScriptManager sm = ScriptManager.GetCurrent(Page); //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MYScript", "ValidateText(" + txtUrlName.ClientID + ")", true); DataManipulationClass objData = new DataManipulationClass(); string stError = ""; if (txtpageid.Text != "") { if (objData.UpdateLinkExchangeMaster_Pageid(Convert.ToInt32(lblid.Text), Convert.ToInt32(txtpageid.Text), ref stError)) { Response.Redirect("Insert-Page-Number.aspx?flag=update"); } else { } } else { lblMsg.Text = "Please enter Page Id"; //this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert13", "<script>alert('Please enter Page Id');</script>"); // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert22", "<script>alert('Please enter Page Id');</script>", true); string[] _strContNameAll = txtpageid.ClientID.ToString().Split(new char[] { '_' }); int _intTempId = Convert.ToInt32(_strContNameAll[1].Substring(3)) + 1; string _strId = ""; if (_intTempId < 10) { _strId = "GridView1_ctl0" + Convert.ToString(_intTempId) + "_txtpageid"; } else { _strId = "GridView1_ctl" + Convert.ToString(_intTempId) + "_txtpageid"; } ScriptManager sm = ScriptManager.GetCurrent(Page); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MYScript", "alert('Please enter Page Id');document.getElementById(\"" + _strId + "\").focus();", true); ScriptManager.RegisterStartupScript(this, this.GetType(), "selectAndFocus", "$get('" + txtpageid.ClientID + "').focus();$get('" + txtpageid.ClientID + "').select();", true); return; } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["log"] == "logout") { if (Request.Cookies["UserInfo"] != null) { if (Request.Cookies["UserInfo"]["userId"] != null) { string[] cookies = Request.Cookies.AllKeys; foreach (string cookie in cookies) { Response.Cookies[cookie].Expires = DateTime.Now.AddDays(-1); } Session.Abandon(); Session.Clear(); Response.Redirect("Index.aspx"); } } } string strError = ""; if (Request.Cookies["UserInfo"] != null) { if (!Page.IsPostBack) { if (Request.Cookies["UserInfo"]["userId"] != null) { int intUserId = Convert.ToInt32(Request.Cookies["UserInfo"]["userId"]); DataManipulationClass objdata = new DataManipulationClass(); // string name = objdata.GetName(intUserId, ref strError); string name = ""; dvlogin.InnerHtml = ""; if (strError == "") { Welcome.InnerHtml = "Welcome " + name; dvlogin.Visible = false; dvlogout.Visible = true; } else { dvlogin.InnerHtml = strError; } } } } else { dvlogin.Visible = true; dvlogout.Visible = false; } }
public void populateStateddl() { GCommon <State> obj = new DataManipulationClass().populateState(); IEnumerator <State> ie = obj.GetEnumerator(); while (ie.MoveNext()) { ListItem li = new ListItem(); li.Text = ie.Current.sname.ToString(); li.Value = ie.Current.sid.ToString(); ddlState.Items.Add(li); } }
public string get_MailCount(int LinkId, string SlNo) { DataManipulationClass objdata = new DataManipulationClass(); string mailcount = ""; string mailtime = ""; StringBuilder sbMail = new StringBuilder(); if (objdata.get_MailCount(LinkId, ref mailcount, ref mailtime)) { if (mailtime != "") { sbMail.Append("<a href=\"javascript:funOpenMailContentDiv(" + LinkId + "," + SlNo + ");\">" + mailcount + " Mails send against this Exchange. Last email sent " + Convert.ToDateTime(mailtime).ToString("MMMM dd, yyyy h:mm tt") + "</a>"); } else { sbMail.Append(mailcount + " Mails send against this Exchange."); } } return(sbMail.ToString()); }
public void populateServiceddl() { GCommon <Service> obj = new DataManipulationClass().populateService(); if (obj.Count > 0) { IEnumerator <Service> ie = obj.GetEnumerator(); ListItem li = new ListItem(); li.Value = "0"; li.Text = "Please Select"; ddlService.Items.Insert(0, li); while (ie.MoveNext()) { li = new ListItem(); li.Text = ie.Current.service_name.ToString(); li.Value = ie.Current.service_id.ToString(); ddlService.Items.Add(li); } } }
private void generateMenu(string id) { string strSql = "SELECT " + "dbo.Menu_Master.Id AS [ID], " + "dbo.Menu_Master.Title AS [Title], " + "dbo.Menu_Master.ParentId AS [pid], " + "dbo.Menu_Master.Level AS [lvl], " + //"dbo.Menu_Master.SQL AS [SQL], " + "CASE WHEN dbo.Menu_Master.PageLink IS NULL THEN '#' ELSE dbo.Menu_Master.PageLink END AS [URL] " + "FROM " + "dbo.Menu_Login_Relation " + "INNER JOIN dbo.Menu_Master ON (dbo.Menu_Login_Relation.MenuId = dbo.Menu_Master.Id) " + "WHERE " + "(dbo.Menu_Master.RecordStatus = '1') " + "AND " + "(dbo.Menu_Login_Relation.LoginId='" + id + "') ORDER BY dbo.Menu_Master.Title"; DataTable dt = new DataManipulationClass().FillDataTable(strSql); dvMenu.InnerHtml = generateRootMenu(dt); }
private void populateSite(int UserId) { GCommon <WebSiteDetail> objLink = new DataManipulationClass().GetSiteCollection(UserId); if (objLink.Count > 0) { System.Collections.Generic.IEnumerator <WebSiteDetail> ie = objLink.GetEnumerator(); ddlSite.Items.Clear(); ListItem li = new ListItem(); li.Text = "Please Select"; li.Value = ""; ddlSite.Items.Add(li); while (ie.MoveNext()) { li = new ListItem(); li.Text = Convert.ToString(ie.Current.SiteURL); li.Value = Convert.ToString(ie.Current.Id); ddlSite.Items.Add(li); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string ids = ""; foreach (ListItem li in cbSubService.Items) { if (li.Selected == true) { ids += li.Value + "|"; } } string strError = ""; DataManipulationClass objDataM = new DataManipulationClass(); if (!objDataM.Add_Service_SubService_Relation(Convert.ToInt32(ddlService.SelectedValue), ids, ref strError)) { lblMsg.Text = strError; } else { lblMsg.Text = "Relation added Successfully"; } }
public void BindDatalist(string UserId, string Type) { DataManipulationClass objdata = new DataManipulationClass(); string strError = ""; string strSQL = ""; if (Type != "2") { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Wait " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " WHERE " + " (LinkExchange.WebSite_Master.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=2 "; } else { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Wait " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " INNER JOIN LinkExchange.User_WebSite_Relation ON (LinkExchange.WebSite_Master.id = LinkExchange.User_WebSite_Relation.WebSiteId)" + " WHERE " + " (LinkExchange.User_WebSite_Relation.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=2 "; } DataTable dtWait = new DataTable(); //dtWait.Columns.Add("SNo", typeof(int)); //dtWait.PrimaryKey = new System.Data.DataColumn[] { dtWait.Columns["Id"] }; dtWait = objdata.FillDataTable(strSQL, ref strError); if (Type != "2") { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Approved " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " WHERE " + " (LinkExchange.WebSite_Master.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=1 "; } else { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Approved " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " INNER JOIN LinkExchange.User_WebSite_Relation ON (LinkExchange.WebSite_Master.id = LinkExchange.User_WebSite_Relation.WebSiteId)" + " WHERE " + " (LinkExchange.User_WebSite_Relation.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=1 "; } DataTable dtApproved = objdata.FillDataTable(strSQL, ref strError); if (Type != "2") { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Reject " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " WHERE " + " (LinkExchange.WebSite_Master.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=3 "; } else { strSQL = " SELECT " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status," + " count(LinkExchange.WebSite_Master.Name)as Reject " + " FROM LinkExchange.LinkExchangeMaster " + " INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId=LinkExchange.WebSite_Master.Id)" + " INNER JOIN LinkExchange.User_WebSite_Relation ON (LinkExchange.WebSite_Master.id = LinkExchange.User_WebSite_Relation.WebSiteId)" + " WHERE " + " (LinkExchange.User_WebSite_Relation.UserId = '" + UserId + "') " + " group by " + " LinkExchange.WebSite_Master.Id , " + " LinkExchange.WebSite_Master.Name, " + " LinkExchange.LinkExchangeMaster.Status " + " having LinkExchange.LinkExchangeMaster.Status=3 "; } DataTable dtReject = objdata.FillDataTable(strSQL, ref strError); //DataRow drWait = null; //dtWait.Columns.Add("Approved", typeof(string)); //for (int i = 0; i < dtWait.Rows.Count; i++) //{ // for (int j = 0; j < dtApproved.Rows.Count; j++) // { // if (dtWait.Rows[i]["id"].ToString() == dtApproved.Rows[j]["id"].ToString()) // { // drWait = dtApproved.NewRow(); // drWait["Approved"] = dtApproved.Rows[j]["Approved"].ToString(); // } // } //} //dtWait.AcceptChanges(); dtWait.PrimaryKey = new DataColumn[1] { dtWait.Columns["Id"] }; dtApproved.PrimaryKey = new DataColumn[1] { dtApproved.Columns["Id"] }; dtReject.PrimaryKey = new DataColumn[1] { dtReject.Columns["Id"] }; dtWait.Merge(dtApproved); dtWait.Merge(dtReject); DataTable dtFinal = new DataTable(); DataRow drFinalRow; dtFinal.Columns.Add("SlNo", typeof(int)); dtFinal.Columns["SlNo"].AutoIncrement = true; dtFinal.Columns["SlNo"].AutoIncrementSeed = 1; dtFinal.Columns.Add("Id", typeof(string)); dtFinal.Columns.Add("Name", typeof(string)); dtFinal.Columns.Add("Wait", typeof(string)); dtFinal.Columns.Add("Approved", typeof(string)); dtFinal.Columns.Add("Reject", typeof(string)); // dtFinal = dtWait.Copy(); for (int j = 0; j < dtWait.Rows.Count; j++) { drFinalRow = dtFinal.NewRow(); drFinalRow["Id"] = Convert.ToString(dtWait.Rows[j]["Id"]); drFinalRow["Name"] = Convert.ToString(dtWait.Rows[j]["Name"]); drFinalRow["Wait"] = dtWait.Rows[j]["Wait"].ToString(); drFinalRow["Approved"] = dtWait.Rows[j]["Approved"].ToString(); drFinalRow["Reject"] = dtWait.Rows[j]["Reject"].ToString(); dtFinal.Rows.Add(drFinalRow); } if (dtFinal.Rows.Count > 0) { rptLink.Visible = true; rptLink.DataSource = dtFinal; rptLink.DataBind(); foreach (RepeaterItem rpt in rptLink.Items) { //HtmlControl sp = rpt.FindControl("spApproved"); HtmlGenericControl spWait = (HtmlGenericControl)rpt.FindControl("spWait"); HtmlGenericControl spWaitView = (HtmlGenericControl)rpt.FindControl("spWaitView"); HtmlGenericControl spApproved = (HtmlGenericControl)rpt.FindControl("spApproved"); HtmlGenericControl spApprovedView = (HtmlGenericControl)rpt.FindControl("spApprovedView"); HtmlGenericControl spReject = (HtmlGenericControl)rpt.FindControl("spReject"); HtmlGenericControl spRejectView = (HtmlGenericControl)rpt.FindControl("spRejectView"); if (spWait.InnerHtml.ToString().Trim() == "") { spWaitView.InnerHtml = ""; } if (spApproved.InnerHtml.ToString().Trim() == "") { spApprovedView.InnerHtml = ""; } if (spReject.InnerHtml.ToString().Trim() == "") { spRejectView.InnerHtml = ""; } } } else { strSQL = "SELECT ROW_NUMBER() OVER(ORDER BY LinkExchange.WebSite_Master.Id) AS 'SlNo',LinkExchange.WebSite_Master.Id ," + " LinkExchange.WebSite_Master.Name," + " 0 as 'Wait',0 as 'Approved',0 as 'Reject'" + " FROM " + " LinkExchange.WebSite_Master" + " WHERE (LinkExchange.WebSite_Master.UserId = '" + UserId + "')"; dtWait = objdata.FillDataTable(strSQL, ref strError); rptLink.Visible = true; rptLink.DataSource = dtWait; rptLink.DataBind(); foreach (RepeaterItem rpt in rptLink.Items) { HtmlGenericControl spWait = (HtmlGenericControl)rpt.FindControl("spWait"); HtmlGenericControl spWaitView = (HtmlGenericControl)rpt.FindControl("spWaitView"); HtmlGenericControl spApproved = (HtmlGenericControl)rpt.FindControl("spApproved"); HtmlGenericControl spApprovedView = (HtmlGenericControl)rpt.FindControl("spApprovedView"); HtmlGenericControl spReject = (HtmlGenericControl)rpt.FindControl("spReject"); HtmlGenericControl spRejectView = (HtmlGenericControl)rpt.FindControl("spRejectView"); if (spWait.InnerHtml.ToString().Trim() == "0") { spWaitView.InnerHtml = ""; } if (spApproved.InnerHtml.ToString().Trim() == "0") { spApprovedView.InnerHtml = ""; } if (spReject.InnerHtml.ToString().Trim() == "0") { spRejectView.InnerHtml = ""; } } } }
protected void btnSearch_Click(object sender, EventArgs e) { if (ddlSubPage.SelectedValue != "") { lblSearch.Text = ""; lblMsg.Text = ""; //string strSQL = "SELECT " + // "LinkExchange.LinkExchangeMaster.Id AS [id], " + // "LinkExchange.SubPage.SubPageName AS [subpagename], " + // "LinkExchange.SubPage.LinkURL AS [linkurl], " + // "LinkExchange.WebSite_Master.Name AS [sitename], " + // "LinkExchange.WebSite_Master.SiteURL AS [siteurl], " + // "LinkExchange.LinkExchangeMaster.HTMLcode AS [htmlcode], " + // "LinkExchange.LinkExchangeMaster.OurAdId AS [adid], " + // "LinkExchange.LinkExchangeMaster.email AS [email], " + // "LinkExchange.LinkExchangeMaster.Reciprocal AS [reci], " + // "LinkExchange.LinkExchangeMaster.Status AS [status] " + // "FROM " + // "LinkExchange.LinkExchangeMaster " + // "INNER JOIN LinkExchange.SubPage ON (LinkExchange.LinkExchangeMaster.SubPageID = LinkExchange.SubPage.Id) " + // "INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId = LinkExchange.WebSite_Master.ID) " + // "WHERE " + // "(LinkExchange.LinkExchangeMaster.HTMLCode LIKE '%" + txtSearchString.Value + "%') AND (LinkExchange.LinkExchangeMaster.websiteid ='" + ddlSite.SelectedValue + "') AND LinkExchange.LinkExchangeMaster.SubPageID ='" + ddlSubPage.SelectedValue + "' AND " + // "(LinkExchange.WebSite_Master.UserId = '" + Convert.ToString(Session["UserID"]) + "') " + // " and LinkExchange.LinkExchangeMaster.pageid is null "+ // " ORDER BY " + // "LinkExchange.LinkExchangeMaster.Status, " + // "LinkExchange.LinkExchangeMaster.Type"; string strSQL = "SELECT " + "LinkExchange.LinkExchangeMaster.Id AS [id], " + "LinkExchange.LinkExchangeMaster.HTMLcode AS [htmlcode], " + "LinkExchange.LinkExchangeMaster.pageid , " + "LinkExchange.LinkExchangeMaster.Reciprocal AS [reci], " + "LinkExchange.LinkExchangeMaster.email AS [email] " + "FROM " + "LinkExchange.LinkExchangeMaster " + // "INNER JOIN LinkExchange.SubPage ON (LinkExchange.LinkExchangeMaster.SubPageID = LinkExchange.SubPage.Id) " + "INNER JOIN LinkExchange.WebSite_Master ON (LinkExchange.LinkExchangeMaster.WebSiteId = LinkExchange.WebSite_Master.ID) " + "WHERE " + "(LinkExchange.LinkExchangeMaster.HTMLCode LIKE '%" + txtSearchString.Value + "%') AND (LinkExchange.LinkExchangeMaster.websiteid ='" + ddlSite.SelectedValue + "') AND LinkExchange.LinkExchangeMaster.SubPageID ='" + ddlSubPage.SelectedValue + "' AND " + "(LinkExchange.WebSite_Master.UserId = '" + Convert.ToString(Session["UserID"]) + "') " + " and LinkExchange.LinkExchangeMaster.Status=2 " + // " and LinkExchange.LinkExchangeMaster.pageid is null " + " ORDER BY " + "LinkExchange.LinkExchangeMaster.Status, " + "LinkExchange.LinkExchangeMaster.Type"; string strError = ""; DataManipulationClass objdata = new DataManipulationClass(); DataTable dtGrid = new DataTable(); dtGrid = objdata.FillDataTable(strSQL, ref strError); if (dtGrid.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dtGrid; GridView1.DataBind(); } else { lblSearch.Text = "No Record found"; GridView1.Visible = false; } } else { lblMsg.Text = "Please select SubPage "; ddlSubPage.Focus(); return; } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { // var hdnMeasurementIds=document.getElementById("hdnMeasurementIds").value; //var strMeasurementIds =new Array(); //var SelectedMeasurements=""; //strMeasurementIds=hdnMeasurementIds.split('|'); //for(var i=0;i<strMeasurementIds.length-1;i++) //{ // if(document.getElementById("CheckBox"+strMeasurementIds[i]).checked == true) // { // SelectedMeasurements+=document.getElementById("CheckBox"+strMeasurementIds[i]).value + "|"; // } //} string[] strCityIds = hidCityIds.Value.Split(new char[] { ',' }); string seletedcities = ""; for (int i = 0; i < strCityIds.Length - 1; i++) { if (Request.Form.Get("chkCity" + strCityIds[i]) != null) { seletedcities += Request.Form.Get("chkCity" + strCityIds[i]) + "|"; } } string[] strcity = seletedcities.Split(new char[] { '|' }); int cityid = 0; if (strcity.Length > 0) { cityid = Convert.ToInt32(strcity[0]); } string[] strSubService = hidSubServId.Value.Split(new char[] { ',' }); string seletedSubService = ""; for (int i = 0; i < strSubService.Length - 1; i++) { if (Request.Form.Get("chkSubServ" + strSubService[i]) != null) { seletedSubService += Request.Form.Get("chkSubServ" + strSubService[i]) + "|"; } } //foreach (DataListItem dl in rptCity.Items) //{ // for (int i = 1; i < strCityIds.Length - 1; i++) // { // CheckBox cbcity = (CheckBox)dl.FindControl("chkCity" + strCityIds[i]); // if (cbcity.Checked == true) // { // seletedcities += cbcity.Text; // } // } //} string strError = ""; Session["login_id"] = 1; Session["package_id"] = 18; string order_id = "-"; DataManipulationClass objDataM = new DataManipulationClass(); if (!objDataM.Add_Package_CitySelection(seletedSubService, cityid, Convert.ToInt32(Session["login_id"]), Convert.ToInt32(Session["package_id"]), order_id, ref strError)) { //lblMsg.Text = strError; } else { //lblMsg.Text = "Relation added Successfully"; Response.Redirect("EditExpertProfile.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Convert.ToString(Session["UserId"]) == null) { Response.Redirect("Default.aspx"); } else { if (!IsPostBack) { string SubPageId = ""; string SiteId = ""; DataManipulationClass objdata = new DataManipulationClass(); DataTable dtLinkDetail = new DataTable(); string strPagination = ""; string strError = ""; int intPageNo = 1; string Status = ""; int intTotalProd = 0; if (Request.QueryString["SiteId"] != null && Request.QueryString["Status"] != null) { Status = Convert.ToString(Request.QueryString["Status"]); string strCurrentSubPageName = ""; ArrayList arrExistProd = new ArrayList(); if (Request.QueryString["pageno"] != null) { intPageNo = Convert.ToInt32(Request.QueryString["pageno"]); } if (objdata.FetchLinkDetailsViewData(ref dtLinkDetail, Convert.ToString(Request.QueryString["SiteId"]), Convert.ToString(Request.QueryString["SubPageId"]), Request.QueryString["Status"], ref intTotalProd, intPageNo, 25, ref strPagination, ref strError)) { rptLinkDetail.Visible = true; rptLinkDetail.DataSource = dtLinkDetail; rptLinkDetail.DataBind(); foreach (RepeaterItem rpt in rptLinkDetail.Items) { HtmlImage btnSendMail = (HtmlImage)rpt.FindControl("btnSendMail"); HtmlGenericControl spReject = (HtmlGenericControl)rpt.FindControl("spReject"); HtmlGenericControl spApproved = (HtmlGenericControl)rpt.FindControl("spApproved"); HtmlGenericControl spViewOurLink = (HtmlGenericControl)rpt.FindControl("spViewOurLink"); HtmlGenericControl hdReciprocal = (HtmlGenericControl)rpt.FindControl("hdReciprocal"); //if (hdReciprocal.InnerHtml.ToString().Trim() != "") //{ // spViewOurLink.InnerHtml = "<a href=" + hdReciprocal.InnerHtml + " target=\"_blank\">Our Link</a>"; //} //else //{ //} Literal lit_SlNo = (Literal)rpt.FindControl("lit_SlNo"); if (Status == "2") { //btnApproved.Visible = false; spApproved.Visible = false; } if (Status == "3") { //btnApproved.Visible = false; spApproved.Visible = false; spReject.Visible = false; } HtmlGenericControl spSubPageName = (HtmlGenericControl)rpt.FindControl("spSubPageName"); // strCurrentSubPageName = Convert.ToString(drCat["SubPageName"].ToString()); strCurrentSubPageName = spSubPageName.InnerHtml.ToString().Trim(); if (!arrExistProd.Contains(strCurrentSubPageName)) { spSubPageName.InnerHtml = strCurrentSubPageName; arrExistProd.Add(strCurrentSubPageName); } else { spSubPageName.InnerHtml = ""; } } lblPage.Text = strPagination; } hdSiteId.Value = Convert.ToString(Request.QueryString["SiteId"]); hdStatus.Value = Convert.ToString(Request.QueryString["Status"]); hdPagecount.Value = Convert.ToString(intTotalProd); hdFrom.Value = Convert.ToString(((intPageNo - 1) * 25) + 1); hdTo.Value = Convert.ToString(intPageNo * 25); lblSiteName.Text = objdata.getSiteName(Convert.ToString(Request.QueryString["SiteId"])); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script>document.getElementById(\"dvRpt\").style.display=\"block\"</script>"); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert2", "<script>document.getElementById(\"dvSubPageWise\").style.display=\"none\"</script>"); } else if (Request.QueryString["SubPageId"] != null && Request.QueryString["Status"] != null) { if (Request.QueryString["pageno"] != null) { intPageNo = Convert.ToInt32(Request.QueryString["pageno"]); } if (objdata.FetchLinkDetailsViewData(ref dtLinkDetail, Convert.ToString(Request.QueryString["SiteId"]), Convert.ToString(Request.QueryString["SubPageId"]), Request.QueryString["Status"], ref intTotalProd, intPageNo, 25, ref strPagination, ref strError)) { if (dtLinkDetail.Rows.Count > 0) { rptSubPageWise.Visible = true; // dtLinkDetail = getSerialNumberToDataTable(dtLinkDetail, intInner); rptSubPageWise.DataSource = dtLinkDetail; rptSubPageWise.DataBind(); foreach (RepeaterItem rpt in rptSubPageWise.Items) { HtmlImage btnSendMail = (HtmlImage)rpt.FindControl("btnSendMail"); HtmlGenericControl spReject = (HtmlGenericControl)rpt.FindControl("spReject"); HtmlGenericControl spApproved = (HtmlGenericControl)rpt.FindControl("spApproved"); HtmlGenericControl spViewOurLink = (HtmlGenericControl)rpt.FindControl("spViewOurLink"); HtmlGenericControl hdReciprocal = (HtmlGenericControl)rpt.FindControl("hdReciprocal"); //if (hdReciprocal.InnerHtml.ToString().Trim() != "") //{ // spViewOurLink.InnerHtml = "<a href=" + hdReciprocal.InnerHtml + " target=\"_blank\">Our Link</a>"; //} //else //{ //} if (Status == "2") { spApproved.Visible = false; } if (Status == "3") { spApproved.Visible = false; spReject.Visible = false; } } } else { rptSubPageWise.Visible = false; } lblPageSubPageWise.Text = strPagination; } hdSubPageId.Value = Convert.ToString(Request.QueryString["SubPageId"]); hdStatus.Value = Convert.ToString(Request.QueryString["Status"]); hdPagecount.Value = Convert.ToString(intTotalProd); hdFrom.Value = Convert.ToString(((intPageNo - 1) * 25) + 1); hdTo.Value = Convert.ToString(intPageNo * 25); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script>document.getElementById(\"dvRpt\").style.display=\"none\"</script>"); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert2", "<script>document.getElementById(\"dvSubPageWise\").style.display=\"block\"</script>"); lblSiteName.Text = objdata.getSubPageName(Convert.ToString(Request.QueryString["SubPageId"])); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { populateStateddl(); Response.Write("Visiotrnmber:" + Convert.ToString(Application["activeVisitors"])); } string strErr = ""; Login objlogin = new Login(); objlogin.username = "******"; objlogin.Address2 = "bb"; DataManipulationClass objdata = new DataManipulationClass(); objdata.AddExpert(objlogin, ref strErr); ArrayList MyList = new ArrayList(); MyList.Add(1); MyList.Add(2); MyList.Add(3); MyList.Add(4); MyList.Add(5); // Create an iEnumerator object IEnumerator iEnum = MyList.GetEnumerator(); // Loop through the data using the iEnumerator while (iEnum.MoveNext()) { Response.Write((iEnum.Current.ToString()) + "<br>"); } List <User> users = new List <User>(); for (int x = 0; x < 5; x++) { User user = new User(); user.Name = "Rob" + x; user.Age = x; users.Add(user); } //foreach (User user in users) //{ // Response.Write(System.String.Format("{0}:{1}", user.Name, user.Age)+"<br>"); //} Response.Write("<br>"); // System.Console.ReadLine(); //for (int x = 0; x < users.Count; x++) //{ // Response.Write(System.String.Format("{0}:{1}", users[x].Name, users[x].Age)); //} IEnumerator <User> ie = users.GetEnumerator(); // Loop through the data using the iEnumerator while (ie.MoveNext()) { Response.Write(ie.Current.Name.ToString() + ":" + ie.Current.Age.ToString() + "<br>"); } // List lst = new List(); //lst.add("Abhishek"); //lst.add("Abhijit"); //lst.add("Manimoy"); //lst.Add("Raj"); //lst.Add("Ayan"); //foreach(string x in lst){ //if(x.length >5) //yeild return x; // } }