4 Feb 2014

How to create an Admin Panel using ASP.NET (or) Asp.net Admin panel project free download

Admin panel pages differs from the normal web page. 
Admin panels are for managing the entire site whcih consist of following modules

1. Users
2. Contents
3. Permission of various pages.
4. Transactions (If website is performing any transaction)
5. Sending Newsletter ( If website has the provision for users to subscribe news letter).
So basically admin panels are for managing the website. So build/arrange your modules based on your actual website/webapplication.

This is the admin panel of Limited Job website. ( Asp.net C# & SQL2008)

LIST OF PAGES : 
AdminHome.aspx
JobSeekerAppliedJobs.aspx
JobSeekerAppliedJobsDetails.aspx
ListOfPostedJobs.aspx
ListOfRegCandidates.aspx
ModifyRegUsers.aspx
PostedJobsDetails.aspx

// Admin class file added below.

ADMIN HOME : 





AdminDal admdal = new AdminDal();

    protected void Page_Load(object sender, EventArgs e)
    {
        lbl_message.Text = "";
    }
    protected void btn_login_Click(object sender, ImageClickEventArgs e)
    {  
         try
         {
             Session["Admin"] = txt_user.Text;
          
              
            
             if (admdal.AdmLogin(txt_user.Text, txt_pwd.Text) == true)
             {
                 Response.Redirect("AdmHome.aspx");
             }
             else
             {
                 lbl_message.Text = "Invalid UserName/Password";
             }
         }
         catch (Exception)
         {

             throw;
         }
         

    }
=================================================================================

Lis tOf Registered Candidates :

here admin can view the all registered users and admin can activate user or admin can deactivate or delete user.






AdminDal AdmDal = new AdminDal();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"].ToString() == "")
        {
            Response.Redirect("AdminMain.aspx");
        }

    }
    protected void btnView_Click(object sender, EventArgs e)
    {
        try
        {
            Grd_AdminViewRegUsers.DataSource = AdmDal.AdminShowAllRegisterByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
            Grd_AdminViewRegUsers.DataBind();
        }
        catch (Exception)
        {
            if (txt_Fmdate.Text == "" && txt_Todate.Text == "")
            {
                Page.RegisterStartupScript("err1", "<script language='javascript'>alert('Please select dates');</script>");
               
            }
           
        }

    }
  
    protected void Grd_AdminViewRegUsers_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete")
        {
          
            AdmDal.JobSeekerId = e.CommandArgument.ToString();
            AdmDal.DeleteRegisterUserInfo();
            Grd_AdminViewRegUsers.DataSource = AdmDal.AdminShowAllRegisterByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
            Grd_AdminViewRegUsers.DataBind();
            

        }
        if (e.CommandName == "Update")
        {
            Session["UserEmail"] = e.CommandArgument.ToString();
            Response.Redirect("ModifyRegUsers.aspx");

        }

    }
    protected void Grd_AdminViewRegUsers_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        Grd_AdminViewRegUsers.PageIndex = e.NewPageIndex;
        try
        {
            Grd_AdminViewRegUsers.DataSource = AdmDal.AdminShowAllRegisterByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
            Grd_AdminViewRegUsers.DataBind();
        }
        catch (Exception)
        {

            throw;
        }

    }

================================================================================
JobSeeker Applied Jobs Details









AdminDal AdmDal = new AdminDal();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"].ToString() == "")
        {
            Response.Redirect("AdminMain.aspx");
        }
        BindGridview();
    }
    private void BindGridview()
    {
        Grd_AdmViewAppliedJobBiddrs.DataSource = AdmDal.AdminJobSeekerAppliedJobDetails();
        Grd_AdmViewAppliedJobBiddrs.DataBind();
    }
    protected void Grd_AdmViewAppliedJobBiddrs_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        {
            Grd_AdmViewAppliedJobBiddrs.PageIndex = e.NewPageIndex;
            BindGridview();

        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
    }
    protected void Grd_AdmViewAppliedJobBiddrs_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        try
        {
            Grd_AdmViewAppliedJobBiddrs.SelectedIndex = e.NewSelectedIndex;
            foreach (GridViewRow gr in Grd_AdmViewAppliedJobBiddrs.Rows)
            {
                if (gr.RowIndex == Grd_AdmViewAppliedJobBiddrs.SelectedIndex)
                {
                    Literal l;
                    l = (Literal)gr.FindControl("lblRegEmail");
                    Session["JobSeekerId"] = l.Text;
                    Response.Redirect("JobSeekerAppliedJobsDetails.aspx");
                }
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }

    }
