public static int Delete(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@iExperienceLevelID", l.ExperienceLevelID); return(db.ExecuteNonQuery("JobsDb_ExperienceLevels_Delete")); }
public static int Insert(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName); SqlParameter p = new SqlParameter("@iExperienceLevelID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_ExperienceLevels_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } }
public static int Insert(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName); SqlParameter p = new SqlParameter("@iExperienceLevelID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_ExperienceLevels_Insert"); if (retval == 1) { return(int.Parse(p.Value.ToString())); } else { return(-1); } }
public static int Update(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@iExperienceLevelID", l.ExperienceLevelID); db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName); return db.ExecuteNonQuery("JobsDb_ExperienceLevels_Update"); }