public LevelEducation GetByPrimaryKey(int id)
{
try
{
string query = "select * from LevelEducation where ID = " + id;
LevelEducation teacher = connect.Query <LevelEducation>(query).FirstOrDefault <LevelEducation>();
return(teacher);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public bool Update(LevelEducation teacher)
{
try
{
string query = "update LevelEducation set Code = @Code,Name = @Name " +
" where ID = @ID ";
return(0 < connect.Execute(query, new
{
teacher.Code,
teacher.Name,
teacher.ID
}));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public int Insert(LevelEducation teacher)
{
try
{
string query = "insert into LevelEducation(" +
" Code,Name)" +
" values (@Code,@Name)" +
" SELECT @@IDENTITY";
int id = connect.Query <int>(query, new
{
teacher.Code,
teacher.Name
}).Single();
return(id);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
