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