public static void AddNewJobRole(JobRole jobRole)
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand("insert into JobRole ( job_role) values ( '" + jobRole.Name + "');", con);
command.ExecuteNonQuery();
con.Close();
}
public ActionResult AddJobRoles(JobRole model)
{
if (!Navigator.IsUserLoggedIn(Session))
{
@ViewBag.Message = "Sorry! You need to login to view this page.";
return View("Message");
//return RedirectToAction("Login", "Account");
}
else if (!Navigator.UserRoleValidation(Session, "manager"))
{
@ViewBag.Message = "Access Denied ! You are not allowed to visit this page.";
return View("Message");
//return RedirectToAction("Login", "Account");
}
AdminDAL.AddNewJobRole(model);
@ViewBag.Message = "Job Role - "+model.Name+" Added !";
@ViewBag.Layout = "~/Views/Shared/_LayoutPageManager.cshtml";
return View("Message");
//return RedirectToAction("Index","Home");
}
public static List<JobRole> GetJobRoles()
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand("select job_role_id, job_role from dbo.JobRole;", con);
SqlDataReader reader = command.ExecuteReader();
if (reader == null || !reader.Read())
{
return null;
}
//Creating a JobRole List
List<JobRole> listJobRole = new List<JobRole>();
do
{
JobRole objJobRole = new JobRole();
objJobRole.Id = Convert.ToInt32(reader[0]);
objJobRole.Name = Convert.ToString(reader[1]);
listJobRole.Add(objJobRole);
}
while (reader.Read());
con.Close();
return listJobRole;
}