=================================================================================
List of Posted Jobs: 

                                          


AdminDal AdmDal = new AdminDal();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"].ToString() == "")
        {
            Response.Redirect("AdminMain.aspx");
        }

    }
    protected void btnView_Click(object sender, EventArgs e)
    {
        try
        {
            Grd_AdminViewAllJobs.DataSource = AdmDal.AdminShowAllJobsByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
            Grd_AdminViewAllJobs.DataBind();
        }
        catch (Exception)
        {

            if (txt_Fmdate.Text == "" && txt_Todate.Text == "")
            {
                Page.RegisterStartupScript("err1", "<script language='javascript'>alert('Please select dates');</script>");

            }
        }

    }
    protected void Grd_AdminViewAllJobs_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        Grd_AdminViewAllJobs.PageIndex = e.NewPageIndex;
        try
        {
            Grd_AdminViewAllJobs.DataSource = AdmDal.AdminShowAllJobsByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
            Grd_AdminViewAllJobs.DataBind();
        }
        catch (Exception)
        {

            throw;
        }
    }
    protected void Grd_AdminViewAllJobs_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Update")
        {
            Session["JobId"] = e.CommandArgument.ToString();
            Response.Redirect("PostedJobsDetails.aspx");

        }
    }
    protected void Grd_AdminViewAllJobs_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Button btn;
        foreach (GridViewRow gr in Grd_AdminViewAllJobs.Rows)
        {
            btn = (Button)gr.FindControl("btndelete");
            AdmDal.JobSeekerId = btn.CommandArgument.ToString();
        }

        AdmDal.DeletePostedJob();
        Grd_AdminViewAllJobs.DataSource = AdmDal.AdminShowAllJobsByDate(Convert.ToDateTime(txt_Fmdate.Text), Convert.ToDateTime(txt_Todate.Text));
        Grd_AdminViewAllJobs.DataBind();

    }
=================================================================================Modify User :


AdminDal AdmDal = new AdminDal();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"].ToString() == "")
        {
            Response.Redirect("AdminMain.aspx");
        }
        if (!IsPostBack)
        {
            BindData();

        }

    }
    private void BindData()
    {
        AdmDal.JobSeekerId = Session["UserEmail"].ToString();
        DataSet ds = new DataSet();
        ds = AdmDal.GetAdminRegisteredUser();
        if (ds.Tables[0].Rows.Count > 0)
        {
            txtDName.Text = ds.Tables[0].Rows[0]["JR_DisplayName"].ToString();
            txteMail.Text = ds.Tables[0].Rows[0]["JR_Email"].ToString();
            txtFname.Text = ds.Tables[0].Rows[0]["JR_FirstName"].ToString();
            txtLname.Text = ds.Tables[0].Rows[0]["JR_LastName"].ToString();
            txtAddress.Text = ds.Tables[0].Rows[0]["JR_Address"].ToString();
            txtCity.Text = ds.Tables[0].Rows[0]["JR_City"].ToString();
            txtState.Text = ds.Tables[0].Rows[0]["JR_State"].ToString();
            txtCountry.Text = ds.Tables[0].Rows[0]["JR_Country"].ToString();
            string JType = ds.Tables[0].Rows[0]["JR_Type"].ToString();
            if (JType == "Poster")
           {
           
               RadioButtonList1.Items.FindByValue("Poster").Selected = true;
           }
            else
           {
               RadioButtonList1.Items.FindByValue("Seeker").Selected = true;

           }

        }
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Admin/ListOfRegCandidates.aspx");
    }
===============================================================

Admin class file:


