My Blog

Friday, November 26, 2010

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;
using System.Xml;

public partial class User_userHome : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("connString"));
    SqlCommand cmd;
    SqlDataReader dr,drdr;
    DBUpdate userNews = new DBUpdate();

    protected void Page_Load(object sender, EventArgs e)
    {
        string name = "";

        int idUser = Convert.ToInt32(Session["idUser"]);

        userNews.cmd.Parameters.Clear();

        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        userNews.cmd.Parameters.Add(p);
        userNews.cmd.Parameters.AddWithValue("@userid", idUser);

        string fetchrow = "select * from userRegistration,tblUser where userRegistration.userId = tblUser.registrationid and tblUser.userid = " + idUser;

        drdr = userNews.datareader(fetchrow);
        while (userNews.dr.Read())
        {

            name = drdr["firstname"].ToString();
        }
        lblWelcome.Text = "Welcome " + name;

    }

    protected void dnldBtn_Click(object sender, ImageClickEventArgs e)
    {

        XmlTextReader reader = null;

        try
        {

            reader = new XmlTextReader("D:\\Lis\\RssNews\\User\\RssXml.xml");

            DataSet ds = new DataSet();

            ds.ReadXml(reader);
            //GridView1.DataSource = ds.Tables["item"];
            //GridView1.DataBind();

            Response.ContentType = "application/octet-stream";
            Response.ContentType = "application/x-download";
            Response.AddHeader("Content-Disposition", "attachment;filename=" + "RssXml.xml");

            Response.WriteFile(Server.MapPath("RssXml.xml"));
            Response.End();

        }

        catch (Exception ex)
        {

            lblMessage.Text = ex.Message;

        }

        finally
        {

            reader.Close();

        }

    }
    protected void btnRss_Click(object sender, ImageClickEventArgs e)
    {
        String strFilePath = "D:\\Lis2008\\RssFeeds\\User\\RssXml.xml";

        XmlTextWriter writer = new XmlTextWriter(strFilePath, Encoding.UTF8);
        writer.WriteStartDocument();
        writer.WriteStartElement("rss");
        writer.WriteAttributeString("version", "2.0");
        writer.WriteString("\n\n");
        writer.WriteStartElement("channel");
        writer.WriteString("\n\n");
        userNews.getcon();
        cmd = new SqlCommand("select * from tblNews", con);
        cmd.Connection = userNews.con;
        dr = cmd.ExecuteReader();
        int cnt = 1;
        while (dr.Read())
        {
            if (cnt == 1)
            {
                writer.WriteString("\n");
                writer.WriteElementString("title", dr["Title"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("description", dr["description"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("link", dr["link"].ToString());
                writer.WriteString("\n");

            }
            else
            {
                writer.WriteStartElement("item");
                writer.WriteString("\n");
                writer.WriteElementString("title", dr["title"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("description", dr["description"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("link", dr["link"].ToString());
                writer.WriteString("\n");
                writer.WriteEndElement();
                writer.WriteString("\n");
            }
            cnt = cnt + 1;
        }

        con.Close();

        writer.WriteEndElement();
        writer.WriteEndElement();
        writer.Flush();

        writer.Close();
        Response.Redirect("RssXml.xml");
    }

    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        //     string gender;

        //    string firstname = txtFirstName.Text.ToString();
        //    string lastname = txtLastName.Text.ToString();
        //    string username = txtUsername.Text.ToString();
        //    string password = txtPassword.Text.ToString();
        //    string address = txtAddress.Text.ToString();
        //    string mobile = txtMobile.Text.ToString();
        //    string phone = txtPhone.Text.ToString();
        //    string email = txtEmail.Text.ToString();

        //    if (rdmale.Checked)
        //    {
        //        gender = "M";
        //    }
        //    else gender = "F";
        //     string status = "Active";
        //     userNews.cmd.Parameters.Clear();

        //     SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        //     p.Direction = ParameterDirection.ReturnValue;
        //     userNews.cmd.Parameters.Add(p);
        //     userNews.cmd.Parameters.AddWithValue("@firstname", txtFirstName.Text);
        //     userNews.cmd.Parameters.AddWithValue("@lastname", txtLastName.Text);
        //     userNews.cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        //     userNews.cmd.Parameters.AddWithValue("@password", txtPassword.Text);
        //     userNews.cmd.Parameters.AddWithValue("@address", txtAddress.Text);
        //     userNews.cmd.Parameters.AddWithValue("@mobile", txtMobile.Text);
        //     userNews.cmd.Parameters.AddWithValue("@phone", txtPhone.Text);
        //     userNews.cmd.Parameters.AddWithValue("@email", txtEmail.Text);
        //     userNews.cmd.Parameters.AddWithValue("@gender", gender);
        //     userNews.cmd.Parameters.AddWithValue("@status", status);

        //    ccJoin.ValidateCaptcha(txtCaptcha1.Text);
        //      if (ccJoin.UserValidated)
        //     {
        //         string s = userNews.excproc("userinsert");
        //         clientScriptAlert("Registered Successfully");
        //     }
        //     else
        //         return;
        //}
        //private void clientScriptAlert(string Message)
        //{
        //    Page.RegisterClientScriptBlock("clientScript", "<script>alert('" + Message + "')</script>");
        }

    }

Reporter Home

add news

add advertisements

dbupdate

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DBUpdate
/// </summary>
public class DBUpdate
{
    public DBUpdate()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("connString"));
    public SqlCommand cmd = new SqlCommand();
    public SqlDataAdapter ada = new SqlDataAdapter();
    public DataTable dt = new DataTable();
    public SqlDataReader dr;

    public SqlConnection getcon()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        return con;
    }
    public string excquery(string cmdtext)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = cmdtext;
            cmd.ExecuteNonQuery();
            return "1";

        }
        catch (Exception ex)
        {
            return ex.Message;
        }
    }
    public string excproc(string procname)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procname;
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            return "1";
        }
        catch (Exception ex)
        {
            return ex.Message;
        }

    }





    public DataTable gettable(string fetchcmd)
    {
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = fetchcmd;
        ada.SelectCommand = cmd;
        dt = new DataTable();
        ada.Fill(dt);
        return dt;

    }
    public SqlDataReader datareader(string fetchrow)
    {
        getcon();
        cmd.Connection = con;
        cmd.CommandText = fetchrow;
        dr = cmd.ExecuteReader();
        return dr;
        closeconnection();

    }

    public void closeconnection()
    {
        if (con.State != ConnectionState.Closed)
        {
            con.Close();
        }
    }

vwRegistrations using checkboxes

public partial class Admin_VwRegistrations : System.Web.UI.Page
{
    DBUpdate registration = new DBUpdate();
    DataTable dt = new DataTable();
    string rid;
    protected void Page_Load(object sender, EventArgs e)
    {

       // lblrid.Text = k;
        if (!Page.IsPostBack)
        {
            LoadData();

        }

    }
    private void LoadData()
    {
        //string constr = @"Server=.\SQLEXPRESS;Database=TestDB;uid=waqas;pwd=sql;";
        string query = @"SELECT * FROM tblReporterRegistration where status =''" ;
     try
        {
        SqlDataAdapter da = new SqlDataAdapter(query, registration.con);

            da.Fill(dt);
            object k = dt.Rows[0][0].ToString();
            lblrid.Text = k.ToString();
        }

       catch (Exception ex)
        {

             Response.Write("<script>alert('Existing Registrations are empty...')</script>");
             // clearall();
             StringBuilder sb = new StringBuilder();
             sb.Append("<script>");
             sb.Append("window.open('adminHome.aspx', '', '');");
             sb.Append("</scri");
             sb.Append("pt>");

             Page.RegisterStartupScript("test", sb.ToString());
        }

        GridView1.DataSource = dt;
        GridView1.DataBind();



}
       private void clientScriptAlert(string Message)
    {
        Page.RegisterClientScriptBlock("clientScript", "<script>alert('" + Message + "')</script>");
    }


    protected void CheckBox3_CheckedChanged(object sender, EventArgs e)
    {
       CheckBox chkStatus = (CheckBox)sender;
        GridViewRow row = (GridViewRow)chkStatus.NamingContainer;

          rid = lblrid.Text;

         // rid = row.Cells[1].Text;//(CheckBox)row.FindControl("cbRows")

        bool status = chkStatus.Checked;

       // CheckBox checkbox = (CheckBox)row.FindControl("regnId");

        registration.con.Open();

        string query = "UPDATE tblReporterRegistration SET status = 'Active' WHERE regnID = " + rid;
        string query2 = "UPDATE tblUser SET status = 'Active' WHERE registrationid = " + rid;

        //SqlConnection con = new SqlConnection(constr);
        SqlCommand com = new SqlCommand(query, registration.con);
        SqlCommand cmd = new SqlCommand(query2, registration.con);

        com.Parameters.Add("@Approved", SqlDbType.Bit).Value = status;
        com.Parameters.Add("@CategoryID", SqlDbType.Int).Value = rid;

      // registration.con.Open();
        com.ExecuteNonQuery();
        cmd.ExecuteNonQuery();
        registration.con.Close();
        LoadData();


}


    //protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    //{
    //    string strupdate = "update tblReporterRegistration set status = 'Active' where regnId = " + ;
    //    registration.excquery(strupdate);
    //}
    //protected void btnAccept_Click1(object sender, EventArgs e)
    //{
    //    string strupdate = "update tblReporterRegistration set status = 'Active' where regnId = " + rid;
    //    registration.excquery(strupdate);
    //}
    //protected void btnReject_Click1(object sender, EventArgs e)
    //{
    //    string strdelete = "delete from tblReporterRegistration   where regnId = " + rid;
    //    registration.excquery(strdelete);
    //}
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chkStatus = (CheckBox)sender;
        GridViewRow row = (GridViewRow)chkStatus.NamingContainer;

        rid = lblrid.Text;

        // rid = row.Cells[1].Text;//(CheckBox)row.FindControl("cbRows")

        bool status = chkStatus.Checked;

        // CheckBox checkbox = (CheckBox)row.FindControl("regnId");

        registration.con.Open();

        string query = "UPDATE tblReporterRegistration SET status = 'Active' WHERE regnID = " + rid;
        string query2 = "UPDATE tblUser SET status = 'Active' WHERE registrationid = " + rid;

        //SqlConnection con = new SqlConnection(constr);
        SqlCommand com = new SqlCommand(query, registration.con);
        SqlCommand cmd = new SqlCommand(query2, registration.con);

        com.Parameters.Add("@Approved", SqlDbType.Bit).Value = status;
        com.Parameters.Add("@CategoryID", SqlDbType.Int).Value = rid;

        // registration.con.Open();
        com.ExecuteNonQuery();
        cmd.ExecuteNonQuery();
        registration.con.Close();
        LoadData();

    }
}