public Boolean insertPosition(enPosition enPosition)
{
try
{
str = "INSERT INTO position (position,status)VALUES(@position,@status);";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@position", DbType.String, enPosition.position);
db.AddInParameter(Dbcmd, "@status", DbType.Int32, enPosition.status);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Boolean updatePosition(enPosition enPosition)
{
try
{
str = "UPDATE position SET position=@position, status=@status WHERE positionID=@positionID;";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@position", DbType.String, enPosition.position);
db.AddInParameter(Dbcmd, "@status", DbType.Int32, enPosition.status);
db.AddInParameter(Dbcmd, "@positionID", DbType.Int32, enPosition.positionID);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
