public static void AddNewQualification(Qualification model)
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand("insert into Qualification ( qualification, type) values ( '" + model.Name + "', '" + model.Type + "');", con);
command.ExecuteNonQuery();
con.Close();
}
public ActionResult AddQualification(Qualification 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.AddNewQualification(model);
@ViewBag.Message = "New Qualification - " + model.Name + " Added !";
@ViewBag.Layout = "~/Views/Shared/_LayoutPageManager.cshtml";
return View("Message");
//return RedirectToAction("Index","Home");
}
public static List<Qualification> getQualifications()
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand("select qualification_id, qualification, type from dbo.Qualification;", con);
SqlDataReader reader = command.ExecuteReader();
if (reader == null || !reader.Read())
{
return null;
}
//Creating a JobRole List
List<Qualification> listQualification = new List<Qualification>();
do
{
Qualification obj = new Qualification();
obj.Id = Convert.ToInt32(reader[0]);
obj.Name = Convert.ToString(reader[1]);
obj.Type = Convert.ToString(reader[2]);
listQualification.Add(obj);
}
while (reader.Read());
reader.Close();
con.Close();
return listQualification;
}
public Skill(Qualification q)
{
this.Id = q.Id;
this.Name = q.Name;
this.Type = q.Type;
}