public class AdminDal
{
    public static string username;
    public static string password;


  
    private string _JobSeekerId;
    public string JobSeekerId
    {
        get { return _JobSeekerId; }
        set { _JobSeekerId = value; }
    }
      public AdminDal()
      {
            //
            // TODO: Add constructor logic here
            //
      }
    public DataSet AdminShowAllRegisterByDate(DateTime FromDt, DateTime ToDt)
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_ViewRegUsers", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@FromDate", FromDt);
        cmd1.Parameters.AddWithValue("@ToDate", ToDt);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;

    }
    public void DeleteRegisterUserInfo()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Delete_Admin_RegisterUserInfo", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@Email", this._JobSeekerId);
        cmd1.ExecuteNonQuery();
        con.Close(); 
    }
    public DataSet GetAdminRegisteredUser()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_RegisteredUser", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@P_EmailId", this._JobSeekerId);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
    public DataSet AdminJobSeekerAppliedJobDetails()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_BiddedJobDetails", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
    public DataSet ShowAppliedJobDetailOfJobsseker()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_ShowAppliedJobDetailOfJobsseker", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@JobSeekerId", this._JobSeekerId);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;

    }
    public DataSet AdminShowAllJobsByDate(DateTime FromDt, DateTime ToDt)
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_ViewAllJobs", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@FromDate", FromDt);
        cmd1.Parameters.AddWithValue("@ToDate", ToDt);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;

    }
    public void DeletePostedJob()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Delete_Admin_PostedJob", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@JobId", this._JobSeekerId);
        cmd1.ExecuteNonQuery();
        con.Close();
    }
    public DataSet GetAdminSelectedJob()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_SelectedJobDetais", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@P_JobId", this._JobSeekerId);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
    public DataSet ShowBiddersAppliedToJob()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd1 = new SqlCommand("Get_Admin_BiddersAppliedToJob", con);
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Parameters.AddWithValue("@P_JobId", this._JobSeekerId);
        SqlDataAdapter da = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
    public bool AdmLogin(string Email, string Password)
    {
        int count;
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        SqlCommand cmdlogin1 = new SqlCommand("Get_Adminlogin", con);
        cmdlogin1.CommandType = CommandType.StoredProcedure;
        cmdlogin1.Parameters.AddWithValue("@P_userid", Email);
        cmdlogin1.Parameters.AddWithValue("@P_password", Password);
        count = Convert.ToInt32(cmdlogin1.ExecuteScalar());
        if (count > 0)
            return true;
        else
           return false;
    }
    public int JobEmailCount(string Email)
    {

        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd = new SqlCommand("Job_EmailCount", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar).Value = Email;
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        con.Close();
        return count;
    }
    public void UpdateUser(string DName,string eMail,string Fname,string Lname,string Address,string City,string State,string Country)
    {

        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        cmd = new SqlCommand("Update_Job_USER_Information", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@P_DisplayName", DName);
        cmd.Parameters.AddWithValue("@P_Email", eMail);
        cmd.Parameters.AddWithValue("@P_FirstName", Fname);
        cmd.Parameters.AddWithValue("@P_LastName", Lname);
        cmd.Parameters.AddWithValue("@P_Address", Address);
        cmd.Parameters.AddWithValue("@P_City", City);
        cmd.Parameters.AddWithValue("@P_State", State);
        cmd.Parameters.AddWithValue("@P_Country", Country);
        cmd.ExecuteNonQuery();
        con.Close();
    }
}
===============================================================================



