public static int Delete(EducationLevel e)
{
DBAccess db = new DBAccess();
db.AddParameter("@iEducationLevelID", e.EducationLevelID);
return(db.ExecuteNonQuery("JobsDb_EducationLevels_Delete"));
}
public static int Update(EducationLevel l)
{
DBAccess db = new DBAccess();
db.AddParameter("@iEducationLevelID", l.EducationLevelID);
db.AddParameter("@sEducationLevelName", l.EducationLevelName);
return(db.ExecuteNonQuery("JobsDb_EducationLevels_Update"));
}
public static int Insert(EducationLevel l)
{
DBAccess db = new DBAccess();
db.AddParameter("@sEducationLevelName", l.EducationLevelName);
SqlParameter p = new SqlParameter("@iEducationLevelID", SqlDbType.Int);
p.Direction = ParameterDirection.Output;
db.AddParameter(p);
int retval = db.ExecuteNonQuery("JobsDb_EducationLevels_Insert");
if (retval == 1)
{
return int.Parse(p.Value.ToString());
}
else
{
return -1;
}
}
public static int Insert(EducationLevel l)
{
DBAccess db = new DBAccess();
db.AddParameter("@sEducationLevelName", l.EducationLevelName);
SqlParameter p = new SqlParameter("@iEducationLevelID", SqlDbType.Int);
p.Direction = ParameterDirection.Output;
db.AddParameter(p);
int retval = db.ExecuteNonQuery("JobsDb_EducationLevels_Insert");
if (retval == 1)
{
return(int.Parse(p.Value.ToString()));
}
else
{
return(-1);
}
}
public static int Update(EducationLevel l)
{
DBAccess db = new DBAccess();
db.AddParameter("@iEducationLevelID", l.EducationLevelID);
db.AddParameter("@sEducationLevelName", l.EducationLevelName);
return db.ExecuteNonQuery("JobsDb_EducationLevels_Update");
}
public static int Delete(EducationLevel e)
{
DBAccess db = new DBAccess();
db.AddParameter("@iEducationLevelID",e.EducationLevelID);
return db.ExecuteNonQuery("JobsDb_EducationLevels_Delete");
}