using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration ;
namespace Plentyoffish
{
	/// <summary>
	/// Summary description for history.
	/// </summary>
	public partial class history : System.Web.UI.Page
	{
		public bool Authorized = false;
					public string MailText="<font color='#000000'>MAIL/PROFILE";
		public string MessageOutput="";
		public string totalmessages="";
public string SID="";
	public string Postto = "history.aspx";
		public string Guid="";
        public System.Text.StringBuilder SecondResults;
		protected void Page_Load(object sender, System.EventArgs e)
		{
	
			
				if ( Session["username"]== null)  
				{
					UserManagement UserData = new UserManagement();
					Authorized = UserData.LoginInfo();
					UserData=null;
				}
				else
				{
					Authorized=true;
				}
			
			
				
		
			if (Session["user_id"] !=null)
			{
				UserManagement UserData = new UserManagement();
				MailText = UserData.HasMessagesInboxMenu();
				SID = UserData.SessionSync();
				UserData=null;
					
			}
			if (Authorized)
			{
				if (Session["Guid"]!=null)
				{
					Guid=Session["Guid"].ToString();
				}
				if (Session["user_id"] !=null)
				{
					UserManagement UserData = new UserManagement();
					MailText = UserData.HasMessages();
					UserData=null;

					
				}
				if (Request.Form.Get("Deletemessageid") != null )  
				{
					//SqlConnection  Conn;
					//Conn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
					//Conn.Open();

					//SqlCommand   SqlCMD =null;
					//SqlCommand   SqlCMDB  =null;
					try
					{
                          string msgid = Request["Deletemessageid"].ToString();
                          if (msgid.IndexOf(",") > 0)
                          {
                              DeleteManyMessages(msgid);
                           //   SqlCMD = new SqlCommand("update datingmessages..messages set deleted=1 where sender_id =" + Session["user_id"].ToString() + " and message_id in (" + Request.Form.Get("Deletemessageid").Replace("'", "") + ")", Conn);
                            //  SqlCMD.ExecuteNonQuery();
                            //  SqlCMD.Dispose();
                            
                          }
                          else
                          {
                              Deletemessage(msgid);
                          }
						
						  // SqlCMDB = new SqlCommand("delete from messagesb where sender_id =" + Session["user_id"].ToString() + " and message_id in ("+ Request.Form.Get("Deletemessageid").Replace("'","")  +")", Conn);
					
						//SqlCMDB.ExecuteNonQuery();
						
					}
					finally
					{
						
						//SqlCMDB.Dispose();
                      //  Conn.Close();
					}

                    SaveNonQuery("Update_usersmail");

					

				}
			
				GetMessageHistory();
			}


		

			// Put user code to initialize the page here
		}
        private void SaveNonQuery(string procedure)
        {


            SqlDataReader reader = null;
            DataProvider dp = new DataProvider(procedure);
            dp.AddParameter("@user_id", Session["user_id"].ToString(), SqlDbType.Int);
            //  dp.AddParameter(name, value, SqlDbType.Int);


            dp.ExecuteNonQuery();
            dp.Close();

        }
        private void DeleteManyMessages(string messages)
        {
            SqlConnection myConnection = null;

            int counter = 65;
            string SQL = "";
            SqlCommand sqlCommand = null;

            string seperator = ",";
            char[] delimiter = seperator.ToCharArray();

            string[] message = messages.Split(delimiter);

            foreach (string s in message)
            {

                if (s != "")
                {
                    if (counter == 65)
                    {
                        SQL = "@message_id" + Convert.ToString((char)counter).ToString();

                    }
                    else
                    {
                        SQL = SQL + ",@message_id" + Convert.ToString((char)counter).ToString();
                    }
                    counter++;
                }

            }

            myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
            myConnection.Open();
            sqlCommand = new SqlCommand("update datingmessages..messages set deleted=1 where sender_id =" + Session["user_id"].ToString() + " and message_id in (" + SQL + ")", myConnection);
            // Response.Write("update datingmessages..messages set messagedeleted=  1 where reciever_id =" + Session["user_id"].ToString() + " and message_id in (" + SQL + ")");
            counter = 65;
            foreach (string s in message)
            {

                if (s != "")
                {

                    sqlCommand.Parameters.AddWithValue("@message_id" + Convert.ToString((char)counter).ToString(), s);
                    //   Response.Write("@message_id" + Convert.ToString((char)counter).ToString() +s);
                    counter++;
                }

            }
            sqlCommand.ExecuteNonQuery();
        }
        private void Deletemessage(string value)
        {


            SqlDataReader reader = null;
            DataProvider dp = new DataProvider("messages_delete_sentmessage");
            dp.AddParameter("@user_id", Session["user_id"].ToString(), SqlDbType.Int);
              dp.AddParameter("@message_id", value, SqlDbType.Int);


            dp.ExecuteNonQuery();
            dp.Close();

        }
		private void GetMessageHistory()
		{
			System.Text.StringBuilder OutputString = new System.Text.StringBuilder();

			string SQLProc="";
            int page_id = 0;
			if (Request["page_id"] ==null  )
			{
				SQLProc="GetMessagehistoryNonPaged";
			}
			else
			{
				SQLProc="GetMessagehistoryPaged";
			}
			DataProvider dp = new DataProvider(SQLProc);
			dp.AddParameter ("@user_id",Session["user_id"].ToString(), SqlDbType.VarChar);
			
			if (Request["page_id"] !=null )
			{
                try
                {
                    page_id = Int32.Parse(Request["page_id"].ToString());
                }
                catch {
                }

                dp.AddParameter("@page_id", page_id.ToString(), SqlDbType.TinyInt);
				dp.AddParameter ("@pagesize",ConfigurationSettings.AppSettings["emailpagesize"].ToString(), SqlDbType.TinyInt);
			
			}
			else
			{
					
			}
			SqlDataReader reader =null;
			try
			{
				reader = dp.ExecuteSqlDataReader();

				if (Request["page_id"] !=null )
				{
                    int MaxLastPage = 0;
                    if (page_id > 0)
                    {
                        MaxLastPage = Int32.Parse(ConfigurationSettings.AppSettings["emailpagesize"].ToString()) * page_id;
                    }
					int skiprows=0;
					bool hasbeen=false;
					
					while (reader.Read())
					{
						totalmessages = reader["messagessent"].ToString()   ;
						if (skiprows==0 && hasbeen==false)
						{
							if (MaxLastPage > Int32.Parse(totalmessages))
							{
								hasbeen=true;
								skiprows = MaxLastPage - Int32.Parse(totalmessages);
									
							}
						}
						if (skiprows==0)
						{
							OutputString.Append("<TR width=\"100%\" class=tablebody><TD ><INPUT name=Deletemessageid type=checkbox value=\"");
							OutputString.Append(reader["message_id"]);
							OutputString.Append("\"></TD><TD align=left >");
         
							OutputString.Append(reader["profile_idb"].ToString());
            
							OutputString.Append("</TD><TD align=left Align=center>&nbsp;&nbsp;<FONT face=arial,helvetica size=2><A href=\"viewmessage.aspx?message_id=");
							OutputString.Append(reader["message_id"].ToString());
							OutputString.Append("&SID=");
							OutputString.Append(SID);
							OutputString.Append("&Guid=");
							OutputString.Append(Guid);
							OutputString.Append("\">");
							OutputString.Append(reader["subjectline"].ToString());
							OutputString.Append("</A></B></FONT></TD><TD nowrap  Align=center>");
							OutputString.Append(reader["sentdate"].ToString());
							OutputString.Append("</FONT></TD>");
							OutputString.Append("<TD  Align=center>");
							OutputString.Append(reader["unread"].ToString());
							OutputString.Append(" </FONT></TD></TR>");
						}
						else
						{
							skiprows--;
						}
					}
				}
				else
				{
					while (reader.Read())
					{
						totalmessages = reader["messagessent"].ToString()   ;
					

						OutputString.Append("<TR width=\"100%\" class=tablebody><TD ><INPUT name=Deletemessageid type=checkbox value=\"");
						OutputString.Append(reader["message_id"].ToString());
						OutputString.Append("\"></TD><TD align=left >");
         
						OutputString.Append(reader["profile_idb"]);
            
						OutputString.Append("</TD><TD align=left Align=center>&nbsp;&nbsp;<FONT face=arial,helvetica size=2><A href=\"viewmessage.aspx?message_id=");
						OutputString.Append(reader["message_id"].ToString());
						OutputString.Append("&SID=");
						OutputString.Append(SID);
						OutputString.Append("&Guid=");
						OutputString.Append(Guid);
						OutputString.Append("\">");
						OutputString.Append(reader["subjectline"].ToString());
						OutputString.Append("</A></B></FONT></TD><TD  nowrap Align=center>");
						OutputString.Append(reader["sentdate"].ToString());
						OutputString.Append("</FONT></TD>");
						OutputString.Append("<TD  Align=center>");
						OutputString.Append(reader["unread"].ToString());
						OutputString.Append(" </FONT></TD></TR>");


					}
				}
			}
			finally
			{
				
				reader.Close();
				dp.Close();
				dp=null;
			}
				MessageOutput=OutputString.ToString();
		}
		public void GenerateMenu()
		{
			try
			{
				int totalmessagesnumeric= 0;
				if (totalmessages!="")
				{
					totalmessagesnumeric=	Int32.Parse(totalmessages);
				}
				int MessagesPerPage = Int32.Parse(ConfigurationSettings.AppSettings["emailpagesize"].ToString());
				int currentpage= 1;
			
				try
				{
					if (Request["page_id"] ==null )
					{

					}
					else
					{
						currentpage= Int32.Parse(Request["page_id"].ToString() );
					}
				}
				catch (Exception Ex) 
				{

					HtmlErrorC.sendHtmlcustomError(Ex, ConfigurationSettings.AppSettings["mailhost"],"History screwup");

				}
			
				try
				{
					if (Request["page_id"] ==null ||Request["page_id"].ToString() =="1" )
					{

					}
					else
					{
						currentpage= Int32.Parse(Request["page_id"].ToString() );
					}
				}
				catch
				{
				}

				if (totalmessagesnumeric > MessagesPerPage)
				{
					Response.Write("More Email --></font>");
					int modval =  totalmessagesnumeric % MessagesPerPage;
					int PagesTodisplay = ((totalmessagesnumeric-modval)/MessagesPerPage)+1;
                    if (totalmessagesnumeric % MessagesPerPage == 0)
                    {
                        PagesTodisplay--;
                    }
                    if (PagesTodisplay > 30)
					{
						PagesTodisplay=30;
					}
					for (int i=1;i<=PagesTodisplay;i++)
					{
						if (currentpage==i)
						{
							Response.Write(i+"&nbsp;");
			
						}
						else
						{
							Response.Write("<a href=history.aspx?Guid="+Guid+"&SID=" + SID +"&page_id="+i+">"+i+"</a>&nbsp;");
			
						}
					}
	
			
				}
			}
			catch (Exception Ex) 
			{

				HtmlErrorC.sendHtmlcustomError(Ex, ConfigurationSettings.AppSettings["mailhost"],"History Menu");

			}
		}
        public void GetPeopleCloseBy()
        {

            SecondResults = new System.Text.StringBuilder();

            DisplayResults DisplayImage = new DisplayResults();
            try
            {
                

                    //string outputstring;
                    int counter = 0;

                    string SQLConnection = ConfigurationSettings.AppSettings["connectionString_replicated_B"].ToString();
                    SqlConnection sqlcon = new SqlConnection(SQLConnection);
                    SqlCommand sqlCommand = null;
                    SqlDataAdapter adapter = new SqlDataAdapter();

                    if (Session["profile_id"] != null && Session["profile_id"].ToString().Trim() != "")
                    {
                        //SQL="Select_peopleclosebyprofile_id " + Session["profile_id"].ToString();
                        sqlCommand = new SqlCommand("Select_peopleclosebyprofile_id", sqlcon);
                        sqlCommand.CommandType = CommandType.StoredProcedure;

                        adapter.SelectCommand = sqlCommand;
                        SqlParameter myParam = new SqlParameter("@profile_id", SqlDbType.Int);
                        myParam.Direction = ParameterDirection.Input;
                        myParam.Value = Session["profile_id"].ToString();
                        adapter.SelectCommand.Parameters.Add(myParam);
                    }
                    else
                    {
                        //SQL="Select_peoplecloseby " + Session["user_id"].ToString();
                        sqlCommand = new SqlCommand("Select_peoplecloseby", sqlcon);
                        sqlCommand.CommandType = CommandType.StoredProcedure;

                        adapter.SelectCommand = sqlCommand;
                        SqlParameter myParam = new SqlParameter("@user_id", SqlDbType.Int);
                        myParam.Direction = ParameterDirection.Input;
                        myParam.Value = Session["user_id"].ToString();
                        adapter.SelectCommand.Parameters.Add(myParam);
                    }
                    //sqlCommand = new SqlCommand(SQL, myConnectionB);
                    //SqlConnection sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["connectionString_replicated"]);
                    //SqlDataAdapter adapter= new SqlDataAdapter(SQL, sqlcon);
                    sqlcon.Open();
                    DataSet dataset = new DataSet();
                    adapter.Fill(dataset, "mytable");
                    //readerB =  sqlCommand.ExecuteReader();


                    if (dataset.Tables["mytable"].Rows.Count > 28)
                    {


                        int totalrows = dataset.Tables["mytable"].Rows.Count;
                        Random RandomClass = new Random();
                        int tempval = RandomClass.Next(0, 7);

                        int ranvarA = 1;
                        int ranvarB = 2;
                        int ranvarC = 3;
                        int ranvarD = 4;
                        int ranvare = 5;
                        int ranvarf = 6;
                        int ranvarg = 7;
                        int ranvarh = 8;
                        int ranvari = 9;
                        int ranvarj = 10;
                        switch (tempval)
                        {
                            case 1:

                                ranvarA = 1;
                                ranvarB = 6;
                                ranvarC = 8;
                                ranvarD = 13;
                                ranvare = 17;
                                ranvarf = 19;
                                ranvarg = 20;
                                ranvarh = 23;
                                ranvari = 25;
                                ranvarj = 26;
                                break;
                            case 2:
                                ranvarA = 2;
                                ranvarB = 3;
                                ranvarC = 7;
                                ranvarD = 9;
                                ranvare = 11;
                                ranvarf = 14;
                                ranvarg = 16;
                                ranvarh = 18;
                                ranvari = 19;
                                ranvarj = 24;
                                break;
                            case 3:
                                ranvarA = 4;
                                ranvarB = 7;
                                ranvarC = 12;
                                ranvarD = 15;
                                ranvare = 16;
                                ranvarf = 19;
                                ranvarg = 22;
                                ranvarh = 25;
                                ranvari = 26;
                                ranvarj = 27;
                                break;
                            case 4:
                                ranvarA = 1;
                                ranvarB = 2;
                                ranvarC = 4;
                                ranvarD = 7;
                                ranvare = 9;
                                ranvarf = 11;
                                ranvarg = 16;
                                ranvarh = 19;
                                ranvari = 21;
                                ranvarj = 23;
                                break;
                            case 5:
                                ranvarA = 9;
                                ranvarB = 10;
                                ranvarC = 11;
                                ranvarD = 12;
                                ranvare = 13;
                                ranvarf = 14;
                                ranvarg = 15;
                                ranvarh = 16;
                                ranvari = 17;
                                ranvarj = 18;
                                break;
                            case 6:
                                ranvarA = 17;
                                ranvarB = 18;
                                ranvarC = 19;
                                ranvarD = 20;
                                ranvare = 21;
                                ranvarf = 22;
                                ranvarg = 23;
                                ranvarh = 24;
                                ranvari = 26;
                                ranvarj = 27;
                                break;
                            case 7:
                                ranvarA = 1;
                                ranvarB = 3;
                                ranvarC = 5;
                                ranvarD = 7;
                                ranvare = 11;
                                ranvarf = 13;
                                ranvarg = 17;
                                ranvarh = 19;
                                ranvari = 23;
                                ranvarj = 24;
                                break;
                        }


                        System.Text.StringBuilder OutputString = new System.Text.StringBuilder();
                       
                            OutputString.Append("<table class=tsbheader><tr>");
                        
                        SecondResults.Append("<table class=tsbheader><tr>");
                        int subcounter = 0;
                        foreach (DataRow d in dataset.Tables["mytable"].Rows)
                        {


                            counter++;
                            bool used = false;
                            string IMme = "";
                            try
                            {
                                if (Int32.Parse(d["minsincelastvisit"].ToString()) < 15 && d["allowim"].ToString() == "True")
                                {
                                    IMme = "<br><center><a href=\"\" onClick=\"javascript: up_launchIC( '" + Session["profile_id"].ToString() + "', '" + d["profile_id"] + "' ); return false;\"><font color=green>IM User</font></a></center>";
                                }
                            }
                            catch (Exception Ex)
                            {

                                HtmlErrorC.sendHtmlcustomError(Ex, ConfigurationSettings.AppSettings["mailhost"], "Inbox IM");

                            }

                            if (counter <= ranvare)
                            {
                                if (counter == ranvarA || ranvarB == counter || ranvarC == counter || ranvarD == counter || ranvare == counter)
                                {
                                    used = true;
                                    if (d["image_locationb"].ToString() != null && d["image_locationb"].ToString().ToLower().IndexOf("plentyof") > 0)
                                    {
                                        OutputString.Append("<td style='width: 75px;'  valign=top><div class=\"rc\"><a href='member");
                                        OutputString.Append(d["profile_id"].ToString());
                                        OutputString.Append(".htm' class='mi'><img src='");
                                        OutputString.Append(DisplayImage.ImageDisplay(d["image_locationb"].ToString(), d["profile_id"].ToString(), ""));

                                        OutputString.Append("' border=0 ></img></a>");
                                        OutputString.Append(IMme + "</div></td>");
                                    }
                                    else
                                    {
                                        OutputString.Append("<td style='width: 75px; border: 1px solid #9BACB4;' ><div class=\"rc\" ><a href='member");
                                        OutputString.Append(d["profile_id"].ToString());
                                        OutputString.Append(".htm' class='mi'>");
                                        OutputString.Append(d["username"].ToString());
                                        OutputString.Append("</a><br> Age: ");
                                        OutputString.Append(d["age"].ToString());
                                        OutputString.Append("<br>");
                                        OutputString.Append(SearchType(d["searchtypes"].ToString()));

                                        OutputString.Append(IMme + "</div></td>");

                                    }
                                }
                            }
                            else
                            {


                                if (counter == ranvarf || ranvarg == counter || ranvarh == counter || ranvari == counter || ranvarj == counter)
                                {
                                    used = true;
                                    if (d["image_locationb"].ToString() != null && d["image_locationb"].ToString().ToLower().IndexOf("plentyof") > 0)
                                    {
                                        OutputString.Append("<td style='width: 75px;'  valign=top><div class=\"rc\"><a href='member");
                                        OutputString.Append(d["profile_id"].ToString());
                                        OutputString.Append(".htm' class='mi'><img src='");
                                        OutputString.Append(DisplayImage.ImageDisplay(d["image_locationb"].ToString(), d["profile_id"].ToString(), ""));

                                        OutputString.Append("' border=0 ></img></a>");
                                        OutputString.Append(IMme + "</div></td>");
                                    }
                                    else
                                    {
                                        OutputString.Append("<td style='width: 75px; border: 1px solid #9BACB4;' ><div class=\"rc\" ><a href='member");
                                        OutputString.Append(d["profile_id"].ToString());
                                        OutputString.Append(".htm' class='mi'>");
                                        OutputString.Append(d["username"].ToString());
                                        OutputString.Append("</a><br> Age: ");
                                        OutputString.Append(d["age"].ToString());
                                        OutputString.Append("<br>");
                                        OutputString.Append(SearchType(d["searchtypes"].ToString()));

                                        OutputString.Append(IMme + "</div></td>");

                                    }
                                }
                            }

                            if (!used && subcounter < 10)
                            {
                                subcounter++;
                                if (d["image_locationb"].ToString() != null && d["image_locationb"].ToString().ToLower().IndexOf("plentyof") > 0)
                                {
                                    SecondResults.Append("<td style='width: 75px;'  valign=top><div class=\"rc\"><a href='member");
                                    SecondResults.Append(d["profile_id"].ToString());
                                    SecondResults.Append(".htm' class='mi'><img src='");
                                    SecondResults.Append(DisplayImage.ImageDisplay(d["image_locationb"].ToString(), d["profile_id"].ToString(), ""));

                                    SecondResults.Append("' border=0 ></img></a>");
                                    SecondResults.Append(IMme + "</div></td>");
                                }
                                else
                                {
                                    SecondResults.Append("<td style='width: 75px; border: 1px solid #9BACB4;' ><div class=\"rc\" ><a href='member");
                                    SecondResults.Append(d["profile_id"].ToString());
                                    SecondResults.Append(".htm' class='mi'>");
                                    SecondResults.Append(d["username"].ToString());
                                    SecondResults.Append("</a><br> Age: ");
                                    SecondResults.Append(d["age"].ToString());
                                    SecondResults.Append("<br>");
                                    SecondResults.Append(SearchType(d["searchtypes"].ToString()));

                                    SecondResults.Append(IMme + "</div></td>");

                                }
                            }

                            used = false;

                            if (counter >= ranvarj && subcounter == 10)
                            {
                                SecondResults.Append("</tr></table>");
                                OutputString.Append("</tr></table>");
                                break;
                            }


                        }

                        Response.Write(OutputString);
                        //	sqlCommand.Dispose();
                        //	readerB.Close();
                        //	myConnectionB.Close();
                    }
                    else
                    {
                        Session["skip"] = "1";
                        GenerateStateLevel();
                    }

                    sqlcon.Close();
                    dataset.Dispose();
                    adapter.Dispose();
                    sqlCommand.Dispose();
               

            }
            catch (Exception Ex)
            {

                HtmlErrorC.sendHtmlcustomError(Ex, ConfigurationSettings.AppSettings["mailhost"], "Inbox screwup");

            }
        }
        private void GenerateStateLevel()
        {
            DisplayResults DisplayImage = new DisplayResults();
            if (Session["skipb"] == null || Session["skipb"].ToString() != "1")
            {



                int counter = 0;
                string SQLConnection = ConfigurationSettings.AppSettings["connectionString_replicated"].ToString();
                SqlConnection sqlcon = new SqlConnection(SQLConnection);
                SqlCommand sqlCommand = null;
                SqlDataAdapter adapter = new SqlDataAdapter();


                //SQL="Select_peoplecloseby " + Session["user_id"].ToString();
                sqlCommand = new SqlCommand("Select_peopleStatecloseby", sqlcon);
                sqlCommand.CommandType = CommandType.StoredProcedure;

                adapter.SelectCommand = sqlCommand;
                SqlParameter myParam = new SqlParameter("@user_id", SqlDbType.Int);
                myParam.Direction = ParameterDirection.Input;
                myParam.Value = Session["user_id"].ToString();
                adapter.SelectCommand.Parameters.Add(myParam);

                sqlcon.Open();

                DataSet dataset = new DataSet();
                adapter.Fill(dataset, "mytable");
                //readerB =  sqlCommand.ExecuteReader();
                if (dataset.Tables["mytable"].Rows.Count > 28)
                {

                    System.Text.StringBuilder OutputString = new System.Text.StringBuilder();

                    OutputString.Append("<table class=tsbheader><tr><td colspan=11 align=center>Last 10 people to check their mail, within 50 miles.  IM User= Instant Message a <a href='lastonlinemycity.aspx'>user online right now</a>.</td></tr><tr>");

                    foreach (DataRow d in dataset.Tables["mytable"].Rows)
                    {


                        counter++;
                        if (counter < 11)
                        {
                            string IMme = "";

                            try
                            {
                                if (Int32.Parse(d["minsincelastvisit"].ToString()) < 12 && d["allowim"].ToString() == "True")
                                {
                                    IMme = "<br><center><a href=\"\" onClick=\"javascript: up_launchIC( '" + Session["profile_id"].ToString() + "', '" + d["profile_id"] + "' ); return false;\"><font color=green>IM User</font></a></center>";
                                }
                            }
                            catch (Exception Ex)
                            {

                                HtmlErrorC.sendHtmlcustomError(Ex, ConfigurationSettings.AppSettings["mailhost"], "Inbox IM");

                            }
                            if (d["image_locationb"].ToString() != null && d["image_locationb"].ToString().ToLower().IndexOf("plentyof") > 0)
                            {
                                OutputString.Append("<td style='width: 75px;' valign=top><div class=\"rc\"><a href='member");
                                OutputString.Append(d["profile_id"].ToString());
                                OutputString.Append(".htm#in' class='mi'><img src='");
                                OutputString.Append(DisplayImage.ImageDisplay(d["image_locationb"].ToString(), d["profile_id"].ToString(), ""));

                                OutputString.Append("' border=0 alt=\"");

                                //  OutputString.Append(d["age"].ToString());
                                // OutputString.Append(" seeking " + SearchType(d["searchtypes"].ToString()));
                                OutputString.Append("\" ></a>");
                                OutputString.Append(IMme + "</div></td>");
                            }
                            else
                            {

                                OutputString.Append("<td style='width: 75px; border: 1px solid #9BACB4;' ><div class=\"rc\" ><a href='member");


                                OutputString.Append(d["profile_id"].ToString());
                                OutputString.Append(".htm#in' class='mi'>");
                                OutputString.Append(d["username"].ToString());
                                OutputString.Append("</a><br> Age: ");
                                OutputString.Append(d["age"].ToString());
                                OutputString.Append("<br>");
                                OutputString.Append(SearchType(d["searchtypes"].ToString()));
                                OutputString.Append(IMme);
                                OutputString.Append("</div></td>");

                            }

                        }
                        else
                        {
                            break;
                        }
                    }

                    Response.Write(OutputString);
                    //	sqlCommand.Dispose();
                    //	readerB.Close();
                    //	myConnectionB.Close();
                }
                else
                {
                    Session["skip"] = "1";

                }
                sqlcon.Close();
                dataset.Dispose();
                adapter.Dispose();
                sqlCommand.Dispose();
            }


        }
        public string Getmenu()
        {
            SitemainMenu BuildMenue = new SitemainMenu();
            return BuildMenue.MainMenuBuilder(MailText, 7);

        }
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
		}
		#endregion
	}
}