74 comments:

  1. i need this source code zip file plz send me at fakhar.csv@gmail.com

    ReplyDelete
  2. hi I want source code as zip folder s.pahmedkhan@gmail.com

    ReplyDelete
  3. hi...i need the source code......:)

    ReplyDelete
  4. i want this admin source please send it to me this email address niki9091@hotmail.com

    ReplyDelete
  5. Nice code....i want this code pls send me it at shely.dhami@gmail.com

    ReplyDelete
  6. please mail me this code at bhaveshvyas23@gmail.com

    ReplyDelete
  7. Nice Code Sir... Please send the Source code to my mail id: sai.rapola@gmail.com

    ReplyDelete
  8. plz send me code kashifshahzad917@gmail.com

    ReplyDelete
  9. please send me this source code at miky.smith7@gmail.com

    ReplyDelete
  10. I need this code please send me it at juthi.cse090203@gmail.com

    ReplyDelete
  11. i need this source code zip file plz send me at msohailpak1@gmail.com

    ReplyDelete
  12. hi .. nice code ..
    i want this code in zip format . . please send me it at sumitpitroda@gmail.com

    ReplyDelete
  13. Please i want the source code zip sent to my email thanks obubus@gmail.com

    ReplyDelete
  14. hi Nice code plz send me this code at esufi88@gmail.com

    ReplyDelete
  15. i need this source code zip file plz send me at boramay56@gmail.com

    ReplyDelete
  16. i need this source code zip file plz send me at boramay56@gmail.com

    ReplyDelete
  17. i need this source code zip file plz send me at boramay56@gmail.com

    ReplyDelete
  18. Sir I Need This Source Code Zip Fiel Please send me at aurangzeb035.ciit@gmail.com

    ReplyDelete
  19. Please i want the source code zip sent to my email thanks imshubhampathak@gmail.com

    ReplyDelete
  20. Source code at japangor@gmail.com

    ReplyDelete
  21. Please i want the source code zip sent to my email thanks huseyinkeser@hotmail.com

    ReplyDelete
  22. Please i want the source code zip sent to my email thanks huseyinkeser@hotmail.com

    ReplyDelete
  23. ifaazkhan@gmail.com please send me the source file.

    ReplyDelete
  24. i need this source code zip file plz send me at ifaazkhan@gmail.com

    ReplyDelete
  25. i need this source code zip file plz send me at ifaazkhan@gmail.com

    ReplyDelete
  26. i need this source code zip file plz send me at amichaudhari007@gmail.com

    ReplyDelete
  27. i need this source code zip file plz send me at albalushian@yahoo.com

    ReplyDelete
  28. PLease send the whole source code to bilalhsa100@gmail.com

    ReplyDelete
  29. I need this source code zip file plz send me at kivancalieren@gmail.com

    ReplyDelete
  30. superrr plz send me the source code at chellamuthumca@gmail.com

    ReplyDelete
  31. i need source code please send me on this account uqi_niceman@yahoo.com

    ReplyDelete
  32. i need this code.... giribabuzee@gmail.com

    ReplyDelete
  33. i need this code.... giribabuzee@gmail.com

    ReplyDelete
  34. i need this code.... giribabuzee@gmail.com

    ReplyDelete
  35. i need this code.... giribabuzee@gmail.com

    ReplyDelete
  36. i need this source code zip file plz send me at silalaboriano@gmail.com

    ReplyDelete
  37. i need this source code zip file plz send me at mary_pisciss@hotmail.com

    ReplyDelete
  38. i need this source code zip file plz send me at sazzadulhaque2012@gmail.com

    ReplyDelete
  39. Crisp code. please mail me this code at swaminath.perumal@gmail.com

    ReplyDelete
  40. plz mail me the source code suresh98.cse@gmail.com

    ReplyDelete
  41. i want this source code in zip file pls send me suraj.possible@yahoo.com

    ReplyDelete
  42. wow great tutorial.please send me source code
    muradbd.info@gmail.com

    ReplyDelete
  43. that is exactly what i was looking for. is it possible to get a source code to dovpav@yahoo.ie, thank you

    ReplyDelete
  44. i want this source code in zip file pls send me sachinbotkule55@gmail.com

    ReplyDelete
  45. please zip file email eijazmusharraf@hotmail.com

    ReplyDelete
  46. please zip file email eijazmusharraf@hotmail.com

    ReplyDelete
  47. I need the source code in zip file please send me anerola.was.atorollari@gmail.com

    ReplyDelete
  48. Great tutorial I am impressed , Please send me the source code in zip file in anerola.was.atorollari@gmail.com

    ReplyDelete
  49. i need this source code zip file plz send me at itutkarshpandey@gmail.com

    ReplyDelete
  50. i need this source code zip file plz send me at itutkarshpandey@gmail.com

    ReplyDelete
  51. plz send me code raju.ahir088@gmail.com

    ReplyDelete
  52. i want its source code.please send me...
    madihamughal57@gmail.com

    ReplyDelete
  53. i want its source code plz send me
    madihamughal57@gmail.com

    ReplyDelete
  54. i need this source code zip file plz send me at mian.uzairghafoor@gmail.com

    ReplyDelete
  55. i need this source code zip file plz send me at mian.uzairghafoor@gmail.com

    ReplyDelete
  56. i want source code please sent me farhan.eurosottech@gmail.com

    ReplyDelete
  57. nice send to me source code shergy123.im@gmail.com

    ReplyDelete
  58. please send me source code
    jeweldiu28@gmail.com

    ReplyDelete
  59. Requesting the source code pls at : Laxmansharmarj29@gmail.com

    ReplyDelete
  60. Hi, Please Send me the code of this project on my email ID
    saiprakash837@gmail.com

    ReplyDelete
  61. Can you send me the source code to yaphethonline@gmail.com ?

    Thank you :D

    ReplyDelete
  62. hi send me source code to javed.asad26@yahoo.com

    ReplyDelete
  63. hi send me this source code plz through yosalangson123@gmail.com

    ReplyDelete
  64. hi can you send the source code to voodoo635@hotmail.com ? cheers

    ReplyDelete
  65. hi can you send me this source code to voodoo635@hotmail.com ? cheers

    ReplyDelete
  66. hi send me source code to m.ghesmati1988@gmail.com

    ReplyDelete
  67. Hi there, just wanted to mention, I liked this blog post.
    It was practical. Keep on posting!

    ReplyDelete
  68. please snd me database of this file on mahajanpoonam30@gmail.com

    ReplyDelete