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 :
Lis tOf Registered Candidates :
here admin can view the all registered users and admin can activate user or admin can deactivate or delete user.
Admin class file:
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(objectsender, EventArgs e)
{
lbl_message.Text = "";
}
protected void btn_login_Click(objectsender, 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(objectsender, EventArgs e)
{
if(Session["Admin"].ToString() == "")
{
Response.Redirect("AdminMain.aspx");
}
}
protected void btnView_Click(objectsender, 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, GridViewCommandEventArgse)
{
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, GridViewPageEventArgse)
{
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 DetailsAdminDal AdmDal = new AdminDal();
protected void Page_Load(objectsender, 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, GridViewPageEventArgse)
{
try
{
Grd_AdmViewAppliedJobBiddrs.PageIndex = e.NewPageIndex;
BindGridview();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected voidGrd_AdmViewAppliedJobBiddrs_SelectedIndexChanging(objectsender, GridViewSelectEventArgs e)
{
try
{
Grd_AdmViewAppliedJobBiddrs.SelectedIndex = e.NewSelectedIndex;
foreach(GridViewRow gr inGrd_AdmViewAppliedJobBiddrs.Rows)
{
if(gr.RowIndex == Grd_AdmViewAppliedJobBiddrs.SelectedIndex)
{
Literall;
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(objectsender, EventArgs e)
{
if(Session["Admin"].ToString() == "")
{
Response.Redirect("AdminMain.aspx");
}
}
protected void btnView_Click(objectsender, 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, GridViewPageEventArgse)
{
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, GridViewCommandEventArgse)
{
if(e.CommandName == "Update")
{
Session["JobId"] = e.CommandArgument.ToString();
Response.Redirect("PostedJobsDetails.aspx");
}
}
protected void Grd_AdminViewAllJobs_RowDeleting(object sender, GridViewDeleteEventArgse)
{
Buttonbtn;
foreach(GridViewRow gr inGrd_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(objectsender, EventArgs e)
{
if(Session["Admin"].ToString() == "")
{
Response.Redirect("AdminMain.aspx");
}
if(!IsPostBack)
{
BindData();
}
}
private void BindData()
{
AdmDal.JobSeekerId = Session["UserEmail"].ToString();
DataSetds = 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();
stringJType = 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(objectsender, EventArgs e)
{
Response.Redirect("../Admin/ListOfRegCandidates.aspx");
}
===============================================================Admin class file:
public class AdminDal
{
public static stringusername;
public static stringpassword;
private string _JobSeekerId;
public string JobSeekerId
{
get { return _JobSeekerId; }
set { _JobSeekerId = value; }
}
public AdminDal()
{
//
// TODO: Add constructor logic here
//
}
public DataSet AdminShowAllRegisterByDate(DateTime FromDt, DateTimeToDt)
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("Get_Admin_ViewRegUsers", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@FromDate", FromDt);
cmd1.Parameters.AddWithValue("@ToDate", ToDt);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public void DeleteRegisterUserInfo()
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("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 = newSqlCommand("Get_Admin_RegisteredUser", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@P_EmailId", this._JobSeekerId);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public DataSet AdminJobSeekerAppliedJobDetails()
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("Get_Admin_BiddedJobDetails", con);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public DataSet ShowAppliedJobDetailOfJobsseker()
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("Get_Admin_ShowAppliedJobDetailOfJobsseker", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@JobSeekerId", this._JobSeekerId);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public DataSet AdminShowAllJobsByDate(DateTime FromDt, DateTimeToDt)
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("Get_Admin_ViewAllJobs", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@FromDate", FromDt);
cmd1.Parameters.AddWithValue("@ToDate", ToDt);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public void DeletePostedJob()
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("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 = newSqlCommand("Get_Admin_SelectedJobDetais", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@P_JobId", this._JobSeekerId);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public DataSet ShowBiddersAppliedToJob()
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = newSqlCommand("Get_Admin_BiddersAppliedToJob", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@P_JobId", this._JobSeekerId);
SqlDataAdapterda = new SqlDataAdapter(cmd1);
DataSetds = new DataSet();
da.Fill(ds);
returnds;
}
public bool AdmLogin(stringEmail, string Password)
{
intcount;
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommandcmdlogin1 = 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)
returntrue;
else
returnfalse;
}
public int JobEmailCount(stringEmail)
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = newSqlCommand("Job_EmailCount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar).Value = Email;
int count = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
returncount;
}
public void UpdateUser(stringDName,string eMail,stringFname,string Lname,stringAddress,string City,stringState,string Country)
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = newSqlCommand("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();
}
}
===============================================================================
if you have any queries feel free to ask me , you can mail me to
