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; }